public void AdvancePaymentAdd(AdvancePaymentInfo advancepaymentinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AdvancePaymentAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); //sprmparam = sccmd.Parameters.Add("@advancePaymentId", SqlDbType.Decimal); //sprmparam.Value = advancepaymentinfo.AdvancePaymentId; sprmparam = sccmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.EmployeeId; sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.LedgerId; sprmparam = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.VoucherNo; sprmparam = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.InvoiceNo; sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime); sprmparam.Value = advancepaymentinfo.Date; sprmparam = sccmd.Parameters.Add("@amount", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.Amount; sprmparam = sccmd.Parameters.Add("@salaryMonth", SqlDbType.DateTime); sprmparam.Value = advancepaymentinfo.SalaryMonth; sprmparam = sccmd.Parameters.Add("@chequenumber", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.Chequenumber; sprmparam = sccmd.Parameters.Add("@chequeDate", SqlDbType.DateTime); sprmparam.Value = advancepaymentinfo.ChequeDate; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.Narration; sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); sprmparam.Value = advancepaymentinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.Extra2; sprmparam = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.SuffixPrefixId; sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.VoucherTypeId; sprmparam = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.FinancialYearId; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
/// <summary> /// Function to edit aduance payment details /// </summary> /// <param name="advancepaymentinfo"></param> public void AdvancePaymentEdit(AdvancePaymentInfo advancepaymentinfo) { try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AdvancePaymentEdit", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@advancePaymentId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.AdvancePaymentId; sprmparam = sccmd.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.EmployeeId; sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.LedgerId; sprmparam = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.VoucherNo; sprmparam = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.InvoiceNo; sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime); sprmparam.Value = advancepaymentinfo.Date; sprmparam = sccmd.Parameters.Add("@amount", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.Amount; sprmparam = sccmd.Parameters.Add("@salaryMonth", SqlDbType.DateTime); sprmparam.Value = advancepaymentinfo.SalaryMonth; sprmparam = sccmd.Parameters.Add("@chequenumber", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.Chequenumber; sprmparam = sccmd.Parameters.Add("@chequeDate", SqlDbType.DateTime); sprmparam.Value = advancepaymentinfo.ChequeDate; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.Narration; //sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime); //sprmparam.Value = advancepaymentinfo.ExtraDate; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.Extra2; sprmparam = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.SuffixPrefixId; sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.VoucherTypeId; sprmparam = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.FinancialYearId; //sccmd.ExecuteScalar(); sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } }
public AdvancePaymentInfo AdvancePaymentView(decimal advancePaymentId) { AdvancePaymentInfo advancepaymentinfo = new AdvancePaymentInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AdvancePaymentView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@advancePaymentId", SqlDbType.Decimal); sprmparam.Value = advancePaymentId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { advancepaymentinfo.AdvancePaymentId = Convert.ToDecimal(sdrreader[0].ToString()); advancepaymentinfo.EmployeeId = Convert.ToDecimal(sdrreader[1].ToString()); advancepaymentinfo.LedgerId = Convert.ToDecimal(sdrreader[2].ToString()); advancepaymentinfo.VoucherNo = sdrreader[3].ToString(); advancepaymentinfo.InvoiceNo = (sdrreader[4].ToString()); advancepaymentinfo.Date = Convert.ToDateTime(sdrreader[5].ToString()); advancepaymentinfo.Amount = Convert.ToDecimal(sdrreader[6].ToString()); advancepaymentinfo.SalaryMonth = Convert.ToDateTime(sdrreader[7].ToString()); advancepaymentinfo.Chequenumber = sdrreader[8].ToString(); advancepaymentinfo.ChequeDate = Convert.ToDateTime(sdrreader[9].ToString()); advancepaymentinfo.Narration = sdrreader[10].ToString(); advancepaymentinfo.ExtraDate = Convert.ToDateTime(sdrreader[11].ToString()); advancepaymentinfo.Extra1 = sdrreader[12].ToString(); advancepaymentinfo.Extra2 = sdrreader[13].ToString(); advancepaymentinfo.SuffixPrefixId = Convert.ToDecimal(sdrreader[14].ToString()); advancepaymentinfo.VoucherTypeId = Convert.ToDecimal(sdrreader[15].ToString()); advancepaymentinfo.FinancialYearId = Convert.ToDecimal(sdrreader[16].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return(advancepaymentinfo); }
//coded by Niyas M // on 16-03-2013 public DataTable AdvancePaymentAddWithIdentity(AdvancePaymentInfo advancepaymentinfo, bool IsAutomatic) { DataTable dtbl = new DataTable(); try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlDataAdapter sqlda = new SqlDataAdapter("AdvancePaymentAddWithIdentity", sqlcon); sqlda.SelectCommand.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sqlda.SelectCommand.Parameters.Add("@employeeId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.EmployeeId; sprmparam = sqlda.SelectCommand.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.LedgerId; sprmparam = sqlda.SelectCommand.Parameters.Add("@voucherNo", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.VoucherNo; sprmparam = sqlda.SelectCommand.Parameters.Add("@invoiceNo", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.InvoiceNo; sprmparam = sqlda.SelectCommand.Parameters.Add("@date", SqlDbType.DateTime); sprmparam.Value = advancepaymentinfo.Date; sprmparam = sqlda.SelectCommand.Parameters.Add("@amount", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.Amount; sprmparam = sqlda.SelectCommand.Parameters.Add("@salaryMonth", SqlDbType.DateTime); sprmparam.Value = advancepaymentinfo.SalaryMonth; sprmparam = sqlda.SelectCommand.Parameters.Add("@chequenumber", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.Chequenumber; sprmparam = sqlda.SelectCommand.Parameters.Add("@chequeDate", SqlDbType.DateTime); sprmparam.Value = advancepaymentinfo.ChequeDate; sprmparam = sqlda.SelectCommand.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.Narration; //sprmparam = sqlda.SelectCommand.Parameters.Add("@extraDate", SqlDbType.DateTime); //sprmparam.Value = advancepaymentinfo.ExtraDate; sprmparam = sqlda.SelectCommand.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.Extra1; sprmparam = sqlda.SelectCommand.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = advancepaymentinfo.Extra2; sprmparam = sqlda.SelectCommand.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.SuffixPrefixId; sprmparam = sqlda.SelectCommand.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.VoucherTypeId; sprmparam = sqlda.SelectCommand.Parameters.Add("@financialYearId", SqlDbType.Decimal); sprmparam.Value = advancepaymentinfo.FinancialYearId; sprmparam = sqlda.SelectCommand.Parameters.Add("@IsAutomatic", SqlDbType.Bit); sprmparam.Value = IsAutomatic; sqlda.Fill(dtbl); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return dtbl; }
public AdvancePaymentInfo AdvancePaymentView(decimal advancePaymentId) { AdvancePaymentInfo advancepaymentinfo = new AdvancePaymentInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("AdvancePaymentView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@advancePaymentId", SqlDbType.Decimal); sprmparam.Value = advancePaymentId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { advancepaymentinfo.AdvancePaymentId = Convert.ToDecimal(sdrreader[0].ToString()); advancepaymentinfo.EmployeeId = Convert.ToDecimal(sdrreader[1].ToString()); advancepaymentinfo.LedgerId = Convert.ToDecimal(sdrreader[2].ToString()); advancepaymentinfo.VoucherNo = sdrreader[3].ToString(); advancepaymentinfo.InvoiceNo = (sdrreader[4].ToString()); advancepaymentinfo.Date = Convert.ToDateTime(sdrreader[5].ToString()); advancepaymentinfo.Amount = Convert.ToDecimal(sdrreader[6].ToString()); advancepaymentinfo.SalaryMonth = Convert.ToDateTime(sdrreader[7].ToString()); advancepaymentinfo.Chequenumber = sdrreader[8].ToString(); advancepaymentinfo.ChequeDate = Convert.ToDateTime(sdrreader[9].ToString()); advancepaymentinfo.Narration = sdrreader[10].ToString(); advancepaymentinfo.ExtraDate = Convert.ToDateTime(sdrreader[11].ToString()); advancepaymentinfo.Extra1 = sdrreader[12].ToString(); advancepaymentinfo.Extra2 = sdrreader[13].ToString(); advancepaymentinfo.SuffixPrefixId = Convert.ToDecimal(sdrreader[14].ToString()); advancepaymentinfo.VoucherTypeId = Convert.ToDecimal(sdrreader[15].ToString()); advancepaymentinfo.FinancialYearId = Convert.ToDecimal(sdrreader[16].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return advancepaymentinfo; }
/// <summary> /// Function to delete /// </summary> public void DeleteFunction() { try { MonthlySalarySP spMonthlySalary = new MonthlySalarySP(); if (!spMonthlySalary.CheckSalaryStatusForAdvancePayment(Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()), dtpSalaryMonth.Value)) { AdvancePaymentInfo infoAdvancepayment = new AdvancePaymentInfo(); AdvancePaymentSP spAdvancePayment = new AdvancePaymentSP(); LedgerPostingSP spLedgerPosting = new LedgerPostingSP(); spAdvancePayment.AdvancePaymentDelete(Convert.ToDecimal(decAdvancePaymentEditId.ToString())); spLedgerPosting.LedgerPostDelete(txtAdvanceVoucherNo.Text.Trim(), decAdvancePaymentEditId); Messages.DeletedMessage(); txtAdvanceVoucherNo.Focus(); Clear(); this.Close(); } else { Messages.ReferenceExistsMessage(); dtpSalaryMonth.Focus(); } } catch (Exception ex) { MessageBox.Show("AP14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public void SaveFunction() { try { AdvancePaymentSP spAdvancepayment = new AdvancePaymentSP(); AdvancePaymentInfo infoAdvancepayment = new AdvancePaymentInfo(); LedgerPostingSP spLedgerPosting = new LedgerPostingSP(); MonthlySalarySP spMonthlySalary = new MonthlySalarySP(); if (CheckAdvanceAmount()) { if (!spMonthlySalary.CheckSalaryAlreadyPaidOrNotForAdvancePayment(Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()), dtpSalaryMonth.Value)) { if (!spAdvancepayment.CheckSalaryAlreadyPaidOrNot(Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()), dtpSalaryMonth.Value)) { if (isAutomatic == true) { infoAdvancepayment.VoucherNo = strVoucherNo; } else { infoAdvancepayment.VoucherNo = txtAdvanceVoucherNo.Text.Trim(); } infoAdvancepayment.EmployeeId = Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()); infoAdvancepayment.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text.ToString()); infoAdvancepayment.Chequenumber = txtCheckNo.Text.ToString(); infoAdvancepayment.Date = Convert.ToDateTime(txtDate.Text.ToString()); infoAdvancepayment.Amount = Convert.ToDecimal(txtAmount.Text.ToString()); if (isAutomatic) { infoAdvancepayment.InvoiceNo = strInvoiceNo; } else { infoAdvancepayment.InvoiceNo = txtAdvanceVoucherNo.Text.Trim(); } infoAdvancepayment.LedgerId = Convert.ToDecimal(cmbCashOrBank.SelectedValue.ToString()); infoAdvancepayment.ChequeDate = Convert.ToDateTime(txtChequeDate.Text.ToString()); infoAdvancepayment.Narration = txtNarration.Text.Trim(); infoAdvancepayment.ExtraDate = Convert.ToDateTime(DateTime.Now.ToString()); infoAdvancepayment.Extra1 = string.Empty; infoAdvancepayment.Extra2 = string.Empty; infoAdvancepayment.VoucherTypeId = decPaymentVoucherTypeId; infoAdvancepayment.SuffixPrefixId = decPaymentSuffixPrefixId; infoAdvancepayment.FinancialYearId = PublicVariables._decCurrentFinancialYearId; if (btnAdvancePaymentSave.Text == "Save") { if (decAdvancePaymentsId != -1) { DataTable dtbl = new DataTable(); dtbl = spAdvancepayment.AdvancePaymentAddWithIdentity(infoAdvancepayment, isAutomatic); foreach (DataRow dr in dtbl.Rows) { decAdvancePaymentId = Convert.ToDecimal(dr.ItemArray[0].ToString()); strUpdatedVoucherNumber = dr.ItemArray[1].ToString(); strUpdatedInvoiceNumber = dr.ItemArray[2].ToString(); } if (!isAutomatic) { strVoucherNo = txtAdvanceVoucherNo.Text.Trim(); } if (isAutomatic) { if (Convert.ToDecimal(strUpdatedVoucherNumber) != Convert.ToDecimal(strVoucherNo)) { Messages.InformationMessage("Voucher number changed from " + strInvoiceNo + " to " + strUpdatedInvoiceNumber); strVoucherNo = strUpdatedVoucherNumber.ToString(); strInvoiceNo = strUpdatedInvoiceNumber; } } txtAdvanceVoucherNo.Focus(); } LedgerPosting(Convert.ToDecimal(cmbCashOrBank.SelectedValue.ToString()), decAdvancePaymentId); Messages.SavedMessage(); Clear(); } } else { Messages.InformationMessage(" Advance already paid for this month"); dtpSalaryMonth.Focus(); } } else { Messages.InformationMessage("Cant pay advance for this month,Salary already paid"); dtpSalaryMonth.Focus(); } } } catch (Exception ex) { MessageBox.Show("AP1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to fill controls for update /// </summary> public void fillFunction() { try { AdvancePaymentSP spadvance = new AdvancePaymentSP(); AdvancePaymentInfo infoadvance = new AdvancePaymentInfo(); VoucherTypeSP spvouchertype = new VoucherTypeSP(); infoadvance = spadvance.AdvancePaymentView(decAdvancePaymentEditId); strVoucherNo = infoadvance.VoucherNo; txtAdvanceVoucherNo.Text = infoadvance.InvoiceNo; strInvoiceNo = infoadvance.InvoiceNo; cmbEmployee.SelectedValue = infoadvance.EmployeeId.ToString(); dtpSalaryMonth.Value = Convert.ToDateTime(infoadvance.SalaryMonth.ToString()); txtDate.Text = infoadvance.Date.ToString("dd-MMM-yyyy"); txtChequeDate.Text = infoadvance.Date.ToString("dd-MMM-yyyy"); cmbCashOrBank.SelectedValue = infoadvance.LedgerId.ToString(); txtCheckNo.Text = infoadvance.Chequenumber; txtAmount.Text = infoadvance.Amount.ToString(); txtNarration.Text = infoadvance.Narration; btnAdvancePaymentSave.Text = "Update"; btnAdvancePaymentDelete.Enabled = true; decAdvancePaymentsId = decAdvancePaymentId; decPaymentVoucherTypeId = infoadvance.VoucherTypeId; decPaymentSuffixPrefixId = infoadvance.SuffixPrefixId; isAutomatic = spvouchertype.CheckMethodOfVoucherNumbering(decPaymentVoucherTypeId); if (isAutomatic) { txtAdvanceVoucherNo.Enabled = false; } else { txtAdvanceVoucherNo.Enabled = true; } } catch (Exception ex) { MessageBox.Show("AP8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function for Ledger Posting /// </summary> /// <param name="decLedgerPostingId"></param> /// <param name="decAdvancePaymentId"></param> public void LedgerPosting(decimal decLedgerPostingId, decimal decAdvancePaymentId) { try { AdvancePaymentSP spAdvancePayment = new AdvancePaymentSP(); AdvancePaymentInfo infoAdvancePayment = new AdvancePaymentInfo(); LedgerPostingSP spLedgerPosting = new LedgerPostingSP(); LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo(); infoLedgerPosting.VoucherTypeId = decPaymentVoucherTypeId; if (isAutomatic) { infoLedgerPosting.VoucherNo = strVoucherNo; } else { infoLedgerPosting.VoucherNo = txtAdvanceVoucherNo.Text.Trim(); } infoLedgerPosting.Date = PublicVariables._dtCurrentDate; infoLedgerPosting.LedgerId = Convert.ToDecimal(cmbCashOrBank.SelectedValue.ToString()); infoLedgerPosting.DetailsId = decAdvancePaymentId; if (isAutomatic) { infoLedgerPosting.InvoiceNo = strInvoiceNo; } else { infoLedgerPosting.InvoiceNo = txtAdvanceVoucherNo.Text.Trim(); } infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId; infoLedgerPosting.Debit = 0; infoLedgerPosting.Credit = Convert.ToDecimal(txtAmount.Text.ToString()); infoLedgerPosting.ChequeNo = string.Empty; infoLedgerPosting.ChequeDate = DateTime.Now; infoLedgerPosting.ExtraDate = PublicVariables._dtCurrentDate; infoLedgerPosting.Extra1 = string.Empty; infoLedgerPosting.Extra2 = string.Empty; spLedgerPosting.LedgerPostingAdd(infoLedgerPosting); infoLedgerPosting.VoucherTypeId = decPaymentVoucherTypeId; if (isAutomatic) { infoLedgerPosting.VoucherNo = strVoucherNo; } else { infoLedgerPosting.VoucherNo = txtAdvanceVoucherNo.Text.Trim(); } infoLedgerPosting.Date = PublicVariables._dtCurrentDate; infoLedgerPosting.LedgerId = 3; infoLedgerPosting.DetailsId = decAdvancePaymentId; if (isAutomatic) { infoLedgerPosting.InvoiceNo = strInvoiceNo; } else { infoLedgerPosting.InvoiceNo = txtAdvanceVoucherNo.Text.Trim(); } infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId; infoLedgerPosting.Debit = Convert.ToDecimal(txtAmount.Text.ToString()); infoLedgerPosting.Credit = 0; infoLedgerPosting.ChequeNo = string.Empty; infoLedgerPosting.ChequeDate = DateTime.Now; infoLedgerPosting.ExtraDate = PublicVariables._dtCurrentDate; infoLedgerPosting.Extra1 = string.Empty; infoLedgerPosting.Extra2 = string.Empty; spLedgerPosting.LedgerPostingAdd(infoLedgerPosting); } catch (Exception ex) { MessageBox.Show("AP6:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to edit /// </summary> public void EditFunction() { try { MonthlySalarySP spMonthlySalary = new MonthlySalarySP(); if (!spMonthlySalary.CheckSalaryStatusForAdvancePayment(Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()), dtpSalaryMonth.Value)) { AdvancePaymentSP spAdvancepayment = new AdvancePaymentSP(); AdvancePaymentInfo infoAdvancepayment = new AdvancePaymentInfo(); LedgerPostingSP spLedgerPosting = new LedgerPostingSP(); if (spAdvancepayment.CheckSalaryAlreadyPaidOrNot(Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()), dtpSalaryMonth.Value)) { txtAmount.ReadOnly = true; } infoAdvancepayment.AdvancePaymentId = (Convert.ToDecimal(decAdvancePaymentEditId.ToString())); infoAdvancepayment.EmployeeId = Convert.ToDecimal(cmbEmployee.SelectedValue.ToString()); infoAdvancepayment.SalaryMonth = Convert.ToDateTime(dtpSalaryMonth.Text.ToString()); infoAdvancepayment.Chequenumber = txtCheckNo.Text.ToString(); infoAdvancepayment.Date = Convert.ToDateTime(txtDate.Text.ToString()); infoAdvancepayment.Amount = Convert.ToDecimal(txtAmount.Text.ToString()); if (CheckAdvanceAmount()) { if (isAutomatic) { infoAdvancepayment.VoucherNo = strVoucherNo; } else { infoAdvancepayment.VoucherNo = txtAdvanceVoucherNo.Text.Trim(); } if (isAutomatic) { infoAdvancepayment.InvoiceNo = strInvoiceNo; } else { infoAdvancepayment.InvoiceNo = txtAdvanceVoucherNo.Text.Trim(); } infoAdvancepayment.LedgerId = Convert.ToDecimal(cmbCashOrBank.SelectedValue.ToString()); infoAdvancepayment.ChequeDate = Convert.ToDateTime(txtChequeDate.Text.ToString()); infoAdvancepayment.Narration = txtNarration.Text.Trim(); infoAdvancepayment.ExtraDate = Convert.ToDateTime(DateTime.Now.ToString()); infoAdvancepayment.Extra1 = string.Empty; infoAdvancepayment.Extra2 = string.Empty; infoAdvancepayment.VoucherTypeId = decPaymentVoucherTypeId; infoAdvancepayment.SuffixPrefixId = decPaymentSuffixPrefixId; infoAdvancepayment.FinancialYearId = PublicVariables._decCurrentFinancialYearId; spAdvancepayment.AdvancePaymentEdit(infoAdvancepayment); LedgerUpdate(); Messages.UpdatedMessage(); txtAdvanceVoucherNo.Focus(); this.Close(); } } else { Messages.ReferenceExistsMessageForUpdate(); dtpSalaryMonth.Focus(); } } catch (Exception ex) { MessageBox.Show("AP3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }