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