/// <summary>
/// Function to get particular values from PurchaseDetails table based on the parameter
/// </summary>
/// <param name="purchaseDetailsId"></param>
/// <returns></returns>
public PurchaseDetailsInfo PurchaseDetailsView(decimal purchaseDetailsId)
{
PurchaseDetailsInfo purchasedetailsinfo = new PurchaseDetailsInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("PurchaseDetailsView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@purchaseDetailsId", SqlDbType.Decimal);
sprmparam.Value = purchaseDetailsId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
purchasedetailsinfo.PurchaseDetailsId = decimal.Parse(sdrreader[0].ToString());
purchasedetailsinfo.PurchaseMasterId = decimal.Parse(sdrreader[1].ToString());
purchasedetailsinfo.ReceiptDetailsId = decimal.Parse(sdrreader[2].ToString());
purchasedetailsinfo.OrderDetailsId = decimal.Parse(sdrreader[3].ToString());
purchasedetailsinfo.ProductId = decimal.Parse(sdrreader[4].ToString());
purchasedetailsinfo.Qty = decimal.Parse(sdrreader[5].ToString());
purchasedetailsinfo.Rate = decimal.Parse(sdrreader[6].ToString());
purchasedetailsinfo.UnitId = decimal.Parse(sdrreader[7].ToString());
purchasedetailsinfo.UnitConversionId = decimal.Parse(sdrreader[8].ToString());
purchasedetailsinfo.Discount = decimal.Parse(sdrreader[9].ToString());
purchasedetailsinfo.TaxId = decimal.Parse(sdrreader[10].ToString());
purchasedetailsinfo.BatchId = decimal.Parse(sdrreader[11].ToString());
purchasedetailsinfo.GodownId = decimal.Parse(sdrreader[12].ToString());
purchasedetailsinfo.RackId = decimal.Parse(sdrreader[13].ToString());
purchasedetailsinfo.TaxAmount = decimal.Parse(sdrreader[14].ToString());
purchasedetailsinfo.GrossAmount = decimal.Parse(sdrreader[15].ToString());
purchasedetailsinfo.NetAmount = decimal.Parse(sdrreader[16].ToString());
purchasedetailsinfo.Amount = decimal.Parse(sdrreader[17].ToString());
purchasedetailsinfo.SlNo = int.Parse(sdrreader[18].ToString());
purchasedetailsinfo.PurchaseDetailsId = decimal.Parse(sdrreader[19].ToString());
purchasedetailsinfo.ExtraDate = DateTime.Parse(sdrreader[20].ToString());
purchasedetailsinfo.Extra1 = sdrreader[21].ToString();
purchasedetailsinfo.Extra2 = sdrreader[22].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return(purchasedetailsinfo);
}
/// <summary>
/// Function to insert values to PurchaseDetails Table
/// </summary>
/// <param name="purchasedetailsinfo"></param>
public void PurchaseDetailsAdd(PurchaseDetailsInfo purchasedetailsinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("PurchaseDetailsAdd", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@purchaseMasterId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.PurchaseMasterId;
sprmparam = sccmd.Parameters.Add("@receiptDetailsId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.ReceiptDetailsId;
sprmparam = sccmd.Parameters.Add("@orderDetailsId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.OrderDetailsId;
sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.ProductId;
sprmparam = sccmd.Parameters.Add("@qty", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.Qty;
sprmparam = sccmd.Parameters.Add("@rate", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.Rate;
sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.UnitId;
sprmparam = sccmd.Parameters.Add("@unitConversionId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.UnitConversionId;
sprmparam = sccmd.Parameters.Add("@discount", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.Discount;
sprmparam = sccmd.Parameters.Add("@taxId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.TaxId;
sprmparam = sccmd.Parameters.Add("@batchId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.BatchId;
sprmparam = sccmd.Parameters.Add("@godownId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.GodownId;
sprmparam = sccmd.Parameters.Add("@rackId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.RackId;
sprmparam = sccmd.Parameters.Add("@taxAmount", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.TaxAmount;
sprmparam = sccmd.Parameters.Add("@grossAmount", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.GrossAmount;
sprmparam = sccmd.Parameters.Add("@netAmount", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.NetAmount;
sprmparam = sccmd.Parameters.Add("@amount", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.Amount;
sprmparam = sccmd.Parameters.Add("@slNo", SqlDbType.Int);
sprmparam.Value = purchasedetailsinfo.SlNo;
sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam.Value = purchasedetailsinfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = purchasedetailsinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = purchasedetailsinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to Update values in PurchaseDetails Table
/// </summary>
/// <param name="purchasedetailsinfo"></param>
public void PurchaseDetailsEdit(PurchaseDetailsInfo purchasedetailsinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("PurchaseDetailsEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@purchaseDetailsId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.PurchaseDetailsId;
sprmparam = sccmd.Parameters.Add("@purchaseMasterId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.PurchaseMasterId;
sprmparam = sccmd.Parameters.Add("@receiptDetailsId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.ReceiptDetailsId;
sprmparam = sccmd.Parameters.Add("@orderDetailsId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.OrderDetailsId;
sprmparam = sccmd.Parameters.Add("@productId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.ProductId;
sprmparam = sccmd.Parameters.Add("@qty", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.Qty;
sprmparam = sccmd.Parameters.Add("@rate", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.Rate;
sprmparam = sccmd.Parameters.Add("@unitId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.UnitId;
sprmparam = sccmd.Parameters.Add("@unitConversionId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.UnitConversionId;
sprmparam = sccmd.Parameters.Add("@discount", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.Discount;
sprmparam = sccmd.Parameters.Add("@taxId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.TaxId;
sprmparam = sccmd.Parameters.Add("@batchId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.BatchId;
sprmparam = sccmd.Parameters.Add("@godownId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.GodownId;
sprmparam = sccmd.Parameters.Add("@rackId", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.RackId;
sprmparam = sccmd.Parameters.Add("@taxAmount", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.TaxAmount;
sprmparam = sccmd.Parameters.Add("@grossAmount", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.GrossAmount;
sprmparam = sccmd.Parameters.Add("@netAmount", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.NetAmount;
sprmparam = sccmd.Parameters.Add("@amount", SqlDbType.Decimal);
sprmparam.Value = purchasedetailsinfo.Amount;
sprmparam = sccmd.Parameters.Add("@slNo", SqlDbType.Int);
sprmparam.Value = purchasedetailsinfo.SlNo;
sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam.Value = purchasedetailsinfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = purchasedetailsinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = purchasedetailsinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
/// <summary>
/// Function to edit purchase invoice
/// </summary>
public void Edit()
{
PurchaseMasterInfo infoPurchaseMaster = new PurchaseMasterInfo();
PurchaseMasterSP spPurchaseMaster = new PurchaseMasterSP();
PurchaseDetailsInfo infoPurchaseDetails = new PurchaseDetailsInfo();
PurchaseDetailsSP spPurchaseDetails = new PurchaseDetailsSP();
MaterialReceiptMasterInfo infoMaterialReceiptMaster = new MaterialReceiptMasterInfo();
MaterialReceiptMasterSP spMaterialReceiptMaster = new MaterialReceiptMasterSP();
PurchaseOrderMasterInfo infoPurchaseOrderMaster = new PurchaseOrderMasterInfo();
PurchaseOrderMasterSP spPurchaseOrderMaster = new PurchaseOrderMasterSP();
StockPostingInfo infoStockPosting = new StockPostingInfo();
StockPostingSP spStockPosting = new StockPostingSP();
LedgerPostingInfo infoLedgerPosting = new LedgerPostingInfo();
LedgerPostingSP spLedgerPosting = new LedgerPostingSP();
PartyBalanceInfo infoPartyBalance = new PartyBalanceInfo();
PartyBalanceSP spPartyBalance = new PartyBalanceSP();
AdditionalCostInfo infoAdditionalCost = new AdditionalCostInfo();
AdditionalCostSP spAdditionalCost = new AdditionalCostSP();
PurchaseBillTaxInfo infoPurchaseBillTax = new PurchaseBillTaxInfo();
PurchaseBillTaxSP spPurchaseBillTax = new PurchaseBillTaxSP();
AccountLedgerInfo infoAccountLedger = new AccountLedgerInfo();
AccountLedgerSP spAccountLedger = new AccountLedgerSP();
UnitConvertionSP spUnitConvertion = new UnitConvertionSP();
ExchangeRateSP spExchangeRate = new ExchangeRateSP();
/*---------------------------------Deleting previous stock posting, Ledger posting, partybalanceposting---------------------------------------*/
infoPurchaseMaster = spPurchaseMaster.PurchaseMasterView(decPurchaseMasterId);
if (infoPurchaseMaster.MaterialReceiptMasterId != 0)
{
infoMaterialReceiptMaster = spMaterialReceiptMaster.MaterialReceiptMasterView(infoPurchaseMaster.MaterialReceiptMasterId);
spStockPosting.StockPostingDeleteForSalesInvoiceAgainstDeliveryNote
(infoPurchaseMaster.VoucherTypeId, infoPurchaseMaster.VoucherNo,
infoMaterialReceiptMaster.VoucherNo, infoMaterialReceiptMaster.VoucherTypeId);
}
spStockPosting.StockPostingDeleteByagainstVoucherTypeIdAndagainstVoucherNoAndVoucherNoAndVoucherType
(0, "NA", infoPurchaseMaster.VoucherNo, infoPurchaseMaster.VoucherTypeId);
try
{
RemoveDelete();
/*-----------------------------------------Purchase Master Edit----------------------------------------------------*/
infoPurchaseMaster.AdditionalCost = Convert.ToDecimal(lblAdditionalCostAmount.Text);
infoPurchaseMaster.BillDiscount = Convert.ToDecimal(txtBillDiscount.Text);
infoPurchaseMaster.CreditPeriod = txtCreditPeriod.Text;
infoPurchaseMaster.Date = Convert.ToDateTime(txtVoucherDate.Text);
infoPurchaseMaster.ExchangeRateId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoPurchaseMaster.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPurchaseMaster.GrandTotal = Convert.ToDecimal(txtGrandTotal.Text);
infoPurchaseMaster.InvoiceNo = txtVoucherNo.Text;
if (isAutomatic)
{
infoPurchaseMaster.SuffixPrefixId = decPurchaseInvoiceSuffixPrefixId;
infoPurchaseMaster.VoucherNo = strVoucherNo;
}
else
{
infoPurchaseMaster.SuffixPrefixId = 0;
infoPurchaseMaster.VoucherNo = strVoucherNo;
}
infoPurchaseMaster.LedgerId = Convert.ToDecimal(cmbCashOrParty.SelectedValue.ToString());
infoPurchaseMaster.LrNo = txtLRNo.Text;
if (cmbPurchaseMode.Text == "Against MaterialReceipt")
{
infoPurchaseMaster.MaterialReceiptMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
}
else
{
infoPurchaseMaster.MaterialReceiptMasterId = 0;
}
infoPurchaseMaster.Narration = txtNarration.Text;
infoPurchaseMaster.PurchaseAccount = Convert.ToDecimal(cmbPurchaseAccount.SelectedValue.ToString());
if (cmbPurchaseMode.Text == "Against PurchaseOrder")
{
infoPurchaseMaster.PurchaseOrderMasterId = Convert.ToDecimal(cmbOrderNo.SelectedValue.ToString());
}
else
{
infoPurchaseMaster.PurchaseOrderMasterId = 0;
}
infoPurchaseMaster.TotalAmount = Convert.ToDecimal(txtTotalAmount.Text);
infoPurchaseMaster.TotalTax = Convert.ToDecimal(lblTaxAmount.Text);
infoPurchaseMaster.TransportationCompany = txtTransportationCompany.Text;
infoPurchaseMaster.UserId = PublicVariables._decCurrentUserId;
infoPurchaseMaster.VendorInvoiceDate = Convert.ToDateTime(txtInvoiceDate.Text);
infoPurchaseMaster.VendorInvoiceNo = txtVendorInvoiceNo.Text;
infoPurchaseMaster.VoucherTypeId = decPurchaseInvoiceVoucherTypeId;
infoPurchaseMaster.Extra1 = string.Empty;
infoPurchaseMaster.Extra2 = string.Empty;
infoPurchaseMaster.ExtraDate = Convert.ToDateTime(DateTime.Now);
infoPurchaseMaster.PurchaseMasterId = decPurchaseMasterId;
spPurchaseMaster.PurchaseMasterEdit(infoPurchaseMaster);
infoPurchaseOrderMaster = spPurchaseOrderMaster.PurchaseOrderMasterView(infoPurchaseMaster.PurchaseOrderMasterId);
infoMaterialReceiptMaster = spMaterialReceiptMaster.MaterialReceiptMasterView(infoPurchaseMaster.MaterialReceiptMasterId);
spLedgerPosting.LedgerPostDelete(strVoucherNo, decPurchaseInvoiceVoucherTypeId);
spAccountLedger.PartyBalanceDeleteByVoucherTypeVoucherNoAndReferenceType(strVoucherNo, decPurchaseInvoiceVoucherTypeId);
foreach (DataGridViewRow dgvrow in dgvProductDetails.Rows)
{
if (dgvrow.Cells["dgvtxtProductId"].Value != null)
{
if (dgvrow.Cells["dgvtxtProductId"].Value.ToString() != string.Empty)
{
/*-----------------------------------------Purchase Details Add----------------------------------------------------*/
infoPurchaseDetails.Amount = Convert.ToDecimal(dgvrow.Cells["dgvtxtAmount"].Value.ToString());
infoPurchaseDetails.BatchId = Convert.ToDecimal(dgvrow.Cells["dgvcmbBatch"].Value.ToString());
infoPurchaseDetails.Discount = Convert.ToDecimal(dgvrow.Cells["dgvtxtDiscount"].Value.ToString());
infoPurchaseDetails.GodownId = Convert.ToDecimal(dgvrow.Cells["dgvcmbGodown"].Value.ToString());
infoPurchaseDetails.GrossAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtGrossValue"].Value.ToString());
infoPurchaseDetails.NetAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtNetValue"].Value.ToString());
infoPurchaseDetails.OrderDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseOrderDetailsId"].Value.ToString());
infoPurchaseDetails.ProductId = Convert.ToDecimal(dgvrow.Cells["dgvtxtProductId"].Value.ToString());
infoPurchaseDetails.PurchaseMasterId = decPurchaseMasterId;
infoPurchaseDetails.Qty = Convert.ToDecimal(dgvrow.Cells["dgvtxtQuantity"].Value.ToString());
infoPurchaseDetails.RackId = Convert.ToDecimal(dgvrow.Cells["dgvcmbRack"].Value.ToString());
infoPurchaseDetails.Rate = Convert.ToDecimal(dgvrow.Cells["dgvtxtRate"].Value.ToString());
infoPurchaseDetails.ReceiptDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxtMaterialReceiptDetailsId"].Value.ToString());
infoPurchaseDetails.SlNo = Convert.ToInt32(dgvrow.Cells["dgvtxtSlNo"].Value.ToString());
infoPurchaseDetails.TaxAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtTaxAmount"].Value.ToString());
infoPurchaseDetails.TaxId = Convert.ToDecimal(dgvrow.Cells["dgvcmbTax"].Value.ToString());
infoPurchaseDetails.UnitConversionId = Convert.ToDecimal(dgvrow.Cells["dgvtxtUnitConversionId"].Value.ToString());
infoPurchaseDetails.UnitId = Convert.ToDecimal(dgvrow.Cells["dgvcmbUnit"].Value.ToString());
infoPurchaseDetails.Extra1 = string.Empty;
infoPurchaseDetails.Extra2 = string.Empty;
infoPurchaseDetails.ExtraDate = Convert.ToDateTime(DateTime.Today);
if (dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value != null)
{
if (dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value.ToString() == "0" || dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value.ToString() == string.Empty)
{
spPurchaseDetails.PurchaseDetailsAdd(infoPurchaseDetails);
}
else
{
infoPurchaseDetails.PurchaseDetailsId = Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseDetailsId"].Value.ToString());
spPurchaseDetails.PurchaseDetailsEdit(infoPurchaseDetails);
}
}
else
{
spPurchaseDetails.PurchaseDetailsAdd(infoPurchaseDetails);
}
infoStockPosting.BatchId = infoPurchaseDetails.BatchId;
infoStockPosting.Date = infoPurchaseMaster.Date;
infoStockPosting.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoStockPosting.GodownId = infoPurchaseDetails.GodownId;
infoStockPosting.InwardQty = infoPurchaseDetails.Qty; /// spUnitConvertion.UnitConversionRateByUnitConversionId(infoPurchaseDetails.UnitConversionId);
infoStockPosting.OutwardQty = 0;
infoStockPosting.ProductId = infoPurchaseDetails.ProductId;
infoStockPosting.RackId = infoPurchaseDetails.RackId;
infoStockPosting.Rate = infoPurchaseDetails.Rate;
infoStockPosting.UnitId = infoPurchaseDetails.UnitId;
if (infoPurchaseDetails.OrderDetailsId != 0)
{
infoStockPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoStockPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoStockPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoStockPosting.AgainstInvoiceNo = "NA";
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstVoucherTypeId = 0;
}
else if (infoPurchaseDetails.ReceiptDetailsId != 0)
{
infoStockPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoStockPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoStockPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoStockPosting.AgainstInvoiceNo = "NA";
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstVoucherTypeId = 0;
}
else if (infoPurchaseDetails.OrderDetailsId == 0 && infoPurchaseDetails.ReceiptDetailsId == 0)
{
infoStockPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoStockPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoStockPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoStockPosting.AgainstInvoiceNo = "NA";
infoStockPosting.AgainstVoucherNo = "NA";
infoStockPosting.AgainstVoucherTypeId = 0;
}
infoStockPosting.Extra1 = string.Empty;
infoStockPosting.Extra2 = string.Empty;
infoStockPosting.ExtraDate = Convert.ToDateTime(DateTime.Today);
spStockPosting.StockPostingAdd(infoStockPosting);
if (infoPurchaseDetails.ReceiptDetailsId != 0)
{
infoStockPosting.InvoiceNo = infoMaterialReceiptMaster.InvoiceNo;
infoStockPosting.VoucherNo = infoMaterialReceiptMaster.VoucherNo;
infoStockPosting.VoucherTypeId = infoMaterialReceiptMaster.VoucherTypeId;
infoStockPosting.AgainstInvoiceNo = infoPurchaseMaster.InvoiceNo;
infoStockPosting.AgainstVoucherNo = infoPurchaseMaster.VoucherNo;
infoStockPosting.AgainstVoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoStockPosting.InwardQty = 0;
infoStockPosting.OutwardQty = infoPurchaseDetails.Qty; /// spUnitConvertion.UnitConversionRateByUnitConversionId(infoPurchaseDetails.UnitConversionId);
spStockPosting.StockPostingAdd(infoStockPosting);
}
}
}
}
/*-----------------------------------------Ledger Posting----------------------------------------------------*/
infoLedgerPosting.Credit = Convert.ToDecimal(txtGrandTotal.Text) * spExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Date = Convert.ToDateTime(PublicVariables._dtCurrentDate);
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoLedgerPosting.LedgerId = infoPurchaseMaster.LedgerId;
infoLedgerPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoLedgerPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.ExtraDate = DateTime.Now;
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
decimal DecBillDiscount = Convert.ToDecimal(txtBillDiscount.Text.Trim().ToString());
if (DecBillDiscount > 0)
{
infoLedgerPosting.Credit = DecBillDiscount * spExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.Debit = 0;
infoLedgerPosting.Date = Convert.ToDateTime(PublicVariables._dtCurrentDate);
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoLedgerPosting.LedgerId = 9;//ledger id of discount received ledger
infoLedgerPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoLedgerPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.ExtraDate = DateTime.Now;
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
infoLedgerPosting.Credit = 0;
infoLedgerPosting.Debit = TotalNetAmount();// * spExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.Date = Convert.ToDateTime(PublicVariables._dtCurrentDate);
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoLedgerPosting.LedgerId = infoPurchaseMaster.PurchaseAccount;
infoLedgerPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoLedgerPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.ExtraDate = DateTime.Now;
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
foreach (DataGridViewRow dgvrow in dgvAdditionalCost.Rows)
{
if (dgvrow.Cells["dgvcmbLedger"].Value != null)
{
if (dgvrow.Cells["dgvcmbLedger"].Value.ToString() != string.Empty)
{
if (dgvrow.Cells["dgvtxtAdditionalCostAmount"].Value != null)
{
if (dgvrow.Cells["dgvtxtAdditionalCostAmount"].Value.ToString() != string.Empty)
{
/*-----------------------------------------Additional Cost Add----------------------------------------------------*/
infoAdditionalCost.Credit = 0;
infoAdditionalCost.Debit = Convert.ToDecimal(dgvrow.Cells["dgvtxtAdditionalCostAmount"].Value.ToString());
infoAdditionalCost.LedgerId = Convert.ToDecimal(dgvrow.Cells["dgvcmbLedger"].Value.ToString());
infoAdditionalCost.VoucherNo = infoPurchaseMaster.VoucherNo;
infoAdditionalCost.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoAdditionalCost.Extra1 = string.Empty;
infoAdditionalCost.Extra2 = string.Empty;
infoAdditionalCost.ExtraDate = DateTime.Now;
if (dgvrow.Cells["dgvtxtAdditionalCostId"].Value != null)
{
if (dgvrow.Cells["dgvtxtAdditionalCostId"].Value.ToString() != string.Empty && dgvrow.Cells["dgvtxtAdditionalCostId"].Value.ToString() != string.Empty)
{
infoAdditionalCost.AdditionalCostId = Convert.ToDecimal(dgvrow.Cells["dgvtxtAdditionalCostId"].Value.ToString());
spAdditionalCost.AdditionalCostEdit(infoAdditionalCost);
}
else
{
spAdditionalCost.AdditionalCostAdd(infoAdditionalCost);
}
}
else
{
spAdditionalCost.AdditionalCostAdd(infoAdditionalCost);
}
/*-----------------------------------------Additional Cost Ledger Posting----------------------------------------------------*/
infoLedgerPosting.Credit = 0;
infoLedgerPosting.Debit = infoAdditionalCost.Debit * spExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.Date = Convert.ToDateTime(PublicVariables._dtCurrentDate);
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoLedgerPosting.LedgerId = infoAdditionalCost.LedgerId;
infoLedgerPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoLedgerPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.ExtraDate = DateTime.Now;
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
}
}
}
if (dgvTax.Visible)
{
foreach (DataGridViewRow dgvrow in dgvTax.Rows)
{
if (dgvrow.Cells["dgvtxtTaxId"].Value != null)
{
if (dgvrow.Cells["dgvtxtTaxId"].Value.ToString() != string.Empty)
{
/*-----------------------------------------PurchaseBillTax Add----------------------------------------------------*/
infoPurchaseBillTax.PurchaseMasterId = decPurchaseMasterId;
infoPurchaseBillTax.TaxAmount = Convert.ToDecimal(dgvrow.Cells["dgvtxtTotalTax"].Value.ToString());
infoPurchaseBillTax.TaxId = Convert.ToDecimal(dgvrow.Cells["dgvtxtTaxId"].Value.ToString());
infoPurchaseBillTax.Extra1 = string.Empty;
infoPurchaseBillTax.Extra2 = string.Empty;
infoPurchaseBillTax.ExtraDate = DateTime.Now;
if (dgvrow.Cells["dgvtxtPurchaseBillTaxId"].Value != null)
{
if (dgvrow.Cells["dgvtxtPurchaseBillTaxId"].Value.ToString() != string.Empty && dgvrow.Cells["dgvtxtPurchaseBillTaxId"].Value.ToString() != "0")
{
infoPurchaseBillTax.PurchaseBillTaxId = Convert.ToDecimal(dgvrow.Cells["dgvtxtPurchaseBillTaxId"].Value.ToString());
spPurchaseBillTax.PurchaseBillTaxEdit(infoPurchaseBillTax);
}
else
{
spPurchaseBillTax.PurchaseBillTaxAdd(infoPurchaseBillTax);
}
}
else
{
spPurchaseBillTax.PurchaseBillTaxAdd(infoPurchaseBillTax);
}
/*-----------------------------------------Tax Ledger Posting----------------------------------------------------*/
infoLedgerPosting.Credit = 0;
infoLedgerPosting.Debit = infoPurchaseBillTax.TaxAmount * spExchangeRate.ExchangeRateViewByExchangeRateId(Convert.ToDecimal(cmbCurrency.SelectedValue.ToString()));
infoLedgerPosting.Date = Convert.ToDateTime(PublicVariables._dtCurrentDate);
infoLedgerPosting.DetailsId = 0;
infoLedgerPosting.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoLedgerPosting.LedgerId = Convert.ToDecimal(dgvrow.Cells["dgvtxtLedgerId"].Value.ToString());
infoLedgerPosting.VoucherNo = infoPurchaseMaster.VoucherNo;
infoLedgerPosting.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoLedgerPosting.YearId = PublicVariables._decCurrentFinancialYearId;
infoLedgerPosting.ChequeDate = DateTime.Now;
infoLedgerPosting.ChequeNo = string.Empty;
infoLedgerPosting.Extra1 = string.Empty;
infoLedgerPosting.Extra2 = string.Empty;
infoLedgerPosting.ExtraDate = DateTime.Now;
spLedgerPosting.LedgerPostingAdd(infoLedgerPosting);
}
}
}
}
/*-----------------------------------------PartyBalance Posting----------------------------------------------------*/
infoAccountLedger = spAccountLedger.AccountLedgerView(infoPurchaseMaster.LedgerId);
if (infoAccountLedger.BillByBill == true)
{
infoPartyBalance.Credit = Convert.ToDecimal(txtGrandTotal.Text);
infoPartyBalance.Debit = 0;
if (txtCreditPeriod.Text != string.Empty)
{
infoPartyBalance.CreditPeriod = Convert.ToInt32(txtCreditPeriod.Text);
}
infoPartyBalance.Date = Convert.ToDateTime(txtVoucherDate.Text);
infoPartyBalance.ExchangeRateId = infoPurchaseMaster.ExchangeRateId;
infoPartyBalance.FinancialYearId = PublicVariables._decCurrentFinancialYearId;
infoPartyBalance.LedgerId = infoPurchaseMaster.LedgerId;
infoPartyBalance.ReferenceType = "New";
infoPartyBalance.InvoiceNo = infoPurchaseMaster.InvoiceNo;
infoPartyBalance.VoucherNo = infoPurchaseMaster.VoucherNo;
infoPartyBalance.VoucherTypeId = infoPurchaseMaster.VoucherTypeId;
infoPartyBalance.AgainstInvoiceNo = "NA";
infoPartyBalance.AgainstVoucherNo = "NA";
infoPartyBalance.AgainstVoucherTypeId = 0;
infoPartyBalance.Extra1 = string.Empty;
infoPartyBalance.Extra2 = string.Empty;
infoPartyBalance.ExtraDate = DateTime.Now;
spPartyBalance.PartyBalanceAdd(infoPartyBalance);
}
Messages.UpdatedMessage();
if (cbxPrintAfterSave.Checked)
{
if (spSettings.SettingsStatusCheck("Printer") == "Dot Matrix")
{
PrintForDotMatrix(decPurchaseMasterId);
}
else
{
Print(decPurchaseMasterId);
}
}
Clear();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("PI39:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to get particular values from PurchaseDetails table based on the parameter
/// </summary>
/// <param name="purchaseDetailsId"></param>
/// <returns></returns>
public PurchaseDetailsInfo PurchaseDetailsView(decimal purchaseDetailsId)
{
PurchaseDetailsInfo purchasedetailsinfo = new PurchaseDetailsInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("PurchaseDetailsView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@purchaseDetailsId", SqlDbType.Decimal);
sprmparam.Value = purchaseDetailsId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
purchasedetailsinfo.PurchaseDetailsId = decimal.Parse(sdrreader[0].ToString());
purchasedetailsinfo.PurchaseMasterId = decimal.Parse(sdrreader[1].ToString());
purchasedetailsinfo.ReceiptDetailsId = decimal.Parse(sdrreader[2].ToString());
purchasedetailsinfo.OrderDetailsId = decimal.Parse(sdrreader[3].ToString());
purchasedetailsinfo.ProductId = decimal.Parse(sdrreader[4].ToString());
purchasedetailsinfo.Qty = decimal.Parse(sdrreader[5].ToString());
purchasedetailsinfo.Rate = decimal.Parse(sdrreader[6].ToString());
purchasedetailsinfo.UnitId = decimal.Parse(sdrreader[7].ToString());
purchasedetailsinfo.UnitConversionId = decimal.Parse(sdrreader[8].ToString());
purchasedetailsinfo.Discount = decimal.Parse(sdrreader[9].ToString());
purchasedetailsinfo.TaxId = decimal.Parse(sdrreader[10].ToString());
purchasedetailsinfo.BatchId = decimal.Parse(sdrreader[11].ToString());
purchasedetailsinfo.GodownId = decimal.Parse(sdrreader[12].ToString());
purchasedetailsinfo.RackId = decimal.Parse(sdrreader[13].ToString());
purchasedetailsinfo.TaxAmount = decimal.Parse(sdrreader[14].ToString());
purchasedetailsinfo.GrossAmount = decimal.Parse(sdrreader[15].ToString());
purchasedetailsinfo.NetAmount = decimal.Parse(sdrreader[16].ToString());
purchasedetailsinfo.Amount = decimal.Parse(sdrreader[17].ToString());
purchasedetailsinfo.SlNo = int.Parse(sdrreader[18].ToString());
purchasedetailsinfo.PurchaseDetailsId = decimal.Parse(sdrreader[19].ToString());
purchasedetailsinfo.ExtraDate = DateTime.Parse(sdrreader[20].ToString());
purchasedetailsinfo.Extra1 = sdrreader[21].ToString();
purchasedetailsinfo.Extra2 = sdrreader[22].ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return purchasedetailsinfo;
}