Click here to Skip to main content
15,891,033 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: (untagged)
C#
protected void bt_submit_Click(object sender, EventArgs e)
  {
      if (string.IsNullOrEmpty(Request.QueryString["Pageid"]))
      {
          if (Session["Id"] != null)
          {

              string str1 = "insert into tbl_conversation([cust_ID],[rep_ID],[conversation_description],[conversation_datetime],[conversation_type],[callback_datetime],[conversation_status],Role) values('" + ddlcustomer.SelectedItem.Value + "','" + Convert.ToInt64(Session["Id"]) + "','" + txtdescriton.Text + "','" + DateTime.Parse(Request.Form[txtconversation_datetime.UniqueID]) + "','" + ddlconversationtype.SelectedItem.Value + "','" + txtcallback.Text + "','1','Admin')";



             // string str2 = "insert into tbl_conversation([cust_ID],[rep_ID],[conversation_description],[conversation_datetime],[conversation_type],[callback_datetime],[conversation_status],Role) values('" + ddlcustomer.SelectedItem.Value + "','" + Convert.ToInt64(Session["Id"]) + "','" + txtdescriton.Text + "','" + DateTime.Parse(Request.Form[txtconversation_datetime.UniqueID]) + "','" + ddlconversationtype.SelectedItem.Value + "','" + txtcallback.Text + "','1','Admin')";
            
             c1.exexuteQry(str1);



          }
          else
          {
              if (Session["RecId"] != null)
              {
                  string str1 = "insert into tbl_conversation([cust_ID],[rep_ID],[conversation_description],[conversation_datetime],[conversation_type],[callback_datetime],[conversation_status],Role) values('" + ddlcustomer.SelectedItem.Value + "','" + Convert.ToInt64(Session["RecId"]) + "','" + txtdescriton.Text + "','" + DateTime.Parse(Request.Form[txtconversation_datetime.UniqueID]) + "','" + ddlconversationtype.SelectedItem.Value + "','" + DateTime.Parse(Request.Form[txtcallback.UniqueID]) + "','1','User')";
                  c1.exexuteQry(str1);
              }
          }



          Response.Write(@"<script langauge='text/javascript'>alert('...Insert successfull...');</script>");
      }
      else
      {
          if (Session["Id"] != null)
          {
              string str = "update tbl_conversation  SET [cust_ID] ='" + ddlcustomer.SelectedItem.Value + "'  ,[rep_ID] ='" + Convert.ToInt64(Session["Id"]) + "'  ,[conversation_description] ='" + txtdescriton.Text + "' ,[conversation_datetime] ='" + DateTime.Parse(Request.Form[txtconversation_datetime.UniqueID]) + "' ,[conversation_type] = '" + ddlconversationtype.SelectedItem.Value + "',[callback_datetime] ='" + DateTime.Parse(Request.Form[txtcallback.UniqueID]) + "',Role='Admin'   where conversation_ID='" + Convert.ToInt64(Request.QueryString["Pageid"]) + "'  ";
              c1.exexuteQry(str);
          }
          else
          {
              if (Session["RecId"] != null)
              {
                  string str = "update tbl_conversation  SET [cust_ID] ='" + ddlcustomer.SelectedItem.Value + "'  ,[rep_ID] ='" + Convert.ToInt64(Session["RecId"]) + "'  ,[conversation_description] ='" + txtdescriton.Text + "' ,[conversation_datetime] ='" + DateTime.Parse(Request.Form[txtconversation_datetime.UniqueID]) + "' ,[conversation_type] = '" + ddlconversationtype.SelectedItem.Value + "',[callback_datetime] ='" + DateTime.Parse(Request.Form[txtcallback.UniqueID]) + "',Role='User'   where conversation_ID='" + Convert.ToInt64(Request.QueryString["Pageid"]) + "' ";
                  c1.exexuteQry(str);
              }
          }
          Response.Write(@"<script langauge='text/javascript'>alert('...Update successfull...');</script>");
          Response.Redirect("Cust_Conversation.aspx");

      }

      fillgrid();
      clear();

  }
<pre><pre lang="c#"><pre lang="c#">
Posted
Comments
Richard MacCutchan 26-Feb-15 6:02am    
What is the question?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900