Btn_Delete
ViewComm_Usercontrol1.Visible = false;
ViewComm_Usercontrol1.Btn_SelectClickedHandler +=
new
ViewComm_Usercontrol.EventHandler(ViewComm_Usercontrol1_BankCode_Btn_Select);
Btn_Delete.Attributes.Add("OnClick", "return confirm_delete();");
ViewComm_Usercontrol1.Visible = true;
ViewComm_Usercontrol1.ClearSelection();
void ViewComm_Usercontrol1_Submas_Btn_Select(object obj, EventArgs e)
{
// TextBox1.Text = ViewComm_Usercontrol1.SelectedValue.ToString().Trim().ToUpper();
TextBox1.Text = ViewComm_Usercontrol1.SelectedValue.ToString().Trim().ToUpper();
string Code1 = TextBox1.Text.ToString().Trim().ToUpper();
if (Code1 != "")
{
string strng1 = cfunction.sqlconnX();
SqlConnection Sqlconn = new SqlConnection();
Sqlconn.ConnectionString = strng1;
SqlDataReader Dr2;
string cmd2;
cmd2 = "select M_Code,M_Name from Bankmas where M_Code = '" + Code1 + "' ";
Sqlconn.Open();
SqlCommand Sqlcmd2 = new SqlCommand(cmd2, Sqlconn);
Sqlcmd2.CommandTimeout = 0;
Dr2 = Sqlcmd2.ExecuteReader();
if (Dr2.Read())
{
string Abc1 = Dr2["M_Name"].ToString().Trim();
TextBox2.Text = Abc1;
Session["UpMode"] = "M";
}
Dr2.Close();
Sqlconn.Close();
}
ViewComm_Usercontrol1.Visible = false;
TextBox2.Focus();
}
protected void Btn_Delete_Click(object sender, EventArgs e)
{
string Code1 = TextBox1.Text.ToString().Trim().ToUpper();
if (Code1 == "")
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "alert('Code Empty..');", true);
return;
}
string UserMno1 = Session["Usr_Mno"].ToString();
string TimeIn1 = "";
string Modnam1 = "";
string ProcsD1 = "";
string Prod1 = "";
string Det1 = "";
DateTime now = System.DateTime.Now;
string UserDateOut = Convert.ToDateTime(now).ToString("yyyy-MM-dd");
string UserTimeOut = Convert.ToDateTime(now).ToString("HH:mm:ss");
if (this.Btn_Delete.Enabled == true)
{
string strng2 = cfunction.sqlconnX();
SqlConnection Sqlconn2 = new SqlConnection();
Sqlconn2.ConnectionString = strng2;
SqlCommand DeleteCmd = new SqlCommand();
DeleteCmd = new SqlCommand("Delete From Bankmas Where M_Code = '" + Code1 + "' ", Sqlconn2);
DeleteCmd.CommandTimeout = 0;
Sqlconn2.Open();
DeleteCmd.ExecuteNonQuery();
Sqlconn2.Close();
Det1 = "Bank Code : " + Code1 + " -- Deleted";
TimeIn1 = Session["UserTimeIn"].ToString();
string UserName1 = Session["Clientname"].ToString();
string UserNm2_Encryp = cfunction2.Encrypt(UserName1).ToString().Trim();
Modnam1 = Session["MmodNameU"].ToString().Trim();
ProcsD1 = Session["LogUpdateDate"].ToString();
Prod1 = Session["ProductM"].ToString();
DeleteCmd = new SqlCommand("Insert usrfan (u_name,time_in,time_out,u_date," +
"menu_no,module_nam,procs_date,m_details,syselec)" +
" Values (" +
"'" + UserNm2_Encryp + "','" + TimeIn1 + "','" + UserTimeOut + "','" + UserDateOut + "'," +
"'" + UserMno1 + "','" + Modnam1 + "','" + ProcsD1 + "','" + Det1 + "','" + Prod1 + "')", Sqlconn2);
DeleteCmd.CommandTimeout = 0;
Sqlconn2.Open();
DeleteCmd.ExecuteNonQuery();
Sqlconn2.Close();
ScriptManager.RegisterStartupScript(this, this.GetType(), "msg", "alert('Code Sucessfully Deleted ..');", true);
TextBox1.Text = "";
TextBox2.Text = "";
}
}