private bool AuthenticateUser(string userName, string password, string browser, string deviceType)
{
_browser = browser;
_deviceType = deviceType;
if (userName == null)
{
return(false);
}
using (WitServiceDBContext db = new WitServiceDBContext())
{
var user = db.AspNetUsers.Where(m => m.UserName == userName.ToString()).FirstOrDefault();
if (user != null && !String.IsNullOrEmpty(password))
{
bool authenticatePassword = Wit_Cryptography.VerifyHashedPassword(user.PasswordHash, password);
if (authenticatePassword)
{
InitializeCompanyUID(user.Id);
GenerateSession(user.Id);
return(true);
}
}
LogMsg("Wrong Username/Password");
return(false);
}
}
internal bool AuthenticateSession(string sessionUID)
{
if (!Wit_Commons.IsStringGUID(sessionUID))
{
LogMsg("Invalid Session");
return(false);
}
using (WitServiceDBContext db = new WitServiceDBContext())
{
var _getSession = (from col in db.Wit_Session
where col.Session_UID == new Guid(sessionUID)
select new { Session_UID = col.Session_UID, UserUID = col.User_UID }).ToList();
if (_getSession.Count == 0)
{
LogMsg("Invalid session.");
return(false);
}
else
{
InitializeSession(_getSession[0].Session_UID, _getSession[0].UserUID.ToString());
}
}
return(true);
}
private void GetTables(string companyUID)
{
using (WitServiceDBContext db = new WitServiceDBContext())
{
var tables = db.Wit_Table.Where(m => m.Company_UID == new Guid(companyUID)).ToList();
Tables = tables;
}
}
private void InitializeCompanyUID(string UserUID)
{
using (WitServiceDBContext db = new WitServiceDBContext())
{
var _comp = (from col in db.Wit_User
where col.User_UID == new Guid(UserUID)
select new { CompanyUID = col.Company_UID }).FirstOrDefault();
_companyUID = _comp.CompanyUID.ToString();
}
}
internal int TerminateSessionID(string sessionID)
{
int rowsAffected = 0;
using (WitServiceDBContext db = new WitServiceDBContext())
{
string _sql;
_sql = string.Format("DELETE FROM Wit_Session WHERE Session_UID = '{0}'", sessionID);
rowsAffected = db.Database.ExecuteSqlCommand(_sql);
return(rowsAffected);
}
}
private void GetCategories(string companyUID)
{
using (WitServiceDBContext db = new WitServiceDBContext())
{
db.Configuration.LazyLoadingEnabled = true;
db.Configuration.ProxyCreationEnabled = true;
var cat = db.Wit_Category.Where(m => m.Company_UID == new Guid(companyUID)).ToList();
foreach (Wit_Category category in cat)
{
Categories.Add(Wit_Category.ToSerializable(category));
AddItem(category);
}
}
}
internal void GenerateSession(string userUID)
{
using (WitServiceDBContext db = new WitServiceDBContext())
{
Wit_Session session = new Wit_Session {
User_UID = new Guid(userUID), Browser = _browser,
DeviceType = _deviceType, IP = _iP,
Location = _location
};
db.Wit_Session.Add(session);
db.SaveChanges();
InitializeSession(session.Session_UID, userUID);
}
}
