public align_sensor_name CreateSensor(string serial_number, string sensor_name, int sensor_type_id)
{
if (db.align_sensor_name.Count(c => c.sensor_name == sensor_name) == 0)
{
var res = db.align_sensor_name.Add(new align_sensor_name
{
serial_number = serial_number,
sensor_name = sensor_name,
sensor_type_id = sensor_type_id,
status = "ac",
create_dt = DateTime.Now
});
int save = db.SaveChanges();
if (save > 0)
{
return(res);
}
throw new Exception("failed save");
}
throw new Exception("have in table");
}
public setting SettingEdit(m_Setting request, int user_id)
{
var res = db.setting.FirstOrDefault(c => c.user_id == user_id);
res.sensor = request.sensor;
res.camera = request.time;
var save = db.SaveChanges();
if (save > 0)
{
return(res);
}
throw new Exception("Failed for save");
}
public s_moisture Create_Moisture(int sensor_id, decimal moisture)
{
var add = db.s_moisture.Add(new s_moisture {
sensor_id = sensor_id,
moisture = moisture,
created_dt = DateTime.Now
});
int res = db.SaveChanges();
if (res > 0)
{
return(add);
}
throw new Exception("failed for save");
}