public bool UpdatePurchaseVoucher(eSunSpeedDomain.PurchaseVoucherModel objpv) { string Query = string.Empty; bool isUpdated = false; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Series", objpv.Series)); paramCollection.Add(new DBParameter("@PurchaseType", objpv.PurchaseType)); paramCollection.Add(new DBParameter("@PurchaseDate", objpv.PV_Date)); paramCollection.Add(new DBParameter("@VoucherNumber", objpv.Voucher_Number)); paramCollection.Add(new DBParameter("@BillNumber", objpv.BillNo)); paramCollection.Add(new DBParameter("@Party", objpv.Party)); paramCollection.Add(new DBParameter("@MatCentre", objpv.MatCenter)); paramCollection.Add(new DBParameter("@Narration", objpv.Narration)); paramCollection.Add(new DBParameter("@TotalQty", objpv.TotalQty, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@TotalAmount", objpv.TotalAmount, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@BSTotalAmount", objpv.BSTotalAmount, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@ModifiedBy", "Admin")); //paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now)); paramCollection.Add(new DBParameter("@PurchaseVoucher_ID", objpv.PV_Id)); Query = "UPDATE Trans_Purchase_Voucher SET [Series]=@Series,[PV_Type]=@PurchaseType,[PV_Date]=@PurchaseDate," + "[VoucherNo]=@VoucherNumber,[BillNo]=@BillNumber," + "[Party]=@Party,[MatCenter]=@MatCentre," + "[Narration]=@Narration,[TotalQty]=@TotalQty," + "[TotalAmount]=@TotalAmount,[BSTotalAmount]=@BSTotalAmount," + "[ModifiedBy]=@ModifiedBy " + "WHERE TransPVId=@PurchaseVoucher_ID;"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { UpdatePurchaseItemandBS(objpv); isUpdated = true; } } catch (Exception ex) { isUpdated = false; throw ex; } return(isUpdated); }
//Update Purchase Voucher public bool UpdatePurchaseVoucher(eSunSpeedDomain.PurchaseVoucherModel objPurc) { string Query = string.Empty; bool isUpdate = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Trans_Purc_Id", objPurc.Trans_Purc_Id)); paramCollection.Add(new DBParameter("@VoucherType", objPurc.VoucherType)); paramCollection.Add(new DBParameter("@PurcDate", objPurc.PurcDate, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@Terms", objPurc.Terms)); paramCollection.Add(new DBParameter("@VoucherNumber", objPurc.VoucherNumber)); paramCollection.Add(new DBParameter("@BillNumber", objPurc.BillNo)); paramCollection.Add(new DBParameter("@LedgerId", objPurc.LedgerId)); paramCollection.Add(new DBParameter("@PurcType", objPurc.PurcType)); paramCollection.Add(new DBParameter("@MatCentre", objPurc.MatCentre)); paramCollection.Add(new DBParameter("@Narration", objPurc.Narration)); paramCollection.Add(new DBParameter("@TotalAmount", objPurc.TotalAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@TotalQty", objPurc.TotalQty, DbType.Decimal)); paramCollection.Add(new DBParameter("@TotalFree", objPurc.TotalFree, DbType.Decimal)); paramCollection.Add(new DBParameter("@TotalBasicAmount", objPurc.TotalBasicAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@TotalDisAmount", objPurc.TotalDisAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@TotalTaxAmount", objPurc.TotalTaxAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@BSTotalAmount", objPurc.BSTotalAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, DbType.DateTime)); paramCollection.Add(new DBParameter("@ModifiedBy", "")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, DbType.DateTime)); System.Data.IDataReader dr = _dbHelper.ExecuteDataReader("spUpdatePurchaseVoucherMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); foreach (Item_VoucherModel item in objPurc.Item_Voucher) { item.ParentId = objPurc.Trans_Purc_Id; if (item.Item_ID > 0) { paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@ParentId", item.ParentId)); paramCollection.Add(new DBParameter("@IId", item.Item_ID)); paramCollection.Add(new DBParameter("@ITM_Id", item.ITM_Id)); paramCollection.Add(new DBParameter("@LedgerId", item.LedgerId)); paramCollection.Add(new DBParameter("@Qty", item.Qty, DbType.Decimal)); paramCollection.Add(new DBParameter("@Unit", item.Unit)); paramCollection.Add(new DBParameter("@Per", item.Per)); paramCollection.Add(new DBParameter("@Price", item.Price, DbType.Decimal)); paramCollection.Add(new DBParameter("@Batch", item.Batch)); paramCollection.Add(new DBParameter("@Free", item.Free, DbType.Decimal)); paramCollection.Add(new DBParameter("@BasicAmt", item.BasicAmt, DbType.Decimal)); paramCollection.Add(new DBParameter("@DiscountPercentage", item.DiscountPercentage, DbType.Decimal)); paramCollection.Add(new DBParameter("@DiscountAmount", item.DiscountAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@TaxAmount", item.TaxAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@Amount", item.Amount, DbType.Decimal)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@ModifiedBy", "")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime)); System.Data.IDataReader drpv = _dbHelper.ExecuteDataReader("spUpdatePurchaseVoucherItemDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); } else { paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@ParentId", item.ParentId)); paramCollection.Add(new DBParameter("@ITM_Id", item.ITM_Id)); paramCollection.Add(new DBParameter("@LedgerId", item.LedgerId)); paramCollection.Add(new DBParameter("@Qty", item.Qty, DbType.Decimal)); paramCollection.Add(new DBParameter("@Unit", item.Unit)); paramCollection.Add(new DBParameter("@Per", item.Per)); paramCollection.Add(new DBParameter("@Price", item.Price, DbType.Decimal)); paramCollection.Add(new DBParameter("@Batch", item.Batch)); paramCollection.Add(new DBParameter("@Free", item.Free, DbType.Decimal)); paramCollection.Add(new DBParameter("@BasicAmt", item.BasicAmt, DbType.Decimal)); paramCollection.Add(new DBParameter("@DiscountPercentage", item.DiscountPercentage, DbType.Decimal)); paramCollection.Add(new DBParameter("@DiscountAmount", item.DiscountAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@TaxAmount", item.TaxAmount, DbType.Decimal)); paramCollection.Add(new DBParameter("@Amount", item.Amount, DbType.Decimal)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@ModifiedBy", "")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, System.Data.DbType.DateTime)); System.Data.IDataReader drpv = _dbHelper.ExecuteDataReader("spInsertPurchaseVoucherItemDetails", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); } } foreach (BillSundry_VoucherModel bs in objPurc.BillSundry_Voucher) { bs.ParentId = objPurc.Trans_Purc_Id; if (bs.BSId > 0) { paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@ParentId", bs.ParentId)); paramCollection.Add(new DBParameter("@BSId", bs.BSId)); paramCollection.Add(new DBParameter("@BS_Id", bs.BS_Id)); paramCollection.Add(new DBParameter("@Percentage", bs.Percentage)); paramCollection.Add(new DBParameter("@Extra", bs.Extra)); paramCollection.Add(new DBParameter("@Amount", bs.Amount)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, DbType.DateTime)); paramCollection.Add(new DBParameter("@ModifiedBy", "")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, DbType.DateTime)); System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader("spUpdatePurchaseVoucherBS", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); } else { paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@ParentId", bs.ParentId)); paramCollection.Add(new DBParameter("@BS_Id", bs.BS_Id)); paramCollection.Add(new DBParameter("@Percentage", bs.Percentage)); paramCollection.Add(new DBParameter("@Extra", bs.Extra)); paramCollection.Add(new DBParameter("@Amount", bs.Amount)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now, DbType.DateTime)); paramCollection.Add(new DBParameter("@ModifiedBy", "")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now, DbType.DateTime)); System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader("spInsertPurchaseVoucherBS", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); } } } catch (Exception ex) { isUpdate = false; //throw ex; } return(isUpdate); }