My Blog: 2010

Friday, November 26, 2010

using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

/// <summary>
/// Summary description for DBUpdate
/// </summary>
public class DBUpdate
{
    public DBUpdate()
    {
        //
        // TODO: Add constructor logic here
        //
    }
    public SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings.Get("connString"));
    public SqlCommand cmd = new SqlCommand();
    public SqlDataAdapter ada = new SqlDataAdapter();
    public DataTable dt = new DataTable();
    public SqlDataReader dr;

    public SqlConnection getcon()
    {
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        return con;
    }
    public string excquery(string cmdtext)
    {
        try
        {
            cmd.Connection = getcon();
            cmd.CommandType = CommandType.Text;
            cmd.CommandText = cmdtext;
            cmd.ExecuteNonQuery();
            return "1";

        }
        catch (Exception ex)
        {
            return ex.Message;
        }
    }
    public string excproc(string procname)
    {
        try
        {
            cmd.Connection = getcon();
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.CommandText = procname;
            cmd.Connection = con;
            cmd.ExecuteNonQuery();
            return "1";
        }
        catch (Exception ex)
        {
            return ex.Message;
        }

    }





    public DataTable gettable(string fetchcmd)
    {
        cmd.Connection = con;
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = fetchcmd;
        ada.SelectCommand = cmd;
        dt = new DataTable();
        ada.Fill(dt);
        return dt;

    }
    public SqlDataReader datareader(string fetchrow)
    {
        getcon();
        cmd.Connection = con;
        cmd.CommandText = fetchrow;
        dr = cmd.ExecuteReader();
        return dr;
        closeconnection();

    }

    public void closeconnection()
    {
        if (con.State != ConnectionState.Closed)
        {
            con.Close();
        }
    }

vwRegistrations using checkboxes

public partial class Admin_VwRegistrations : System.Web.UI.Page
{
    DBUpdate registration = new DBUpdate();
    DataTable dt = new DataTable();
    string rid;
    protected void Page_Load(object sender, EventArgs e)
    {

       // lblrid.Text = k;
        if (!Page.IsPostBack)
        {
            LoadData();

        }

    }
    private void LoadData()
    {
        //string constr = @"Server=.\SQLEXPRESS;Database=TestDB;uid=waqas;pwd=sql;";
        string query = @"SELECT * FROM tblReporterRegistration where status =''" ;
     try
        {
        SqlDataAdapter da = new SqlDataAdapter(query, registration.con);

            da.Fill(dt);
            object k = dt.Rows[0][0].ToString();
            lblrid.Text = k.ToString();
        }

       catch (Exception ex)
        {

             Response.Write("<script>alert('Existing Registrations are empty...')</script>");
             // clearall();
             StringBuilder sb = new StringBuilder();
             sb.Append("<script>");
             sb.Append("window.open('adminHome.aspx', '', '');");
             sb.Append("</scri");
             sb.Append("pt>");

             Page.RegisterStartupScript("test", sb.ToString());
        }

        GridView1.DataSource = dt;
        GridView1.DataBind();



}
       private void clientScriptAlert(string Message)
    {
        Page.RegisterClientScriptBlock("clientScript", "<script>alert('" + Message + "')</script>");
    }


    protected void CheckBox3_CheckedChanged(object sender, EventArgs e)
    {
       CheckBox chkStatus = (CheckBox)sender;
        GridViewRow row = (GridViewRow)chkStatus.NamingContainer;

          rid = lblrid.Text;

         // rid = row.Cells[1].Text;//(CheckBox)row.FindControl("cbRows")

        bool status = chkStatus.Checked;

       // CheckBox checkbox = (CheckBox)row.FindControl("regnId");

        registration.con.Open();

        string query = "UPDATE tblReporterRegistration SET status = 'Active' WHERE regnID = " + rid;
        string query2 = "UPDATE tblUser SET status = 'Active' WHERE registrationid = " + rid;

        //SqlConnection con = new SqlConnection(constr);
        SqlCommand com = new SqlCommand(query, registration.con);
        SqlCommand cmd = new SqlCommand(query2, registration.con);

        com.Parameters.Add("@Approved", SqlDbType.Bit).Value = status;
        com.Parameters.Add("@CategoryID", SqlDbType.Int).Value = rid;

      // registration.con.Open();
        com.ExecuteNonQuery();
        cmd.ExecuteNonQuery();
        registration.con.Close();
        LoadData();


}


