/// <summary> /// Function to Update values in PDCClearanceMaster Table /// </summary> /// <param name="pdcclearancemasterinfo"></param> public void PDCClearanceMasterEdit(PDCClearanceMasterInfo pdcclearancemasterinfo) { try { spPdcClearanceMaster.PDCClearanceMasterEdit(pdcclearancemasterinfo); } catch (Exception ex) { MessageBox.Show("PDCC8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Function to insert values to PDCClearanceMaster Table /// </summary> /// <param name="pdcclearancemasterinfo"></param> /// <returns></returns> public decimal PDCClearanceMasterAdd(PDCClearanceMasterInfo pdcclearancemasterinfo) { decimal decIdentity = 0; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("PDCClearanceMasterAdd", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.VoucherNo; sprmparam = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.InvoiceNo; sprmparam = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.SuffixPrefixId; sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime); sprmparam.Value = pdcclearancemasterinfo.Date; sprmparam = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.LedgerId; sprmparam = sccmd.Parameters.Add("@type", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.Type; sprmparam = sccmd.Parameters.Add("@againstId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.AgainstId; sprmparam = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.VoucherTypeId; sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.Narration; sprmparam = sccmd.Parameters.Add("@status", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.Status; sprmparam = sccmd.Parameters.Add("@userId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.UserId; sprmparam = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal); sprmparam.Value = pdcclearancemasterinfo.FinancialYearId; sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.Extra1; sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam.Value = pdcclearancemasterinfo.Extra2; decIdentity = Convert.ToDecimal(sccmd.ExecuteScalar().ToString()); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sqlcon.Close(); } return(decIdentity); }
public void PDCClearanceMasterEdit(PDCClearanceMasterInfo pdcclearancemasterinfo) { try { if (base.sqlcon.State == ConnectionState.Closed) { base.sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("PDCClearanceMasterEdit", base.sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam16 = new SqlParameter(); sprmparam16 = sccmd.Parameters.Add("@PDCClearanceMasterId", SqlDbType.Decimal); sprmparam16.Value = pdcclearancemasterinfo.PDCClearanceMasterId; sprmparam16 = sccmd.Parameters.Add("@voucherNo", SqlDbType.VarChar); sprmparam16.Value = pdcclearancemasterinfo.VoucherNo; sprmparam16 = sccmd.Parameters.Add("@invoiceNo", SqlDbType.VarChar); sprmparam16.Value = pdcclearancemasterinfo.InvoiceNo; sprmparam16 = sccmd.Parameters.Add("@suffixPrefixId", SqlDbType.Decimal); sprmparam16.Value = pdcclearancemasterinfo.SuffixPrefixId; sprmparam16 = sccmd.Parameters.Add("@date", SqlDbType.DateTime); sprmparam16.Value = pdcclearancemasterinfo.Date; sprmparam16 = sccmd.Parameters.Add("@ledgerId", SqlDbType.Decimal); sprmparam16.Value = pdcclearancemasterinfo.LedgerId; sprmparam16 = sccmd.Parameters.Add("@type", SqlDbType.VarChar); sprmparam16.Value = pdcclearancemasterinfo.Type; sprmparam16 = sccmd.Parameters.Add("@againstId", SqlDbType.Decimal); sprmparam16.Value = pdcclearancemasterinfo.AgainstId; sprmparam16 = sccmd.Parameters.Add("@voucherTypeId", SqlDbType.Decimal); sprmparam16.Value = pdcclearancemasterinfo.VoucherTypeId; sprmparam16 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar); sprmparam16.Value = pdcclearancemasterinfo.Narration; sprmparam16 = sccmd.Parameters.Add("@status", SqlDbType.VarChar); sprmparam16.Value = pdcclearancemasterinfo.Status; sprmparam16 = sccmd.Parameters.Add("@userId", SqlDbType.Decimal); sprmparam16.Value = pdcclearancemasterinfo.UserId; sprmparam16 = sccmd.Parameters.Add("@financialYearId", SqlDbType.Decimal); sprmparam16.Value = pdcclearancemasterinfo.FinancialYearId; sprmparam16 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar); sprmparam16.Value = pdcclearancemasterinfo.Extra1; sprmparam16 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar); sprmparam16.Value = pdcclearancemasterinfo.Extra2; sccmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { base.sqlcon.Close(); } }
/// <summary> /// Function to get particular values from PDCClearanceMaster Table based on the parameter /// </summary> /// <param name="PDCClearanceMasterId"></param> /// <returns></returns> public PDCClearanceMasterInfo PDCClearanceMasterView(decimal PDCClearanceMasterId) { PDCClearanceMasterInfo pdcclearancemasterinfo = new PDCClearanceMasterInfo(); try { pdcclearancemasterinfo = spPdcClearanceMaster.PDCClearanceMasterView(PDCClearanceMasterId); } catch (Exception ex) { MessageBox.Show("PDCC10:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(pdcclearancemasterinfo); }
/// <summary> /// Function to insert values to PDCClearanceMaster Table /// </summary> /// <param name="pdcclearancemasterinfo"></param> /// <returns></returns> public decimal PDCClearanceMasterAdd(PDCClearanceMasterInfo pdcclearancemasterinfo) { decimal decIdentity = 0; try { decIdentity = spPdcClearanceMaster.PDCClearanceMasterAdd(pdcclearancemasterinfo); } catch (Exception ex) { MessageBox.Show("PDCC7:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(decIdentity); }
/// <summary> /// /// </summary> /// <param name="PDCClearanceMasterId"></param> /// <returns></returns> public PDCClearanceMasterInfo PDCClearanceMasterView(decimal PDCClearanceMasterId) { PDCClearanceMasterInfo infoPDCClearanceMaster = new PDCClearanceMasterInfo(); try { infoPDCClearanceMaster = spPDCClearanceMaster.PDCClearanceMasterView(PDCClearanceMasterId); } catch (Exception ex) { MessageBox.Show("PCRE11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } return(infoPDCClearanceMaster); }
/// <summary> /// Function to get particular values from PDCClearanceMaster Table based on the parameter /// </summary> /// <param name="PDCClearanceMasterId"></param> /// <returns></returns> public PDCClearanceMasterInfo PDCClearanceMasterView(decimal PDCClearanceMasterId) { PDCClearanceMasterInfo pdcclearancemasterinfo = new PDCClearanceMasterInfo(); SqlDataReader sdrreader = null; try { if (sqlcon.State == ConnectionState.Closed) { sqlcon.Open(); } SqlCommand sccmd = new SqlCommand("PDCClearanceMasterView", sqlcon); sccmd.CommandType = CommandType.StoredProcedure; SqlParameter sprmparam = new SqlParameter(); sprmparam = sccmd.Parameters.Add("@PDCClearanceMasterId", SqlDbType.Decimal); sprmparam.Value = PDCClearanceMasterId; sdrreader = sccmd.ExecuteReader(); while (sdrreader.Read()) { pdcclearancemasterinfo.PDCClearanceMasterId = decimal.Parse(sdrreader[0].ToString()); pdcclearancemasterinfo.VoucherNo = sdrreader[1].ToString(); pdcclearancemasterinfo.InvoiceNo = sdrreader[2].ToString(); pdcclearancemasterinfo.SuffixPrefixId = decimal.Parse(sdrreader[3].ToString()); pdcclearancemasterinfo.Date = DateTime.Parse(sdrreader[4].ToString()); pdcclearancemasterinfo.LedgerId = decimal.Parse(sdrreader[5].ToString()); pdcclearancemasterinfo.Type = sdrreader[6].ToString(); pdcclearancemasterinfo.AgainstId = decimal.Parse(sdrreader[7].ToString()); pdcclearancemasterinfo.VoucherTypeId = decimal.Parse(sdrreader[8].ToString()); pdcclearancemasterinfo.Narration = sdrreader[9].ToString(); pdcclearancemasterinfo.Status = sdrreader[10].ToString(); pdcclearancemasterinfo.UserId = decimal.Parse(sdrreader[11].ToString()); pdcclearancemasterinfo.FinancialYearId = decimal.Parse(sdrreader[12].ToString()); pdcclearancemasterinfo.ExtraDate = DateTime.Parse(sdrreader[13].ToString()); pdcclearancemasterinfo.Extra1 = sdrreader[14].ToString(); pdcclearancemasterinfo.Extra2 = sdrreader[15].ToString(); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } finally { sdrreader.Close(); sqlcon.Close(); } return(pdcclearancemasterinfo); }
/// <summary> /// Save Function /// </summary> public void SaveFunction() { try { DateValidation Objdatevalidation = new DateValidation(); OtherDateValidationFunction ObjotherdateValidation = new OtherDateValidationFunction(); Objdatevalidation.DateValidationFunction(txtVoucherDate); AccountLedgerBll bllAccountLedger = new AccountLedgerBll(); SettingsBll BllSettings = new SettingsBll(); txtVoucherDate.Text = txtVoucherDate.Text.Trim(); cmbvouchertype.Text = cmbvouchertype.Text.Trim(); txtAmount.Text = txtAmount.Text.Trim(); txtBank.Text = txtBank.Text.Trim(); txtcheckdate.Text = txtcheckdate.Text.Trim(); txtcheckNo.Text = txtcheckNo.Text.Trim(); txtNarration.Text = txtNarration.Text.Trim(); DataTable dtblMaster = new DataTable(); PDCClearanceBll BllPdcClearance = new PDCClearanceBll(); PDCClearanceMasterInfo infoPdcclearance = new PDCClearanceMasterInfo(); infoPdcclearance.SuffixPrefixId = decSufixprefixPdcpayableID; infoPdcclearance.FinancialYearId = Convert.ToDecimal(PublicVariables._decCurrentFinancialYearId.ToString()); infoPdcclearance.VoucherNo = strVoucherNo; infoPdcclearance.InvoiceNo = txtvoucherNo.Text; if (txtVoucherDate.Text != string.Empty) infoPdcclearance.Date = Convert.ToDateTime(txtVoucherDate.Text); else infoPdcclearance.Date = DateTime.Now; infoPdcclearance.LedgerId = decimal.Parse(strledgerId.ToString()); infoPdcclearance.AgainstId = decmasterId; infoPdcclearance.UserId = PublicVariables._decCurrentUserId; infoPdcclearance.VoucherTypeId = decPDCclearanceVoucherTypeId; infoPdcclearance.Status = cmbStatus.Text.ToString(); infoPdcclearance.Type = cmbvouchertype.Text.ToString(); infoPdcclearance.ExtraDate = DateTime.Now; infoPdcclearance.Narration = txtNarration.Text; infoPdcclearance.Extra1 = string.Empty; infoPdcclearance.Extra2 = string.Empty; if (!isInEditMode) { decimal decIdentity = BllPdcClearance.PDCClearanceMasterAdd(infoPdcclearance); LedgerPostingAdd(); if (cmbStatus.Text.ToString() == "Bounced") { if (bllAccountLedger.AccountGroupIdCheck(txtAccountLedger.Text.ToString())) { PartyBalanceAddOrEdit(); } } Messages.SavedMessage(); if (cbxPrint.Checked) { if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix") { PrintForDotMatrix(decIdentity); } else { Print(decIdentity); } } ClearFunction(); } else { decimal decIdentity = decPDCClearanceEditId; infoPdcclearance.PDCClearanceMasterId = decPDCClearanceEditId; BllPdcClearance.PDCClearanceMasterEdit(infoPdcclearance); bllAccountLedger.LedgerPostingDeleteByVoucherTypeAndVoucherNo(strVoucherNo, decPDCclearanceVoucherTypeId); LedgerPostingAdd(); bllAccountLedger.PartyBalanceDeleteByVoucherTypeVoucherNoAndReferenceType(strVoucherNo, decPDCclearanceVoucherTypeId); if (cmbStatus.Text.ToString() == "Bounced") { if (bllAccountLedger.AccountGroupIdCheck(txtAccountLedger.Text.ToString())) { PartyBalanceAddOrEdit(); } } Messages.UpdatedMessage(); if (cbxPrint.Checked) { if (BllSettings.SettingsStatusCheck("Printer") == "Dot Matrix") { PrintForDotMatrix(decIdentity); } else { Print(decIdentity); } } this.Close(); } } catch (Exception ex) { MessageBox.Show("PC11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
/// <summary> /// Its the fill function to update or delete /// </summary> public void FillFunction() { try { PDCClearanceMasterInfo infoPDCClearance = new PDCClearanceMasterInfo(); PDCClearanceBll BllPdcClearance = new PDCClearanceBll(); infoPDCClearance = BllPdcClearance.PDCClearanceMasterView(decPDCClearanceEditId); VoucherTypeComboFill(); strVoucherNo = infoPDCClearance.VoucherNo; strInvoiceNo = infoPDCClearance.InvoiceNo; txtvoucherNo.Text = strInvoiceNo; decSufixprefixPdcpayableID = infoPDCClearance.SuffixPrefixId; decPDCclearanceVoucherTypeId = infoPDCClearance.VoucherTypeId; VoucherTypeBll BllVOucherType = new VoucherTypeBll(); isAutomatic = BllVOucherType.CheckMethodOfVoucherNumbering(decPDCclearanceVoucherTypeId); if (isAutomatic) { txtvoucherNo.ReadOnly = true; } else { txtvoucherNo.ReadOnly = false; } if (infoPDCClearance.PDCClearanceMasterId != 0) { txtvoucherNo.Text = infoPDCClearance.VoucherNo; dtpVoucherDate.Value = infoPDCClearance.Date; txtVoucherDate.Text = dtpVoucherDate.Value.ToString("dd-MMM-yyyy"); txtNarration.Text = infoPDCClearance.Narration; cmbvouchertype.Text = infoPDCClearance.Type; InvoiceNumberCombofill(cmbvouchertype.Text.ToString(), decMasterIdEdit); cmbStatus.Text = infoPDCClearance.Status; cmbInvoiceNo.SelectedValue = decMasterIdEdit; btnSave.Text = "Update"; } } catch (Exception ex) { MessageBox.Show("PC14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information); } }