/// <summary>
/// Function to update the details
/// </summary>
public void EditFunction()
{
try
{
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
InfoSalesMaster.SalesMasterId = decSalesMasterId;
InfoSalesMaster.InvoiceNo = txtVoucherNo.Text.Trim();
InfoSalesMaster.AdditionalCost = 0;
InfoSalesMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
InfoSalesMaster.BillDiscount = Convert.ToDecimal(txtBillDiscount.Text);
InfoSalesMaster.CounterId = Convert.ToDecimal(cmbCounter.SelectedValue.ToString());
InfoSalesMaster.CreditPeriod = 0;
InfoSalesMaster.CustomerName = "";
InfoSalesMaster.Date = Convert.ToDateTime(txtDate.Text.Trim());
InfoSalesMaster.DeliveryNoteMasterId = 0;
if (cmbSalesMan.SelectedValue.ToString() != null)
{
InfoSalesMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
}
else
{
InfoSalesMaster.EmployeeId = 0;
}
decimal decExachangeRateId = spExchangeRate.ExchangerateViewByCurrencyId(PublicVariables._decCurrencyId);
InfoSalesMaster.ExchangeRateId = decExachangeRateId;
InfoSalesMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
InfoSalesMaster.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text.Trim());
InfoSalesMaster.LrNo = string.Empty;
InfoSalesMaster.Narration = txtNarration.Text.Trim();
InfoSalesMaster.OrderMasterId = 0;
InfoSalesMaster.POS = true;
InfoSalesMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
InfoSalesMaster.QuotationMasterId = 0;
InfoSalesMaster.SalesAccount = Convert.ToDecimal(cmbSalesAccount.SelectedValue.ToString());
InfoSalesMaster.TaxAmount = Convert.ToDecimal(lblTaxTotalAmount.Text);
InfoSalesMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
InfoSalesMaster.TransportationCompany = "";
InfoSalesMaster.UserId = PublicVariables._decCurrentUserId;
InfoSalesMaster.VoucherTypeId = DecPOSVoucherTypeId;
if (isAutomatic)
{
InfoSalesMaster.SuffixPrefixId = decPOSSuffixPrefixId;
}
else
{
InfoSalesMaster.SuffixPrefixId = 0;
}
if (isAutomatic)
{
InfoSalesMaster.VoucherNo = strVoucherNo;
}
else
{
InfoSalesMaster.VoucherNo = txtVoucherNo.Text.Trim();
}
InfoSalesMaster.ExtraDate = DateTime.Now;
InfoSalesMaster.Extra1 = string.Empty;
InfoSalesMaster.Extra2 = string.Empty;
spSalesMaster.SalesMasterEdit(InfoSalesMaster);
decimal dcAgainstVopucherTypeId = 0;
string strAgainstVoucherNo = "NA";
spStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType(dcAgainstVopucherTypeId, strAgainstVoucherNo, strVoucherNo, InfoSalesMaster.VoucherTypeId);
spLedgerPosting.LedgerPostDelete(InfoSalesMaster.VoucherNo, InfoSalesMaster.VoucherTypeId);
removeSalesInvoiceDetails();
SalesInvoiceDetailsEdit();
Messages.UpdatedMessage();
if (objfrmSalesInvoiceRegister != null)
{
if (cbxPrintAfterSave.Checked)
{
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesMasterId);
}
else
{
Print(decSalesMasterId);
}
}
objfrmSalesInvoiceRegister.gridFill();
}
if (frmSalesReportObj != null)
{
if (cbxPrintAfterSave.Checked)
{
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesMasterId);
}
else
{
Print(decSalesMasterId);
}
}
frmSalesReportObj.gridFill();
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("POS: 50" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save values to partyBalance table
/// </summary>
public void partyBalance()
{
try
{
PartyBalanceInfo infoPatryBalance = new PartyBalanceInfo();
PartyBalanceSP spPartyBalance = new PartyBalanceSP();
AccountLedgerSP spLedger = new AccountLedgerSP();
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
if (decOpeningBlnc > 0)
{
if (cmbBillbyBill.Text == "Yes")
{
infoPatryBalance.Date = PublicVariables._dtFromDate;
infoPatryBalance.LedgerId = decledgerid;
infoPatryBalance.VoucherTypeId = 1;
infoPatryBalance.VoucherNo = decledgerid.ToString();
infoPatryBalance.AgainstVoucherTypeId = 0;
infoPatryBalance.AgainstVoucherNo = "0";
infoPatryBalance.ReferenceType = "New";
if (cmbDrorCr.Text == "Dr")
{
infoPatryBalance.Debit = decOpeningBlnc;
infoPatryBalance.Credit = 0;
}
else
{
infoPatryBalance.Debit = 0;
infoPatryBalance.Credit = decOpeningBlnc;
}
infoPatryBalance.InvoiceNo = decledgerid.ToString();
infoPatryBalance.AgainstInvoiceNo = "0";
infoPatryBalance.CreditPeriod = 0;
infoPatryBalance.ExchangeRateId = spExchangeRate.ExchangerateViewByCurrencyId(PublicVariables._decCurrencyId);
infoPatryBalance.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPatryBalance.Extra1 = string.Empty;
infoPatryBalance.Extra2 = string.Empty;
}
spPartyBalance.PartyBalanceAdd(infoPatryBalance);
}
}
catch (Exception ex)
{
MessageBox.Show("Cus15:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save An items to table
/// </summary>
public void SaveFunction()
{
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
LedgerPostingSP spLedgerPosting = new LedgerPostingSP();
UnitConvertionSP SPUnitConversion = new UnitConvertionSP();
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
try
{
InfoSalesMaster.InvoiceNo = txtVoucherNo.Text.Trim();
InfoSalesMaster.AdditionalCost = 0;
InfoSalesMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
InfoSalesMaster.BillDiscount = Convert.ToDecimal(txtBillDiscount.Text);
if (cmbCounter.SelectedIndex > -1)
{
InfoSalesMaster.CounterId = Convert.ToDecimal(cmbCounter.SelectedValue.ToString());
}
else
{
InfoSalesMaster.CounterId = 0;
}
InfoSalesMaster.CreditPeriod = 0;
InfoSalesMaster.CustomerName = string.Empty;
InfoSalesMaster.Date = Convert.ToDateTime(txtDate.Text);
InfoSalesMaster.DeliveryNoteMasterId = 0;
if (cmbSalesMan.SelectedValue.ToString() != null)
{
InfoSalesMaster.EmployeeId = Convert.ToDecimal(cmbSalesMan.SelectedValue.ToString());
}
else
{
InfoSalesMaster.EmployeeId = 0;
}
decimal decExachangeRateId = spExchangeRate.ExchangerateViewByCurrencyId(PublicVariables._decCurrencyId);
InfoSalesMaster.ExchangeRateId = decExachangeRateId;
InfoSalesMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
InfoSalesMaster.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text.Trim());
InfoSalesMaster.LrNo = string.Empty;
InfoSalesMaster.Narration = txtNarration.Text.Trim();
InfoSalesMaster.OrderMasterId = 0;
InfoSalesMaster.POS = true;
if (cmbPricingLevel.SelectedValue.ToString() != null)
{
InfoSalesMaster.PricinglevelId = Convert.ToDecimal(cmbPricingLevel.SelectedValue.ToString());
}
else
{
InfoSalesMaster.PricinglevelId = 0;
}
InfoSalesMaster.QuotationMasterId = 0;
InfoSalesMaster.SalesAccount = Convert.ToDecimal(cmbSalesAccount.SelectedValue.ToString());
InfoSalesMaster.TaxAmount = Convert.ToDecimal(lblTaxTotalAmount.Text.ToString());
InfoSalesMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
InfoSalesMaster.TransportationCompany = string.Empty;
InfoSalesMaster.UserId = PublicVariables._decCurrentUserId;
InfoSalesMaster.VoucherTypeId = DecPOSVoucherTypeId;
if (isAutomatic)
{
InfoSalesMaster.SuffixPrefixId = decPOSSuffixPrefixId;
InfoSalesMaster.VoucherNo = strVoucherNo;
}
else
{
InfoSalesMaster.SuffixPrefixId = 0;
InfoSalesMaster.VoucherNo = txtVoucherNo.Text;
}
InfoSalesMaster.ExtraDate = DateTime.Now;
InfoSalesMaster.Extra1 = string.Empty;
InfoSalesMaster.Extra2 = string.Empty;
decSalesMasterId = spSalesMaster.SalesMasterAdd(InfoSalesMaster);
int inRowCount = dgvPointOfSales.RowCount;
InfoSalesDetails.SalesMasterId = decSalesMasterId;
InfoSalesDetails.ExtraDate = DateTime.Now;
InfoSalesDetails.Extra1 = string.Empty;
InfoSalesDetails.Extra2 = string.Empty;
for (int inI = 0; inI < inRowCount; inI++)
{
if (dgvPointOfSales.Rows[inI].Cells["dgvtxtProductName"].Value != null && dgvPointOfSales.Rows[inI].Cells["dgvtxtProductName"].Value.ToString() != string.Empty)
{
if (dgvPointOfSales.Rows[inI].Cells["dgvtxtQuantity"].Value != null && dgvPointOfSales.Rows[inI].Cells["dgvtxtQuantity"].Value.ToString() != string.Empty)
{
InfoSalesDetails.SlNo = Convert.ToInt32(dgvPointOfSales.Rows[inI].Cells["dgvtxtSlNo"].Value.ToString());
InfoSalesDetails.ProductId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtProductId"].Value.ToString());
InfoSalesDetails.Qty = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtQuantity"].Value.ToString());
InfoSalesDetails.Rate = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtRate"].Value.ToString());
InfoSalesDetails.UnitId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtUnitId"].Value.ToString());
InfoSalesDetails.UnitConversionId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtunitconversionId"].Value.ToString());
InfoSalesDetails.Discount = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtDiscount"].Value.ToString());
InfoSalesDetails.TaxId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxttaxid"].Value.ToString());
InfoSalesDetails.BatchId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtBatchId"].Value.ToString());
InfoSalesDetails.GodownId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtGodownId"].Value.ToString());
InfoSalesDetails.RackId = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtRackId"].Value.ToString());
InfoSalesDetails.TaxAmount = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtTaxAmount"].Value.ToString());
InfoSalesDetails.GrossAmount = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtGrossValue"].Value.ToString());
InfoSalesDetails.NetAmount = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtNetAmount"].Value.ToString());
InfoSalesDetails.Amount = Convert.ToDecimal(dgvPointOfSales.Rows[inI].Cells["dgvtxtTotalAmount"].Value.ToString());
spSalesDetails.SalesDetailsAdd(InfoSalesDetails);
infoStockPosting.Date = InfoSalesMaster.Date;
infoStockPosting.VoucherTypeId = DecPOSVoucherTypeId;
infoStockPosting.VoucherNo = strVoucherNo;
infoStockPosting.InvoiceNo = txtVoucherNo.Text.Trim();
infoStockPosting.AgainstVoucherTypeId = 0;
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstInvoiceNo = "NA";
infoStockPosting.ProductId = InfoSalesDetails.ProductId;
infoStockPosting.BatchId = InfoSalesDetails.BatchId;
infoStockPosting.UnitId = InfoSalesDetails.UnitId;
infoStockPosting.GodownId = InfoSalesDetails.GodownId;
infoStockPosting.RackId = InfoSalesDetails.RackId;
infoStockPosting.InwardQty = 0;
infoStockPosting.OutwardQty = InfoSalesDetails.Qty / SPUnitConversion.UnitConversionRateByUnitConversionId(InfoSalesDetails.UnitConversionId); ;
infoStockPosting.Rate = InfoSalesDetails.Rate;
infoStockPosting.FinancialYearId = InfoSalesMaster.FinancialYearId;
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
spStockPosting.StockPostingAdd(infoStockPosting);
}
}
}
int inTaxRowCount = dgvPOSTax.RowCount;
InfoSalesBillTax.SalesMasterId = decSalesMasterId;
InfoSalesBillTax.ExtraDate = DateTime.Now;
InfoSalesBillTax.Extra1 = string.Empty;
InfoSalesBillTax.Extra2 = string.Empty;
for (int inI = 0; inI < inTaxRowCount; inI++)
{
if (dgvPOSTax.Rows[inI].Cells["dgvtxttax"].Value != null && dgvPOSTax.Rows[inI].Cells["dgvtxttax"].Value.ToString() != string.Empty)
{
if (dgvPOSTax.Rows[inI].Cells["dgvtxtTaxAmt"].Value != null && dgvPOSTax.Rows[inI].Cells["dgvtxtTaxAmt"].Value.ToString() != string.Empty)
{
InfoSalesBillTax.TaxId = Convert.ToInt32(dgvPOSTax.Rows[inI].Cells["dgvtxttax"].Value.ToString());
InfoSalesBillTax.TaxAmount = Convert.ToDecimal(dgvPOSTax.Rows[inI].Cells["dgvtxtTaxAmt"].Value.ToString());
spSalesBillTax.SalesBillTaxAdd(InfoSalesBillTax);
}
}
}
ledgerPostingAdd();
if (spSalesMaster.SalesInvoiceInvoicePartyCheckEnableBillByBillOrNot(Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString())))
{
partyBalanceAdd();
}
Messages.SavedMessage();
if (cbxPrintAfterSave.Checked)
{
SettingsSP spSettings = new SettingsSP();
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decSalesMasterId);
}
else
{
Print(decSalesMasterId);
}
}
ClearFunctions();
}
catch (Exception ex)
{
MessageBox.Show("POS:44" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}