public bool UpdateProductionVoucher(ProductionVoucherModel objProduction) { string Query = string.Empty; bool isUpdated = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Series", objProduction.Series)); //paramCollection.Add(new DBParameter("@PVType", objProduction.ProductionType)); paramCollection.Add(new DBParameter("@PVDate", objProduction.PV_Date)); paramCollection.Add(new DBParameter("@VoucherNumber", objProduction.Voucher_Number)); paramCollection.Add(new DBParameter("@BillNo", objProduction.BillNo)); paramCollection.Add(new DBParameter("@Duedate", objProduction.DueDate)); paramCollection.Add(new DBParameter("@Party", objProduction.Party)); //paramCollection.Add(new DBParameter("@MatCentre", objProduction.MatCenter)); paramCollection.Add(new DBParameter("@Narration", objProduction.Narration)); //paramCollection.Add(new DBParameter("@TotalQty", objProduction.TotalQty, System.Data.DbType.Decimal)); //paramCollection.Add(new DBParameter("@TotalAmount", objProduction.TotalAmount, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@BSTotalAmount", objProduction.BSTotalAmount, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@ModifiedBy", "Admin")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now)); paramCollection.Add(new DBParameter("@id", objProduction.Production_Id)); Query = "UPDATE Trans_Production_Voucher SET [Series]=@Series,[Production_Type]=@PVType,[Production_Date]=@PVDate," + "[VoucherNo]=@VoucherNumber,[BillNo]=@BillNo,[DueDate]=@Duedate," + "[Party]=@Party,[MatCenter]=@MatCenter,[Narration]=@Narration,[TotalQty]=@TotalQty,[TotalAmount]=@TotalAmount,[BSTotalAmount]=@BSTotalAmount," + "[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " + "WHERE Production_Id=@id;"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { //UpdateItemandBS(objProduction); isUpdated = true; } } catch (Exception ex) { isUpdated = false; throw ex; } return(isUpdated); }
public bool SaveProductionVoucher(ProductionVoucherModel objProduction) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@ProductiopnSeries", objProduction.Series)); paramCollection.Add(new DBParameter("@ProductionType", objProduction.ProductionType)); paramCollection.Add(new DBParameter("@Date", objProduction.PV_Date)); paramCollection.Add(new DBParameter("@Voucher_Number", objProduction.Voucher_Number)); paramCollection.Add(new DBParameter("@BillNo", objProduction.BillNo)); paramCollection.Add(new DBParameter("@DueDate", objProduction.DueDate)); paramCollection.Add(new DBParameter("@Party", objProduction.Party)); paramCollection.Add(new DBParameter("@MatCenter", objProduction.MatCenter)); paramCollection.Add(new DBParameter("@Narration", objProduction.Narration)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now)); Query = "INSERT INTO Trans_Production_Voucher ([Series],[Production_Type],[Production_Date],[VoucherNo],[BillNo],[DueDate],[Party],[MatCenter],[Narration]," + "[CreatedBy],[CreatedDate]) VALUES " + "(@ProductiopnSeries,@ProductionType,@Date,@Voucher_Number,@BillNo,@DueDate, " + " @Party,@MatCenter,@Narration,@CreatedBy,@CreatedDate)"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { SaveProductionItems(objProduction.Item_Voucher); SaveProductionBillSundry(objProduction.BillSundry_Voucher); isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
public bool SaveProductionVoucher(ProductionVoucherModel objProduction) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@VoucherNumber", objProduction.Voucher_Number)); paramCollection.Add(new DBParameter("@Series", objProduction.Series)); paramCollection.Add(new DBParameter("@ProductionDate", objProduction.PV_Date, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@BOMName", objProduction.BOMName)); paramCollection.Add(new DBParameter("@MatCentreIG", objProduction.MatCenterIG)); paramCollection.Add(new DBParameter("@MatCentreIC", objProduction.MatCenterIC)); paramCollection.Add(new DBParameter("@Narration", objProduction.Narration)); //paramCollection.Add(new DBParameter("@ItemTotalAmount", objSales.TotalAmount)); //paramCollection.Add(new DBParameter("@ItemTotalQty", objSales.TotalQty)); //paramCollection.Add(new DBParameter("@BSTotalAmount", objSales.BSTotalAmount)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); System.Data.IDataReader dr = _dbHelper.ExecuteDataReader("spInsertProductionMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); int id = 0; dr.Read(); id = Convert.ToInt32(dr[0]); SaveProductionItemgenerated(objProduction.Item_Generated, id); SaveProductionItemconsumed(objProduction.Item_Consumed, id); } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
private bool UpdateItemandBS(ProductionVoucherModel objproduction) { try { //UPDATE Item voucher -CHILD TABLE UPDATES foreach (Item_VoucherModel item in objproduction.Item_Voucher) { if (item.Item_ID > 0) { UpdateProductionVoucherItems(item); } else { SaveProductionVoucherItems(item); } } //Update Bill Sundry Items foreach (BillSundry_VoucherModel bs in objproduction.BillSundry_Voucher) { if (bs.BSId > 0) { UpdateProductionBillSundryVoucher(bs); } else { SaveProductionBillSundryVoucher(bs); } } } catch (Exception ex) { return(false); } return(true); }
public ProductionVoucherModel GetAllProductionbyId(int id) { ProductionVoucherModel objProduction = new ProductionVoucherModel(); string Query = "SELECT * FROM Trans_Production_Voucher WHERE Production_Id=" + id; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objProduction.Production_Id = Convert.ToInt32(dr["Production_Id"]); objProduction.Series = dr["series"].ToString(); objProduction.PV_Date = DataFormat.GetDateTime(dr["Production_Date"]); objProduction.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]); objProduction.BillNo = Convert.ToInt32(dr["BillNo"].ToString()); objProduction.DueDate = Convert.ToDateTime(dr["DueDate"]); //objProduction.ProductionType = dr["Production_Type"].ToString(); objProduction.Party = dr["party"].ToString(); //objProduction.MatCenter = dr["MatCenter"].ToString(); objProduction.Narration = dr["Narration"].ToString(); //objProduction.TotalQty = Convert.ToDecimal(dr["TotalQty"]); //objProduction.TotalAmount = Convert.ToDecimal(dr["TotalAmount"].ToString()); objProduction.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]); //SELECT Credit Note Accounts string itemQuery = "SELECT * FROM Trans_Production_Items WHERE Production_Id=" + id; System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject()); //objProduction.Item_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["Production_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()); //objProduction.Item_Voucher.Add(objitem); } string BSQuery = "SELECT * FROM Trans_Production_BS WHERE Production_Id=" + id; System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(BSQuery, _dbHelper.GetConnObject()); //objProduction.BillSundry_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["Production_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()); //objProduction.BillSundry_Voucher.Add(objbs); } } return(objProduction); }