    //protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    //{
    //    string strupdate = "update tblReporterRegistration set status = 'Active' where regnId = " + ;
    //    registration.excquery(strupdate);
    //}
    //protected void btnAccept_Click1(object sender, EventArgs e)
    //{
    //    string strupdate = "update tblReporterRegistration set status = 'Active' where regnId = " + rid;
    //    registration.excquery(strupdate);
    //}
    //protected void btnReject_Click1(object sender, EventArgs e)
    //{
    //    string strdelete = "delete from tblReporterRegistration   where regnId = " + rid;
    //    registration.excquery(strdelete);
    //}
    protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
    {
        CheckBox chkStatus = (CheckBox)sender;
        GridViewRow row = (GridViewRow)chkStatus.NamingContainer;

        rid = lblrid.Text;

        // rid = row.Cells[1].Text;//(CheckBox)row.FindControl("cbRows")

        bool status = chkStatus.Checked;

        // CheckBox checkbox = (CheckBox)row.FindControl("regnId");

        registration.con.Open();

        string query = "UPDATE tblReporterRegistration SET status = 'Active' WHERE regnID = " + rid;
        string query2 = "UPDATE tblUser SET status = 'Active' WHERE registrationid = " + rid;

        //SqlConnection con = new SqlConnection(constr);
        SqlCommand com = new SqlCommand(query, registration.con);
        SqlCommand cmd = new SqlCommand(query2, registration.con);

        com.Parameters.Add("@Approved", SqlDbType.Bit).Value = status;
        com.Parameters.Add("@CategoryID", SqlDbType.Int).Value = rid;

        // registration.con.Open();
        com.ExecuteNonQuery();
        cmd.ExecuteNonQuery();
        registration.con.Close();
        LoadData();

    }
}

Thursday, September 30, 2010

correct chatting

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Text;

public partial class ChatRoom : System.Web.UI.Page, System.Web.UI.ICallbackEventHandler
{
    Class1 obj = new Class1();
    private void ddlbind()
    {
        obj.gettable("select * from Usertab where UserID!=" + Convert.ToInt32(Session["ChatUserID"]));

        DropDownList1.DataSource = obj.dt;
        DropDownList1.DataBind();
    }
    private string _callBackStatus;
   // this.InsertMessage(ConfigurationManager.AppSettings["ChatLoggedInText"] + " " + DateTime.Now.ToString());
    private void GetLoggedInUsers()

     {

             LinqChatDataContext db = new LinqChatDataContext();

            // let's check if this authenticated user exist in the

           // LoggedInUser table (means user is logged-in to this room)

         var user = (from u in db.LoggedInUsers

                       where u.UserID == Convert.ToInt32(Session["ChatUserID"])

                       && u.RoomID == Convert.ToInt32(lblRoomId.Text)

                       select u).SingleOrDefault();

           // if user does not exist in the LoggedInUser table

           // then let's add/insert the user to the table

             if (user == null)

            {

                 LoggedInUser loggedInUser = new LoggedInUser();

               loggedInUser.UserID = Convert.ToInt32(Session["ChatUserID"]);

                loggedInUser.RoomID = Convert.ToInt32(lblRoomId.Text);

                db.LoggedInUsers.InsertOnSubmit(loggedInUser);

                db.SubmitChanges();

            }

           string userIcon;

           StringBuilder sb = new StringBuilder();

          // get all logged in users to this room

           var loggedInUsers = from l in db.LoggedInUsers

                              where l.RoomID == Convert.ToInt32(lblRoomId.Text)

                               select l;

            // list all logged in chat users in the user list

           foreach (var loggedInUser in loggedInUsers)
          {

               // show user icon based on sex

               if (loggedInUser.Usertab.Sex.ToString().ToLower() == "m")

                    userIcon = "<img src='Images/manIcon.gif' style='vertical-align:middle' alt=''> ";

                else

                    userIcon = "<img src='Images/womanIcon.gif' style='vertical-align:middle' alt=''> ";

                 if (loggedInUser.Usertab.Username != (string)Session["ChatUsername"])

                        sb.Append(userIcon + "<a href=#>" + loggedInUser.Usertab.Username + "</a><br>");

               else
                   sb.Append(userIcon + "<b>" + loggedInUser.Usertab.Username + "</b><br>");

            }

          // holds the names of the users shown in the chatroom

           litUsers.Text = sb.ToString();
      }
    private void InsertMessage(string text)

