public bool UpdatePurchaseVoucherItems(eSunSpeedDomain.Item_VoucherModel objPurchItem)
{
string Query = string.Empty;
bool isUpdated = true;
try
{
DBParameterCollection paramCollection = new DBParameterCollection();
paramCollection.Add(new DBParameter("@Purchase_Item", objPurchItem.Item));
paramCollection.Add(new DBParameter("@Purchase_Qty", objPurchItem.Qty));
paramCollection.Add(new DBParameter("@Purchase_Unit", objPurchItem.Qty));
paramCollection.Add(new DBParameter("@Purchase_Price", objPurchItem.Price));
paramCollection.Add(new DBParameter("@Purchase_Amount", objPurchItem.Amount));
paramCollection.Add(new DBParameter("@ModifiedBy", "Admin"));
paramCollection.Add(new DBParameter("@ModifiedDate", DateTime.Now));
paramCollection.Add(new DBParameter("@PurchaseVoucher_ID", objPurchItem.ParentId));
paramCollection.Add(new DBParameter("@PurchaseItem_ID", objPurchItem.Item_ID));
Query = "UPDATE PurchaseItem_Voucher SET [Purchase_Item]=@Purchase_Item,[Purchase_Qty]=@Purchase_Qty,[Purchase_Unit]=@Purchase_Unit," +
"[Purchase_Price]=@Purchase_Price,[Purchase_Amount]=@Purchase_Amount,[ModifiedBy]=@ModifiedBy,[ModifiedDate]=@ModifiedDate " +
"WHERE PurchaseVoucher_ID=@PurchaseVoucher_ID AND [PurchaseItem_ID]=@PurchaseItem_ID";
if (_dbHelper.ExecuteNonQuery(Query, paramCollection) > 0)
{
isUpdated = true;
}
}
catch (Exception ex)
{
isUpdated = false;
throw ex;
}
return(isUpdated);
}
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);
}
