/// <summary>
/// Function to generate Voucher number as per settings
/// </summary>
public void VoucherNumberGeneration()
{
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
TransactionsGeneralFillBll TransactionGenerateFillObj = new TransactionsGeneralFillBll();
DeliveryNoteBll bllDeliveryNote = new DeliveryNoteBll();
string tableName = "DeliveryNoteMaster";
string strPrefix = string.Empty;
string strSuffix = string.Empty;
try
{
strVoucherNo = "0";
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0";
}
strVoucherNo = TransactionGenerateFillObj.VoucherNumberAutomaicGeneration(decDeliveryNoteVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
if (Convert.ToDecimal(strVoucherNo) != bllDeliveryNote.DeliveryNoteMasterGetMaxPlusOne(decDeliveryNoteVoucherTypeId))
{
strVoucherNo = bllDeliveryNote.DeliveryNoteMasterMax1(decDeliveryNoteVoucherTypeId).ToString();
strVoucherNo = TransactionGenerateFillObj.VoucherNumberAutomaicGeneration(decDeliveryNoteVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
if (bllDeliveryNote.DeliveryNoteMasterMax1(decDeliveryNoteVoucherTypeId) == "0")
{
strVoucherNo = "0";
strVoucherNo = TransactionGenerateFillObj.VoucherNumberAutomaicGeneration(decDeliveryNoteVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
}
}
if (isAutomatic)
{
infoSuffixPrefix = new SuffixPrefixSettingsBll().GetSuffixPrefixDetails(decDeliveryNoteVoucherTypeId, dtpDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
decDeliveryNoteSuffixPrefixId = infoSuffixPrefix.SuffixprefixId;
strDeliveryNoteNo = strPrefix + strVoucherNo + strSuffix;
txtDeliveryNoteNo.Text = strDeliveryNoteNo;
txtDeliveryNoteNo.ReadOnly = true;
}
else
{
txtDeliveryNoteNo.Text = string.Empty;
strDeliveryNoteNo = txtDeliveryNoteNo.Text.Trim();
}
}
catch (Exception ex)
{
MessageBox.Show("DN09:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to reset the form to make new service voucher
/// </summary>
public void Clear()
{
try
{
/*Automatic invoice number generation*/
TransactionsGeneralFillBll obj = new TransactionsGeneralFillBll();
VoucherDate();
if (isAutomatic) // Checking voucher number generation is automatic or not
{
ServicesBll BllService = new ServicesBll();
ContraVoucherDetailsBll bllContraVoucherDetails = new ContraVoucherDetailsBll();
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0";
}
strVoucherNo = obj.VoucherNumberAutomaicGeneration(DecServicetVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, tableName);
if (Convert.ToDecimal(strVoucherNo) != (BllService.ServiceMasterGetMax(DecServicetVoucherTypeId)) + 1)
{
strVoucherNo = BllService.ServiceMasterGetMax(DecServicetVoucherTypeId).ToString();
strVoucherNo = obj.VoucherNumberAutomaicGeneration(DecServicetVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, tableName);
if (BllService.ServiceMasterGetMax(DecServicetVoucherTypeId) == 0)
{
strVoucherNo = "0";
strVoucherNo = obj.VoucherNumberAutomaicGeneration(DecServicetVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, tableName);
}
}
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(DecServicetVoucherTypeId, dtpVoucherDate.Value); // Getting suffix-prefix settings
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
decServiceSuffixPrefixId = infoSuffixPrefix.SuffixprefixId;
strInvoiceNo = strPrefix + strVoucherNo + strSuffix; // Generating invoice number with suffix and prefix
txtInvoiceNumber.Text = strInvoiceNo;
txtInvoiceNumber.ReadOnly = true;
txtVoucherDate.Select();
}
else
{
txtInvoiceNumber.Text = string.Empty;
txtInvoiceNumber.ReadOnly = false;
}
ServiceAcoountComboFill();
GridParticularComboFill();
SalesmanComboFill();
CashOrPartyComboFill();
isEditMode = false;
txtDiscount.Text = "0";
txtTotalAmount.Text = "0";
txtGrandTotal.Text = "0";
txtCreditPeriod.Text = "0";
txtCustomer.Text = string.Empty;
txtNarration.Text = string.Empty;
PrintCheck();
int inCount = dgvServiceVoucher.RowCount;
for (int i = 0; i < inCount; i++)
{
dgvServiceVoucher.Rows[i].Cells["dgvcmbParticulars"].Value = null;
dgvServiceVoucher.Rows[i].Cells["dgvtxtMeasure"].Value = null;
dgvServiceVoucher.Rows[i].Cells["dgvtxtAmount"].Value = null;
}
dgvServiceVoucher.ClearSelection();
btnDelete.Enabled = false;
btnSave.Text = "Save";
dgvServiceVoucher.Rows.Clear();
}
catch (Exception ex)
{
MessageBox.Show("SV 04 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// These function for generating the voucher no automatically if its automatic with preffix and sufix
/// </summary>
public void VoucherNumberGeneration()
{
try
{
TransactionsGeneralFillBll obj = new TransactionsGeneralFillBll();
//ContraMasterSP spContraMaster = new ContraMasterSP();
ContraVoucherDetailsBll bllContraVoucherDetails = new ContraVoucherDetailsBll();
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0";
}
strVoucherNo = obj.VoucherNumberAutomaicGeneration(DecContraVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpContraVoucherDate.Value, tableName);
if (Convert.ToDecimal(strVoucherNo) != bllContraVoucherDetails.ContraVoucherMasterGetMaxPlusOne(DecContraVoucherTypeId))
{
strVoucherNo = bllContraVoucherDetails.ContraVoucherMasterGetMax(DecContraVoucherTypeId).ToString();
strVoucherNo = obj.VoucherNumberAutomaicGeneration(DecContraVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpContraVoucherDate.Value, tableName);
if (bllContraVoucherDetails.ContraVoucherMasterGetMax(DecContraVoucherTypeId) == "0")
{
strVoucherNo = "0";
strVoucherNo = obj.VoucherNumberAutomaicGeneration(DecContraVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpContraVoucherDate.Value, tableName);
}
}
if (isAutomatic)
{
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(DecContraVoucherTypeId, dtpContraVoucherDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
decContraSuffixPrefixId = infoSuffixPrefix.SuffixprefixId;
strInvoiceNo = strPrefix + strVoucherNo + strSuffix;
txtVoucherNo.Text = strInvoiceNo;
txtVoucherNo.ReadOnly = true;
}
}
catch (Exception ex)
{
MessageBox.Show("CV:08" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Voucher no generation function based on the settings
/// </summary>
public void VoucherNumberGeneration()
{
try
{
TransactionsGeneralFillBll obj = new TransactionsGeneralFillBll();
PDCRecivebleBll BllPdcRecieveble = new PDCRecivebleBll();
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0";
}
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decPDCReceivableVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, strtableName);
if (Convert.ToDecimal(strVoucherNo) != BllPdcRecieveble.PDCReceivableMaxUnderVoucherTypePlusOne(decPDCReceivableVoucherTypeId))
{
strVoucherNo = BllPdcRecieveble.PDCReceivableMaxUnderVoucherType(decPDCReceivableVoucherTypeId).ToString();
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decPDCReceivableVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, strtableName);
if (BllPdcRecieveble.PDCReceivableMaxUnderVoucherType(decPDCReceivableVoucherTypeId).ToString() == "0")
{
strVoucherNo = "0";
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decPDCReceivableVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, strtableName);
}
}
if (isAutomatic)
{
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decPDCReceivableVoucherTypeId, dtpVoucherDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
decSufixprefixPdcReceivableID = infoSuffixPrefix.SuffixprefixId;
strInvoiceNo = strPrefix + strVoucherNo + strSuffix;
txtVoucherNo.Text = strInvoiceNo;
txtVoucherNo.ReadOnly = true;
txtVoucherNo.Enabled = false;
lblVoucherNoManualValidator.Visible = false;
}
else
{
txtVoucherNo.ReadOnly = false;
txtVoucherNo.Text = string.Empty;
lblVoucherNoManualValidator.Visible = true;
strInvoiceNo = txtVoucherNo.Text.Trim();
}
}
catch (Exception ex)
{
MessageBox.Show("PR17:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to reset the form to create new sales quatation
/// </summary>
public void Clear()
{
TransactionsGeneralFillBll transactionGeneralFillObj = new TransactionsGeneralFillBll();
SalesQuotationBll bllSalesQuotation = new SalesQuotationBll();
try
{
if (isAutomatic)
{
strSalesQuotationNo = bllSalesQuotation.SalesQuotationMasterGetMax(decsalesQuotationTypeId).ToString();
if (strSalesQuotationNo == string.Empty)
{
strSalesQuotationNo = " 0";
}
strSalesQuotationNo = transactionGeneralFillObj.VoucherNumberAutomaicGeneration(decsalesQuotationTypeId, Convert.ToDecimal(strSalesQuotationNo), dtpSalesQuotationDate.Value, tableName);
if (Convert.ToDecimal(strSalesQuotationNo) != bllSalesQuotation.SalesQuotationMaxGetPlusOne(decsalesQuotationTypeId))
{
strSalesQuotationNo = Convert.ToString(bllSalesQuotation.SalesQuotationMaxGetPlusOne(decsalesQuotationTypeId));
strSalesQuotationNo = transactionGeneralFillObj.VoucherNumberAutomaicGeneration(decsalesQuotationTypeId, Convert.ToDecimal(strSalesQuotationNo), dtpSalesQuotationDate.Value, tableName);
if (bllSalesQuotation.SalesQuotationMasterGetMax(decsalesQuotationTypeId) == 0)
{
strSalesQuotationNo = "0";
strSalesQuotationNo = transactionGeneralFillObj.VoucherNumberAutomaicGeneration(decsalesQuotationTypeId, Convert.ToDecimal(strSalesQuotationNo), dtpSalesQuotationDate.Value, tableName);
}
}
if (isAutomatic)
{
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decsalesQuotationTypeId, dtpSalesQuotationDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
decSalesQuotationPreffixSuffixId = infoSuffixPrefix.SuffixprefixId;
strInvoiceNo = strPrefix + strSalesQuotationNo + strSuffix;
txtQuotationNo.Text = strInvoiceNo;
txtQuotationNo.ReadOnly = true;
}
}
else
{
txtQuotationNo.Text = string.Empty;
}
salesQuotationDatefill();
if (!ShowProductCode())
{
this.dgvProduct.Columns["dgvtxtProductCode"].Visible = false;
}
if (!ShowBarcode())
{
this.dgvProduct.Columns["dgvtxtBarcode"].Visible = false;
}
if (PrintAfetrSave())
{
cbxPrintAfterSave.Checked = true;
}
else
{
cbxPrintAfterSave.Checked = false;
}
dgvProduct.Rows.Clear();
txtNarration.Text = string.Empty;
txtTotal.Text = string.Empty;
btnSave.Text = "Save";
btnDelete.Enabled = false;
cbxApproved.Checked = false;
ComboCurrencyFill();
ComboPricingLevelFill();
ComboSalesManFill();
CashOrPartyCombofill();
FillProducts(false, null);
}
catch (Exception ex)
{
MessageBox.Show("SQ:31" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to generate the voucher number as per settings
/// </summary>
public void voucherNumberGeneration()
{
try
{
TransactionsGeneralFillBll obj = new TransactionsGeneralFillBll();
SalaryVoucherBll BllSalaryVoucher = new SalaryVoucherBll();
//-----------------------------------------Voucher number Automatic generation ------------------------------------------------//
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0";
}
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decMonthlyVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, tableName);
if (Convert.ToDecimal(strVoucherNo) != BllSalaryVoucher.SalaryVoucherMasterGetMaxPlusOne(decMonthlyVoucherTypeId))
{
strVoucherNo = BllSalaryVoucher.SalaryVoucherMasterGetMax(decMonthlyVoucherTypeId).ToString();
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decMonthlyVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, tableName);
if (BllSalaryVoucher.SalaryVoucherMasterGetMax(decMonthlyVoucherTypeId) == "0")
{
strVoucherNo = "0";
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decMonthlyVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, tableName);
}
}
if (isAutomatic)
{
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decMonthlyVoucherTypeId, dtpVoucherDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
strInvoiceNo = strPrefix + strVoucherNo + strSuffix;
txtVoucherNo.Text = strInvoiceNo;
txtVoucherNo.ReadOnly = true;
}
}
catch (Exception ex)
{
MessageBox.Show("MSV14:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to clear the fields
/// </summary>
public void clear()
{
try
{
TransactionsGeneralFillBll obj = new TransactionsGeneralFillBll();
JournalVoucherBll bllJournalVoucher = new JournalVoucherBll();
//-----------------------------------VoucherNo automatic generation-------------------------------------------//
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0"; //strMax;
}
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decJournalVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, tableName);
if (Convert.ToDecimal(strVoucherNo) != bllJournalVoucher.JournalMasterGetMaxPlusOne(decJournalVoucherTypeId))
{
strVoucherNo = bllJournalVoucher.JournalMasterGetMax(decJournalVoucherTypeId).ToString();
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decJournalVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, tableName);
if (bllJournalVoucher.JournalMasterGetMax(decJournalVoucherTypeId).ToString() == "0")
{
strVoucherNo = "0";
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decJournalVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpVoucherDate.Value, tableName);
}
}
//===================================================================================================================//
if (isAutomatic)
{
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decJournalVoucherTypeId, dtpVoucherDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
strInvoiceNo = strPrefix + strVoucherNo + strSuffix;
txtVoucherNo.Text = strInvoiceNo;
txtVoucherNo.ReadOnly = true;
}
else
{
txtVoucherNo.ReadOnly = false;
txtVoucherNo.Text = string.Empty;
strInvoiceNo = txtVoucherNo.Text.Trim();
}
dgvJournalVoucher.Rows.Clear();
VoucherDate();
dtpVoucherDate.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
txtDebitTotal.Text = string.Empty;
txtCreditTotal.Text = string.Empty;
txtNarration.Text = string.Empty;
btnSave.Text = "Save";
btnDelete.Enabled = false;
isEditMode = false;
dtblPartyBalance.Clear();//to clear party balance entries to clear the dgvpatybalance
PrintCheck();
if (!txtVoucherNo.ReadOnly)
{
txtVoucherNo.Focus();
}
else
{
txtDate.Select();
}
}
catch (Exception ex)
{
MessageBox.Show("JV2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// To reset the form here and Generate the voucher no generation
/// </summary>
public void Clear()
{
try
{
TransactionsGeneralFillBll obj = new TransactionsGeneralFillBll();
if (btnSave.Text == "Update")
{
if (frmPaymentRegisterObj != null)
{
frmPaymentRegisterObj.Close();
}
}
if (isAutomatic)
{
SalaryVoucherBll BllSalaryVoucher = new SalaryVoucherBll();
//PaymentMasterSP SpPaymentMaster = new PaymentMasterSP();
PaymentVoucherBll BllPaymentVoucher = new PaymentVoucherBll();
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0";
}
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decPaymentVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
if (Convert.ToDecimal(strVoucherNo) != BllPaymentVoucher.PaymentMasterMax(decPaymentVoucherTypeId) + 1)
{
strVoucherNo = BllPaymentVoucher.PaymentMasterMax(decPaymentVoucherTypeId).ToString();
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decPaymentVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
if (BllPaymentVoucher.PaymentMasterMax(decPaymentVoucherTypeId) == 0)
{
strVoucherNo = "0";
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decPaymentVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
}
}
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decPaymentVoucherTypeId, dtpDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
strInvoiceNo = strPrefix + strVoucherNo + strSuffix;
txtVoucherNo.Text = strInvoiceNo;
txtVoucherNo.ReadOnly = true;
}
else
{
txtVoucherNo.Text = string.Empty;
txtVoucherNo.ReadOnly = false;
}
dtpDate.MinDate = PublicVariables._dtFromDate;
dtpDate.MaxDate = PublicVariables._dtToDate;
dtpDate.Value = PublicVariables._dtCurrentDate;
cmbBankorCash.SelectedIndex = -1;
txtNarration.Text = string.Empty;
txtTotal.Text = string.Empty;
dgvPaymentVoucher.ClearSelection();
dgvPaymentVoucher.Rows.Clear();
btnSave.Text = "Save";
btnDelete.Enabled = false;
cbxPrintafterSave.Checked = false;
dtblPartyBalance.Clear();
if (isAutomatic)
{
txtDate.Select();
}
else
{
txtVoucherNo.Select();
}
PrintCheck();
}
catch (Exception ex)
{
MessageBox.Show("PV9:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function for Voucher Number Generation
/// </summary>
public void VoucherNumberGeneration()
{
string strPrefix = string.Empty;
string strSuffix = string.Empty;
string tableName = "PurchaseReturnMaster";
string strReturnNo = string.Empty;
TransactionsGeneralFillBll TransactionGeneralFillObj = new TransactionsGeneralFillBll();
PurchaseReturnBll BllPurchaseReturn = new PurchaseReturnBll();
try
{
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0";
}
strVoucherNo = TransactionGeneralFillObj.VoucherNumberAutomaicGeneration(decPurchaseReturnVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
if (Convert.ToDecimal(strVoucherNo) != BllPurchaseReturn.PurchaseReturnMasterGetMaxPlusOne(decPurchaseReturnVoucherTypeId))
{
strVoucherNo = BllPurchaseReturn.PurchaseReturnMasterGetMax(decPurchaseReturnVoucherTypeId).ToString();
strVoucherNo = TransactionGeneralFillObj.VoucherNumberAutomaicGeneration(decPurchaseReturnVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
if (BllPurchaseReturn.PurchaseReturnMasterGetMax(decPurchaseReturnVoucherTypeId) == "0")
{
strVoucherNo = "0";
strVoucherNo = TransactionGeneralFillObj.VoucherNumberAutomaicGeneration(decPurchaseReturnVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
}
}
if (isAutomatic)
{
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decPurchaseReturnVoucherTypeId, dtpDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
decPurchaseReturnSuffixPrefixId = infoSuffixPrefix.SuffixprefixId;
strReturnNo = strPrefix + strVoucherNo + strSuffix;
txtReturnNo.Text = strReturnNo;
txtReturnNo.ReadOnly = true;
}
}
catch (Exception ex)
{
MessageBox.Show("PR:27" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to clear the fields
/// </summary>
public void Clear()
{
try
{
TransactionsGeneralFillBll obj = new TransactionsGeneralFillBll();
StockJournalBll BllStockJournal = new StockJournalBll();
if (isAutomatic)
{
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0";
}
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, TableName);
if (Convert.ToDecimal(strVoucherNo) != BllStockJournal.StockJournalMasterMaxPlusOne(decVoucherTypeId))
{
strVoucherNo = BllStockJournal.StockJournalMasterMax(decVoucherTypeId).ToString();
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, TableName);
if (BllStockJournal.StockJournalMasterMax(decVoucherTypeId).ToString() == "0")
{
strVoucherNo = "0";
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, TableName);
}
}
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decVoucherTypeId, dtpDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
strInvoiceNo = strPrefix + strVoucherNo + strSuffix;
txtVoucherNo.Text = strInvoiceNo;
txtVoucherNo.ReadOnly = true;
}
else
{
txtVoucherNo.ReadOnly = false;
txtVoucherNo.Text = string.Empty;
strInvoiceNo = txtVoucherNo.Text.Trim();
}
if (PrintAfetrSave())
{
cbxPrintAfterSave.Checked = true;
}
else
{
cbxPrintAfterSave.Checked = false;
}
btnDelete.Enabled = false;
btnSave.Text = "Save";
gbxTransactionType.Enabled = true;
cmbFinishedGoods.Enabled = true;
txtQty.Enabled = true;
btnAdd.Enabled = true;
VoucherDate();
dgvConsumption.Rows.Clear();
dgvProduction.Rows.Clear();
dgvAdditionalCost.Rows.Clear();
cmbFinishedGoods.Text = string.Empty;
txtQty.Text = String.Empty;
txtNarration.Text = string.Empty;
lblAdditionalCostAmount.Text = "0.00";
lblConsumptionAmount.Text = "0.00";
lblProductionAmount.Text = "0.00";
}
catch (Exception ex)
{
MessageBox.Show("SJ:29" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to generate Voucher number as per settings
/// </summary>
public void VoucherNoGeneration()
{
TransactionsGeneralFillBll obj = new TransactionsGeneralFillBll();
AdvancePaymentBll bllAdvancePayment = new AdvancePaymentBll();
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0";
}
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decPaymentVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpSalaryMonth.Value, strAdvancePayment);
if (Convert.ToDecimal(strVoucherNo) != bllAdvancePayment.AdvancePaymentGetMaxPlusOne(decPaymentVoucherTypeId))
{
strVoucherNo = bllAdvancePayment.AdvancePaymentGetMax(decPaymentVoucherTypeId).ToString();
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decPaymentVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpSalaryMonth.Value, strAdvancePayment);
if (bllAdvancePayment.AdvancePaymentGetMax(decPaymentVoucherTypeId) == "0")
{
strVoucherNo = "0";
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decPaymentVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpSalaryMonth.Value, strAdvancePayment);
}
}
if (isAutomatic)
{
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decPaymentVoucherTypeId, dtpDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
strInvoiceNo = strPrefix + strVoucherNo + strSuffix;
txtAdvanceVoucherNo.Text = strInvoiceNo;
txtAdvanceVoucherNo.Enabled = false;
}
}
/// <summary>
/// Function to generate voucherNo
/// </summary>
public void VoucherNumberGeneration()
{
try
{
TransactionsGeneralFillBll obj = new TransactionsGeneralFillBll();
MaterialReceiptBll bllMaterialReceiptMaster = new MaterialReceiptBll();
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0";
}
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decMaterialReceiptVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
if (Convert.ToDecimal(strVoucherNo) != bllMaterialReceiptMaster.MaterialReceiptMasterGetMaxPlusOne(decMaterialReceiptVoucherTypeId))
{
strVoucherNo = bllMaterialReceiptMaster.MaterialReceiptMasterGetMax(decMaterialReceiptVoucherTypeId).ToString();
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decMaterialReceiptVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
if (bllMaterialReceiptMaster.MaterialReceiptMasterGetMax(decMaterialReceiptVoucherTypeId) == "0")
{
strVoucherNo = "0";
strVoucherNo = obj.VoucherNumberAutomaicGeneration(decMaterialReceiptVoucherTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, tableName);
}
}
if (isAutomatic)
{
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decMaterialReceiptVoucherTypeId, dtpDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
decMaterialReceiptSuffixPrefixId = infoSuffixPrefix.SuffixprefixId;
strReceiptNo = strPrefix + strVoucherNo + strSuffix;
txtReceiptNo.Text = strReceiptNo;
txtReceiptNo.ReadOnly = true;
}
}
catch (Exception ex)
{
MessageBox.Show("MR1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to use the voucherno Automatic generation
/// </summary>
public void VoucherNumberGeneration()
{
string strTableName = "SalesOrderMaster";
string strPrefix = string.Empty;
string strSuffix = string.Empty;
string strInvoiceNo = string.Empty;
try
{
SalesOrderBll bllSalesOrder = new SalesOrderBll();
TransactionsGeneralFillBll TransactionGeneralFillObj = new TransactionsGeneralFillBll();
if (isAutomatic)
{
strVoucherNo = "0";
if (strVoucherNo == string.Empty)
{
strVoucherNo = "0"; //strMax;
}
strVoucherNo = TransactionGeneralFillObj.VoucherNumberAutomaicGeneration(decSalesOrderTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, strTableName);
if (Convert.ToDecimal(strVoucherNo) != bllSalesOrder.SalesOrderVoucherMasterMaxPlusOne(decSalesOrderTypeId))
{
strVoucherNo = bllSalesOrder.SalesOrderVoucherMasterMax(decSalesOrderTypeId).ToString();
strVoucherNo = TransactionGeneralFillObj.VoucherNumberAutomaicGeneration(decSalesOrderTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, strTableName);
if (bllSalesOrder.SalesOrderVoucherMasterMax(decSalesOrderTypeId).ToString() == "0")
{
strVoucherNo = "0";
strVoucherNo = TransactionGeneralFillObj.VoucherNumberAutomaicGeneration(decSalesOrderTypeId, Convert.ToDecimal(strVoucherNo), dtpDate.Value, strTableName);
}
}
if (isAutomatic)
{
SuffixPrefixSettingsBll BllSuffixPrefixSettings = new SuffixPrefixSettingsBll();
SuffixPrefixInfo infoSuffixPrefix = new SuffixPrefixInfo();
infoSuffixPrefix = BllSuffixPrefixSettings.GetSuffixPrefixDetails(decSalesOrderTypeId, dtpDate.Value);
strPrefix = infoSuffixPrefix.Prefix;
strSuffix = infoSuffixPrefix.Suffix;
strInvoiceNo = strPrefix + strVoucherNo + strSuffix;
txtOrderNo.Text = strInvoiceNo;
txtOrderNo.ReadOnly = true;
}
else
{
txtOrderNo.ReadOnly = false;
txtOrderNo.Text = string.Empty;
strInvoiceNo = txtOrderNo.Text.Trim();
}
}
}
catch (Exception ex)
{
MessageBox.Show("SO40:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}