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); }