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(); } }