public IQueryable<SystemSettingViewModel> GetSystemSetting(String EventClass)
{
List<SystemSettingViewModel> ret = new List<SystemSettingViewModel>();
var qry = db.SystemSetting.Where(x => x.Seq != 0);
if(EventClass != "" && db.SystemSetting.Where(x => x.EventClass == EventClass).Count()!=0)
qry = db.SystemSetting.Where(x => x.EventClass == EventClass);
else
qry = db.SystemSetting.Where(x => x.EventClass == null);
foreach (SystemSetting o in qry)
{
SystemSettingViewModel s = new SystemSettingViewModel();
s.AlertTimes = o.AlertTimes;
s.EventClass = o.EventClass;
s.isSysDefault = o.isSysDefault;
s.Seq =o.Seq;
s.SugArriveMin = o.SugArriveMin;
s.SugFinishMin = o.SugFinishMin;
s.AnnexNeed = o.AnnexNeed;
s.AutoAssign = o.AutoAssign;
s.AutoAssignUserType = o.AutoAssignUserType;
s.AssignUserType = o.AssignUserType;
s.ScheduleStartDTNeed = o.ScheduleStartDTNeed;
s.Alert43Day = o.Alert43Day;
s.ExamineNeed = o.ExamineNeed;
ret.Add(s);
}
return ret.AsQueryable();
}
public String SaveSystemSetting(SystemSettingViewModel Setting)
{
String ret = "false";
try
{
if (Setting.EventClass == null)
{
SystemSetting setting = db.SystemSetting.Find(db.SystemSetting.Where(x => x.EventClass == null).Select(x => x.Seq).First());
setting.SugArriveMin = Setting.SugArriveMin;
setting.SugFinishMin = Setting.SugFinishMin;
setting.AnnexNeed = Setting.AnnexNeed;
//setting.AutoAssign = Setting.AutoAssign;
setting.AutoAssign = false;
//setting.AutoAssignUserType = Setting.AutoAssignUserType;
setting.AutoAssignUserType = 1;
setting.ScheduleStartDTNeed = Setting.ScheduleStartDTNeed;
setting.AssignUserType = Setting.AssignUserType;
setting.Alert43Day = Setting.Alert43Day;
setting.ExamineNeed = Setting.ExamineNeed;
db.SaveChanges();
ret = "true";
}
else
{
if (Setting.isSysDefault)
{
SystemSetting setting = new SystemSetting();
setting.EventClass = Setting.EventClass;
setting.AlertTimes = db.SystemSetting.Where(x => x.EventClass == null).Select(x => x.AlertTimes).First();
setting.SugArriveMin = Setting.SugArriveMin;
setting.SugFinishMin = Setting.SugFinishMin;
setting.isSysDefault = false;
setting.AnnexNeed = Setting.AnnexNeed;
//setting.AutoAssign = Setting.AutoAssign;
setting.AutoAssign = false;
//setting.AutoAssignUserType = Setting.AutoAssignUserType;
setting.AutoAssignUserType = 1;
setting.ScheduleStartDTNeed = Setting.ScheduleStartDTNeed;
setting.AssignUserType = Setting.AssignUserType;
setting.Alert43Day = Setting.Alert43Day;
setting.ExamineNeed = Setting.ExamineNeed;
db.SystemSetting.Add(setting);
db.SaveChanges();
ret = "true";
}
else
{
SystemSetting setting = db.SystemSetting.Find(db.SystemSetting.Where(x => x.EventClass==Setting.EventClass).Select(x => x.Seq).First());
setting.SugArriveMin = Setting.SugArriveMin;
setting.SugFinishMin = Setting.SugFinishMin;
setting.AnnexNeed = Setting.AnnexNeed;
//setting.AutoAssign = Setting.AutoAssign;
setting.AutoAssign = false;
//setting.AutoAssignUserType = Setting.AutoAssignUserType;
setting.AutoAssignUserType = 1;
setting.ScheduleStartDTNeed = Setting.ScheduleStartDTNeed;
setting.AssignUserType = Setting.AssignUserType;
setting.Alert43Day = Setting.Alert43Day;
setting.ExamineNeed = Setting.ExamineNeed;
db.SaveChanges();
ret = "true";
}
}
}
catch
{
ret = "false";
}
return ret;
}