private void btnSave_Click(object sender, RoutedEventArgs e) { try { bValidation = false; BeforeUpdate(); if (bValidation == false) { MASTERMEMBER mmMst = (from mas in db.MASTERMEMBERs where mas.MEMBER_CODE == dMember_Code select mas).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(mmMst); mmMst.Tdf_PaymentDate = Convert.ToDateTime(dtpPaymentDate.SelectedDate); mmMst.TDF_AMOUNT = Convert.ToDecimal(txtAmount.Text); db.SaveChanges(); var NewData = new JSonHelper().ConvertObjectToJSon(mmMst); AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERMEMBER", "TDF MANUAL ENTRY"); MessageBox.Show("Saved Sucessfully"); fClear(); } } catch (Exception ex) { ExceptionLogging.SendErrorToText(ex); } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { try { if (ID != 0) { if (MessageBox.Show("Do you want to Delete this '" + txtNubeBranch.Text + "'", "DELETE", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { MASTERNUBEBRANCH ms = db.MASTERNUBEBRANCHes.Where(x => x.NUBE_BRANCH_CODE == ID).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(ms); db.MASTERNUBEBRANCHes.Remove(ms); db.SaveChanges(); AppLib.EventHistory(this.Tag.ToString(), 2, OldData, "", "MASTERNUBEBRANCH"); MessageBox.Show("Deleted Successfully!", "DELETED", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } } else { MessageBox.Show("Please Select Any NUBE Branch! (Double Click to Select)"); } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { try { if (ID != 0) { if (MessageBox.Show("Do you want to delete '" + txtStateName.Text + "'", "DELETE", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { MASTERSTATE c = db.MASTERSTATEs.Where(x => x.STATE_CODE == ID).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(c); db.MASTERSTATEs.Remove(c); db.SaveChanges(); AppLib.EventHistory(this.Tag.ToString(), 2, OldData, "", "MASTERSTATE"); MessageBox.Show("Deleted Successfully", "DELETED", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } } else { MessageBox.Show("Please Select Any State! (Double Click to Select)", "SELECT", MessageBoxButton.OK, MessageBoxImage.Information); } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { try { if (ID != 0) { var s = txtBankName.Text; if (MessageBox.Show("Do you want to Delete '" + s + "'?", "Delete Confirmation", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { decimal i = Convert.ToDecimal(ID); MASTERBANK mb = db.MASTERBANKs.Where(x => x.BANK_CODE == ID).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(mb); db.MASTERBANKs.Remove(mb); db.SaveChanges(); AppLib.EventHistory(this.Tag.ToString(), 2, OldData, "", "MASTERBANK"); MessageBox.Show("Deleted Successfully"); ClearForm(); LoadWindow(); } } else { MessageBox.Show("Please Select Any Bank! (Double Click to Select)"); } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { try { if (txtCountry.Text == "") { MessageBox.Show("No record to delete", "DELETE", MessageBoxButton.OK, MessageBoxImage.Exclamation); } else { if (MessageBox.Show("Do you want to delete '" + txtCountry.Text + "'?", "DELETE CONFIRMATION", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { CountrySetup c = db.CountrySetups.Where(x => x.ID == ID).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(c); db.CountrySetups.Remove(c); db.SaveChanges(); AppLib.EventHistory(this.Tag.ToString(), 2, OldData, "", "CountrySetup"); MessageBox.Show("Deleted Successfully", "DELETED", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnDelete_Click(object sender, RoutedEventArgs e) { try { if (iID == 1) { MessageBox.Show("You Can't Delete This User! , Contact Administrator!", "User Restricted!", MessageBoxButton.OK, MessageBoxImage.Information); } else if (iID != 0) { if (MessageBox.Show("Do you want to delete '" + txtUserName.Text + "'", "DELETE", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { UserAccount usc = (from x in db.UserAccounts where x.UserId == iID select x).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(usc); db.UserAccounts.Remove(usc); db.SaveChanges(); AppLib.EventHistory(this.Tag.ToString(), 2, OldData, "", "UserAccount"); MessageBox.Show("Deleted Successfully", "DELETED", MessageBoxButton.OK, MessageBoxImage.Information); fClear(); } } else { MessageBox.Show("Please Select Any User! (Double Click to Select)", "SELECT", MessageBoxButton.OK, MessageBoxImage.Information); } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (cmbCountry.Text == "") { MessageBox.Show("Enter Bank..", "Information"); } else if (txtStateName.Text == "") { MessageBox.Show("Enter Branchcode..", "Information"); } else { if (MessageBox.Show("Do you want to save this record?", "SAVE", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (ID != 0) { decimal id = (decimal)ID; var s = cmbCountry.Text.ToString(); MASTERSTATE mb = db.MASTERSTATEs.Where(x => x.STATE_CODE == id).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(mb); mb.Country = Convert.ToDecimal(cmbCountry.SelectedValue); mb.STATE_NAME = txtStateName.Text; db.SaveChanges(); AppLib.lstMASTERSTATE = db.MASTERSTATEs.OrderBy(x => x.STATE_NAME).ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(mb); AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERSTATE"); MessageBox.Show("Saved Successfully", "Saved"); FormClear(); } else { MASTERSTATE mb = new MASTERSTATE(); mb.Country = Convert.ToDecimal(cmbCountry.SelectedValue); mb.STATE_NAME = txtStateName.Text; db.MASTERSTATEs.Add(mb); db.SaveChanges(); AppLib.lstMASTERSTATE = db.MASTERSTATEs.OrderBy(x => x.STATE_NAME).ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(mb); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "MASTERSTATE"); MessageBox.Show("Saved Successfully", "Saved"); FormClear(); } } } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (txtPersonTitle.Text == "") { MessageBox.Show("Enter Title...", "Information", MessageBoxButton.OK, MessageBoxImage.Error); txtPersonTitle.Focus(); } else { if (MessageBox.Show("Do you want to save this record?", "SAVE CONFIRMATION", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { if (ID != 0) { NameTitleSetup ms = db.NameTitleSetups.Where(x => x.ID == ID).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(ms); ms.TitleName = txtPersonTitle.Text; db.SaveChanges(); AppLib.lstNameTitleSetup = db.NameTitleSetups.ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(ms); AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "NameTitleSetup"); MessageBox.Show("Saved Successfully!", "SAVED", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } else { var pt = (from p in db.NameTitleSetups where p.TitleName == txtPersonTitle.Text select p).SingleOrDefault(); if (pt != null) { MessageBox.Show("'" + txtPersonTitle.Text + "' Already exist.Enter new Title.", "Information", MessageBoxButton.OK, MessageBoxImage.Error); txtPersonTitle.Focus(); } else { NameTitleSetup ms = new NameTitleSetup(); ms.TitleName = txtPersonTitle.Text; db.NameTitleSetups.Add(ms); db.SaveChanges(); AppLib.lstNameTitleSetup = db.NameTitleSetups.ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(ms); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "NameTitleSetup"); MessageBox.Show("Saved Successfully!", "SAVED", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } } } } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (txtCity.Text == "") { MessageBox.Show("Enter City...", "Information", MessageBoxButton.OK, MessageBoxImage.Exclamation); } else if (cmbState.Text == "") { MessageBox.Show("Enter State...", "Information", MessageBoxButton.OK, MessageBoxImage.Exclamation); } else { if (MessageBox.Show("Do you wanrt to save this record?", "SAVE CONFIRMATION", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (ID != 0) { MASTERCITY c = db.MASTERCITies.Where(x => x.CITY_CODE == ID).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(c); c.CITY_NAME = txtCity.Text; c.STATE_CODE = Convert.ToDecimal(cmbState.SelectedValue); db.SaveChanges(); AppLib.lstMASTERCITY = db.MASTERCITies.OrderBy(x => x.CITY_NAME).ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(c); AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERCITY"); MessageBox.Show("Saved Successfully!", "Saved", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } else { MASTERCITY c = new MASTERCITY(); c.CITY_NAME = txtCity.Text; c.STATE_CODE = Convert.ToDecimal(cmbState.SelectedValue); db.MASTERCITies.Add(c); db.SaveChanges(); AppLib.lstMASTERCITY = db.MASTERCITies.OrderBy(x => x.CITY_NAME).ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(c); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "MASTERCITY"); MessageBox.Show("Saved Successfully!", "Saved", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } } } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (txtNubeBranch.Text == "") { MessageBox.Show("Enter NubeBranch...", "Information"); } else { if (MessageBox.Show("Do you wanrt to save this record?", "SAVE CONFIRMATION", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (ID != 0) { MASTERNUBEBRANCH ms = db.MASTERNUBEBRANCHes.Where(x => x.NUBE_BRANCH_CODE == ID).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(ms); ms.NUBE_BRANCH_NAME = txtNubeBranch.Text; ms.NUBE_BRANCH_USERCODE = txtNUBECODE.Text; db.SaveChanges(); var NewData = new JSonHelper().ConvertObjectToJSon(ms); AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERNUBEBRANCH"); MessageBox.Show("Saved Successfully!", "Saved", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } else { if (db.MASTERNUBEBRANCHes.Where(x => x.NUBE_BRANCH_NAME == txtNubeBranch.Text).Select(x => x.NUBE_BRANCH_NAME).FirstOrDefault() == txtNubeBranch.Text.ToString()) { MessageBox.Show("'" + txtNubeBranch.Text + "' already Name exist! Enter new Name...!", "Information"); } else { MASTERNUBEBRANCH ms = new MASTERNUBEBRANCH(); ms.NUBE_BRANCH_NAME = txtNubeBranch.Text; ms.NUBE_BRANCH_USERCODE = txtNUBECODE.Text; db.MASTERNUBEBRANCHes.Add(ms); db.SaveChanges(); var NewData = new JSonHelper().ConvertObjectToJSon(ms); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "MASTERNUBEBRANCH"); MessageBox.Show("Saved Successfully!", "Saved", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } } } } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (txtCountry.Text == "") { MessageBox.Show("Enter Country...", "Information"); txtCountry.Focus(); } else { if (MessageBox.Show("Do you wanrt to save this record?", "SAVE CONFIRMATION", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (db.CountrySetups.Where(x => x.CountryName == txtCountry.Text).Select(x => x.CountryName).FirstOrDefault() == txtCountry.Text.ToString()) { MessageBox.Show("'" + txtCountry.Text + "' already exist! Enter new Country...", "Information"); } else if (ID != 0) { CountrySetup c = db.CountrySetups.Where(x => x.ID == ID).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(c); c.CountryName = txtCountry.Text; db.SaveChanges(); AppLib.lstCountrySetup = db.CountrySetups.OrderBy(x => x.CountryName).ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(c); AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "CountrySetup"); MessageBox.Show("Saved Successfully!", "Saved", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } else { CountrySetup c = new CountrySetup(); c.CountryName = txtCountry.Text; db.CountrySetups.Add(c); db.SaveChanges(); AppLib.lstCountrySetup = db.CountrySetups.OrderBy(x => x.CountryName).ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(c); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "CountrySetup"); MessageBox.Show("Saved Successfully!", "Saved", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } } } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (txtReasonName.Text == "") { MessageBox.Show("Enter Reason...", "Information", MessageBoxButton.OK, MessageBoxImage.Error); txtReasonName.Focus(); } else if (chkIsBefitValid.IsChecked == true && string.IsNullOrEmpty(txtMinimumYear.Text)) { MessageBox.Show("Enter Minimum Year...", "Information", MessageBoxButton.OK, MessageBoxImage.Error); txtMinimumYear.Focus(); } else if (chkIsBefitValid.IsChecked == true && string.IsNullOrEmpty(txtMinimumRefund.Text)) { MessageBox.Show("Enter Minimum Refund...", "Information", MessageBoxButton.OK, MessageBoxImage.Error); txtMinimumRefund.Focus(); } else if (chkIsBefitValid.IsChecked == true && string.IsNullOrEmpty(txtMAximumRefund.Text)) { MessageBox.Show("Enter Maximum Refund...", "Information", MessageBoxButton.OK, MessageBoxImage.Error); txtMAximumRefund.Focus(); } else if (chkIsBefitValid.IsChecked == true && string.IsNullOrEmpty(txtAmnt1.Text)) { MessageBox.Show("Enter Amount1...", "Information", MessageBoxButton.OK, MessageBoxImage.Error); txtAmnt1.Focus(); } else if (chkIsBefitValid.IsChecked == true && string.IsNullOrEmpty(txtAmnt2.Text)) { MessageBox.Show("Enter Amount2...", "Information", MessageBoxButton.OK, MessageBoxImage.Error); txtAmnt2.Focus(); } else { if (MessageBox.Show("Do you want to save this record?", "SAVE CONFIRMATION", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { if (ID != 0) { MASTERRESIGNSTATU ms = db.MASTERRESIGNSTATUS.Where(x => x.RESIGNSTATUS_CODE == ID).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(ms); ms.RESIGNSTATUS_NAME = txtReasonName.Text; if (chkIsBefitValid.IsChecked == true) { ms.IsBenefitValid = Convert.ToBoolean(chkIsBefitValid.IsChecked); ms.MinimumYear = Convert.ToInt32(txtMinimumYear.Text); ms.MinimumRefund = Convert.ToInt32(txtMinimumRefund.Text); ms.MaximumRefund = Convert.ToInt32(txtMAximumRefund.Text); ms.AmtPerYear1 = Convert.ToInt32(txtAmnt1.Text); ms.AmtPerYear2 = Convert.ToInt32(txtAmnt2.Text); } db.SaveChanges(); var NewData = new JSonHelper().ConvertObjectToJSon(ms); AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERRESIGNSTATUS"); MessageBox.Show("Saved Successfully!", "SAVED", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } else { if (db.MASTERRESIGNSTATUS.Where(x => x.RESIGNSTATUS_NAME == txtReasonName.Text).ToString() == txtReasonName.Text.ToString()) { MessageBox.Show("'" + txtReasonName.Text + "' Already exist.Enter new relation.", "Information", MessageBoxButton.OK, MessageBoxImage.Error); txtReasonName.Focus(); } else { MASTERRESIGNSTATU ms = new MASTERRESIGNSTATU(); ms.RESIGNSTATUS_NAME = txtReasonName.Text; if (chkIsBefitValid.IsChecked == true) { ms.IsBenefitValid = Convert.ToBoolean(chkIsBefitValid.IsChecked); ms.MinimumYear = Convert.ToInt32(txtMinimumYear.Text); ms.MinimumRefund = Convert.ToInt32(txtMinimumRefund.Text); ms.MaximumRefund = Convert.ToInt32(txtMAximumRefund.Text); ms.AmtPerYear1 = Convert.ToInt32(txtAmnt1.Text); ms.AmtPerYear2 = Convert.ToInt32(txtAmnt2.Text); } db.MASTERRESIGNSTATUS.Add(ms); db.SaveChanges(); var NewData = new JSonHelper().ConvertObjectToJSon(ms); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "MASTERRESIGNSTATUS"); MessageBox.Show("Saved Successfully!", "SAVED", MessageBoxButton.OK, MessageBoxImage.Information); FormClear(); } } } } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (string.IsNullOrEmpty(txtUserName.Text)) { MessageBox.Show("User Name is Empty!"); txtUserName.Focus(); return; } else if (string.IsNullOrEmpty(txtPassword.Password.ToString())) { MessageBox.Show("Password is Empty!"); txtPassword.Focus(); return; } else if (string.IsNullOrEmpty(cmbUserType.Text)) { MessageBox.Show("User Type is Empty!"); cmbUserType.Focus(); return; } else { if (MessageBox.Show("Do you want to Save '" + txtUserName.Text + "'?", "SAVE", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (iID == 0) { UserAccount usc = (from x in db.UserAccounts where x.UserName == txtUserName.Text select x).FirstOrDefault(); if (usc == null) { UserAccount us = new UserAccount() { UserName = txtUserName.Text, UserType = Convert.ToInt32(cmbUserType.SelectedValue), Password = txtPassword.Password, CompanyName = txtCompanyName.Text, UserCode = txtUserCode.Text }; db.UserAccounts.Add(us); db.SaveChanges(); var NewData = new JSonHelper().ConvertObjectToJSon(us); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "UserAccount"); MessageBox.Show("User Account Added Sucessfully!"); fClear(); } else { MessageBox.Show("User Name Already Found!"); txtUserName.Focus(); return; } } else if (iID == 1) { MessageBox.Show("You Can't Change This! , Contact Administrator!", "User Restricted!", MessageBoxButton.OK, MessageBoxImage.Information); } else { UserAccount usc = (from x in db.UserAccounts where x.UserId == iID select x).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(usc); usc.UserName = txtUserName.Text; usc.UserType = Convert.ToInt32(cmbUserType.SelectedValue); usc.Password = txtPassword.Password; usc.CompanyName = txtCompanyName.Text; usc.UserCode = txtUserCode.Text; db.SaveChanges(); var NewData = new JSonHelper().ConvertObjectToJSon(usc); AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "UserAccount"); MessageBox.Show("User Account Updated Successfully!"); fClear(); } } } } catch (Exception) { throw; } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (txtOrganisationName.Text == "") { MessageBox.Show("Enter Organisation ...", "Information", MessageBoxButton.OK, MessageBoxImage.Error); txtOrganisationName.Focus(); } else { if (MessageBox.Show("Do you want to save this record?", "SAVE CONFIRMATION", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes) { if (db.MASTERNAMESETUPs.Where(x => x.ORGANISATION_NAME == txtOrganisationName.Text).ToString() == txtOrganisationName.Text.ToString()) { MessageBox.Show("'" + txtOrganisationName.Text + "' Already exist.Enter new relation.", "Information", MessageBoxButton.OK, MessageBoxImage.Error); txtOrganisationName.Focus(); } else { if (txtOrganisationName.Text != "") { MASTERNAMESETUP ms = db.MASTERNAMESETUPs.Where(x => x.ORGANISATION_NAME == txtOrganisationName.Text).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(ms); ms.ORGANISATION_NAME = txtOrganisationName.Text; ms.ADDRESS1 = txtAddress1.Text; ms.ADDRESS2 = txtAddress2.Text; ms.ADDRESS3 = txtAddress3.Text; ms.CITY = txtCity.Text; ms.STATE = txtState.Text; ms.COUNTRY = txtCountry.Text; ms.PHONE = txtPhoneNo.Text; ms.ZIPCODE = txtZipCode.Text; ms.SERVERNAME = txtServerName.Text; ms.NEWEXEPATH = txtExePath.Text; ms.NEWIMAGESPATH = txtNewImagePath.Text; ms.NEWREPORTSPATH = txtNewReportPath.Text; ms.SERVERNAME = txtServerName.Text; ms.VERSION = txtVersion.Text; ms.EnterenceFees = Convert.ToDecimal(txtEntranceFeed.Text); ms.BadgeAmount = Convert.ToDecimal(txtBadgeAmt.Text); ms.BF = Convert.ToDecimal(txtBF.Text); ms.BuildingFund = Convert.ToDecimal(txtBuildingFund.Text); ms.Insurance = Convert.ToDecimal(txtInsurance.Text); ms.Subscription = Convert.ToDecimal(txtSubscription.Text); ms.LevyAmount = Convert.ToDecimal(txtLevyAmount.Text); ms.TDFAmount = Convert.ToDecimal(txtTDFAmount.Text); ms.RejoinAmount = Convert.ToDecimal(txtRejoinAmount.Text); ms.SenderEmailId = txtEmailID.Text; ms.SenderPassword = txtPassword.Password; ms.CCEamilId1 = txtCCEmailID1.Text; ms.CCEamilId2 = txtCCEmailID2.Text; ms.PrinterName = txtPrinterName.Text; ms.BackUpPath = txtPath.Text; db.SaveChanges(); var NewData = new JSonHelper().ConvertObjectToJSon(ms); AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERNAMESETUP"); MessageBox.Show("Saved Successfully!", "SAVED", MessageBoxButton.OK, MessageBoxImage.Information); if (sFormName == "HOME") { frmHomeMaster frm = new frmHomeMaster(); this.Close(); frm.ShowDialog(); } else { this.Close(); } } else { MASTERNAMESETUP ms = new MASTERNAMESETUP(); ms.ORGANISATION_NAME = txtOrganisationName.Text; ms.ADDRESS1 = txtAddress1.Text; ms.ADDRESS2 = txtAddress2.Text; ms.ADDRESS3 = txtAddress3.Text; ms.CITY = txtCity.Text; ms.STATE = txtState.Text; ms.COUNTRY = txtCountry.Text; ms.PHONE = txtPhoneNo.Text; ms.ZIPCODE = txtZipCode.Text; ms.SERVERNAME = txtServerName.Text; ms.NEWEXEPATH = txtExePath.Text; ms.NEWIMAGESPATH = txtNewImagePath.Text; ms.NEWREPORTSPATH = txtNewReportPath.Text; ms.SERVERNAME = txtServerName.Text; ms.VERSION = txtVersion.Text; ms.EnterenceFees = Convert.ToDecimal(txtEntranceFeed.Text); ms.BadgeAmount = Convert.ToDecimal(txtBadgeAmt.Text); ms.BF = Convert.ToDecimal(txtBF.Text); ms.BuildingFund = Convert.ToDecimal(txtBuildingFund.Text); ms.Insurance = Convert.ToDecimal(txtInsurance.Text); ms.Subscription = Convert.ToDecimal(txtSubscription.Text); ms.LevyAmount = Convert.ToDecimal(txtLevyAmount.Text); ms.TDFAmount = Convert.ToDecimal(txtTDFAmount.Text); ms.RejoinAmount = Convert.ToDecimal(txtRejoinAmount.Text); ms.SenderEmailId = txtEmailID.Text; ms.SenderPassword = txtPassword.Password; ms.CCEamilId1 = txtCCEmailID1.Text; ms.CCEamilId2 = txtCCEmailID2.Text; ms.PrinterName = txtPrinterName.Text; ms.BackUpPath = txtPath.Text; db.MASTERNAMESETUPs.Add(ms); db.SaveChanges(); var NewData = new JSonHelper().ConvertObjectToJSon(ms); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "MASTERNAMESETUP"); MessageBox.Show("Saved Successfully!", "SAVED", MessageBoxButton.OK, MessageBoxImage.Information); if (sFormName == "HOME") { frmHomeMaster frm = new frmHomeMaster(); this.Close(); frm.ShowDialog(); } else { this.Close(); } } } } } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (txtBankName.Text == "") { MessageBox.Show("Enter Bank Name!"); txtBankName.Focus(); } else if (txtBankUserCode.Text == "") { MessageBox.Show("Enter User Code!"); txtBankUserCode.Focus(); } //else if (cmbNubeBranch.Text == "") //{ // MessageBox.Show("Enter Branch Name!"); // cmbNubeBranch.Focus(); //} else if (MessageBox.Show("Do You want to save this Record?", "Save Confirmation", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (ID != 0) { decimal id = (decimal)ID; MASTERBANK mb = db.MASTERBANKs.Where(x => x.BANK_CODE == id).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(mb); mb.BANK_NAME = txtBankName.Text; mb.BANK_USERCODE = txtBankUserCode.Text; //mb.NUBE_BRANCH = 2; db.SaveChanges(); AppLib.lstMASTERBANK = db.MASTERBANKs.OrderBy(x => x.BANK_NAME).ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(mb); AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERBANK"); MessageBox.Show("Saved Successfully"); ClearForm(); } else { MASTERBANK mb = new MASTERBANK(); mb.BANK_NAME = txtBankName.Text; mb.BANK_USERCODE = txtBankUserCode.Text; //mb.NUBE_BRANCH = 2; db.MASTERBANKs.Add(mb); db.SaveChanges(); AppLib.lstMASTERBANK = db.MASTERBANKs.OrderBy(x => x.BANK_NAME).ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(mb); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "MASTERBANK"); MessageBox.Show("Saved Successfully"); ClearForm(); } } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { bValidation = false; BeforeUpdate(); if (bValidation == false) { MASTERMEMBER mmMst = (from mas in db.MASTERMEMBERs where mas.MEMBER_CODE == dMember_Code select mas).FirstOrDefault(); if (bUpdate == false) { DataView dv = new DataView(dtArrearPost); dv.RowFilter = "AMOUNT>0"; int iTotalDuePay = dv.Count; ArrearPostMaster arrearMaster = new ArrearPostMaster { MemberCode = dMember_Code, EntryDate = DateTime.Now, BeforeLastPaymentDate = mmMst.LASTPAYMENT_DATE, BeforeTotalBF = mmMst.ACCBF, BeforeTotalSubscription = mmMst.ACCSUBSCRIPTION, BeforeTotalMonthsPaid = Convert.ToInt32(mmMst.TOTALMONTHSPAID), TotalDuePay = iTotalDuePay, UpdatedStatus = "Not Updated" }; db.ArrearPostMasters.Add(arrearMaster); db.SaveChanges(); var NewData = new JSonHelper().ConvertObjectToJSon(arrearMaster); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "ArrearPostMaster"); DataTable dtTemp = new DataTable(); dtTemp = ((DataView)dgArrearPost.ItemsSource).ToTable(); var iMasterId = Convert.ToInt32(db.ArrearPostMasters.Max(x => x.ID)); List <ArrearPostDetail> lstArrearDtl = new List <ArrearPostDetail>(); foreach (DataRow row in dtTemp.Rows) { if (Convert.ToDecimal(row["AMOUNT"]) != 0) { ArrearPostDetail arrearDtl = new ArrearPostDetail { MasterId = iMasterId, Year = Convert.ToInt32(row["YEAR"]), Month = Convert.ToDateTime("1/" + row["MONTH"] + row["YEAR"]).Month, TotalAmount = Convert.ToDecimal(row["AMOUNT"]), AmounBF = Convert.ToDecimal(row["BF"]), AmountInsurance = Convert.ToDecimal(row["INSURANCE"]), AmountSubscription = Convert.ToDecimal(row["SUBSCRIPTION"]), UpdatedStatus = "Not Updated", MemberCode = Convert.ToInt32(dMember_Code) }; lstArrearDtl.Add(arrearDtl); } } if (lstArrearDtl.Count > 0) { db.ArrearPostDetails.AddRange(lstArrearDtl); db.SaveChanges(); var NewData1 = new JSonHelper().ConvertObjectToJSon(lstArrearDtl); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData1, "ArrearPostDetail"); } MessageBox.Show("Details are Saved Sucessfully"); fClear(); } else { ArrearPostMaster mst = (from mas in db.ArrearPostMasters where mas.ID == iArrearMst_ID select mas).FirstOrDefault(); var OldData = new JSonHelper().ConvertObjectToJSon(mst); DataView dv = new DataView(dtArrearPost); dv.RowFilter = "AMOUNT>0"; int iTotalDuePay = dv.Count; if (mst != null) { mst.UpdatedEntryDate = DateTime.Now; mst.IsEdited = true; mst.TotalDuePay = iTotalDuePay; } db.SaveChanges(); var NewData = new JSonHelper().ConvertObjectToJSon(mst); AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "ArrearPostMaster"); ArrearPostDetail dtl = (from mas in db.ArrearPostDetails where mas.MasterId == iArrearMst_ID select mas).FirstOrDefault(); var OldData1 = new JSonHelper().ConvertObjectToJSon(dtl); if (dtl != null) { db.ArrearPostDetails.RemoveRange(db.ArrearPostDetails.Where(x => x.MasterId == iArrearMst_ID)); db.SaveChanges(); } DataTable dtTemp = new DataTable(); dtTemp = ((DataView)dgArrearPost.ItemsSource).ToTable(); List <ArrearPostDetail> lstArrearDtl = new List <ArrearPostDetail>(); foreach (DataRow row in dtTemp.Rows) { if (Convert.ToDecimal(row["AMOUNT"]) != 0) { ArrearPostDetail arrearDtl = new ArrearPostDetail { MasterId = iArrearMst_ID, Year = Convert.ToInt32(row["YEAR"]), Month = Convert.ToDateTime("1/" + row["MONTH"] + row["YEAR"]).Month, TotalAmount = Convert.ToDecimal(row["AMOUNT"]), AmounBF = Convert.ToDecimal(row["BF"]), AmountInsurance = Convert.ToDecimal(row["INSURANCE"]), AmountSubscription = Convert.ToDecimal(row["SUBSCRIPTION"]), UpdatedStatus = "Not Updated", MemberCode = Convert.ToInt32(dMember_Code) }; lstArrearDtl.Add(arrearDtl); } } if (lstArrearDtl.Count > 0) { db.ArrearPostDetails.AddRange(lstArrearDtl); db.SaveChanges(); var NewData1 = new JSonHelper().ConvertObjectToJSon(lstArrearDtl); AppLib.EventHistory(this.Tag.ToString(), 1, OldData1, NewData1, "ArrearPostDetail"); } MessageBox.Show("Details are Updated Sucessfully"); fClear(); } } } catch (Exception ex) { ExceptionLogging.SendErrorToText(ex); } }
private void btnSave_Click(object sender, RoutedEventArgs e) { try { if (cmbBankName.Text == "") { MessageBox.Show("Enter Bank..", "Information"); txtBranchName.Focus(); } else if (txtBranchCode.Text == "") { MessageBox.Show("Enter Branchcode..", "Information"); txtBranchCode.Focus(); } else if (txtBranchName.Text == "") { MessageBox.Show("Enter Branchname..", "Information"); } else { if (MessageBox.Show("Do you want to save this record?", "SAVE", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { if (ID != 0) { decimal id = (decimal)ID; var s = cmbBankName.Text.ToString(); MASTERBANKBRANCH mb = db.MASTERBANKBRANCHes.Where(x => x.BANKBRANCH_CODE == id).FirstOrDefault(); //var OldData = new JSonHelper().ConvertObjectToJSon(mb); mb.BANK_CODE = Convert.ToDecimal(cmbBankName.SelectedValue); mb.BANKBRANCH_NAME = txtBranchName.Text; mb.BANKBRANCH_USERCODE = txtBranchCode.Text; mb.BANKBRANCH_ADDRESS1 = txtAddress1.Text; mb.BANKBRANCH_ADDRESS2 = txtAddress2.Text; mb.BANKBRANCH_ADDRESS3 = txtAddress3.Text; mb.BANKBRANCH_CITY_CODE = Convert.ToDecimal(cmbCity.SelectedValue); mb.BANKBRANCH_COUNTRY = (cmbCountry.Text.ToString() == null ? "" : cmbCountry.Text.ToString()); mb.BANKBRANCH_EMAIL = txtEmail.Text; mb.BANKBRANCH_PHONE1 = txtMobile.Text; mb.BANKBRANCH_PHONE2 = txtPhone.Text; mb.BANKBRANCH_STATE_CODE = Convert.ToDecimal(cmbState.SelectedValue); mb.BANKBRANCH_ZIPCODE = txtPostalCode.Text; mb.NUBE_BRANCH_CODE = Convert.ToDecimal(cmbNUBEBranch.SelectedValue); mb.HEAD_QUARTERS = Convert.ToDecimal(ckbHeadOffice.IsChecked); db.SaveChanges(); AppLib.lstMASTERBANKBRANCH = db.MASTERBANKBRANCHes.OrderBy(x => x.BANKBRANCH_NAME).ToList(); //var NewData = new JSonHelper().ConvertObjectToJSon(mb); //AppLib.EventHistory(this.Tag.ToString(), 1, OldData, NewData, "MASTERBANKBRANCH"); MessageBox.Show("Saved Successfully", "Saved"); ClearForm(); } else { MASTERBANKBRANCH mb = new MASTERBANKBRANCH(); mb.BANK_CODE = Convert.ToDecimal(cmbBankName.SelectedValue); mb.BANKBRANCH_NAME = txtBranchName.Text; mb.BANKBRANCH_USERCODE = txtBranchCode.Text; mb.BANKBRANCH_ADDRESS1 = txtAddress1.Text; mb.BANKBRANCH_ADDRESS2 = txtAddress2.Text; mb.BANKBRANCH_ADDRESS3 = txtAddress3.Text; mb.BANKBRANCH_CITY_CODE = Convert.ToDecimal(cmbCity.SelectedValue); mb.BANKBRANCH_COUNTRY = (cmbCountry.Text.ToString() == null ? "" : cmbCountry.Text.ToString()); mb.BANKBRANCH_EMAIL = txtEmail.Text; mb.BANKBRANCH_PHONE1 = txtMobile.Text; mb.BANKBRANCH_PHONE2 = txtPhone.Text; mb.BANKBRANCH_STATE_CODE = Convert.ToDecimal(cmbState.SelectedValue); mb.BANKBRANCH_ZIPCODE = txtPostalCode.Text; mb.NUBE_BRANCH_CODE = Convert.ToDecimal(cmbNUBEBranch.SelectedValue); mb.HEAD_QUARTERS = Convert.ToDecimal(ckbHeadOffice.IsChecked); db.MASTERBANKBRANCHes.Add(mb); db.SaveChanges(); AppLib.lstMASTERBANKBRANCH = db.MASTERBANKBRANCHes.OrderBy(x => x.BANKBRANCH_NAME).ToList(); var NewData = new JSonHelper().ConvertObjectToJSon(mb); AppLib.EventHistory(this.Tag.ToString(), 0, "", NewData, "MASTERBANKBRANCH"); MessageBox.Show("Saved Successfully!", "Saved"); ClearForm(); } } } } catch (Exception ex) { Nube.ExceptionLogging.SendErrorToText(ex); } }