public static bool InsertCashMemo(FuelCashMemo model)
{
int cashmemoid;
using (var conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
using (var cmd = new SqlCommand("sp_InsertCashMemo", 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);
conn.Open();
try
{
cashmemoid = (int)cmd.ExecuteScalar();
}
catch (Exception ex)
{
throw;
}
conn.Close();
}
}
return(true);// GetUpdatedCashMemoData(cashmemoid);
}
public static bool BALSaveCashMemoDetails(FuelCashOtherMemo model)
{
try
{
foreach (var item in model.listFuel)
{
FuelCashMemo chitmodel = new FuelCashMemo()
{
VechileNumber = model.VechileNumber,
SerialNumber = model.SerialNumber,
OtherFule = "",
OtherPrice = 00,
FuelStationID = model.FuelStationID,
InsertedBy = model.InsertedBy,
//DieselBookno = model.DieselBookno,
Fueltype = item.Fueltype,
FuelQuantity = item.FuelQuantity,
Price = item.Price
};
DataRepository.FuelRepository.InsertCashMemo(chitmodel);
}
}
catch (Exception)
{
return(false);
}
return(true);
//return DataRepository.FuelRepository.InsertCashMemo(model).ToList();
}