           {
                LinqChatDataContext db = new LinqChatDataContext();
                Message message = new Message();
                message.RoomID = Convert.ToInt32(lblRoomId.Text);
                message.UserID= Convert.ToInt32(Session["ChatUserID"]);
                if (String.IsNullOrEmpty(text))
                {
                    message.Text = txtMessage.Text.Replace("<", "");
                    message.Color = ddlColor.SelectedValue;
                }
                else
                {
                    message.Text = text;
                    message.Color = "gray";
                }
                message.ToUserID = null;            // in the future, we will use this value for private messages
                message.TimeStamp = DateTime.Now;
                db.Messages.InsertOnSubmit(message);
                db.SubmitChanges();

       }
    private void GetRoomInformation()
    {
        // get the room information from the database
        // we're going to set this up so that we can use
        // many rooms if we want to
        LinqChatDataContext db = new LinqChatDataContext();

        var room = (from r in db.Rooms
                    where r.RoomID == Convert.ToInt32(lblRoomId.Text)
                    select r).SingleOrDefault();

        lblRoomId.Text = room.RoomID.ToString();
        lblRoomName.Text = room.Name;
    }

     //this.InsertMessage(ConfigurationManager.AppSettings["ChatLoggedInText"] + " " + DateTime.Now.ToString())
    protected void Page_Load(object sender, EventArgs e)



    {
         if (!IsPostBack)
         {
             ddlbind();
             string roomId = (string)Request["roomId"];
             lblRoomId.Text = roomId;
             this.GetRoomInformation();
             this.GetLoggedInUsers();
             this.InsertMessage(ConfigurationManager.AppSettings["ChatLoggedInText"] + " " + DateTime.Now.ToString());
             this.GetMessages();

             // create a call back reference so we can log-out user when user closes the browser
             string callBackReference = Page.ClientScript.GetCallbackEventReference(this, "arg", "LogOutUser", "");
             string logOutUserCallBackScript = "function LogOutUserCallBack(arg, context) { " + callBackReference + "; }";
             Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "LogOutUserCallBack", logOutUserCallBackScript, true);
         }
    }
    void System.Web.UI.ICallbackEventHandler.RaiseCallbackEvent(string eventArgument)

        {

            _callBackStatus = "failed";

           // log out the user by deleting from the LoggedInUser table

    string callBackReference = Page.ClientScript.GetCallbackEventReference(this, "arg", "LogOutUser", "");

                string logOutUserCallBackScript = "function LogOutUserCallBack(arg, context) { " + callBackReference + "; }";

                 Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "LogOutUserCallBack", logOutUserCallBackScript, true);       LinqChatDataContext db = new LinqChatDataContext();

            var loggedInUser = (from l in db.LoggedInUsers

                                 where l.UserID == Convert.ToInt32(Session["ChatUserID"])

                              && l.RoomID == Convert.ToInt32(lblRoomId.Text)

                               select l).SingleOrDefault();

           db.LoggedInUsers.DeleteOnSubmit(loggedInUser);

             db.SubmitChanges();

          // insert a message that this user has logged out

           this.InsertMessage("Just logged out! " + DateTime.Now.ToString());

              _callBackStatus = "success";
         }

     private void GetMessages()

        {
            LinqChatDataContext db = new LinqChatDataContext();
            var messages = (from m in db.Messages
                            where m.UserID == Convert.ToInt32(Session["ChatUserID"]) && m.RoomID == Convert.ToInt32(lblRoomId.Text)
            orderby m.TimeStamp descending
            select m).Take(20).OrderBy(m => m.TimeStamp);
            if (messages != null)
             {

              StringBuilder sb = new StringBuilder();
              int ctr = 0;    // toggle counter for alternating color
               foreach (var message in messages)

               {

                    // alternate background color on messages

                    if (ctr == 0)

                     {
                       sb.Append("<div style='padding: 10px;'>");

                       ctr = 1;

                   }

                   else

                  {

                        sb.Append("<div style='background-color: #EFEFEF; padding: 10px;'>");
                       ctr = 0;

                   }

                     if (message.Usertab.Sex.ToString().ToLower() == "m")

                        sb.Append("<img src='Images/manIcon.gif' style='vertical-align:middle' alt=''> " + message.Text + "</div>");

                    else

                    sb.Append("<img src='Images/womanIcon.gif' style='vertical-align:middle' alt=''> " + message.Text + "</div>");
              }


             litMessages.Text = sb.ToString();

           }

         }

