public bool deleteStatusReport(Models.StatusReport s) { try { Models.DataBaseTableClassesDataContext db = new Models.DataBaseTableClassesDataContext(); if (s.StatusReportID != null) { Models.StatusReport Snew = null; var query = from Sr in db.StatusReports where Sr.StatusReportID == s.StatusReportID select Sr; /*Linq Queries Return An Ienumerable Collection Like a list<> SO the use of a foreach loop eventhough there will be only one or 0 status report.*/ foreach (var q in query) { Snew = q; } if (Snew != null) { db.StatusReports.DeleteOnSubmit(Snew); db.SubmitChanges(); } } return true; } catch (Exception ex) { return false; } }
public bool createStatusReports(Models.StatusReport s) { try { Models.DataBaseTableClassesDataContext db = new Models.DataBaseTableClassesDataContext(); db.StatusReports.InsertOnSubmit(s); db.SubmitChanges(); return true; } catch (Exception ex) { return false; } }
public StatusReportModel() { StR = new List<StatusReport>(); db = new DataBaseTableClassesDataContext(); WpList = new List<SelectListItem>(); foreach (StatusReport s in db.StatusReports) { StR.Add(s); } foreach (WorkPackageDescription w in db.WorkPackageDescriptions) { WpList.Add(new SelectListItem { Text = w.Wp_Title, Value = w.Wp_Id.ToString() }); } }
public SoftwareReqtsModel() { Sr = new List<Software_Requirement>(); db = new DataBaseTableClassesDataContext(); Pids=new List<SelectListItem>(); Wp_unused = new List<SelectListItem>(); Wp_used = new List<SelectListItem>(); foreach (Software_Requirement sr in db.Software_Requirements) { Sr.Add(sr); } foreach (Project p in db.Projects) { Pids.Add(new SelectListItem { Text = p.ProjectName, Value = p.ProjectID.ToString()}); } }
public ProjectModel() { ProjectList = new List<Project>(); StatusList = new List<SelectListItem>(); ManagerList = new List<SelectListItem>(); db = new DataBaseTableClassesDataContext(); foreach (Project p in db.Projects) { ProjectList.Add(p); } foreach (ProjectStatus Ps in db.ProjectStatus) { StatusList.Add(new SelectListItem { Text = Ps.StatusValue, Value = Ps.ProjectStatusID.ToString() }); } foreach (Employee e in db.Employees) { ManagerList.Add(new SelectListItem{Text=e.Fname + " " + e.Lname,Value=e.EmpId.ToString()}); } }
public ActionResult Register(RegisterModel model) { if (ModelState.IsValid) { // Attempt to register the user MembershipCreateStatus createStatus = MembershipService.CreateUser(model.UserName, model.Password, model.Email); if (createStatus == MembershipCreateStatus.Success) { FormsService.SignIn(model.UserName, false /* createPersistentCookie */); DataBaseTableClassesDataContext db = new DataBaseTableClassesDataContext(); Employee e = new Employee(); e.Fname = model.UserName; db.Employees.InsertOnSubmit(e); db.SubmitChanges(); return RedirectToAction("Index", "Home"); } else { ModelState.AddModelError("", AccountValidation.ErrorCodeToString(createStatus)); } } // If we got this far, something failed, redisplay form ViewData["PasswordLength"] = MembershipService.MinPasswordLength; return View(model); }
public GridModel() { Bugs=new List<BugReport>(); db = new DataBaseTableClassesDataContext(); ProjectList = new List<SelectListItem>(); EmpList = new List<SelectListItem>(); ReqList = new List<SelectListItem>(); foreach (Project p in db.Projects) { ProjectList.Add(new SelectListItem { Text = p.ProjectName, Value = p.ProjectName }); } foreach (Employee e in db.Employees) { EmpList.Add(new SelectListItem { Text = e.Fname + " " + e.Lname, Value = e.Fname + " " + e.Lname }); } foreach (Software_Requirement SR in db.Software_Requirements) { ReqList.Add(new SelectListItem { Text = SR.Sr_Title, Value = SR.Sr_Title }); } xmlFilepath = HttpContext.Current.Server.MapPath("~\\App_Data\\Lab07.xml"); Fill(xmlFilepath); }