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