public static FuelChashModel GetCashFuelSalesDetails(CashFuleSale model)
{
FuelChashModel objcash = new FuelChashModel();
using (var conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
using (var cmd = new SqlCommand("sp_GetCashFuelSale", conn))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("pumpid", model.PumpId);
cmd.Parameters.AddWithValue("fueltypeid", model.FuelType);
cmd.Parameters.AddWithValue("patrolQuantity", model.ChitQuanity);
cmd.Parameters.AddWithValue("staffqaunity", model.StaffQuanity);
cmd.Parameters.AddWithValue("otherquantity", model.OtherQuanity);
cmd.Parameters.AddWithValue("startreading", model.StartReading);
cmd.Parameters.AddWithValue("endreading", model.EndReading);
conn.Open();
SqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
objcash = new FuelChashModel
{
Quantity = (Convert.ToDecimal(rd["CashQuantity"])),
Price = Convert.ToDecimal(rd["TotalPrice"])
};
}
}
}
return(objcash);
}
public ActionResult GetCashDetails(CashFuleSale model)
{
var data = BusinessAccessLayer.BALFuel.BALGetCashFuelSalesDetails(model);
return(Json(data, JsonRequestBehavior.AllowGet));
}
public static FuelChashModel BALGetCashFuelSalesDetails(CashFuleSale model)
{
return(FuelRepository.GetCashFuelSalesDetails(model));
}
