public bool UpdateMatIssueVoucher(MatRcvdModel objMatRcvd) { string Query = string.Empty; bool isUpdated = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Series", objMatRcvd.Series)); paramCollection.Add(new DBParameter("@Date", objMatRcvd.Rcvd_Date)); paramCollection.Add(new DBParameter("@VoucherNumber", objMatRcvd.Voucher_Number)); paramCollection.Add(new DBParameter("@Type", objMatRcvd.type)); paramCollection.Add(new DBParameter("@Party", objMatRcvd.Party)); paramCollection.Add(new DBParameter("@MatCentre", objMatRcvd.MatCenter)); paramCollection.Add(new DBParameter("@Narration", objMatRcvd.Narration)); paramCollection.Add(new DBParameter("@qty", objMatRcvd.TotalQty)); paramCollection.Add(new DBParameter("@amount", objMatRcvd.TotalAmount)); paramCollection.Add(new DBParameter("@bsamount", objMatRcvd.BSTotalAmount)); paramCollection.Add(new DBParameter("@ModifiedBy", "Admin")); paramCollection.Add(new DBParameter("@id", objMatRcvd.Rcvd_Id)); Query = "UPDATE Trans_MatRcvd_Voucher SET [Series]=@Series,[Rcvd_Date]=@Date," + "[VoucherNo]=@VoucherNumber,[Type]=@Type," + "[Party]=@Party,[MatCentre]=@MatCentre," + "[Narration]=@Narration,[TotalQty]=@qty,[TotalAmount]=@amount,[BSTotalAmount]=@bsamount,[ModifiedBy]=@ModifiedBy " + "WHERE [MatRcvd_Id]=@id "; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { UpdateItemandBS(objMatRcvd); isUpdated = true; } } catch (Exception ex) { isUpdated = false; throw ex; } return(isUpdated); }
public bool SaveMatRcvdVoucher(MatRcvdModel objrcvd) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Series", objrcvd.Series)); paramCollection.Add(new DBParameter("@Voucher_Date", objrcvd.Rcvd_Date)); paramCollection.Add(new DBParameter("@Voucher_Number", objrcvd.Voucher_Number)); paramCollection.Add(new DBParameter("@Type", objrcvd.type)); paramCollection.Add(new DBParameter("@Party", objrcvd.Party)); paramCollection.Add(new DBParameter("@MatCenter", objrcvd.MatCenter)); paramCollection.Add(new DBParameter("@Narration", objrcvd.Narration)); paramCollection.Add(new DBParameter("@TotalQty", objrcvd.TotalQty)); paramCollection.Add(new DBParameter("@TotalAmount", objrcvd.TotalAmount)); paramCollection.Add(new DBParameter("@BSTotal", objrcvd.BSTotalAmount)); paramCollection.Add(new DBParameter("@CreatedBy", objrcvd.CreatedBy)); Query = "INSERT INTO Trans_MatRcvd_Voucher ([Series],[Rcvd_Date],[VoucherNo],[Type],[Party],[MatCentre],[Narration],[TotalQty],[TotalAmount],[BSTotalAmount]," + "[CreatedBy]) VALUES " + "(@Series,@Voucher_Date,@Voucher_Number,@Type,@Party," + "@MatCenter,@Narration,@TotalQty,@TotalAmount,@BSTotal,@CreatedBy)"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { SaveMatRcvdItems(objrcvd.RcvdItem_Voucher); SaveMatRcvdBillSundry(objrcvd.RcvdBillSundry_Voucher); isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
public bool SaveMatRcvdVoucher(MatRcvdModel objrcvd) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@VoucherNumber", objrcvd.Voucher_Number)); paramCollection.Add(new DBParameter("@Series", objrcvd.Series)); paramCollection.Add(new DBParameter("@MatRcvdDate", objrcvd.Rcvd_Date, System.Data.DbType.DateTime)); //paramCollection.Add(new DBParameter("@BillNo", objSales.BillNo)); //paramCollection.Add(new DBParameter("@DueDate", objSales.DueDate)); paramCollection.Add(new DBParameter("@MatRcvdType", objrcvd.Type)); paramCollection.Add(new DBParameter("@MatRcvdParty", objrcvd.Party)); paramCollection.Add(new DBParameter("@MatCentre", objrcvd.MatCenter)); paramCollection.Add(new DBParameter("@Narration", objrcvd.Narration)); paramCollection.Add(new DBParameter("@ItemTotalAmount", objrcvd.TotalAmount)); paramCollection.Add(new DBParameter("@ItemTotalQty", objrcvd.TotalQty)); paramCollection.Add(new DBParameter("@BSTotalAmount", objrcvd.BSTotalAmount)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); System.Data.IDataReader dr = _dbHelper.ExecuteDataReader("spInsertMatRcvddMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); int id = 0; dr.Read(); id = Convert.ToInt32(dr[0]); SaveMatRcvdItems(objrcvd.RcvdItem_Voucher, id); SaveMatRcvdBillSundry(objrcvd.RcvdBillSundry_Voucher, id); } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
private bool UpdateItemandBS(MatRcvdModel objmat) { try { //UPDATE Item voucher -CHILD TABLE UPDATES foreach (Item_VoucherModel item in objmat.RcvdItem_Voucher) { if (item.Item_ID > 0) { UpdateMatRcvdItems(item); } else { SaveMatRcvdPartyItems(item); } } //Update Bill Sundry Items foreach (BillSundry_VoucherModel bs in objmat.RcvdBillSundry_Voucher) { if (bs.BSId > 0) { SaveMatRcvdPartyItems(bs); } else { SaveMatRcvdPartyBillSundryVoucher(bs); } } } catch (Exception ex) { return(false); } return(true); }
public MatRcvdModel GetAllMatRcvdbyId(int id) { MatRcvdModel objMatRcvd = new MatRcvdModel(); string Query = "SELECT * FROM Trans_MatRcvd_Voucher WHERE MatRcvd_Id=" + id; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objMatRcvd.Rcvd_Id = Convert.ToInt32(dr["Matrcvd_Id"]); objMatRcvd.Series = dr["series"].ToString(); objMatRcvd.Rcvd_Date = DataFormat.GetDateTime(dr["Rcvd_Date"]); objMatRcvd.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]); objMatRcvd.type = dr["Type"].ToString(); objMatRcvd.Party = dr["party"].ToString(); objMatRcvd.MatCenter = dr["MatCentre"].ToString(); objMatRcvd.Narration = dr["Narration"].ToString(); objMatRcvd.TotalQty = Convert.ToDecimal(dr["TotalQty"]); objMatRcvd.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString()); objMatRcvd.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]); //SELECT Credit Note Accounts string itemQuery = "SELECT * FROM Trans_MatRcvd_Items WHERE MatRcvd_Id=" + id; System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject()); objMatRcvd.RcvdItem_Voucher = new List <Item_VoucherModel>(); Item_VoucherModel objitem; while (drItems.Read()) { objitem = new Item_VoucherModel(); objitem.Item_ID = Convert.ToInt32(drItems["ItemId"]); objitem.ParentId = DataFormat.GetInteger(drItems["MatRcvd_Id"]); objitem.Item = drItems["item"].ToString(); objitem.Batch = drItems["Batch"].ToString(); objitem.Qty = Convert.ToInt32(drItems["qty"].ToString()); objitem.Unit = (drItems["unit"].ToString()); objitem.Price = Convert.ToDecimal(drItems["price"]); objitem.Amount = Convert.ToInt32(drItems["amount"].ToString()); objitem.TotalAmount = Convert.ToDecimal(drItems["TotalAmount"]); objitem.TotalQty = Convert.ToInt32(drItems["TotalQty"].ToString()); objMatRcvd.RcvdItem_Voucher.Add(objitem); } string BSQuery = "SELECT * FROM Trans_MatRcvd_BS WHERE MatRcvd_Id=" + id; System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(BSQuery, _dbHelper.GetConnObject()); objMatRcvd.RcvdBillSundry_Voucher = new List <BillSundry_VoucherModel>(); BillSundry_VoucherModel objbs; while (drbs.Read()) { objbs = new BillSundry_VoucherModel(); objbs.BSId = Convert.ToInt32(drbs["BSId"]); objbs.ParentId = DataFormat.GetInteger(drbs["MatRcvd_Id"]); objbs.BillSundry = drbs["BillSundry"].ToString(); objbs.Percentage = Convert.ToDecimal(drbs["Percentage"].ToString()); objbs.Amount = Convert.ToDecimal((drbs["Amount"].ToString())); objbs.TotalAmount = Convert.ToDecimal(drbs["TotalAmount"].ToString()); objMatRcvd.RcvdBillSundry_Voucher.Add(objbs); } } return(objMatRcvd); }
private void btnSave_Click(object sender, EventArgs e) { eSunSpeedDomain.MatRcvdModel objrcvd = new MatRcvdModel(); if (tbxVchNumber.Text.Trim() == "") { MessageBox.Show("Voucher Number Can Not Be Blank!"); return; } objrcvd.Series = tbxSeries.Text.Trim(); objrcvd.Type = tbxType.Text.Trim(); objrcvd.Rcvd_Date = Convert.ToDateTime(dtDate.Text); objrcvd.Voucher_Number = Convert.ToInt32(tbxVchNumber.Text.Trim()); objrcvd.Party = tbxParty.Text.Trim(); objrcvd.MatCenter = tbxVchNumber.Text.Trim(); objrcvd.Narration = tbxNarration.Text.Trim(); objrcvd.TotalAmount = Convert.ToDecimal(Amount.SummaryItem.SummaryValue); objrcvd.TotalQty = Convert.ToInt32(Qty.SummaryItem.SummaryValue); //MatRcvd 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); } objrcvd.RcvdItem_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.Narration = row["Narration"].ToString(); objBS.Percentage = Convert.ToDecimal(row["Percentage"]); objBS.Amount = Convert.ToDecimal(row["Amount"]); objBS.Type = row["Extra"].ToString(); lstBS.Add(objBS); } objrcvd.BSTotalAmount = Convert.ToDecimal(BSAmount.SummaryItem.SummaryValue); objrcvd.RcvdBillSundry_Voucher = lstBS; bool isSuccess = objMRBL.SaveMatRcvdVoucher(objrcvd); if (isSuccess) { MessageBox.Show("Saved Successfully!"); // Dialogs.PopUPDialog d = new Dialogs.PopUPDialog("Saved Successfully!"); // d.ShowDialog(); } }