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