public static bool SaveFuelDetails(FuelPriceListModel model) { using (var conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString)) { using (var cmd = new SqlCommand("sp_InsertFuelDetails", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("station_id", model.PumpID); cmd.Parameters.AddWithValue("fuel_type_id", model.FuelID); cmd.Parameters.AddWithValue("price", model.Price); cmd.Parameters.AddWithValue("updated_by", model.UpdatedBy); conn.Open(); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { throw; } conn.Close(); } } return(true); }
public ActionResult SaveFuelDetails(FuelPriceListModel model) { var user = ((UserValidation.CustomPrincipal)(HttpContext.Request.RequestContext.HttpContext.User)).User; model.UpdatedBy = user.LoginEmpID; var data = BusinessAccessLayer.BALFuel.BALSaveFuelDetails(model); return(Json(data, JsonRequestBehavior.AllowGet)); }
public static bool BALSaveFuelDetails(FuelPriceListModel model) { return(DataRepository.FuelRepository.SaveFuelDetails(model)); }