public bool Create(AssignSettingViewModel assignSettingViewModel)
{
bool ret = false;
try
{
DefaultAssignSetting defaultAssignSetting = new DefaultAssignSetting();
defaultAssignSetting.AreaID = assignSettingViewModel.AreaID;
if (assignSettingViewModel.EventClass == "" || assignSettingViewModel.EventClass == null)
defaultAssignSetting.isSysDefault = true;
else {
defaultAssignSetting.isSysDefault = false;
defaultAssignSetting.EventClass = assignSettingViewModel.EventClass;
}
defaultAssignSetting.AreaID = assignSettingViewModel.AreaID;
defaultAssignSetting.ResponsibleClassID = assignSettingViewModel.ResponsibleID;
db.DefaultAssignSetting.Add(defaultAssignSetting);
db.SaveChanges();
ret = true;
}
catch
{
}
return ret;
}
public IQueryable<AssignSettingViewModel> Read(String EventClass)
{
List<AssignSettingViewModel> ret = new List<AssignSettingViewModel>();
var qry = db.DefaultAssignSetting.Where(x => x.Seq != 0);
if (EventClass == "" || EventClass == null)
qry = qry.Where(x => x.isSysDefault == true);
else
qry = qry.Where(x => x.EventClass == EventClass);
foreach (DefaultAssignSetting o in qry)
{
AssignSettingViewModel e = new AssignSettingViewModel();
e.Seq = o.Seq;
e.AreaID = o.AreaID;
e.AreaStr = o.Area.Name;
e.EventClass = o.EventClass;
e.isSysDefault = o.isSysDefault;
e.ResponsibleID = o.ResponsibleClassID;
e.ResponsibleStr = o.ResponsibleClass.Name + "-" + o.ResponsibleClass.UserData2.UserName;
ret.Add(e);
}
return ret.AsQueryable();
}
public Boolean CheckedUsed(AssignSettingViewModel assignSettingViewModel) {
if (assignSettingViewModel.EventClass == null || assignSettingViewModel.EventClass == "")
{
if (db.DefaultAssignSetting.Where(x => x.AreaID == assignSettingViewModel.AreaID && x.isSysDefault == true).Count() > 0)
return false;
}
else
{
if (db.DefaultAssignSetting.Where(x => x.AreaID == assignSettingViewModel.AreaID && x.EventClass == assignSettingViewModel.EventClass).Count() > 0)
return false;
}
return true;
}
public bool Delete(AssignSettingViewModel assignSettingViewModel)
{
bool ret = false;
try
{
DefaultAssignSetting d = db.DefaultAssignSetting.Find(assignSettingViewModel.Seq);
db.DefaultAssignSetting.Remove(d);
db.SaveChanges();
ret = true;
}
catch
{
}
return ret;
}
public bool Update(AssignSettingViewModel assignSettingViewModel)
{
bool ret = false;
try
{
DefaultAssignSetting d = db.DefaultAssignSetting.Find(assignSettingViewModel.Seq);
d.ResponsibleClassID = assignSettingViewModel.ResponsibleID;
db.SaveChanges();
ret = true;
}
catch
{
}
return ret;
}
