private void ScatterData() { try { TBL_MP_Admin_VoucherNoSetup model = (new ServiceVoucherNoSetup()).GetVoucherSetupDBRecordByID(this.pkID); if (model != null) { cboYears.SelectedItem = ((List <SelectListItem>)cboYears.DataSource).Where(x => x.ID == model.Fk_YearID).FirstOrDefault(); txtNoPrefix.Text = model.NoPrefix.ToString(); txtSeparator.Text = txtSeparatorSuffix.Text = model.NoSeperator; txtNoPadding.Text = model.NoPad.ToString(); txtNoPostFix.Text = model.NoPostfix; txtVoucherNoPreview.Text = model.VoucherNoPreview; chkIs_continuedNextYear.Checked = model.Is_NoContinuedNextYear; if (model.NoStartingFrom != null) { txtNoStartingFrom.Text = model.NoStartingFrom.ToString(); } } } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "frmAddEditVoucherNoSetup::ScatterData", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public bool UpdateVoucherNoSetup(TBL_MP_Admin_VoucherNoSetup model) { bool result = false; try { TBL_MP_Admin_VoucherNoSetup dbModel = _dbContext.TBL_MP_Admin_VoucherNoSetup.Where(x => x.PK_VoucherSetupID == model.PK_VoucherSetupID).FirstOrDefault(); if (dbModel != null) { dbModel.fk_FormID = model.fk_FormID; dbModel.Fk_YearID = model.Fk_YearID; dbModel.NoPrefix = model.NoPrefix; dbModel.NoSeperator = model.NoSeperator; dbModel.NoPad = model.NoPad; dbModel.NoPostfix = model.NoPostfix; dbModel.Is_NoContinuedNextYear = model.Is_NoContinuedNextYear; dbModel.NoStartingFrom = model.NoStartingFrom; dbModel.LastModifiedBy = model.LastModifiedBy; dbModel.LastModifiedDate = model.LastModifiedDate; _dbContext.SaveChanges(); result = true; } } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceVoucherNoSetup::UpdateVoucherNoSetup", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(result); }
public TBL_MP_Admin_VoucherNoSetup GetVoucherSetupDBRecordByID(int pkID) { TBL_MP_Admin_VoucherNoSetup model = null; try { model = _dbContext.TBL_MP_Admin_VoucherNoSetup.Where(x => x.PK_VoucherSetupID == pkID).FirstOrDefault(); } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceVoucherNoSetup::GetVoucherSetupDBRecordByID", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(model); }
public int AddNewVoucherNoSetup(TBL_MP_Admin_VoucherNoSetup model) { int newID = 0; try { _dbContext.TBL_MP_Admin_VoucherNoSetup.Add(model); _dbContext.SaveChanges(); newID = model.PK_VoucherSetupID; } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceVoucherNoSetup::AddNewVoucherNoSetup", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(newID); }
public string GenerateNewProjectNumber(int currFinYear, int currBrachID, int companyID) { string keyCode = string.Empty; int intPreviousYearCount = 0; int cnt; string strNumber; string strQuery = string.Empty; try { TBL_MP_Admin_VoucherNoSetup objVoucherSetup = (from xx in _dbContext.TBL_MP_Admin_VoucherNoSetup where xx.fk_FormID == (int)DB_FORM_IDs.PROJECT && xx.Fk_YearID == currFinYear && xx.Fk_BranchID == currBrachID select xx).FirstOrDefault(); strQuery = string.Format("SELECT count(*) FROM TBL_MP_PMC_ProjectMaster WHERE ProjectNumber NOT LIKE '%AMMEND%' and FK_YearID={0} AND FK_BranchID={1} AND FK_CompanyID={2}", currFinYear, currBrachID, companyID); cnt = _dbContext.Database.SqlQuery <int>(strQuery).FirstOrDefault(); // IF NO. CONTINUED FROM PREVIOUS YEAR GENERATE NEXT NUMBER BY REFEREING PREVIOUS YEAR MAX. NUMBER if (objVoucherSetup.Is_NoContinuedNextYear) { TBL_MP_Admin_VoucherNoSetup objVoucherSetupPrevYear = (from xx in _dbContext.TBL_MP_Admin_VoucherNoSetup where xx.fk_FormID == (int)DB_FORM_IDs.PROJECT && xx.Fk_YearID == currFinYear - 1 && xx.Fk_BranchID == currBrachID select xx).FirstOrDefault(); TBL_MP_PMC_ProjectMaster lastProjectPrevYear = (from xx in _dbContext.TBL_MP_PMC_ProjectMaster where xx.FK_YearID == currFinYear - 1 && xx.FK_BranchID == currBrachID && xx.FK_CompanyID == companyID orderby xx.CreatedDatetime descending select xx).FirstOrDefault(); if (lastProjectPrevYear != null) { string lstnumber = lastProjectPrevYear.ProjectNumber.Replace(objVoucherSetupPrevYear.NoPrefix, "").Replace(objVoucherSetupPrevYear.NoPostfix, "").Replace(objVoucherSetupPrevYear.NoSeperator, ""); intPreviousYearCount = int.Parse(lstnumber); } else { intPreviousYearCount = 1; } cnt += intPreviousYearCount; } else { cnt += (int)objVoucherSetup.NoStartingFrom; } strNumber = cnt.ToString().PadLeft(objVoucherSetup.NoPad, '0'); //0083 keyCode += objVoucherSetup.NoPrefix + objVoucherSetup.NoSeperator + strNumber + objVoucherSetup.NoSeperator + objVoucherSetup.NoPostfix; // XL/SO/0083/2018-19 } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceProject::GenerateNewProjectNumber", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(keyCode); }
public string GenerateNewLoanRequestNumber(int currFinYear, int currBrachID, int companyID) { string keyCode = string.Empty; int intPreviousYearCount = 0; int cnt; string strNumber; string strQuery = string.Empty; try { // 0123 TBL_MP_Admin_VoucherNoSetup objAdvanceSetup = (from xx in _dbContext.TBL_MP_Admin_VoucherNoSetup where xx.fk_FormID == (int)DB_FORM_IDs.LOAN_REQUEST && xx.Fk_YearID == currFinYear && xx.Fk_BranchID == currBrachID select xx).FirstOrDefault(); if (objAdvanceSetup == null) { string strMessage = "Unable to locate Voucher No. setup for the selected Financial Year or Branch"; MessageBox.Show(strMessage, "Caution", MessageBoxButtons.OK, MessageBoxIcon.Error); return(string.Empty); } strQuery = string.Format("SELECT count(*) FROM TBL_MP_HR_LoanRequestApplication WHERE FK_YearID={0} AND FK_BranchID={1} AND FK_CompanyID={2}", currFinYear, currBrachID, companyID); cnt = _dbContext.Database.SqlQuery <int>(strQuery).FirstOrDefault(); // IF NO. CONTINUED FROM PREVIOUS YEAR GENERATE NEXT NUMBER BY REFEREING PREVIOUS YEAR MAX. NUMBER if (objAdvanceSetup.Is_NoContinuedNextYear) { TBL_MP_Admin_VoucherNoSetup objVoucherSetupPrevYear = (from xx in _dbContext.TBL_MP_Admin_VoucherNoSetup where xx.fk_FormID == (int)DB_FORM_IDs.LOAN_REQUEST && xx.Fk_YearID == currFinYear - 1 && xx.Fk_BranchID == currBrachID select xx).FirstOrDefault(); TBL_MP_HR_LoanRequestApplication lastLeavePrevYear = (from xx in _dbContext.TBL_MP_HR_LoanRequestApplication where xx.FK_YearID == currFinYear - 1 && xx.FK_BranchID == currBrachID && xx.FK_CompanyID == companyID orderby xx.LoanRequestDate descending select xx).FirstOrDefault(); if (lastLeavePrevYear != null) { string lstnumber = lastLeavePrevYear.LoanRequestNo.Replace(objVoucherSetupPrevYear.NoPrefix, "").Replace(objVoucherSetupPrevYear.NoPostfix, "").Replace(objVoucherSetupPrevYear.NoSeperator, ""); intPreviousYearCount = int.Parse(lstnumber); } else { intPreviousYearCount = 1; } cnt += intPreviousYearCount; } else { cnt += (int)objAdvanceSetup.NoStartingFrom; } strNumber = cnt.ToString().PadLeft(objAdvanceSetup.NoPad, '0'); //0083 keyCode += objAdvanceSetup.NoPrefix + objAdvanceSetup.NoSeperator + strNumber + objAdvanceSetup.NoSeperator + objAdvanceSetup.NoPostfix; // XL/SO/0083/2018-19 } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "ServiceLoanRequest::GenerateNewLoanRequestNumber", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(keyCode); }
private void btnSave_Click(object sender, EventArgs e) { TBL_MP_Admin_VoucherNoSetup model = null; ServiceVoucherNoSetup _service = new ServiceVoucherNoSetup(); try { errorProvider1.Clear(); if (!this.ValidateChildren()) { return; } if (pkID == 0) { model = new TBL_MP_Admin_VoucherNoSetup(); } else { model = _service.GetVoucherSetupDBRecordByID(this.pkID); } //gather data from controls inot model model.fk_FormID = this.FORM_ID; model.Fk_YearID = ((SelectListItem)cboYears.SelectedItem).ID; model.NoPrefix = txtNoPrefix.Text; model.NoSeperator = txtSeparator.Text; model.NoPad = int.Parse(txtNoPadding.Text); model.NoPostfix = txtNoPostFix.Text; model.VoucherNoPreview = txtVoucherNoPreview.Text; model.Is_NoContinuedNextYear = chkIs_continuedNextYear.Checked; if (chkIs_continuedNextYear.Checked) { model.NoStartingFrom = null; } else { model.NoStartingFrom = int.Parse(txtNoStartingFrom.Text); } if (pkID == 0) { model.FK_PreparedBy = Program.CURR_USER.EmployeeID; model.CreatedDatetime = AppCommon.GetServerDateTime(); model.Fk_BranchID = Program.CURR_USER.BranchID; _service.AddNewVoucherNoSetup(model); } else { model.LastModifiedBy = Program.CURR_USER.EmployeeID; model.LastModifiedDate = AppCommon.GetServerDateTime(); _service.UpdateVoucherNoSetup(model); } this.DialogResult = DialogResult.OK; } catch (Exception ex) { string errMessage = ex.Message; if (ex.InnerException != null) { errMessage += string.Format("\n{0}", ex.InnerException.Message); } MessageBox.Show(errMessage, "frmAddEditVoucherNoSetup::btnSave_Click", MessageBoxButtons.OK, MessageBoxIcon.Error); } }