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