public String SaveAlertSetting(AlertSettingViewModel 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.AlertTimes = Setting.AlertTimes;
db.SaveChanges();
var qry = db.AlertTimeSetting.Where(x => x.EventClass == null);
foreach (AlertTimeSetting o in qry) {
o.StartTime = Setting.TimeSetting[0].StartTime;
o.StartTime2 = Setting.TimeSetting[0].StartTime2;
o.StartTime3 = Setting.TimeSetting[0].StartTime3;
o.EndTime = Setting.TimeSetting[0].EndTime;
o.EndTime2 = Setting.TimeSetting[0].EndTime2;
o.EndTime3 = Setting.TimeSetting[0].EndTime3;
o.isAlert = Setting.TimeSetting[o.Week - 1].isAlert;
}
db.SaveChanges();
var qry2 = db.AlertHolidaySetting.Where(x => x.EventClass == null);
foreach (AlertHolidaySetting o in qry2) {
db.AlertHolidaySetting.Remove(o);
}
db.SaveChanges();
for (int k = 0; k < Setting.HolidaySetting.Count; k++) {
AlertHolidaySetting hSetting = new AlertHolidaySetting();
hSetting.EventClass = null;
hSetting.EndDate = Setting.HolidaySetting[k].EndDate.Date.AddHours(23).AddMinutes(59);
hSetting.isSysDefault = true;
hSetting.StartDate = Setting.HolidaySetting[k].StartDate.Date;
hSetting.isAlert = Setting.HolidaySetting[k].isAlert;
db.AlertHolidaySetting.Add(hSetting);
db.SaveChanges();
}
for (int k = 0; k < Setting.DetailSetting.Count; k++) {
int temp = Setting.DetailSetting[k].AlertEvent;
var qry3 = db.AlertDetailSetting.Where(x => x.EventClass == null && x.AlertEvent == temp);
foreach (AlertDetailSetting o in qry3) {
o.FirstTime = Setting.DetailSetting[k].FirstTime;
if (Setting.DetailSetting[k].Memo == null)
o.Memo = "";
else
o.Memo = Setting.DetailSetting[k].Memo;
o.SecondTime = Setting.DetailSetting[k].SecondTime;
o.Times = Setting.DetailSetting[k].Times;
}
db.SaveChanges();
}
ret = "true";
}
else {
if (Setting.isSysDefault) {
SystemSetting setting = new SystemSetting();
setting.EventClass = Setting.EventClass;
setting.AlertTimes = Setting.AlertTimes;
setting.SugArriveMin = db.SystemSetting.Where(x => x.EventClass == null).Select(x => x.SugArriveMin).First();
setting.SugFinishMin = db.SystemSetting.Where(x => x.EventClass == null).Select(x => x.SugFinishMin).First();
setting.isSysDefault = false;
db.SystemSetting.Add(setting);
db.SaveChanges();
for (int k = 0; k < Setting.DetailSetting.Count; k++) {
AlertDetailSetting dSetting = new AlertDetailSetting();
dSetting.EventClass = Setting.DetailSetting[k].EventClass;
dSetting.AlertEvent = Setting.DetailSetting[k].AlertEvent;
dSetting.FirstTime = Setting.DetailSetting[k].FirstTime;
if (Setting.DetailSetting[k].Memo==null)
dSetting.Memo = "";
else
dSetting.Memo = Setting.DetailSetting[k].Memo;
dSetting.SecondTime = Setting.DetailSetting[k].SecondTime;
dSetting.isSysDefault = false;
dSetting.Times = Setting.DetailSetting[k].Times;
db.AlertDetailSetting.Add(dSetting);
db.SaveChanges();
}
ret = "true";
}
else {
SystemSetting setting = db.SystemSetting.Find(db.SystemSetting.Where(x => x.EventClass == Setting.EventClass).Select(x => x.Seq).First());
setting.AlertTimes = Setting.AlertTimes;
db.SaveChanges();
for (int k = 0; k < Setting.DetailSetting.Count; k++) {
int temp = Setting.DetailSetting[k].AlertEvent;
var qry = db.AlertDetailSetting.Where(x => x.EventClass == Setting.EventClass && x.AlertEvent == temp);
foreach (AlertDetailSetting o in qry) {
o.FirstTime = Setting.DetailSetting[k].FirstTime;
if (Setting.DetailSetting[k].Memo == null)
o.Memo = "";
else
o.Memo = Setting.DetailSetting[k].Memo;
o.SecondTime = Setting.DetailSetting[k].SecondTime;
o.Times = Setting.DetailSetting[k].Times;
}
db.SaveChanges();
}
ret = "true";
}
if (Setting.TimeSetting[0].isSysDefault) {
for (int k = 0; k < 7; k++) {
AlertTimeSetting aSetting = new AlertTimeSetting();
aSetting.EventClass = Setting.TimeSetting[k].EventClass;
aSetting.EndTime = Setting.TimeSetting[k].EndTime;
aSetting.EndTime2 = Setting.TimeSetting[k].EndTime2;
aSetting.EndTime3 = Setting.TimeSetting[k].EndTime3;
aSetting.isAlert = Setting.TimeSetting[k].isAlert;
aSetting.isSysDefault = false;
aSetting.StartTime = Setting.TimeSetting[k].StartTime;
aSetting.StartTime2 = Setting.TimeSetting[k].StartTime2;
aSetting.StartTime3 = Setting.TimeSetting[k].StartTime3;
aSetting.Week = Setting.TimeSetting[k].Week;
db.AlertTimeSetting.Add(aSetting);
db.SaveChanges();
}
ret = "true";
}
else {
var qry = db.AlertTimeSetting.Where(x => x.EventClass == Setting.EventClass);
foreach (AlertTimeSetting o in qry) {
o.StartTime = Setting.TimeSetting[0].StartTime;
o.StartTime2 = Setting.TimeSetting[0].StartTime2;
o.StartTime3 = Setting.TimeSetting[0].StartTime3;
o.EndTime = Setting.TimeSetting[0].EndTime;
o.EndTime2 = Setting.TimeSetting[0].EndTime2;
o.EndTime3 = Setting.TimeSetting[0].EndTime3;
o.isAlert = Setting.TimeSetting[o.Week - 1].isAlert;
}
db.SaveChanges();
ret = "true";
}
var qry2 = db.AlertHolidaySetting.Where(x => x.EventClass == Setting.EventClass);
foreach (AlertHolidaySetting o in qry2) {
db.AlertHolidaySetting.Remove(o);
}
db.SaveChanges();
for (int k = 0; k < Setting.HolidaySetting.Count; k++) {
AlertHolidaySetting hSetting = new AlertHolidaySetting();
hSetting.EventClass = Setting.EventClass;
hSetting.EndDate = Setting.HolidaySetting[k].EndDate.Date.AddHours(23).AddMinutes(59);
hSetting.isSysDefault = false;
hSetting.StartDate = Setting.HolidaySetting[k].StartDate.Date;
hSetting.isAlert = Setting.HolidaySetting[k].isAlert;
db.AlertHolidaySetting.Add(hSetting);
db.SaveChanges();
}
}
}
catch
{
ret = "false";
}
return ret;
}
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;
}
