public bool UpdateSalesVoucher(UnassembleVoucherModel objassemble) { string Query = string.Empty; bool isUpdated = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Series", objassemble.Series)); paramCollection.Add(new DBParameter("@Date", objassemble.UA_Date)); paramCollection.Add(new DBParameter("@VoucherNumber", objassemble.Voucher_Number)); paramCollection.Add(new DBParameter("@BomName", objassemble.BOM_Name)); paramCollection.Add(new DBParameter("@MatCentre1", objassemble.MatCenterIG)); paramCollection.Add(new DBParameter("@MatCentre2", objassemble.MatCenterIC)); paramCollection.Add(new DBParameter("@Narration", objassemble.Narration)); paramCollection.Add(new DBParameter("@TotalQty", objassemble.TotalAmountIG, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@TotalAmount", objassemble.TotalAmountIG, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@BSTotalAmount", objassemble.BSTotalAmount, System.Data.DbType.Decimal)); paramCollection.Add(new DBParameter("@ModifiedBy", "Admin")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now)); paramCollection.Add(new DBParameter("@UassembleVoucher_ID", objassemble.UA_Id)); Query = "UPDATE Trans_Unassemble_Voucher SET [Series]=@Series,[UA_Date]=@Date," + "[VoucherNo]=@VoucherNumber,[BOM_Name]=@BomName," + "[MatCenter1]=@MatCentre1,[MatCenter2]=@MatCentre2," + "[Narration]=@Narration,[TotalQty]=@TotalQty," + "[TotalAmount]=@TotalAmount,[BSTotalAmount]=@BSTotalAmount," + "[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " + "WHERE Unassemble_Id=@UassembleVoucher_ID;"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { //UpdateItemandBS(objassemble); isUpdated = true; } } catch (Exception ex) { isUpdated = false; throw ex; } return(isUpdated); }
public bool SaveUnassembleVoucher(UnassembleVoucherModel objAssemble) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@VoucherNumber", objAssemble.Voucher_Number)); paramCollection.Add(new DBParameter("@Series", objAssemble.Series)); paramCollection.Add(new DBParameter("@Date", objAssemble.UA_Date, System.Data.DbType.DateTime)); paramCollection.Add(new DBParameter("@BOMName", objAssemble.BOM_Name)); paramCollection.Add(new DBParameter("@MatCentreIG", objAssemble.MatCenterIG)); paramCollection.Add(new DBParameter("@MatCentreIC", objAssemble.MatCenterIC)); paramCollection.Add(new DBParameter("@Narration", objAssemble.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("spInsertUnassembleMaster", _dbHelper.GetConnObject(), paramCollection, System.Data.CommandType.StoredProcedure); int id = 0; dr.Read(); id = Convert.ToInt32(dr[0]); SaveUnassembleItemgenerate(objAssemble.Item_Generated, id); SaveUnassembleItemConsumed(objAssemble.Item_Consumed, id); } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
public bool SaveUnassembleVoucher(UnassembleVoucherModel objAssemble) { string Query = string.Empty; bool isSaved = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@Series", objAssemble.Series)); paramCollection.Add(new DBParameter("@AssembleDate", objAssemble.UA_Date)); paramCollection.Add(new DBParameter("@VoucherNumber", objAssemble.Voucher_Number)); paramCollection.Add(new DBParameter("@MatCenter1", objAssemble.MatCenter1)); paramCollection.Add(new DBParameter("@MatCenter2", objAssemble.MatCenter2)); paramCollection.Add(new DBParameter("@Narration", objAssemble.Narration)); paramCollection.Add(new DBParameter("@TotalQty", objAssemble.TotalQty)); paramCollection.Add(new DBParameter("@TotalAmount", objAssemble.TotalAmount)); paramCollection.Add(new DBParameter("@BSTotalAmount", objAssemble.BSTotalAmount)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); paramCollection.Add(new DBParameter("@CreatedDate", DateTime.Now)); Query = "INSERT INTO Trans_Unassemble_Voucher ([Series],[UA_Date],[VoucherNo],[MatCenter1]," + "[MatCenter2],[Narration],[TotalQty],[TotalAmount],[BSTotalAmount],[CreatedBy],[CreatedDate]) VALUES " + "(@Series,@AssembleDate,@VoucherNumber,@MatCenter1,@MatCenter2,@Narration,@TotalQty,@TotalAmount,@BSTotalAmount,@CreatedBy,@CreatedDate)"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { SaveUnassembleItems(objAssemble.AssembleItem_Voucher); SaveUnassembleBillSundry(objAssemble.AssembleBillSundry_Voucher); isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
private bool UpdateItemandBS(UnassembleVoucherModel objassemble) { try { //UPDATE Item voucher -CHILD TABLE UPDATES foreach (Item_VoucherModel item in objassemble.AssembleItem_Voucher) { if (item.Item_ID > 0) { UpdateUnassembleVoucherItems(item); } else { SaveUnassembleVoucherItem(item); } } //Update Bill Sundry Items foreach (BillSundry_VoucherModel bs in objassemble.AssembleBillSundry_Voucher) { if (bs.BSId > 0) { UpdateUnassembleBillSundryVoucher(bs); } else { SaveUnassembleVoucherBillSundryVoucher(bs); } } } catch (Exception ex) { return(false); } return(true); }
public UnassembleVoucherModel GetAllUnassemblebyId(int id) { UnassembleVoucherModel objassemble = new UnassembleVoucherModel(); string Query = "SELECT * FROM Trans_Unassemble_Voucher WHERE Unassemble_Id=" + id; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objassemble.UA_Id = Convert.ToInt32(dr["Unassemble_Id"]); objassemble.Series = dr["series"].ToString(); objassemble.UA_Date = DataFormat.GetDateTime(dr["UA_Date"]); objassemble.Voucher_Number = DataFormat.GetInteger(dr["VoucherNo"]); objassemble.BOM_Name = dr["BOM_Name"].ToString(); objassemble.MatCenterIG = dr["MatCenter1"].ToString(); objassemble.MatCenterIC = dr["MatCenter2"].ToString(); objassemble.Narration = dr["Narration"].ToString(); objassemble.TotalQtyIG = Convert.ToDecimal(dr["TotalQty"]); objassemble.TotalAmountIG = Convert.ToDecimal(dr["TotalAmount"].ToString()); objassemble.BSTotalAmount = Convert.ToDecimal(dr["BSTotalAmount"]); //SELECT Credit Note Accounts string itemQuery = "SELECT * FROM Trans_Unassemble_Items WHERE Unassemble_Id=" + id; System.Data.IDataReader drItems = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject()); //objassemble.AssembleItem_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["Unassemble_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()); //objassemble.AssembleItem_Voucher.Add(objitem); } string BSQuery = "SELECT * FROM Trans_Unassemble_BS WHERE Unassemble_Id=" + id; System.Data.IDataReader drbs = _dbHelper.ExecuteDataReader(BSQuery, _dbHelper.GetConnObject()); //objassemble.AssembleBillSundry_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["Unassemble_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()); //objassemble.AssembleBillSundry_Voucher.Add(objbs); } } return(objassemble); }