public static bool BALInsertChit(ChitFuel model)
{
try
{
foreach (var item in model.listFuel)
{
if (item.FuelQuantity > Convert.ToDecimal(0.0))
{
ChitFuelModelInsert chitmodel = new ChitFuelModelInsert()
{
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.InsertChit(chitmodel);
}
}
}
catch (Exception)
{
return(false);
}
return(true);
}
public static bool InsertChit(ChitFuelModelInsert model)
{
int cashmemoid;
using (var conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
using (var cmd = new SqlCommand("sp_InsertChitFuel", 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("comment", model.Comment);
cmd.Parameters.AddWithValue("dieselbookno", model.DieselBookno);
cmd.Parameters.AddWithValue("dieselchitno", model.ChitNo);
conn.Open();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
return(false);
}
conn.Close();
}
}
return(true);
}
