public static bool InsertOtherFule(FuelOtherSale model)
{
using (var conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
using (var cmd = new SqlCommand("sp_InsertOtherFuel", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("vechilenumber", model.VechileNumber);
cmd.Parameters.AddWithValue("fuletype", model.Fueltype);
cmd.Parameters.AddWithValue("quantity", model.FuelQuantity);
cmd.Parameters.AddWithValue("price", model.Price);
//cmd.Parameters.AddWithValue("otherfuel", model.OtherFule);
//cmd.Parameters.AddWithValue("otherprice", model.OtherPrice);
cmd.Parameters.AddWithValue("station_id", model.FuelStationID);
cmd.Parameters.AddWithValue("insertedby", model.InsertedBy);
cmd.Parameters.AddWithValue("serial_no", model.SerialNumber);
cmd.Parameters.AddWithValue("comment", model.Comment);
conn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw;
}
conn.Close();
}
}
return(true);
}
public static bool BALInsertOtherFule(OtherFuelModel model)
{
try
{
foreach (var item in model.listFuel)
{
if (item.FuelQuantity > 0)
{
FuelOtherSale chitmodel = new FuelOtherSale()
{
VechileNumber = model.VechileNumber,
//ChitNo = model.ChitNo,
Comment = model.Comment,
OtherFule = "",
OtherPrice = 00,
FuelStationID = model.FuelStationID,
InsertedBy = model.InsertedBy,
// DieselBookno = model.DieselBookno,
Fueltype = item.Fueltype,
FuelQuantity = item.FuelQuantity,
Price = item.Price
};
DataRepository.FuelRepository.InsertOtherFule(chitmodel);
}
}
}
catch (Exception)
{
return(false);
}
return(true);
}
