private void btn_Clear_Click(object sender, EventArgs e) { try { for (int i = 0; i < Chk_Document_Type.ItemCount; i++) { Chk_Document_Type.SetItemChecked(i, false); } } catch (Exception ex) { } }
private void btn_Submit_Click(object sender, EventArgs e) { try { if (Chk_Document_Type.CheckedItems.Count > 0) { SplashScreenManager.ShowForm(this, typeof(Masters.WaitForm1), true, true, false); DataTable dt_Document_Check_Type = new DataTable(); dt_Document_Check_Type.Columns.AddRange(new DataColumn[6] { new DataColumn("Order_Id", typeof(int)), new DataColumn("Order_Task", typeof(int)), new DataColumn("User_Id", typeof(int)), new DataColumn("Document_Check_Type_Id", typeof(int)), new DataColumn("Check_Status", typeof(bool)), new DataColumn("Status", typeof(bool)), }); int Count = 0; Hashtable htcheck = new Hashtable(); DataTable dtcheck = new DataTable(); htcheck.Add("@Trans", "CHECK_BY_USER"); htcheck.Add("@Order_Id", Order_Id); htcheck.Add("@Order_Task", Order_Task_Id); htcheck.Add("@User_Id", User_Id); dtcheck = dataaccess.ExecuteSP("usp_Docuement_Check_Type", htcheck); if (dtcheck.Rows.Count > 0) { Count = int.Parse(dtcheck.Rows[0]["COUNT"].ToString()); } else { Count = 0; } for (int i = 0; i < Chk_Document_Type.ItemCount; i++) { string Document_Check_Status = Chk_Document_Type.GetItemCheckState(i).ToString(); bool doc_Status = false; if (Document_Check_Status == "Checked") { doc_Status = true; } else { doc_Status = false; } dt_Document_Check_Type.Rows.Add(Order_Id, Order_Task_Id, User_Id, int.Parse(Chk_Document_Type.GetItemValue(i).ToString()), doc_Status, "True"); } if (Count == 0) { // Insert using (Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ConnectionString)) { Con.Open(); using (SqlBulkCopy sqlBulk = new SqlBulkCopy(Con)) { sqlBulk.ColumnMappings.Add("Order_Id", "Order_Id"); sqlBulk.ColumnMappings.Add("Order_Task", "Order_Task"); sqlBulk.ColumnMappings.Add("User_Id", "User_Id"); sqlBulk.ColumnMappings.Add("Document_Check_Type_Id", "Document_Check_Type_Id"); sqlBulk.ColumnMappings.Add("Check_Status", "Check_Status"); sqlBulk.ColumnMappings.Add("Status", "Status"); sqlBulk.BulkCopyTimeout = 3000; sqlBulk.BatchSize = 1000; sqlBulk.DestinationTableName = "Tbl_Orders_Document_Check_Type_Status"; sqlBulk.WriteToServer(dt_Document_Check_Type); } Update_Insert_Update_Time(); } SplashScreenManager.CloseForm(); XtraMessageBox.Show("Dcoument Details Submitted"); // this is employee Order Entry form Event this.Mainfrom.Disable_Next_Task_Method(); this.Close(); } // Update if (Count > 0) { //update using (Con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["Con"].ConnectionString)) { using (SqlCommand command = new SqlCommand("usp_Docuement_Check_Type", Con)) { try { Con.Open(); //Creating temp table on database command.CommandText = "IF OBJECT_ID('tempdb..#TmpDocCheck') IS NOT NULL DROP TABLE #TmpDocCheck ; CREATE TABLE #TmpDocCheck(Order_Id int, Order_Task int ,User_Id int,Document_Check_Type_Id int,Check_Status bit,Status bit)"; command.ExecuteNonQuery(); //Bulk insert into temp table using (SqlBulkCopy bulkcopy = new SqlBulkCopy(Con)) { bulkcopy.BulkCopyTimeout = 660; bulkcopy.DestinationTableName = "#TmpDocCheck"; bulkcopy.WriteToServer(dt_Document_Check_Type); bulkcopy.Close(); } // Updating destination table, and dropping temp table command.CommandTimeout = 0; command.CommandText = "update Tbl_Orders_Document_Check_Type_Status set Tbl_Orders_Document_Check_Type_Status.Check_Status=#TmpDocCheck.Check_Status " + " from Tbl_Orders_Document_Check_Type_Status inner join #TmpDocCheck on Tbl_Orders_Document_Check_Type_Status.Order_Id=#TmpDocCheck.Order_Id " + " and Tbl_Orders_Document_Check_Type_Status.Order_Task =#TmpDocCheck.Order_Task and Tbl_Orders_Document_Check_Type_Status.User_Id=#TmpDocCheck.User_Id " + " and Tbl_Orders_Document_Check_Type_Status.Document_Check_Type_Id =#TmpDocCheck.Document_Check_Type_Id"; command.ExecuteNonQuery(); Update_Insert_Update_Time(); SplashScreenManager.CloseForm(); XtraMessageBox.Show("Dcoument Details Submitted"); // this is employee Order Entry form Event this.Mainfrom.Disable_Next_Task_Method(); this.Close(); } catch (Exception ex) { Con.Close(); SplashScreenManager.CloseForm(); XtraMessageBox.Show("Problem while Submitting data ; Pelase check with Administrator"); // Handle exception properly } finally { // SplashScreenManager.CloseForm(); Con.Close(); } } } } } else { XtraMessageBox.Show("Please Select any one Option"); } } catch (Exception ex) { DevExpress.XtraEditors.XtraMessageBox.Show(defaultLookAndFeel1.LookAndFeel, this, "Something Went Wrong Please Check with Administrator.", "Warning", MessageBoxButtons.OK); } finally { // Con.Close(); } }