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