public void InsertLog(string userId)
{
try
{
_billCollDataContext = new BillCollDataContext();
TraceLog trLog = new TraceLog();
trLog.UserId = int.Parse(userId);
trLog.LoginTime = DateTime.Now;
_billCollDataContext.TraceLogs.InsertOnSubmit(trLog);
User user = _billCollDataContext.Users.Single(u => u.UserId == int.Parse(userId));
user.isLoggedIn = true;
_billCollDataContext.SubmitChanges();
//if (_connectionString.Equals(string.Empty) != true)
//{
//_databaseManager.OpenDatabaseConnection();
//string sqlCommand = " INSERT INTO TraceLog (UserId,LoginTime) VALUES ("+userId+",GETDATE())";
//_databaseManager.ExcecuteCommand(sqlCommand);
//sqlCommand = " Update Users set isLoggedIn=1 where UserId="+userId;
//_databaseManager.ExcecuteCommand(sqlCommand);
//}
}
catch (Exception exception)
{
throw exception;
}
finally
{
//_databaseManager.CloseDatabaseConnection();
}
}
public bool UpdateLog(string userId)
{
try
{
int logId = (from trLogs in _billCollDataContext.TraceLogs
where trLogs.UserId == int.Parse(userId)
select trLogs.LogId).Max();
TraceLog trLog = _billCollDataContext.TraceLogs.Single(t => t.LogId == logId);
trLog.LogoutTime = DateTime.Now;
_billCollDataContext.SubmitChanges();
return(true);
//if(_connectionString.Equals(string.Empty)!=true)
//{
// _databaseManager.OpenDatabaseConnection();
// string sqlQuerey="select MAX(LogId) from TraceLog where userId="+userId;
// string logId=_databaseManager.GetSingleString(sqlQuerey);
// string sqlCommand = " Update TraceLog set LogoutTime =GETDATE() where LogId="+logId;
// _databaseManager.ExcecuteCommand(sqlCommand);
// sqlCommand = " Update Users set isLoggedIn=0 where UserId="+userId;
// _databaseManager.ExcecuteCommand(sqlCommand);
// return true;
//}
}catch (Exception exception)
{
throw exception;
}
finally
{
//_databaseManager.CloseDatabaseConnection();
}
return(false);
}
public void CreteNewUser(User user)
{
try
{
_databaseManager.SetConnectionString = _connectionString;
_databaseManager.OpenDatabaseConnection();
user.Password = encryptionDecriptionManager.ComputeHash(user.Password, new byte[user.Password.Length]);
_billCollDataContext = new BillCollDataContext();
_billCollDataContext.Users.InsertOnSubmit(user);
_billCollDataContext.SubmitChanges();
}
catch (Exception exception)
{
throw exception;
}
finally
{
_databaseManager.CloseDatabaseConnection();
}
}
public void ChangePassword(string userId, string oldPassword, string newPassword)
{
try
{
_billCollDataContext = new BillCollDataContext();
if (!_connectionString.Equals(String.Empty))
{
newPassword = encryptionDecriptionManager.ComputeHash(newPassword, new byte[newPassword.Length]);
oldPassword = encryptionDecriptionManager.ComputeHash(oldPassword, new byte[oldPassword.Length]);
//List<User> listUser = (from user in _billCollDataContext.Users
// where user.LoginName == userId && user.Password == oldPassword
// select user).ToList();
var user = _billCollDataContext.Users.Single(u => u.LoginName == userId && u.Password == oldPassword);
user.Password = newPassword;
_billCollDataContext.SubmitChanges();
}
}
catch (Exception exception)
{
throw exception;
}
}
