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