public bool SavePurchaseBillSundryVoucher(eSunSpeedDomain.BillSundry_VoucherModel objBSVoucher) { string Query = string.Empty; bool isSaved = true; objBSVoucher.ParentId = GetPurchaseVoucherId(); try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@PurchaseVoucher_ID", objBSVoucher.ParentId)); paramCollection.Add(new DBParameter("@PurchaseBillSundry_Name", objBSVoucher.BillSundry)); paramCollection.Add(new DBParameter("@PurchaseBillSundry_Amount", objBSVoucher.Amount)); paramCollection.Add(new DBParameter("@PurchaseBillSundry_Qty", objBSVoucher.Percentage)); paramCollection.Add(new DBParameter("@PurchaseBillSundry_Unit", objBSVoucher.TotalAmount)); paramCollection.Add(new DBParameter("@CreatedBy", "Admin")); Query = "INSERT INTO PurchaseBillSundry_Voucher([PurchaseVoucher_ID],[PurchaseBillSundry_Name],[PurchaseBillSundry_Amount]," + "[PurchaseBillSundry_Qty],[PurchaseBillSundry_Unit],[CreatedBy]) VALUES " + "(@PurchaseVoucher_ID,@PurchaseBillSundry_Name,@PurchaseBillSundry_Amount,@PurchaseBillSundry_Qty,@PurchaseBillSundry_Unit,@CreatedBy)"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isSaved = true; } } catch (Exception ex) { isSaved = false; throw ex; } return(isSaved); }
public bool UpdatePurchaseBillSundryVoucher(eSunSpeedDomain.BillSundry_VoucherModel objBSVoucher) { string Query = string.Empty; bool isUpdate = true; try { DBParameterCollection paramCollection = new DBParameterCollection(); paramCollection.Add(new DBParameter("@PurchaseBillSundry_Name", objBSVoucher.BillSundry)); paramCollection.Add(new DBParameter("@PurchaseBillSundry_Amount", objBSVoucher.Amount)); paramCollection.Add(new DBParameter("@PurchaseBillSundry_Qty", objBSVoucher.Amount)); paramCollection.Add(new DBParameter("@PurchaseBillSundry_Unit", objBSVoucher.Percentage)); paramCollection.Add(new DBParameter("@ModifiedBy", "Admin")); paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now)); paramCollection.Add(new DBParameter("@PurchaseBillSundry_ID", objBSVoucher.BSId)); paramCollection.Add(new DBParameter("@PurchaseVoucher_ID", objBSVoucher.ParentId)); Query = "UPDATE PurchaseBillSundry_Voucher SET [PurchaseBillSundry_Name]=@PurchaseBillSundry_Name,[PurchaseBillSundry_Amount]=@PurchaseBillSundry_Amount," + "[PurchaseBillSundry_Qty]=@PurchaseBillSundry_Qty,[PurchaseBillSundry_Unit]=@PurchaseBillSundry_Unit,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " + "WHERE [PurchaseBillSundry_ID]=@PurchaseBillSundry_ID AND [PurchaseVoucher_ID]=@PurchaseVoucher_ID"; if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0) { isUpdate = true; } } catch (Exception ex) { isUpdate = false; throw ex; } return(isUpdate); }
public List <eSunSpeedDomain.PurchaseVoucherMainModel> GetAllPurchaseVouchers() { List <eSunSpeedDomain.PurchaseVoucherMainModel> lstPurchaseVouchers = new List <eSunSpeedDomain.PurchaseVoucherMainModel>(); eSunSpeedDomain.PurchaseVoucherMainModel objPurch; string Query = "SELECT * FROM PurchaseMain_Voucher"; System.Data.IDataReader dr = _dbHelper.ExecuteDataReader(Query, _dbHelper.GetConnObject()); while (dr.Read()) { objPurch = new eSunSpeedDomain.PurchaseVoucherMainModel(); objPurch.PurchaseVoucher_ID = DataFormat.GetInteger(dr["PurchaseVoucher_ID"]); objPurch.PurchaseVoucher_Date = DataFormat.GetDateTime(dr["PurchaseVoucher_Date"]); objPurch.PurchaseVoucher_Number = DataFormat.GetInteger(dr["PurchaseVoucher_Number"]); objPurch.PurchaseVoucher_PurchaseType = dr["PurchaseVoucher_PurchType"].ToString(); objPurch.PurchaseVoucher_Party = dr["PurchaseVoucher_Party"].ToString(); objPurch.PurchaseVoucher_MatCenter = dr["PurchaseVoucher_MatCenter"].ToString(); //Add Purchase Items string itemQuery = "SELECT * FROM PurchaseItem_Voucher WHERE PurchaseVoucher_ID=" + objPurch.PurchaseVoucher_ID; System.Data.IDataReader drItem = _dbHelper.ExecuteDataReader(itemQuery, _dbHelper.GetConnObject()); objPurch.PurchaseItem_Voucher = new List <eSunSpeedDomain.Item_VoucherModel>(); eSunSpeedDomain.Item_VoucherModel objItemModel; while (drItem.Read()) { objItemModel = new eSunSpeedDomain.Item_VoucherModel(); objItemModel.ParentId = DataFormat.GetInteger(drItem["PurchaseVoucher_ID"]); objItemModel.Item_ID = DataFormat.GetInteger(drItem["PurchaseItem_ID"]); objItemModel.Item = drItem["Purchase_Item"].ToString(); objItemModel.Price = Convert.ToDecimal(drItem["Purchase_Price"]); objItemModel.Qty = Convert.ToDecimal(drItem["Purchase_Qty"]); objItemModel.Unit = drItem["Purchase_Unit"].ToString(); objPurch.PurchaseItem_Voucher.Add(objItemModel); } //Add Bill Sundry Voucher items string bsQuery = "SELECT * FROM PurchaseBillSundry_Voucher WHERE PurchaseVoucher_ID=" + objPurch.PurchaseVoucher_ID; System.Data.IDataReader drBS = _dbHelper.ExecuteDataReader(bsQuery, _dbHelper.GetConnObject()); objPurch.BillSundry_Voucher = new List <eSunSpeedDomain.BillSundry_VoucherModel>(); eSunSpeedDomain.BillSundry_VoucherModel objBSModel; while (drBS.Read()) { objBSModel = new eSunSpeedDomain.BillSundry_VoucherModel(); objBSModel.ParentId = DataFormat.GetInteger(drBS["PurchaseVoucher_ID"]); objBSModel.BSId = DataFormat.GetInteger(drBS["PurchaseBillSundry_ID"]); objBSModel.BillSundry = drBS["PurchaseBillSundry_Name"].ToString(); objBSModel.Amount = Convert.ToDecimal(drBS["PurchaseBillSundry_Amount"]); objBSModel.Percentage = Convert.ToDecimal(drBS["PurchaseBillSundry_Qty"]); //objBSModel.TotalAmount = drBS["PurchaseBillSundry_Unit"] objPurch.BillSundry_Voucher.Add(objBSModel); } lstPurchaseVouchers.Add(objPurch); } return(lstPurchaseVouchers); }