protected void BtnSend_Click(object sender, EventArgs e)
     {
         if (txtMessage.Text.Length > 0)
         {
             this.InsertMessages(null);
             this.GetMessages();
             txtMessage.Text = String.Empty;
             ScriptManager1.SetFocus(txtMessage.ClientID);
         }

}
private void InsertMessages(string text)
{
    LinqChatDataContext db = new LinqChatDataContext();
    Message message = new Message();
    message.RoomID = Convert.ToInt32(lblRoomId.Text);
    message.UserID = Convert.ToInt32(Session["ChatUserID"]);
    if (String.IsNullOrEmpty(text))
    {
        message.Text = txtMessage.Text.Replace("<", "");
        message.Color = ddlColor.SelectedValue;
    }
    else
    {
        message.Text = text;
        message.Color = "gray";
    }
    message.ToUserID = Convert.ToInt32(DropDownList1.SelectedItem.Value);            // in the future, we will use this value for private messages
    message.TimeStamp = DateTime.Now;
    db.Messages.InsertOnSubmit(message);
    db.SubmitChanges();

}
protected void Timer1_OnTick(object sender, EventArgs e)
{
    this.GetLoggedInUsers();
    this.GetMessagesddl();

    if ((string)Session["IsChatroomInFocus"] == null)
        ScriptManager1.SetFocus(txtMessage);

}
protected void BtnLogOut_Click(object sender, EventArgs e)
{
    obj.excquery("delete from Message where UserId=" + Convert.ToInt32(Session["ChatUserID"]) + "");
    obj.excquery("delete from Message where ToUserId=" + Convert.ToInt32(Session["ChatUserID"]) + "");
       LinqChatDataContext db = new LinqChatDataContext();
       var loggedInUser = (from l in db.LoggedInUsers
       where l.UserID == Convert.ToInt32(Session["ChatUserID"])
       && l.RoomID == Convert.ToInt32(lblRoomId.Text)
       select l).SingleOrDefault();
       db.LoggedInUsers.DeleteOnSubmit(loggedInUser);
       db.SubmitChanges();
       // insert a message that this user has logged out
       this.InsertMessage("Just logged out! " + DateTime.Now.ToString());
       // clean the session
        Session.RemoveAll();
        Session.Abandon();

       // redirect the user to the login page
        Response.Redirect("Default.aspx");
}
    string System.Web.UI.ICallbackEventHandler.GetCallbackResult()

         {

            return _callBackStatus;

   }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        GetMessagesddl();

    }
    private void GetMessagesddl()
    {
        LinqChatDataContext db = new LinqChatDataContext();
        var messages = (from m in db.Messages
                        where m.UserID == Convert.ToInt32(DropDownList1.SelectedItem.Value) && m.ToUserID == Convert.ToInt32(Session["ChatUserID"]) && m.RoomID == Convert.ToInt32(lblRoomId.Text) || m.UserID == Convert.ToInt32(Session["ChatUserID"]) && m.ToUserID == Convert.ToInt32(DropDownList1.SelectedItem.Value) && m.RoomID == Convert.ToInt32(lblRoomId.Text)
                        orderby m.TimeStamp descending
                        select m).Take(20).OrderBy(m => m.TimeStamp);
        if (messages != null)
        {

            StringBuilder sb = new StringBuilder();
            int ctr = 0;    // toggle counter for alternating color
            foreach (var message in messages)
            {

                // alternate background color on messages

                if (ctr == 0)
                {
                    sb.Append("<div style='padding: 10px;'>");

                    ctr = 1;

                }

                else
                {

                    sb.Append("<div style='background-color: #EFEFEF; padding: 10px;'>");
                    ctr = 0;

                }

                if (message.Usertab.Sex.ToString().ToLower() == "m")

                    sb.Append("<img src='Images/manIcon.gif' style='vertical-align:middle' alt=''> " + message.Text + "</div>");

                else

                    sb.Append("<img src='Images/womanIcon.gif' style='vertical-align:middle' alt=''> " + message.Text + "</div>");
            }

            litMessages.Text = sb.ToString();

        }

    }
}

