private void Insert_Update_Delete_Data() { try { switch (lblMode.Text) { case J_Mode.Add: // all validation if (ValidateFields() == false) { return; } // Save Confirmation Message if (cmnService.J_SaveConfirmationMessage(ref txtPartyName) == true) { return; } // set the transaction as begin dmlService.J_BeginTransaction(); // insert query & execution strSQL = "INSERT INTO MST_PARTY (" + " BRANCH_ID," + " PARTY_CATEGORY_ID," + " PARTY_NAME," + " ADDRESS1," + " ADDRESS2," + " ADDRESS3," + " CITY," + " PIN," + " CONTACT_PERSON," + " MOBILE_NO," + " PHONE_NO," + " FAX," + " EMAIL_ID," + " VAT_NO," + " USER_ID," + " CREATE_DATE) " + " VALUES( " + J_Var.J_pBranchId + "," + " " + Support.GetItemData(cmbPartyCategory, cmbPartyCategory.SelectedIndex) + "," + " '" + cmnService.J_ReplaceQuote(txtPartyName.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtAddress1.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtAddress2.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtAddress3.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtCity.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtPin.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtContactPersonName.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtMobileNo.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtPhone.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtFaxNo.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtEmailID.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtVatNo.Text.Trim()) + "'," + " " + J_Var.J_pUserId + "," + " " + cmnService.J_DateOperator() + dtService.J_ConvertMMddyyyy(dmlService.J_ReturnServerDate()) + cmnService.J_DateOperator() + ")"; if (dmlService.J_ExecSql(strSQL) == false) { txtPartyName.Select(); return; } // get last inserted area id as per branch & user lngSearchId = dmlService.J_ReturnMaxValue("MST_PARTY", "PARTY_ID", " BRANCH_ID = " + J_Var.J_pBranchId + " " + "AND USER_ID = " + J_Var.J_pUserId + ""); if (lngSearchId == 0) { return; } // Transaction is commited dmlService.J_Commit(); // after insert data, the message is displayed cmnService.J_PanelMessage(J_PanelIndex.e00_DisplayText, J_Msg.AddModeSave); // all controls are cleared ClearControls(); txtPartyName.Select(); break; case J_Mode.Edit: // all validation if (ValidateFields() == false) { return; } // Save Confirmation Message if (cmnService.J_SaveConfirmationMessage(ref txtPartyName) == true) { return; } // set the transaction as begin dmlService.J_BeginTransaction(); // update query & execution strSQL = "UPDATE MST_PARTY " + "SET PARTY_CATEGORY_ID = " + Support.GetItemData(cmbPartyCategory, cmbPartyCategory.SelectedIndex) + ", " + " PARTY_NAME = '" + cmnService.J_ReplaceQuote(txtPartyName.Text.Trim()) + "'," + " ADDRESS1 = '" + cmnService.J_ReplaceQuote(txtAddress1.Text.Trim()) + "'," + " ADDRESS2 = '" + cmnService.J_ReplaceQuote(txtAddress2.Text.Trim()) + "'," + " ADDRESS3 = '" + cmnService.J_ReplaceQuote(txtAddress3.Text.Trim()) + "'," + " CITY = '" + cmnService.J_ReplaceQuote(txtCity.Text.Trim()) + "'," + " PIN = '" + cmnService.J_ReplaceQuote(txtPin.Text.Trim()) + "'," + " CONTACT_PERSON = '" + cmnService.J_ReplaceQuote(txtContactPersonName.Text.Trim()) + "'," + " MOBILE_NO = '" + cmnService.J_ReplaceQuote(txtMobileNo.Text.Trim()) + "'," + " PHONE_NO = '" + cmnService.J_ReplaceQuote(txtPhone.Text.Trim()) + "'," + " FAX = '" + cmnService.J_ReplaceQuote(txtFaxNo.Text.Trim()) + "'," + " EMAIL_ID = '" + cmnService.J_ReplaceQuote(txtEmailID.Text.Trim()) + "'," + " VAT_NO = '" + cmnService.J_ReplaceQuote(txtVatNo.Text.Trim()) + "'" + "WHERE PARTY_ID = " + lngSearchId + ""; if (dmlService.J_ExecSql(strSQL) == false) { txtPartyName.Select(); return; } // Transaction is commited dmlService.J_Commit(); // after insert data, the message is displayed cmnService.J_PanelMessage(J_PanelIndex.e00_DisplayText, J_Msg.EditModeSave); // all controls are cleared ClearControls(); // Refresh the view grid strSQL = strQuery + "ORDER BY " + strOrderBy; if (dsetGridClone != null) { dsetGridClone.Clear(); } dsetGridClone = dmlService.J_ShowDataInGrid(ref ViewGrid, strSQL, strMatrix); //Show Data into the Grid if (dsetGridClone == null) { return; } // change the buttons status lblMode.Text = J_Mode.View; cmnService.J_StatusButton(this, lblMode.Text); BtnDelete.BackColor = Color.LightGray; BtnDelete.Enabled = false; ControlVisible(false); dmlService.J_setGridPosition(ref this.ViewGrid, dsetGridClone, "PARTY_ID", lngSearchId); break; case J_Mode.Delete: break; } } catch (Exception err_handler) { dmlService.J_Rollback(); cmnService.J_UserMessage(err_handler.Message); } }
private void Insert_Update_Delete_Data() { try { string strLastDate = string.Empty; //----------------------------------------------------------- if (mskLastDate.Text == " / /") { strLastDate = "null"; } else { strLastDate = cmnService.J_DateOperator() + dtService.J_ConvertMMddyyyy(mskLastDate.Text) + cmnService.J_DateOperator(); } switch (lblMode.Text) { case J_Mode.Add: // all validation if (ValidateFields() == false) { return; } // Save Confirmation Message if (cmnService.J_SaveConfirmationMessage(ref txtPrefix) == true) { return; } // set the transaction as begin dmlService.J_BeginTransaction(); // Area Code Logic //mf.MF_GetAreaCode(dmlService.J_pCommand, J_Var.J_pBranchCode) // insert query & execution strSQL = "INSERT INTO MST_INVOICE_SERIES (" + " BRANCH_ID," + " COMPANY_ID," + " PREFIX," + " START_NO," + " LAST_NO," + " LAST_DATE," + " HEADER_DISPLAY_TEXT," + " USER_ID," + " CREATE_DATE) " + " VALUES( " + J_Var.J_pBranchId + "," + " " + Convert.ToInt32(Support.GetItemData(cmbCompanyName, cmbCompanyName.SelectedIndex)) + "," + " '" + cmnService.J_ReplaceQuote(txtPrefix.Text.Trim()) + "'," + " " + Convert.ToInt32(cmnService.J_NumericData(txtStartNo)) + "," + " " + Convert.ToInt32(cmnService.J_NumericData(txtStartNo)) + "," + " " + strLastDate + "," + " '" + cmnService.J_ReplaceQuote(txtDisplayText.Text.Trim()) + "'," + " " + J_Var.J_pUserId + "," + " " + cmnService.J_DateOperator() + dtService.J_ConvertMMddyyyy(dmlService.J_ReturnServerDate()) + cmnService.J_DateOperator() + ")"; if (dmlService.J_ExecSql(strSQL) == false) { cmbCompanyName.Select(); return; } // get last inserted area id as per branch & user lngSearchId = dmlService.J_ReturnMaxValue("MST_INVOICE_SERIES", "INVOICE_SERIES_ID", " BRANCH_ID = " + J_Var.J_pBranchId + " " + "AND USER_ID = " + J_Var.J_pUserId + ""); if (lngSearchId == 0) { return; } // Transaction is commited dmlService.J_Commit(); // after insert data, the message is displayed cmnService.J_PanelMessage(J_PanelIndex.e00_DisplayText, J_Msg.AddModeSave); // all controls are cleared ClearControls(); cmbCompanyName.Select(); break; case J_Mode.Edit: // all validation if (ValidateFields() == false) { return; } // Save Confirmation Message if (cmnService.J_SaveConfirmationMessage(ref txtPrefix) == true) { return; } // set the transaction as begin dmlService.J_BeginTransaction(); // update query & execution strSQL = "UPDATE MST_INVOICE_SERIES " + "SET COMPANY_ID = " + Convert.ToInt32(Support.GetItemData(cmbCompanyName, cmbCompanyName.SelectedIndex)) + "," + " PREFIX = '" + cmnService.J_ReplaceQuote(txtPrefix.Text.Trim()) + "'," + " START_NO = " + Convert.ToInt32(cmnService.J_NumericData(txtStartNo)) + "," + " LAST_NO = " + Convert.ToInt32(cmnService.J_NumericData(txtStartNo)) + "," + " LAST_DATE = " + strLastDate + "," + " HEADER_DISPLAY_TEXT = '" + cmnService.J_ReplaceQuote(txtDisplayText.Text.Trim()) + "' " + "WHERE INVOICE_SERIES_ID = " + lngSearchId + ""; if (dmlService.J_ExecSql(strSQL) == false) { cmbCompanyName.Select(); return; } // Transaction is commited dmlService.J_Commit(); // after insert data, the message is displayed cmnService.J_PanelMessage(J_PanelIndex.e00_DisplayText, J_Msg.EditModeSave); // all controls are cleared ClearControls(); // Refresh the view grid strSQL = strQuery + "ORDER BY " + strOrderBy; if (dsetGridClone != null) { dsetGridClone.Clear(); } dsetGridClone = dmlService.J_ShowDataInGrid(ref ViewGrid, strSQL, strMatrix); //Show Data into the Grid if (dsetGridClone == null) { return; } // change the buttons status lblMode.Text = J_Mode.View; cmnService.J_StatusButton(this, lblMode.Text); BtnDelete.BackColor = Color.LightGray; BtnDelete.Enabled = false; ControlVisible(false); dmlService.J_setGridPosition(ref this.ViewGrid, dsetGridClone, "INVOICE_SERIES_ID", lngSearchId); break; case J_Mode.Delete: break; } } catch (Exception err_handler) { dmlService.J_Rollback(); cmnService.J_UserMessage(err_handler.Message); } }
private void Insert_Update_Delete_Data() { try { switch (lblMode.Text) { case J_Mode.Add: // all validation if (ValidateFields() == false) { return; } // Save Confirmation Message if (cmnService.J_SaveConfirmationMessage(ref txtCompanyName) == true) { return; } // set the transaction as begin dmlService.J_BeginTransaction(); // insert query & execution strSQL = "INSERT INTO MST_COMPANY (" + " BRANCH_ID," + " COMPANY_NAME," + " ADDRESS1," + " ADDRESS2," + " ADDRESS3," + " CITY," + " PIN," + " CONTACT_NO," + " FAX," + " EMAIL_ID," + " WEB_SITE," + " CONTACT_PERSON," + " SIGNATORY," + " VAT_NO," + " CST_NO," + " SERVICE_TAX_NO," + " PAN," + " USER_ID," + " CREATE_DATE, " + " CIN_NO, " + " MAX_DAYS_PERMIT, " + " BANK_DETAIL1, " + //-- 2016/02/18 ANIK " BANK_DETAIL2, " + " BANK_DETAIL3, " + " BANK_DETAIL4, " + " BANK_DETAIL5)" + " VALUES( " + J_Var.J_pBranchId + "," + " '" + cmnService.J_ReplaceQuote(txtCompanyName.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtAddress1.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtAddress2.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtAddress3.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtCity.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtPin.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtContactNo.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtFax.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtEmailID.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtWebsite.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtContactPersonName.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtSignatory.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtVATNo.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtCSTNo.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtServiceTaxNo.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtPAN.Text.Trim()) + "'," + " " + J_Var.J_pUserId + "," + " " + cmnService.J_DateOperator() + dtService.J_ConvertMMddyyyy(dmlService.J_ReturnServerDate()) + cmnService.J_DateOperator() + ", " + " '" + cmnService.J_ReplaceQuote(txtCINNo.Text.Trim()) + "'," + " " + cmnService.J_ReplaceQuote(txtMaxPermitedDays.Text.Trim()) + ", " + " '" + cmnService.J_ReplaceQuote(txtBankDetails1.Text.Trim()) + "', " + //-- 2016/02/18 ANIK " '" + cmnService.J_ReplaceQuote(txtBankDetails2.Text.Trim()) + "', " + " '" + cmnService.J_ReplaceQuote(txtBankDetails3.Text.Trim()) + "', " + " '" + cmnService.J_ReplaceQuote(txtBankDetails4.Text.Trim()) + "', " + " '" + cmnService.J_ReplaceQuote(txtBankDetails5.Text.Trim()) + "')"; if (dmlService.J_ExecSql(strSQL) == false) { txtCompanyName.Select(); return; } // get last inserted area id as per branch & user lngSearchId = dmlService.J_ReturnMaxValue("MST_COMPANY", "COMPANY_ID", " BRANCH_ID = " + J_Var.J_pBranchId + " " + "AND USER_ID = " + J_Var.J_pUserId + ""); if (lngSearchId == 0) { return; } // Transaction is commited dmlService.J_Commit(); // after insert data, the message is displayed cmnService.J_PanelMessage(J_PanelIndex.e00_DisplayText, J_Msg.AddModeSave); // all controls are cleared ClearControls(); txtCompanyName.Select(); break; case J_Mode.Edit: // all validation if (ValidateFields() == false) { return; } // Save Confirmation Message if (cmnService.J_SaveConfirmationMessage(ref txtCompanyName) == true) { return; } // set the transaction as begin dmlService.J_BeginTransaction(); // update query & execution strSQL = "UPDATE MST_COMPANY " + "SET COMPANY_NAME = '" + cmnService.J_ReplaceQuote(txtCompanyName.Text.Trim()) + "'," + " ADDRESS1 = '" + cmnService.J_ReplaceQuote(txtAddress1.Text.Trim()) + "'," + " ADDRESS2 = '" + cmnService.J_ReplaceQuote(txtAddress2.Text.Trim()) + "'," + " ADDRESS3 = '" + cmnService.J_ReplaceQuote(txtAddress3.Text.Trim()) + "'," + " CITY = '" + cmnService.J_ReplaceQuote(txtCity.Text.Trim()) + "'," + " PIN = '" + cmnService.J_ReplaceQuote(txtPin.Text.Trim()) + "'," + " CONTACT_NO = '" + cmnService.J_ReplaceQuote(txtContactNo.Text.Trim()) + "'," + " FAX = '" + cmnService.J_ReplaceQuote(txtFax.Text.Trim()) + "'," + " EMAIL_ID = '" + cmnService.J_ReplaceQuote(txtEmailID.Text.Trim()) + "'," + " WEB_SITE = '" + cmnService.J_ReplaceQuote(txtWebsite.Text.Trim()) + "'," + " CONTACT_PERSON = '" + cmnService.J_ReplaceQuote(txtContactPersonName.Text.Trim()) + "'," + " SIGNATORY = '" + cmnService.J_ReplaceQuote(txtSignatory.Text.Trim()) + "'," + " VAT_NO = '" + cmnService.J_ReplaceQuote(txtVATNo.Text.Trim()) + "'," + " CST_NO = '" + cmnService.J_ReplaceQuote(txtCSTNo.Text.Trim()) + "'," + " SERVICE_TAX_NO = '" + cmnService.J_ReplaceQuote(txtServiceTaxNo.Text.Trim()) + "'," + " PAN = '" + cmnService.J_ReplaceQuote(txtPAN.Text.Trim()) + "', " + " CIN_NO = '" + cmnService.J_ReplaceQuote(txtCINNo.Text.Trim()) + "', " + " MAX_DAYS_PERMIT = " + cmnService.J_ReplaceQuote(txtMaxPermitedDays.Text.Trim()) + ", " + " BANK_DETAIL1 = '" + cmnService.J_ReplaceQuote(txtBankDetails1.Text.Trim()) + "', " + //-- 2016/02/18 ANIK " BANK_DETAIL2 = '" + cmnService.J_ReplaceQuote(txtBankDetails2.Text.Trim()) + "', " + " BANK_DETAIL3 = '" + cmnService.J_ReplaceQuote(txtBankDetails3.Text.Trim()) + "', " + " BANK_DETAIL4 = '" + cmnService.J_ReplaceQuote(txtBankDetails4.Text.Trim()) + "', " + " BANK_DETAIL5 = '" + cmnService.J_ReplaceQuote(txtBankDetails5.Text.Trim()) + "' " + "WHERE COMPANY_ID = " + lngSearchId + ""; if (dmlService.J_ExecSql(strSQL) == false) { txtCompanyName.Select(); return; } // Transaction is commited dmlService.J_Commit(); // after insert data, the message is displayed cmnService.J_PanelMessage(J_PanelIndex.e00_DisplayText, J_Msg.EditModeSave); // all controls are cleared ClearControls(); // Refresh the view grid strSQL = strQuery + "ORDER BY " + strOrderBy; if (dsetGridClone != null) { dsetGridClone.Clear(); } dsetGridClone = dmlService.J_ShowDataInGrid(ref ViewGrid, strSQL, strMatrix); //Show Data into the Grid if (dsetGridClone == null) { return; } // change the buttons status lblMode.Text = J_Mode.View; cmnService.J_StatusButton(this, lblMode.Text); BtnDelete.BackColor = Color.LightGray; BtnDelete.Enabled = false; ControlVisible(false); dmlService.J_setGridPosition(ref this.ViewGrid, dsetGridClone, "COMPANY_ID", lngSearchId); break; case J_Mode.Delete: break; } } catch (Exception err_handler) { dmlService.J_Rollback(); cmnService.J_UserMessage(err_handler.Message); } }
private void Insert_Update_Delete_Data() { try { switch (lblMode.Text) { case J_Mode.Add: // all validation if (ValidateFields() == false) { return; } // Save Confirmation Message if (cmnService.J_SaveConfirmationMessage(ref txtTaxDesc) == true) { return; } // set the transaction as begin dmlService.J_BeginTransaction(); // Area Code Logic //mf.MF_GetAreaCode(dmlService.J_pCommand, J_Var.J_pBranchCode) // insert query & execution strSQL = "INSERT INTO MST_TAX (" + " BRANCH_ID," + " TAX_DESC," + " TAX_RATE," + " USER_ID," + " CREATE_DATE) " + " VALUES( " + J_Var.J_pBranchId + "," + " '" + cmnService.J_ReplaceQuote(txtTaxDesc.Text.Trim().ToUpper()) + "'," + " " + Convert.ToDouble(cmnService.J_ReplaceQuote(txtTaxPercentage.Text.Trim())) + "," + " " + J_Var.J_pUserId + "," + " " + cmnService.J_DateOperator() + dtService.J_ConvertMMddyyyy(dmlService.J_ReturnServerDate()) + cmnService.J_DateOperator() + ")"; if (dmlService.J_ExecSql(strSQL) == false) { txtTaxDesc.Select(); return; } // get last inserted tax id as per branch & user lngSearchId = dmlService.J_ReturnMaxValue("MST_TAX", "TAX_ID", " BRANCH_ID = " + J_Var.J_pBranchId + " " + "AND USER_ID = " + J_Var.J_pUserId + ""); if (lngSearchId == 0) { return; } // Transaction is commited dmlService.J_Commit(); // after insert data, the message is displayed cmnService.J_PanelMessage(J_PanelIndex.e00_DisplayText, J_Msg.AddModeSave); // all controls are cleared ClearControls(); txtTaxDesc.Select(); break; case J_Mode.Edit: // all validation if (ValidateFields() == false) { return; } // Save Confirmation Message if (cmnService.J_SaveConfirmationMessage(ref txtTaxDesc) == true) { return; } // set the transaction as begin dmlService.J_BeginTransaction(); // update query & execution strSQL = "UPDATE MST_TAX " + "SET TAX_DESC = '" + cmnService.J_ReplaceQuote(txtTaxDesc.Text.Trim().ToUpper()) + "'," + " TAX_RATE = " + Convert.ToDouble(cmnService.J_ReplaceQuote(txtTaxPercentage.Text.Trim())) + " " + "WHERE TAX_ID = " + lngSearchId + ""; if (dmlService.J_ExecSql(strSQL) == false) { txtTaxDesc.Select(); return; } // Transaction is commited dmlService.J_Commit(); // after insert data, the message is displayed cmnService.J_PanelMessage(J_PanelIndex.e00_DisplayText, J_Msg.EditModeSave); // all controls are cleared ClearControls(); // Refresh the view grid strSQL = strQuery + "ORDER BY " + strOrderBy; if (dsetGridClone != null) { dsetGridClone.Clear(); } dsetGridClone = dmlService.J_ShowDataInGrid(ref ViewGrid, strSQL, strMatrix); //Show Data into the Grid if (dsetGridClone == null) { return; } // change the buttons status lblMode.Text = J_Mode.View; cmnService.J_StatusButton(this, lblMode.Text); BtnDelete.BackColor = Color.LightGray; BtnDelete.Enabled = false; ControlVisible(false); dmlService.J_setGridPosition(ref this.ViewGrid, dsetGridClone, "TAX_ID", lngSearchId); break; case J_Mode.Delete: break; } } catch (Exception err_handler) { dmlService.J_Rollback(); cmnService.J_UserMessage(err_handler.Message); } }
private void Insert_Update_Delete_Data() { try { string strLoginId = string.Empty; int intCategory = 0; switch (lblMode.Text) { case J_Mode.Add: // all validations if (ValidateFields() == false) { return; } // Save Confirmation Message if (cmnService.J_SaveConfirmationMessage(ref txtUserName) == true) { return; } intCategory = Convert.ToInt32(chkActiveInactive.Checked == true ? "0" : "1"); // Begin Transaction dmlService.J_BeginTransaction(); strSQL = "INSERT INTO MST_USER (" + " BRANCH_ID," + " USER_CODE," + " DISPLAY_NAME," + " LOGIN_ID," + " USER_PASSWORD," + " USER_CATEGORY) " + " VALUES( " + J_Var.J_pBranchId + "," + " ''," + " '" + cmnService.J_ReplaceQuote(txtUserName.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtLoginId.Text.Trim()) + "'," + " '" + cmnService.J_ReplaceQuote(txtPassword.Text.Trim()) + "'," + " " + intCategory + ")"; if (dmlService.J_ExecSql(strSQL) == false) { txtUserName.Select(); return; } lngSearchId = dmlService.J_ReturnMaxValue("MST_USER", "USER_ID", " BRANCH_ID = " + J_Var.J_pBranchId + " " + "AND " + cmnService.J_SQLDBFormat("LOGIN_ID", J_SQLColFormat.UCase) + " = '" + cmnService.J_ReplaceQuote(txtLoginId.Text.Trim().ToUpper()) + "'"); if (lngSearchId == 0) { return; } dmlService.J_Commit(); cmnService.J_PanelMessage(J_PanelIndex.e00_DisplayText, J_Msg.AddModeSave); ClearControls(); txtUserName.Select(); break; case J_Mode.Edit: // For Modify if (ValidateFields() == false) { return; } if (cmnService.J_SaveConfirmationMessage(ref txtUserName) == true) { return; } intCategory = Convert.ToInt32(chkActiveInactive.Checked == true ? "0" : "1"); // Begin Transaction dmlService.J_BeginTransaction(); strSQL = "UPDATE MST_USER " + "SET DISPLAY_NAME = '" + cmnService.J_ReplaceQuote(txtUserName.Text.Trim()) + "'," + " USER_CATEGORY = " + intCategory + " "; // If reset password is checked then update password too if (chkResetPassword.Checked == true) { strSQL = strSQL + ", USER_PASSWORD = '******' "; } strSQL = strSQL + "WHERE USER_ID = " + lngSearchId + ""; if (dmlService.J_ExecSql(strSQL) == false) { txtUserName.Select(); return; } dmlService.J_Commit(); cmnService.J_PanelMessage(J_PanelIndex.e00_DisplayText, J_Msg.EditModeSave); ClearControls(); strSQL = strQuery + "ORDER BY " + strOrderBy; if (dsetGridClone != null) { dsetGridClone.Clear(); } dsetGridClone = dmlService.J_ShowDataInGrid(ref ViewGrid, strSQL, strMatrix); //Show Data into the Grid if (dsetGridClone == null) { return; } lblMode.Text = J_Mode.View; cmnService.J_StatusButton(this, lblMode.Text); BtnDelete.BackColor = Color.LightGray; BtnDelete.Enabled = false; ControlVisible(false); dmlService.J_setGridPosition(ref ViewGrid, dsetGridClone, "USER_ID", lngSearchId); break; case J_Mode.Delete: break; } } catch (Exception err_handler) { dmlService.J_Rollback(); cmnService.J_UserMessage(err_handler.Message); } }