public bool SavePurchaseVoucher(PurchaseVoucherMainModel objPurc)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@VoucherNumber", objPurc.PurchaseVoucher_Number));
paramCollection.Add(new DBParameter("@Series", objPurc.PurchaseVoucher_Series));
paramCollection.Add(new DBParameter("@PurcDate", objPurc.PurchaseVoucher_Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@PurcType", objPurc.PurchaseVoucher_PurchaseType));
paramCollection.Add(new DBParameter("@Party", objPurc.PurchaseVoucher_Party));
paramCollection.Add(new DBParameter("@MatCentre", objPurc.PurchaseVoucher_MatCenter));
paramCollection.Add(new DBParameter("@Narration", objPurc.Narration));
paramCollection.Add(new DBParameter("@ItemTotalAmount", objPurc.TotalAmount));
paramCollection.Add(new DBParameter("@ItemTotalQty", objPurc.TotalQty));
paramCollection.Add(new DBParameter("@BSTotalAmount", objPurc.BSTotalAmount));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertPurchaseVoucher", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
int id = 0;
dr.Read();
id = Convert.ToInt32(dr[0]);
SavePurchaseVoucherItems(objPurc.PurchaseItem_Voucher, id);
SavePurchaseBillSundryVoucher(objPurc.BillSundry_Voucher, id);
//Query = "INSERT INTO PurchaseMain_Voucher([PurchaseVoucher_Series],[PurchaseVoucher_Date],[PurchaseVoucher_Number],[PurchaseVoucher_PurchaseType],[PurchaseVoucher_Party]," +
//"[PurchaseVoucher_MatCenter],[CreatedBy]) VALUES " +
//"(@PurchaseVoucher_Series,@PurchaseVoucher_Date,@PurchaseVoucher_Number,@PurchaseVoucher_PurchaseType,@PurchaseVoucher_Party,@PurchaseVoucher_MatCenter,@CreatedBy)";
//if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
// isSaved = true;
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
//SAVE PURCHASE Quotation
public bool SavePurchaseQuotation(PurchaseVoucherMainModel objPurcQuotation)
{
string Query = string.Empty;
bool isSaved = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@VoucherNumber", objPurcQuotation.PurchaseVoucher_Number));
paramCollection.Add(new DBParameter("@Series", objPurcQuotation.PurchaseVoucher_Series));
paramCollection.Add(new DBParameter("@PurcDate", objPurcQuotation.PurchaseVoucher_Date, System.Data.DbType.DateTime));
paramCollection.Add(new DBParameter("@PurcType", objPurcQuotation.PurchaseVoucher_PurchaseType));
paramCollection.Add(new DBParameter("@Party", objPurcQuotation.PurchaseVoucher_Party));
paramCollection.Add(new DBParameter("@MatCentre", objPurcQuotation.PurchaseVoucher_MatCenter));
paramCollection.Add(new DBParameter("@Narration", objPurcQuotation.Narration));
paramCollection.Add(new DBParameter("@ItemTotalAmount", objPurcQuotation.TotalAmount));
paramCollection.Add(new DBParameter("@ItemTotalQty", objPurcQuotation.TotalQty));
paramCollection.Add(new DBParameter("@BSTotalAmount", objPurcQuotation.BSTotalAmount));
paramCollection.Add(new DBParameter("@CreatedBy", "Admin"));
System.Data.IDataReader dr =
_dbHelper.ExecuteDataReader("spInsertPurchaseQuotationMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure);
int id = 0;
dr.Read();
id = Convert.ToInt32(dr[0]);
SavePurchaseQuotationItems(objPurcQuotation.PurchaseItem_Voucher, id);
SavePurchaseQuotationBillSundry(objPurcQuotation.BillSundry_Voucher, id);
}
catch (Exception ex)
{
isSaved = false;
throw ex;
}
return(isSaved);
}
private void btnSave_Click(object sender, EventArgs e)
{
PurchaseVoucherMainModel objPurcQuot = new PurchaseVoucherMainModel();
if (tbxVoucherNo.Text.Trim() == "")
{
MessageBox.Show("Voucher Number Can Not Be Blank!");
return;
}
objPurcQuot.PurchaseVoucher_Series = tbxSeries.Text.Trim();
objPurcQuot.PurchaseVoucher_PurchaseType = tbxPurcType.Text.Trim();
objPurcQuot.PurchaseVoucher_Date = Convert.ToDateTime(dtDate.Text);
objPurcQuot.PurchaseVoucher_Number = Convert.ToInt32(tbxVoucherNo.Text.Trim());
objPurcQuot.PurchaseVoucher_Party = tbxParty.Text.Trim();
objPurcQuot.PurchaseVoucher_MatCenter = tbxMatCenter.Text.Trim();
objPurcQuot.Narration = tbxNarration.Text.Trim();
objPurcQuot.TotalAmount = Convert.ToDecimal(Amount.SummaryItem.SummaryValue);
objPurcQuot.TotalQty = Convert.ToInt32(Qty.SummaryItem.SummaryValue);
//Purchase Quotation Items
Item_VoucherModel objItem;
List <Item_VoucherModel> lstItemsPQ = new List <Item_VoucherModel>();
for (int i = 0; i < gdvItem.DataRowCount; i++)
{
DataRow row = gdvItem.GetDataRow(i);
objItem = new Item_VoucherModel();
objItem.Item = row["Item"].ToString();
objItem.Qty = Convert.ToDecimal(row["Qty"]);
objItem.Unit = row["Unit"].ToString();
objItem.Amount = Convert.ToDecimal(row["Amount"].ToString());
objItem.Price = Convert.ToDecimal(row["Price"].ToString());
lstItemsPQ.Add(objItem);
}
objPurcQuot.PurchaseItem_Voucher = lstItemsPQ;
//Purchase Qutation Bill Sundry
BillSundry_VoucherModel objBS;
List <BillSundry_VoucherModel> lstBSPQ = new List <BillSundry_VoucherModel>();
for (int i = 0; i < gridBs.DataRowCount; i++)
{
DataRow row = gridBs.GetDataRow(i);
objBS = new BillSundry_VoucherModel();
objBS.BillSundry = row["BillSundry"].ToString();
objBS.Narration = row["Narration"].ToString();
objBS.Percentage = Convert.ToDecimal(row["Percentage"]);
objBS.Amount = Convert.ToDecimal(row["Amount"]);
objBS.Type = row["Extra"].ToString();
lstBSPQ.Add(objBS);
}
objPurcQuot.BSTotalAmount = Convert.ToDecimal(BSAmount.SummaryItem.SummaryValue);
objPurcQuot.BillSundry_Voucher = lstBSPQ;
bool isSuccess = objPQBL.SavePurchaseQuotation(objPurcQuot);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
// Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
// d.ShowDialog();
}
}
private void btnSave_Click(object sender, EventArgs e)
{
PurchaseVoucherMainModel objPurc = new PurchaseVoucherMainModel();
if (tbxVoucherNumber.Text.Trim() == "")
{
MessageBox.Show("Voucher Number Can Not Be Blank!");
return;
}
objPurc.PurchaseVoucher_Series = tbxSeries.Text.Trim();
objPurc.PurchaseVoucher_PurchaseType = tbxPurchaseType.Text.Trim();
objPurc.PurchaseVoucher_Date = Convert.ToDateTime(dtDate.Text);
objPurc.PurchaseVoucher_Number = Convert.ToInt32(tbxVoucherNumber.Text.Trim());
objPurc.PurchaseVoucher_Party = tbxParty.Text.Trim();
objPurc.PurchaseVoucher_MatCenter = tbxMatCentre.Text.Trim();
objPurc.Narration = tbxNarration.Text.Trim();
objPurc.TotalAmount = Convert.ToDecimal(Amount.SummaryItem.SummaryValue);
objPurc.TotalQty = Convert.ToInt32(Qty.SummaryItem.SummaryValue);
//Bill Number and Due date not captured- check with Ravi if these are required
//Items
Item_VoucherModel objItem;
List <Item_VoucherModel> lstItems = new List <Item_VoucherModel>();
for (int i = 0; i < gdvItem.DataRowCount; i++)
{
DataRow row = gdvItem.GetDataRow(i);
objItem = new Item_VoucherModel();
objItem.Item = row["Item"].ToString();
objItem.Qty = Convert.ToDecimal(row["Qty"]);
objItem.Unit = row["Unit"].ToString();
objItem.Amount = Convert.ToDecimal(row["Amount"].ToString());
objItem.Price = Convert.ToDecimal(row["Price"].ToString());
lstItems.Add(objItem);
}
objPurc.PurchaseItem_Voucher = lstItems;
//Bill Sundry
BillSundry_VoucherModel objBS;
List <BillSundry_VoucherModel> lstBS = new List <BillSundry_VoucherModel>();
for (int i = 0; i < gridBs.DataRowCount; i++)
{
DataRow row = gridBs.GetDataRow(i);
objBS = new BillSundry_VoucherModel();
objBS.BillSundry = row["BillSundry"].ToString();
objBS.Percentage = Convert.ToDecimal(row["Percentage"]);
objBS.Amount = Convert.ToDecimal(row["Amount"]);
objBS.Type = row["Extra"].ToString();
lstBS.Add(objBS);
}
objPurc.BSTotalAmount = Convert.ToDecimal(BSAmount.SummaryItem.SummaryValue);
objPurc.BillSundry_Voucher = lstBS;
//objSalesVoucher = new SalesVoucherBL();
bool isSuccess = objbl.SavePurchaseOrder(objPurc);
if (isSuccess)
{
MessageBox.Show("Saved Successfully!");
// Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!");
// d.ShowDialog();
}
}