Wednesday, September 29, 2010

stored procedures

protected void btnSave_Click(object sender, ImageClickEventArgs e)
    {


        string s;
           title = txtTitle.Text.ToString();
         insertcontents.cmd.Parameters.AddWithValue("@title",txtTitle.Text);
         insertcontents.cmd.Parameters.AddWithValue("@url",txtTitle.Text+".html");

         insertcontents.cmd.Parameters.AddWithValue("@bloggerid", Session["idUser"]);
        insertcontents.cmd.Parameters.AddWithValue("@date",DateTime.Now.ToString());
        s = insertcontents.excproc("spInsertTitle");
        if (s == "1")
            Response.Write("Inserted Succ");
       // insertcontents.cmd.Parameters.AddWithValue("@status","Active");


    }

ALTER PROCEDURE [dbo].[spInsertTitle]
    (@title varchar(150), @url varchar(50),@bloggerid int,@date varchar(20))
AS

insert into tblTitle values (@title,@url,@bloggerid,@date)

dynamic html

public partial class Blogger_BlogPost : System.Web.UI.Page
{
    DBUpdate insertcontents = new DBUpdate();
    StreamWriter sw;
    string title;
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnPublish_Click(object sender, ImageClickEventArgs e)
    {
        sw = File.CreateText(Server.MapPath(txtTitle.Text+".html"));
        sw.WriteLine("<h3>"+txtTitle.Text+"</h3>");
        sw.WriteLine(contentEditor.Content);
        sw.Close();

chatting

http://www.junnark.com/Articles/Build-a-Web-Chat-Application-Using-ASP-Net-LINQ-and-AJAX-CS.aspx

chatroom.aspx.cs

ublic partial class ChatRoom : System.Web.UI.Page, System.Web.UI.ICallbackEventHandler
{
    Class1 obj = new Class1();
    private string _callBackStatus;
   // this.InsertMessage(ConfigurationManager.AppSettings["ChatLoggedInText"] + " " + DateTime.Now.ToString());
    private void GetLoggedInUsers()

     {

             LinqChatDataContext db = new LinqChatDataContext();

            // let's check if this authenticated user exist in the

           // LoggedInUser table (means user is logged-in to this room)

         var user = (from u in db.LoggedInUsers

                       where u.UserID == Convert.ToInt32(Session["ChatUserID"])

                       && u.RoomID == Convert.ToInt32(lblRoomId.Text)

                       select u).SingleOrDefault();

           // if user does not exist in the LoggedInUser table

           // then let's add/insert the user to the table

             if (user == null)

            {

                 LoggedInUser loggedInUser = new LoggedInUser();

               loggedInUser.UserID = Convert.ToInt32(Session["ChatUserID"]);

                loggedInUser.RoomID = Convert.ToInt32(lblRoomId.Text);

                db.LoggedInUsers.InsertOnSubmit(loggedInUser);

                db.SubmitChanges();

            }

           string userIcon;

           StringBuilder sb = new StringBuilder();

          // get all logged in users to this room

           var loggedInUsers = from l in db.LoggedInUsers

                              where l.RoomID == Convert.ToInt32(lblRoomId.Text)

                               select l;

            // list all logged in chat users in the user list

           foreach (var loggedInUser in loggedInUsers)
          {

               // show user icon based on sex

               if (loggedInUser.Usertab.Sex.ToString().ToLower() == "m")

                    userIcon = "<img src='Images/manIcon.gif' style='vertical-align:middle' alt=''> ";

                else

                    userIcon = "<img src='Images/womanIcon.gif' style='vertical-align:middle' alt=''> ";

                 if (loggedInUser.Usertab.Username != (string)Session["ChatUsername"])

                        sb.Append(userIcon + "<a href=#>" + loggedInUser.Usertab.Username + "</a><br>");

               else
                   sb.Append(userIcon + "<b>" + loggedInUser.Usertab.Username + "</b><br>");

            }

          // holds the names of the users shown in the chatroom

           litUsers.Text = sb.ToString();
      }
    private void InsertMessage(string text)

           {
                LinqChatDataContext db = new LinqChatDataContext();
                Message message = new Message();
                message.RoomID = Convert.ToInt32(lblRoomId.Text);
                message.UserID= Convert.ToInt32(Session["ChatUserID"]);
                if (String.IsNullOrEmpty(text))
                {
                    message.Text = txtMessage.Text.Replace("<", "");
                    message.Color = ddlColor.SelectedValue;
                }
                else
                {
                    message.Text = text;
                    message.Color = "gray";
                }
                message.ToUserID = null;            // in the future, we will use this value for private messages
                message.TimeStamp = DateTime.Now;
                db.Messages.InsertOnSubmit(message);
                db.SubmitChanges();

       }
    private void GetRoomInformation()
    {
        // get the room information from the database
        // we're going to set this up so that we can use
        // many rooms if we want to
        LinqChatDataContext db = new LinqChatDataContext();

        var room = (from r in db.Rooms
                    where r.RoomID == Convert.ToInt32(lblRoomId.Text)
                    select r).SingleOrDefault();

        lblRoomId.Text = room.RoomID.ToString();
        lblRoomName.Text = room.Name;
    }

     //this.InsertMessage(ConfigurationManager.AppSettings["ChatLoggedInText"] + " " + DateTime.Now.ToString())
    protected void Page_Load(object sender, EventArgs e)


    {
         if (!IsPostBack)
         {
             string roomId = (string)Request["roomId"];
             lblRoomId.Text = roomId;
             this.GetRoomInformation();
             this.GetLoggedInUsers();
       this.InsertMessage(ConfigurationManager.AppSettings["ChatLoggedInText"] + " " + DateTime.Now.ToString());
             this.GetMessages();

             // create a call back reference so we can log-out user when user closes the browser
             string callBackReference = Page.ClientScript.GetCallbackEventReference(this, "arg", "LogOutUser", "");
             string logOutUserCallBackScript = "function LogOutUserCallBack(arg, context) { " + callBackReference + "; }";
             Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "LogOutUserCallBack", logOutUserCallBackScript, true);
         }
    }
    void System.Web.UI.ICallbackEventHandler.RaiseCallbackEvent(string eventArgument)

        {

            _callBackStatus = "failed";

           // log out the user by deleting from the LoggedInUser table

    string callBackReference = Page.ClientScript.GetCallbackEventReference(this, "arg", "LogOutUser", "");

                string logOutUserCallBackScript = "function LogOutUserCallBack(arg, context) { " + callBackReference + "; }";

                 Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "LogOutUserCallBack", logOutUserCallBackScript, true);       LinqChatDataContext db = new LinqChatDataContext();

            var loggedInUser = (from l in db.LoggedInUsers

                                 where l.UserID == Convert.ToInt32(Session["ChatUserID"])

                              && l.RoomID == Convert.ToInt32(lblRoomId.Text)

                               select l).SingleOrDefault();

           db.LoggedInUsers.DeleteOnSubmit(loggedInUser);

             db.SubmitChanges();

          // insert a message that this user has logged out

           this.InsertMessage("Just logged out! " + DateTime.Now.ToString());

              _callBackStatus = "success";
         }

