protected void btn_sess_Click(object sender, EventArgs e) { try { //Check remmarks Update or Not con = DBaccess.GetConnection(); string getperiodstr = ""; getperiodstr = "select * from( Select procagent,Agent_Name from (sELECT Agent_id as procagent FROM Procurementimport where Plant_Code='" + plant_Code + "' and Prdate='" + txt_FromDate.Text + "' and sessions='" + ddl_ses.SelectedItem.Text + "' GROUP BY Agent_id ) as procimport left join(Select agent_id,Agent_Name from Agent_Master where Plant_code='" + plant_Code + "') as am on procimport.procagent=am.Agent_Id ) as gg where gg.procagent=Agent_Name"; SqlCommand cmdperiod = new SqlCommand(getperiodstr, con); SqlDataAdapter sall = new SqlDataAdapter(cmdperiod); getmissagent.Rows.Clear(); sall.Fill(getmissagent); if (getmissagent.Rows.Count > 0) { GridView2.DataSource = getmissagent; GridView2.DataBind(); GridView2.Visible = true; } else { GridView2.Visible = false; int Rstatus = 0; Rstatus = Bllusers.Remarksstatussess(Company_code, plant_Code, txt_FromDate.Text, txt_FromDate.Text, ddl_ses.SelectedItem.Value); if (Rstatus >= 1) { string remarksmsg = "Check the RemarksUpdate..."; uscMsgBox1.AddMessage(remarksmsg, MessageBoxUsc_Message.enmMessageType.Success); } else { //Check the Data Already Transfer or Not int DataTrasfer = 0; DataTrasfer = Bllusers.DatatransferChecksess(Company_code, plant_Code, txt_FromDate.Text, txt_FromDate.Text, ddl_ses.SelectedItem.Value); if (DataTrasfer >= 1) { string remarksmsg = "Already DataTransfer..."; uscMsgBox1.AddMessage(remarksmsg, MessageBoxUsc_Message.enmMessageType.Success); } else { try { using (con = DBaccess.GetConnection()) { setBO(); SqlCommand cmdd = new SqlCommand("DELETE from PROCUREMENT where plant_code='" + plant_Code + "' and prdate between '" + txt_FromDate.Text + "' and '" + txt_FromDate.Text + "' and Sessions='" + ddl_ses.SelectedItem.Value + "' ", con); cmdd.ExecuteNonQuery(); impdbBL.deleteimportsess(rateBO); SqlCommand cmd = new SqlCommand(); SqlCommand cmd1 = new SqlCommand(); DataTable dtt = new DataTable(); SqlDataAdapter daa; daa = new SqlDataAdapter("SELECT * from PROCUREMENTIMPORT where plant_code='" + plant_Code + "' and prdate between '" + txt_FromDate.Text + "' and '" + txt_FromDate.Text + "' and Sessions='" + ddl_ses.SelectedItem.Value + "' ", con); daa.Fill(dtt); int count1 = dtt.Rows.Count; DataTable dt = new DataTable(); SqlDataAdapter da; da = new SqlDataAdapter("SELECT * from PROCUREMENT where plant_code='" + plant_Code + "' and prdate between '" + txt_FromDate.Text + "' and '" + txt_FromDate.Text + "' and Sessions='" + ddl_ses.SelectedItem.Value + "' ", con); da.Fill(dt); int count = dt.Rows.Count; cmd.Connection = con; cmd1.Connection = con; if (count == count1) { con.Close(); string countmsg = count.ToString() + "__Rows are inserted..."; uscMsgBox1.AddMessage(countmsg, MessageBoxUsc_Message.enmMessageType.Success); } else { SqlCommand cmd2 = new SqlCommand("DELETE from PROCUREMENT where plant_code='" + plant_Code + "' and prdate between '" + txt_FromDate.Text + "' and '" + txt_FromDate.Text + "' and Sessions='" + ddl_ses.SelectedItem.Value + "' ", con); cmd2.ExecuteNonQuery(); con.Close(); string countmsg = "Datas Not Inserted..."; uscMsgBox1.AddMessage(countmsg, MessageBoxUsc_Message.enmMessageType.Success); } } } catch (Exception ex) { con.Close(); using (con = DBaccess.GetConnection()) { SqlCommand cmd = new SqlCommand(); SqlCommand cmd1 = new SqlCommand(); DataTable dtt = new DataTable(); SqlDataAdapter daa; daa = new SqlDataAdapter("SELECT * from PROCUREMENTIMPORT where plant_code='" + plant_Code + "' and prdate between '" + txt_FromDate.Text + "' and '" + txt_FromDate.Text + "' and Sessions='" + ddl_ses.SelectedItem.Value + "' ", con); daa.Fill(dtt); int count1 = dtt.Rows.Count; DataTable dt = new DataTable(); SqlDataAdapter da; da = new SqlDataAdapter("SELECT * from PROCUREMENT where plant_code='" + plant_Code + "' and prdate between '" + txt_FromDate.Text + "' and '" + txt_FromDate.Text + "' and Sessions='" + ddl_ses.SelectedItem.Value + "' ", con); da.Fill(dt); int count = dt.Rows.Count; cmd.Connection = con; cmd1.Connection = con; if (count == count1) { con.Close(); string countmsg = count.ToString() + "__Rows are inserted..."; uscMsgBox1.AddMessage(countmsg, MessageBoxUsc_Message.enmMessageType.Success); } else { SqlCommand cmd2 = new SqlCommand("DELETE from PROCUREMENT where plant_code='" + plant_Code + "' and prdate between '" + txt_FromDate.Text + "' and '" + txt_FromDate.Text + "' and Sessions='" + ddl_ses.SelectedItem.Value + "' ", con); cmd2.ExecuteNonQuery(); con.Close(); string countmsg = "Datas Not Inserted..."; uscMsgBox1.AddMessage(countmsg, MessageBoxUsc_Message.enmMessageType.Success); } } } } } } } catch (Exception ex) { } }