public static void SetSettingValue(string ns, string key, string value)
{
using (var context = new BusProjectEntities())
{
var entity =
context.tblSystems.FirstOrDefault(
z => z.strNamespace.ToLower() == ns.ToLower() && z.strKey.ToLower() == key.ToLower());
if (entity != null)
{
entity.strValue = value;
entity.LastModify = DateTime.UtcNow;
if (AccountManager.LoginInfo != null)
{
entity.ModifedBy = AccountManager.LoginInfo.UserId;
}
}
else
{
entity = new tblSystem()
{
strNamespace = ns,
strKey = key,
strValue = value,
LastModify = DateTime.UtcNow
};
if (AccountManager.LoginInfo != null)
{
entity.ModifedBy = AccountManager.LoginInfo.UserId;
}
context.tblSystems.Add(entity);
}
context.SaveChanges();
}
}
public System_Data(int code, int equipment)
{
if (equipment == 0)
{
return;
}
tblSystem tbls = new tblSystem
{
equipment_code = equipment,
system_code = code
};
db.tblSystems.InsertOnSubmit(tbls);
db.SubmitChanges();
}
public static SelectList systemList()
{
List <SelectListItem> _system = new List <SelectListItem>();
tblSystem ts = new tblSystem();
List <systems> systemList = ts.getAll().ToList();
foreach (systems rec in systemList)
{
_system.Add(new SelectListItem()
{
Text = rec.systemName,
Value = rec.systemId.ToString()
});
}
return(new SelectList(_system, "Value", "Text", null));
}
protected void lbtnSubmitNewSystem_Click(object sender, EventArgs e)
{
tblSystem system = new tblSystem();
if (db.tblSystems.Any(d => d.Title == txtNewSystemTitle.Text))
{
Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('" + txtNewSystemTitle.Text + " " + "already exists!" + "');", true);
}
else
{
system.Title = txtNewSystemTitle.Text;
db.tblSystems.Add(system);
db.SaveChanges();
Page.ClientScript.RegisterStartupScript(GetType(), "msgbox", "alert('Added successfully');", true);
txtNewSystemTitle.Text = "";
}
}
protected string querySystems(ref systemsViewModel viewModel)
{
string ret = "";
tblSystem ts = new tblSystem();
systemsViewModel tmpVM = viewModel;
var qry = (from a in ts.getAllDisp()
select a).AsQueryable();
if (!string.IsNullOrWhiteSpace(viewModel.projectId))
{
qry = qry.Where(x => x.projectId == new Guid(tmpVM.projectId));
}
if (!string.IsNullOrWhiteSpace(viewModel.systemName))
{
qry = qry.Where(x => x.systemName.Contains(tmpVM.systemName));
}
viewModel.systemList = qry.ToList();
return(ret);
}
protected string query(ref systemEntityViewModel viewModel)
{
string ret = "";
systemEntity tmpModel = viewModel.editModel;
tblSystem ts = new tblSystem(uow.GetDbContext());
var qry = (from a in uow.systemEntityRepository.GetAll()
join b in uow.systemTemplateRepository.GetAll()
on a.systemTemplateId equals b.systemTemplateId
into c
from d in c.DefaultIfEmpty()
join e in uow.systemEntityRepository.GetAll()
on a.parentEntityId equals e.systemEntityId
into f
from g in f.DefaultIfEmpty()
join h in ts.getAll()
on a.systemId equals h.systemId into i
from j in i.DefaultIfEmpty()
select new systemEntityDisp
{
systemEntityId = a.systemEntityId,
createtime = a.createtime,
entityName = a.entityName,
entityDescription = a.entityDescription,
systemTemplateId = a.systemTemplateId,
templateName = d.templateName,
parentEntityId = a.parentEntityId,
parentEntityName = g.entityName,
systemId = a.systemId,
systemName = j.systemName
}).AsQueryable();
if (!string.IsNullOrWhiteSpace(tmpModel.entityName))
{
qry = qry.Where(x => x.entityName.Contains(tmpModel.entityName));
}
if (!string.IsNullOrWhiteSpace(tmpModel.entityDescription))
{
qry = qry.Where(x => x.entityDescription.Contains(
tmpModel.entityDescription));
}
if (tmpModel.systemTemplateId != null &&
tmpModel.systemTemplateId != Guid.Empty)
{
qry = qry.Where(x => x.systemTemplateId == tmpModel.systemTemplateId);
}
if (tmpModel.parentEntityId != null &&
tmpModel.parentEntityId != Guid.Empty)
{
qry = qry.Where(x => x.parentEntityId == tmpModel.parentEntityId);
}
if (tmpModel.systemId != Guid.Empty &&
!string.IsNullOrWhiteSpace(tmpModel.systemId.ToString()))
{
qry = qry.Where(x => x.systemId == tmpModel.systemId);
}
if (qry.Any())
{
viewModel.queryResult = qry.ToList();
}
else
{
viewModel.queryResult = null;
}
return(ret);
}
public ActionResult Systems(systemsViewModel viewModel)
{
ActionResult ar;
var multiSelect = Request.Form["multiSelect"];
ViewBag.projectList = PMdropdownOption.projectList();
var projectId = Session["projectId"];
if (projectId == null)
{
return(RedirectToAction("Index", "Project"));
}
{
viewModel.projectId = projectId.ToString();
ViewBag.projectName = Session["projectName"] + "";
ViewBag.projectLock = true;
}
//else
viewModel.clearMsg();
tblSystem ts = new tblSystem();
systemEditViewModel tmpVM;
systems sys;
switch (viewModel.cmd)
{
case "query":
viewModel.errorMsg = querySystems(ref viewModel);
ar = View(viewModel);
break;
case "add":
tmpVM = new systemEditViewModel();
tmpVM.pageStatus = (int)PAGE_STATUS.ADD;
TempData["systemEditViewModel"] = tmpVM;
ar = RedirectToAction("AddUpdate");
return(ar);
case "update":
sys = ts.getById(viewModel.singleSelect);
if (sys != null)
{
tmpVM = new systemEditViewModel();
tmpVM.editModel = sys;
tmpVM.pageStatus = (int)PAGE_STATUS.EDIT;
TempData["systemEditViewModel"] = tmpVM;
ar = RedirectToAction("AddUpdate");
return(ar);
}
viewModel.errorMsg = "error reading this system";
ar = View(viewModel);
break;
case "entity":
sys = ts.getById(viewModel.singleSelect);
if (sys != null)
{
Session["systemId"] = sys.systemId.ToString();
Session["systemName"] = sys.systemName + "";
ar = RedirectToAction("Index", "SystemEntity");
return(ar);
}
viewModel.errorMsg = "error reading this system";
ar = View(viewModel);
break;
case "delete":
//undone !!... (3) delete project delete article also
if (string.IsNullOrWhiteSpace(multiSelect))
{
viewModel.errorMsg = "please select system to delete";
}
else
{
string[] selected = multiSelect.Split(',');
foreach (string systemId in selected.ToList())
{
viewModel.errorMsg += ts.Delete(systemId);
}
viewModel.errorMsg += ts.SaveChanges();
if (string.IsNullOrWhiteSpace(viewModel.errorMsg))
{
viewModel.successMsg = "successfully deleted";
viewModel.errorMsg =
querySystems(ref viewModel);
}
}
//viewModel.errorMsg = querySystems(ref viewModel);
ar = View(viewModel);
break;
default:
ar = View(viewModel);
break;
}
return(ar);
}
public ActionResult AddUpdate(systemEditViewModel viewModel)
{
ActionResult ar;
var projectId = Session["projectId"];
if (projectId != null)
{
viewModel.editModel.projectId = new Guid(projectId.ToString());
ViewBag.projectName = Session["projectName"] + "";
ViewBag.projectLock = true;
}
else
{
return(RedirectToAction("Index", "Project"));
}
ViewBag.projectList = PMdropdownOption.projectList();
// two combo system type, system group
ViewBag.systemTypeList = SDdropdownOptions.systemTypeList();
ViewBag.systemGroupList = SDdropdownOptions.systemGroupList();
string err;
viewModel.clearMsg();
switch (viewModel.cmd)
{
case "save":
err = checkForm(viewModel);
if (err.Length > 0)
{
viewModel.errorMsg = err;
ar = View(viewModel);
break;
}
tblSystem ts = new tblSystem();
if (viewModel.pageStatus == (int)PAGE_STATUS.ADD)
{
viewModel.editModel.systemId = Guid.NewGuid();
viewModel.editModel.createtime = DateTime.Now;
viewModel.editModel.systemArticleId = Guid.NewGuid();
using (var trans = ts.BeginTransaction())
{
err += ts.Add(viewModel.editModel);
err += ts.SaveChanges();
err += addSystemArticle(viewModel,
ts.GetDbContext());
if (err.Length > 0)
{
trans.Rollback();
}
else
{
trans.Commit();
}
}
if (err.Length == 0)
{
viewModel.successMsg = "new system saved";
viewModel.pageStatus = (int)PAGE_STATUS.ADDSAVED;
}
else
{
viewModel.errorMsg = err;
}
}
else if (viewModel.pageStatus == (int)PAGE_STATUS.EDIT)
{
err += ts.Update(viewModel.editModel);
err += ts.SaveChanges();
if (err.Length == 0)
{
viewModel.successMsg = "system updated";
viewModel.pageStatus = (int)PAGE_STATUS.SAVED;
}
else
{
viewModel.errorMsg = err;
}
}
else
{
viewModel.errorMsg = "wrong page status " + viewModel.pageStatus;
}
ar = View(viewModel);
break;
case "addNew":
systemEditViewModel tmpVM = new systemEditViewModel();
tmpVM.pageStatus = (int)PAGE_STATUS.ADD;
TempData["systemEditViewModel"] = tmpVM;
ar = RedirectToAction("AddUpdate");
return(ar);
case "query":
ar = RedirectToAction("Systems");
return(ar);
default:
ar = View(viewModel);
break;
}
return(ar);
}