     private void GetMessages()

        {
            LinqChatDataContext db = new LinqChatDataContext();
            var messages = (from m in db.Messages
                            where m.RoomID == Convert.ToInt32(lblRoomId.Text)
            orderby m.TimeStamp descending
            select m).Take(20).OrderBy(m => m.TimeStamp);
            if (messages != null)
             {

              StringBuilder sb = new StringBuilder();
              int ctr = 0;    // toggle counter for alternating color
               foreach (var message in messages)

               {

                    // alternate background color on messages

                    if (ctr == 0)

                     {
                       sb.Append("<div style='padding: 10px;'>");

                       ctr = 1;

                   }

                   else

                  {

                        sb.Append("<div style='background-color: #EFEFEF; padding: 10px;'>");
                       ctr = 0;

                   }

                     if (message.Usertab.Sex.ToString().ToLower() == "m")

                        sb.Append("<img src='Images/manIcon.gif' style='vertical-align:middle' alt=''> " + message.Text + "</div>");

                    else

                    sb.Append("<img src='Images/womanIcon.gif' style='vertical-align:middle' alt=''> " + message.Text + "</div>");
              }


             litMessages.Text = sb.ToString();

           }

         }

protected void BtnSend_Click(object sender, EventArgs e)
     {
         if (txtMessage.Text.Length > 0)
         {
             this.InsertMessages(null);
             this.GetMessages();
             txtMessage.Text = String.Empty;
             ScriptManager1.SetFocus(txtMessage.ClientID);
         }

}
private void InsertMessages(string text)
{
    LinqChatDataContext db = new LinqChatDataContext();
    Message message = new Message();
    message.RoomID = Convert.ToInt32(lblRoomId.Text);
    message.UserID = Convert.ToInt32(Session["ChatUserID"]);
    if (String.IsNullOrEmpty(text))
    {
        message.Text = txtMessage.Text.Replace("<", "");
        message.Color = ddlColor.SelectedValue;
    }
    else
    {
        message.Text = text;
        message.Color = "gray";
    }
    message.ToUserID = null;            // in the future, we will use this value for private messages
    message.TimeStamp = DateTime.Now;
    db.Messages.InsertOnSubmit(message);
    db.SubmitChanges();

}
protected void Timer1_OnTick(object sender, EventArgs e)
{
    this.GetLoggedInUsers();
    this.GetMessages();

    if ((string)Session["IsChatroomInFocus"] == null)
        ScriptManager1.SetFocus(txtMessage);

}
protected void BtnLogOut_Click(object sender, EventArgs e)
{
       LinqChatDataContext db = new LinqChatDataContext();
       var loggedInUser = (from l in db.LoggedInUsers
       where l.UserID == Convert.ToInt32(Session["ChatUserID"])
       && l.RoomID == Convert.ToInt32(lblRoomId.Text)
       select l).SingleOrDefault();
       db.LoggedInUsers.DeleteOnSubmit(loggedInUser);
       db.SubmitChanges();
       // insert a message that this user has logged out
       this.InsertMessage("Just logged out! " + DateTime.Now.ToString());
       // clean the session
        Session.RemoveAll();
        Session.Abandon();
       // redirect the user to the login page
        Response.Redirect("Default.aspx");
}
    string System.Web.UI.ICallbackEventHandler.GetCallbackResult()

         {

            return _callBackStatus;

   }
    protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
    {
        //obj.gettable("select * from Usertab where UserID=" + DropDownList1.SelectedItem.Value + "");
        //if(obj.dt.Rows.Count>0)
        //{

        //}

    }
}

My Blog

Friday, November 26, 2010

displaynews

Userhome

Reporter Home

add news

add advertisements

dbupdate