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