public static bool BALInsertStaffFule(staffFuel model) { try { foreach (var item in model.listFuel) { if (item.FuelQuantity > 0) { FuelStafflModel chitmodel = new FuelStafflModel() { VechileNumber = model.VechileNumber, //ChitNo = model.ChitNo, Comment = model.Comment, FuelStationID = model.FuelStationID, InsertedBy = model.InsertedBy, ChitNo = model.ChitNo, BookNo = model.DieselBookno, Fueltype = item.Fueltype, FuelQuantity = item.FuelQuantity, Price = item.Price }; DataRepository.FuelRepository.InsertStaffFule(chitmodel); } } } catch (Exception) { return(false); } return(true); }
public static bool InsertStaffFule(FuelStafflModel model) { int cashmemoid; using (var conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)) { using (var cmd = new SqlCommand("sp_InsertStaffFuel", 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("deiselbookno", model.BookNo); cmd.Parameters.AddWithValue("chitno", model.ChitNo); cmd.Parameters.AddWithValue("comment", model.Comment); conn.Open(); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { throw; } conn.Close(); } } return(true); }