public LoginResponse LoginUser(string username, string password)
{
CRySTALDataConnections.CRySTALDataSet.UsersDataTable usrs;
CRySTALDataConnections.CRySTALDataSet.RolesDataTable roles;
CRySTALDataConnections.CRySTALDataSet.SessionsDataTable sessions;
CRySTALDataConnections.CRySTALDataSetTableAdapters.UsersTableAdapter uta = new CRySTALDataConnections.CRySTALDataSetTableAdapters.UsersTableAdapter();
CRySTALDataConnections.CRySTALDataSetTableAdapters.RolesTableAdapter rta = new CRySTALDataConnections.CRySTALDataSetTableAdapters.RolesTableAdapter();
CRySTALDataConnections.CRySTALDataSetTableAdapters.SessionsTableAdapter sta = new CRySTALDataConnections.CRySTALDataSetTableAdapters.SessionsTableAdapter();
usrs = uta.GetDataByUnPass(username, password);
LoginResponse resp = new LoginResponse();
resp.LoginSuccess = false;
if (usrs.Rows.Count > 0)
{
roles = rta.GetDataByUserID((int)usrs.Rows[0].ItemArray[0]);
Guid g = Guid.NewGuid();
resp.LoginSuccess = true;
resp.Roles = new List<string>();
resp.SessionID = g.ToString();
foreach (CRySTALDataConnections.CRySTALDataSet.RolesRow role in roles.Rows)
{
resp.Roles.Add(role.Role);
}
sta.InsertLoginEvent(g, (int)usrs.Rows[0].ItemArray[0], DateTime.Now);
}
return resp;
}
public static int getEmployeeID(string sessionID)
{
CRySTALDataConnections.CRySTALDataSetTableAdapters.SessionsTableAdapter sta = new CRySTALDataConnections.CRySTALDataSetTableAdapters.SessionsTableAdapter();
CRySTALDataConnections.CRySTALDataSet.SessionsDataTable sdt;
sdt = sta.GetDataBySessionID(new Guid(sessionID));
if (sdt.Rows.Count == 0) return 0;
return sdt.First().UserID;
}
