public long SaveUser(ClsUser objSave)
{
try
{
long UserId = 0;
using (TransactionScope scope = new TransactionScope())
{
using (this.objDataContext = new UserDataContext(Functions.StrConnection))
{
objSave.strPassword = objSave.strPassword.EncryptString();
var result = this.objDataContext.InsertOrUpdateUser(objSave.lgId, 1, objSave.strFirstName, objSave.strSurName, objSave.strMobileNo, objSave.strEmailID, objSave.strUserName, objSave.strPassword, objSave.strAddress, "EMP/12345", objSave.lgRoleId, objSave.blIsActive, objSave.blIsLogin, mySession.Current.UserId, PageMaster.User, objSave.lgAdminUserId, objSave.intSessionDurationHour, objSave.intUnsuccessfulLoginAttempt, objSave.intPasswordExpirationCount).FirstOrDefault();
if (result != null)
{
UserId = result.InsertedId;
this.objDataContext.InsertOrUpdateUserTrackerPermissions(0, UserId, objSave.blTripStartDate, objSave.blTripEndDate, objSave.blLocationStart, objSave.blLocationEnd, objSave.blTripReasonName, objSave.blReasonRemarks, objSave.blKmStart, objSave.blKmEnd, objSave.blKmDriven, objSave.blFuelStart, objSave.blFuelEnd, objSave.blUsername, objSave.blEntryDatetime, objSave.blEntryMethod, objSave.blEditable, objSave.blActive, objSave.blCompanyName, objSave.blEditColumn, objSave.blDeleteColumn, mySession.Current.UserId);
}
scope.Complete();
}
return(UserId);
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId);
return(0);
}
}
public ClsUser GetUserByEmailId(string strEmailId)
{
ClsUser objClsUser = new ClsUser();
try
{
using (this.objDataContext = new UserDataContext(Functions.StrConnection))
{
GetUserByEmailIdResult item = this.objDataContext.GetUserByEmailId(strEmailId).FirstOrDefault();
if (item != null)
{
objClsUser.lgId = item.Id;
objClsUser.strEmailID = item.EmailID;
objClsUser.strFirstName = item.FirstName;
objClsUser.strSurName = item.SurName;
objClsUser.strMobileNo = item.MobileNo;
objClsUser.strPassword = item.Password;
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId);
}
return(objClsUser);
}
public ClsUser ChangePassword(long lgUserId, string strUserPwd)
{
ClsUser objUserMaster = new ClsUser();
try
{
objUserMaster = this.GetUserByUserId(lgUserId);
if (objUserMaster != null)
{
objUserMaster.strPassword = strUserPwd;
}
this.SaveUser(objUserMaster);
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId);
}
return(objUserMaster);
}
public ClsUser GetUserByUserId(long lgUserId)
{
ClsUser objClsUser = new ClsUser();
try
{
using (this.objDataContext = new UserDataContext(Functions.StrConnection))
{
GetUserByIdResult item = this.objDataContext.GetUserById(lgUserId).FirstOrDefault();
if (item != null)
{
objClsUser.lgId = item.Id;
objClsUser.strFirstName = item.FirstName;
objClsUser.strSurName = item.SurName;
objClsUser.strMobileNo = item.MobileNo;
objClsUser.strEmailID = item.EmailID;
objClsUser.strUserName = item.UserName;
objClsUser.strPassword = item.Password.DecryptString();
objClsUser.strConfirmPassword = item.Password.DecryptString();
objClsUser.strAddress = item.Address;
objClsUser.lgRoleId = item.RoleId;
objClsUser.lgBranchId = item.BranchId;
objClsUser.strBranchName = item.UserBranchName;
objClsUser.blIsActive = item.IsActive;
objClsUser.blIsLogin = item.IsLogin;
objClsUser.strEmployeeCode = item.EmployeeCode;
objClsUser.lgVehicleDistributeId = item.VehicleDistributeId ?? 0;
objClsUser.lgAdminUserId = item.AssignBy;
objClsUser.intSessionDurationHour = item.SessionDurationHour;
objClsUser.intUnsuccessfulLoginAttempt = item.UnsuccessfulLoginAttempt;
objClsUser.intPasswordExpirationCount = item.PasswordExpirationCount;
}
}
}
catch (Exception ex)
{
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId);
}
return(objClsUser);
}
public ClsUser ValidateLogin(string strUserName, string strPassword)
{
try
{
using (this.objDataContext = new UserDataContext(Functions.StrConnection))
{
User objUser = this.objDataContext.Users.Where(n => n.UserName == strUserName && n.Password == strPassword && n.IsActive == true).FirstOrDefault();
if (objUser != null)
{
ClsUser objClsUser = new ClsUser();
objClsUser.lgId = objUser.Id;
objClsUser.lgBranchId = objUser.BranchId;
objClsUser.strFirstName = objUser.FirstName;
objClsUser.strSurName = objUser.SurName;
objClsUser.strMobileNo = objUser.MobileNo;
objClsUser.strEmailID = objUser.EmailID;
objClsUser.strUserName = objUser.UserName;
objClsUser.strPassword = objUser.Password.DecryptString();
objClsUser.strAddress = objUser.Address;
objClsUser.lgRoleId = objUser.RoleId;
objClsUser.blIsActive = objUser.IsActive;
objClsUser.blIsLogin = objUser.IsLogin;
objClsUser.strEmployeeCode = objUser.EmployeeCode;
objClsUser.lgAdminUserId = objUser.AssignBy;
objClsUser.intSessionDurationHour = objUser.SessionDurationHour;
objClsUser.dtPasswordExpireOn = objUser.PasswordExpireOn;
objClsUser.intUnsuccessfulLoginAttempt = objUser.UnsuccessfulLoginAttempt;
return(objClsUser);
}
return(null);
}
}
catch (Exception ex)
{
throw ex;
Functions.Write(ex, System.Reflection.MethodBase.GetCurrentMethod().Name, PageMaster.User, mySession.Current.UserId);
return(null);
}
}
