// PUT api/values/5 public Object Put(int id, [FromBody] string driverGain) { DriverGain u = JsonConvert.DeserializeObject <DriverGain>(driverGain); u.ID = id; return(new { success = DriverGainBLL.UpdateDriverGain(u) }); }
// POST api/values public int Post([FromBody] string driverGain) { JsonSerializerSettings serializerSettings = new JsonSerializerSettings { Formatting = Formatting.Indented }; DriverGain u = JsonConvert.DeserializeObject <DriverGain>(driverGain, serializerSettings); return(DriverGainBLL.InsertDriverGain(u)); }
public int InsertDriverGain(DriverGain driverGain) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@IDUserDriver", driverGain.IDUserDriver); parameters.Add("@IDCar", driverGain.IDCar); parameters.Add("@NetGainPerKm", driverGain.NetGainPerKm); parameters.Add("@RegDate", driverGain.RegDate); return((int)SqlMapper.ExecuteScalar(connection, SQL_INSERIR, parameters)); }
public bool UpdateDriverGain(DriverGain driverGain) { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@ID", driverGain.ID); parameters.Add("@IDUserDriver", driverGain.IDUserDriver); parameters.Add("@IDCar", driverGain.IDCar); parameters.Add("@NetGainPerKm", driverGain.NetGainPerKm); return(SqlMapper.Execute(connection, SQL_UPDATE, parameters) > 0); }
public bool UpdateDriverGain(DriverGain driverGain) { return(DriverGainDAL.UpdateDriverGain(driverGain)); }
public int InsertDriverGain(DriverGain driverGain) { return(DriverGainDAL.InsertDriverGain(driverGain)); }