public bool UserDelete(long id)
{
if (!dbEntities.ETUsers.Where(x => x.UserID == 1).Any()) // Need to change
{
TempData["messagealert"] = Status.Delete;
Userval = new ETUser();
Userval = dbEntities.ETUsers.Where(x => x.UserID == id).SingleOrDefault();
if (User != null)
{
dbEntities.ETUsers.Remove(Userval);
dbEntities.SaveChanges();
return(true);
}
}
return(false);
//if (!dbEntities.TBL_ADMIN_USER.Where(x => x.ROLE_ID == id).Any())
//{
// TempData["messagealert"] = Status.Delete;
// role = new TBL_ROLE();
// role = dbEntities.TBL_ROLE.Where(x => x.ROLE_ID == id && x.ROLE_NAME != "superadmin").SingleOrDefault();
// if (role != null)
// {
// dbEntities.TBL_ROLE.Remove(role);
// dbEntities.SaveChanges();
// return true;
// }
//}
//return false;
}
public ActionResult Profiles()
{
ViewBag.messagealert = string.Empty;
long userId = Convert.ToInt64(Session["UserID"]);
UserVal = new ETUser();
UserVal = repUsers.GetUser(userId);
ViewBag.UserTitles = repUsers.getDataValues("Title", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Gender = repUsers.getDataValues("Gender", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.MaritalStatus = repUsers.getDataValues("MaritalStatus", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.DeviceType = repUsers.getDataValues("DeviceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
return(View(UserVal));
}
public bool UserUpdateStatus(bool status, long Userid)
{
Userval = new ETUser();
Userval = repUsers.GetUser(Userid);
if (Userval != null)
{
//try
//{
Userval.ConfirmPassword = Userval.Password;
if (status)
{
Userval.IsActive = false;
Userval.ModifiedBy = Convert.ToInt64(Session["UserID"]);
Userval.ModifiedDate = DateTime.Now;
}
else
{
Userval.IsActive = true;
Userval.ModifiedBy = Convert.ToInt64(Session["UserID"]);
Userval.ModifiedDate = DateTime.Now;
}
dbEntities.Entry(Userval).State = EntityState.Modified;
dbEntities.SaveChanges();
//}
//catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
//{
// Exception raise = dbEx;
// foreach (var validationErrors in dbEx.EntityValidationErrors)
// {
// foreach (var validationError in validationErrors.ValidationErrors)
// {
// string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// // raise a new exception nesting
// // the current instance as InnerException
// raise = new InvalidOperationException(message, raise);
// }
// }
// throw raise;
//}
return(true);
}
return(false);
}
public bool OtpUpdateStatus(long Userid, long Otp)
{
Userval = new ETUser();
Userval = repUsers.GetUser(Userid);
if (Userval != null)
{
Userval.ConfirmPassword = Userval.Password;
Userval.Otp = Otp.ToString();
Userval.ModifiedBy = Convert.ToInt64(Session["UserID"]);
Userval.ModifiedDate = DateTime.Now;
dbEntities.Entry(Userval).State = EntityState.Modified;
dbEntities.SaveChanges();
return(true);
}
return(false);
}
public bool OtpUpdateStatus(long Userid, long Otp, string DeviceType)
{
UserVal = new ETUser();
UserVal = repUsers.GetUser(Userid);
if (UserVal != null)
{
UserVal.ConfirmPassword = UserVal.Password;
UserVal.Otp = Otp.ToString();
UserVal.OtpReceivedDate = DateTime.Now.AddMinutes(Convert.ToInt64(ConfigurationSettings.AppSettings["OtpValidTime"]));
UserVal.OtpReceivedDevice = DeviceType;
UserVal.ModifiedBy = Convert.ToInt64(Session["UserID"]);
UserVal.ModifiedDate = DateTime.Now;
dbEntities.Entry(UserVal).State = EntityState.Modified;
dbEntities.SaveChanges();
return(true);
}
return(false);
}
public string OtpStatusVerify(long UserId, string Otp, string DeviceType)
{
UserVal = new ETUser();
UserVal = dbEntities.ETUsers.Where(x => x.UserID == UserId && x.Otp.ToString().Trim().Equals(Otp.Trim()) && x.IsActive == true).SingleOrDefault();
if (UserVal != null)
{
if (UserVal.OtpReceivedDevice != DeviceType)
{
return("Device");
}
else if (!(UserVal.OtpReceivedDate > DateTime.Now))
{
return("Otp");
}
else
{
return("Valid");
}
}
return("Invalid");
}
public ActionResult PasswordChange(PasswordChange updateUser)
{
TempData["messagealert"] = string.Empty;
var errors = ModelState.Values.SelectMany(v => v.Errors);
if (ModelState.IsValid)
{
long userId = Convert.ToInt64(Session["UserID"]);
UserVal = new ETUser();
UserVal = repUsers.GetUserForPasswordChange(userId);
if (!repUsers.GetUserPasswordExits(userId, Common.EncryptPassword(updateUser.OldPassword)))
{
ViewBag.messagealert = "Please check your Old Password";
return(View(updateUser));
}
else if (!updateUser.NewPassword.Equals(updateUser.ConfirmPassword))
{
ViewBag.messagealert = "Please New and confirm password not match";
return(View(updateUser));
}
else
{
UserVal.Password = Common.EncryptPassword(updateUser.NewPassword);
UserVal.ConfirmPassword = Common.EncryptPassword(updateUser.ConfirmPassword);
UserVal.ModifiedBy = Convert.ToInt64(Session["UserID"]);
UserVal.ModifiedDate = DateTime.Now;
dbEntities.Entry(UserVal).State = EntityState.Modified;
dbEntities.SaveChanges();
//bool mail = mailing.PasswordChanged(updateuser.EMAIL_ID, updateuser.NAME, "Your Password Changed", updateuser.LOGIN_NAME, "password");
if (UserVal.UserID != 0)
{
TempData["messagealert"] = Status.Update;
}
}
return(RedirectToAction("Logout", "Login"));
}
return(View());
}
public string ForgotPassword(string mailId)
{
UserVal = new ETUser();
UserVal = dbEntities.ETUsers.Where(x => x.Email == mailId || x.LoginName == mailId).SingleOrDefault();
if (UserVal != null)
{
//user.IS_CREATED = false;
//user.RANDOM_ID = user.RANDOM_ID + 1;
//dbEntities.SaveChanges();
//bool isMailsent = mailing.AdminCreatePassword(user.Email, user.FirstName, repcommon.EncryptPassword(user.ADMIN_USER_ID.ToString()), repcommon.EncryptPassword(user.RANDOM_ID.ToString()), user.LoginName);
//if (isMailsent)
//{
// return "success";
//}
}
else
{
return("notexist");
}
return("failed");
}
public ActionResult User_edit(long Id)
{
ViewBag.messagealert = string.Empty;
Userval = new ETUser();
Userval = repUsers.GetUser(Id);
Userval.Password = Common.DecryptPassword(Userval.Password);
ViewBag.UserTitles = repUsers.getDataValues("Title", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
//repUsers.getTitle("Title", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Gender = repUsers.getDataValues("Gender", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.MaritalStatus = repUsers.getDataValues("MaritalStatus", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.UserLevel = repUsers.getDataValues("UserLevel", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.ReportingUser = repUsers.getMappedReportingUser();
ViewBag.DeviceType = repUsers.getDataValues("DeviceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Role = repUsers.getRole();
//ViewBag.ReportingUserID = Userval.ReportingUser;
//ViewBag.UserLevelID = Userval.UserLevel;
//ViewBag.RoleID = Userval.RoleID;
//ViewBag.MaritalStatusID = Userval.MaritalStatus;
//ViewBag.GenderID = Userval.Gender;
//ViewBag.TitleID = Userval.Title;
return(View(Userval));
}
public ActionResult Profiles(ProfileChange updateUser)
{
TempData["messagealert"] = string.Empty;
var errors = ModelState.Values.SelectMany(v => v.Errors);
if (ModelState.IsValid)
{
long userId = Convert.ToInt64(Session["UserID"]);
UserVal = new ETUser();
UserVal = repUsers.GetUser(userId);
if (repUsers.LogInNameIsExist(updateUser.LoginName, userId))
{
ViewBag.messagealert = "LogInName already exist";
ViewBag.UserTitles = repUsers.getDataValues("Title", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Gender = repUsers.getDataValues("Gender", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.MaritalStatus = repUsers.getDataValues("MaritalStatus", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.DeviceType = repUsers.getDataValues("DeviceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
return(View(UserVal));
}
else if (repUsers.EmailIsExist(updateUser.Email, userId) || !Common.IsValidEmail(updateUser.Email))
{
if (!Common.IsValidEmail(updateUser.Email))
{
ViewBag.messagealert = "Please Enter Valid Email";
}
else
{
ViewBag.messagealert = "Email already exist";
}
ViewBag.UserTitles = repUsers.getDataValues("Title", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Gender = repUsers.getDataValues("Gender", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.MaritalStatus = repUsers.getDataValues("MaritalStatus", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.DeviceType = repUsers.getDataValues("DeviceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
return(View(UserVal));
}
else if (repUsers.PhoneIsExist(updateUser.Phone, userId))
{
ViewBag.messagealert = "Phone already exist";
ViewBag.UserTitles = repUsers.getDataValues("Title", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Gender = repUsers.getDataValues("Gender", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.MaritalStatus = repUsers.getDataValues("MaritalStatus", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.DeviceType = repUsers.getDataValues("DeviceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
return(View(UserVal));
}
else
{
//try
//{
UserVal.Title = updateUser.Title;
UserVal.FirstName = updateUser.FirstName;
UserVal.MiddleName = updateUser.MiddleName;
UserVal.LastName = updateUser.LastName;
UserVal.Email = updateUser.Email;
UserVal.Phone = updateUser.Phone;
UserVal.Gender = updateUser.Gender;
UserVal.MaritalStatus = updateUser.MaritalStatus;
UserVal.DOB = updateUser.DOB;
UserVal.Address = updateUser.Address;
UserVal.LoginName = updateUser.LoginName;
//UserVal.Password = UserVal.Password;
UserVal.ConfirmPassword = UserVal.Password;
//UserVal.UserLevel = UserVal.UserLevel;
UserVal.IsTwoFactor = updateUser.IsTwoFactor;
UserVal.DeviceID = updateUser.DeviceID;
UserVal.DeviceType = updateUser.DeviceType;
UserVal.UserField1 = updateUser.UserField1;
UserVal.UserField2 = updateUser.UserField2;
UserVal.UserField3 = updateUser.UserField3;
UserVal.ModifiedBy = Convert.ToInt64(Session["UserID"]);
UserVal.ModifiedDate = DateTime.Now;
dbEntities.Entry(UserVal).State = EntityState.Modified;
dbEntities.SaveChanges();
if (UserVal.UserID != 0)
{
TempData["messagealert"] = Status.Update;
}
//}
//catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
//{
// Exception raise = dbEx;
// foreach (var validationErrors in dbEx.EntityValidationErrors)
// {
// foreach (var validationError in validationErrors.ValidationErrors)
// {
// string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// // raise a new exception nesting
// // the current instance as InnerException
// raise = new InvalidOperationException(message, raise);
// }
// }
// throw raise;
//}
}
return(RedirectToAction("Index", "Home"));
}
return(View());
}
public ActionResult Index(LoginDetail objLoginDetails)
{
if (objLoginDetails != null)
{
if (Common.IsValidEmail(objLoginDetails.Email))
{
objLoginDetails.GetTypes = "Email Id";
}
else
{
objLoginDetails.GetTypes = "Usename";
if (dbEntities.ETUsers.Any(x => x.LoginName == objLoginDetails.Email))
{
objLoginDetails.Email = dbEntities.ETUsers.Where(x => x.LoginName == objLoginDetails.Email).Select(x => x.Email).First();
}
}
//////List<long> CompanyId = new List<long>();
//////List<long> TeamId = new List<long>();
//////var data = dbEntities.ETUsers.Where(x => CompanyId.Contains(x.UserID) || TeamId.Contains(x.RoleID));
////////string strWhere = "UserID = 1";
////////IQueryable<ETUser> emp = dbEntities.ETUsers.Select<ETUser>(strWhere).AsQueryable();
////////DataTable dt = dbEntities.ETUsers.ToArray();
//////DataTable dt = new DataTable();
//////if (dt.Columns.Count == 0)
//////{
////// dt.Columns.Add("UserId");
////// dt.Columns.Add("Teams");
////// dt.Columns.Add("UserName");
////// dt.Columns.Add("City");
//////}
//////for (int i = 0; i < 10; i++)
//////{
////// dt.Rows.Add();
////// dt.Rows[i][0] = i;
////// dt.Rows[i][1] = "Microsoft" + (i + 1).ToString();
////// dt.Rows[i][2] = "Test" + (i + 1).ToString();
////// dt.Rows[i][3] = "Chennai" + (i + 1).ToString();
//////}
//////string condition = "UserId = 1 or Teams = 'Microsoft5' or UserName = '******'";
////////DataTable dtFilter = dt.Select(condition).CopyToDataTable();
//////var filter = dt.Select(condition);
////////var filters = dbEntities.ETUsers.Where(condition);
//////// dbEntities.ETUsers.Select(x => new {
//////// x.UserID, x.FirstName, x.LastName, x.Title, x.IsActive, x.IsTwoFactor, x.LoginName, x.MaritalStatus, x.Otp,
//////// x.Phone, x.Email, x.UserLevel, x.RoleID
////////}).CopyToDataTable();
//////string input = "data";
//////var result = dbEntities.ETUsers.Where(x => x.UserID.ToString().Contains(input) || x.FirstName.Contains(input) || x.LastName.Contains(input)).ToList();
//////string FirstName = "Dinesh";
//////string LastName = "Viswa";
//////var result1 = dbEntities.ETUsers.Where(x => x.UserID.ToString().Contains(input)).ToList();
//////if (FirstName != "")
//////{
////// var result2 = dbEntities.ETUsers.Where(x => x.FirstName.ToString().Contains(FirstName)).ToList();
////// result1.Union(result2);
//////}
//////if (LastName != "")
//////{
////// var result2 = dbEntities.ETUsers.Where(x => x.LastName.ToString().Contains(LastName)).ToList();
////// result1.Union(result2);
//////}
LoginDetailCheck checkLogin = repUser.CheckLoginUser(objLoginDetails);
if (checkLogin.isSuccess)
{
ETUser loginDetails = checkLogin.loginDetails;
if (loginDetails != null)
{
List <long> MappedUser = new List <long>();
Session["UserID"] = loginDetails.UserID;
Session["UserName"] = loginDetails.FirstName + " " + loginDetails.MiddleName + " " + loginDetails.LastName;
Session["RoleID"] = loginDetails.RoleID;
Session["RoleName"] = null; //loginDetails.ETRole.RoleName;
Session["LoginName"] = loginDetails.LoginName; // New
Session["Email"] = loginDetails.Email;
Session["Phone"] = loginDetails.Phone;
Session["LastName"] = loginDetails.LastName;
Session["IsTwoFactor"] = loginDetails.IsTwoFactor;
Session["UserLevel"] = loginDetails.UserLevel;
Session["ReportingUser"] = loginDetails.ReportingUser;
MappedUser = dbEntities.ETUsers.Where(x => x.ReportingUser == loginDetails.UserID || x.UserID == loginDetails.UserID).Select(x => x.UserID).Distinct().ToList();
Session["MappedUser"] = MappedUser;
Session.Timeout = 300;
repUser.LogForUserLogin(checkLogin, objLoginDetails.Email);
var userVerify = dbEntities.ETUserVerifieds.Where(x => x.UserID == loginDetails.UserID && x.IsActive).FirstOrDefault();
if (loginDetails.IsTwoFactor)
{
return(RedirectToAction("Twofactor", "CommonUser"));
}
else if (userVerify != null && (!userVerify.IsEmailVefified || !userVerify.IsPhoneVerified)) // || !userVerify.IsOtherVerified))
{
if (!userVerify.IsEmailVefified)
{
//return RedirectToAction("TwofactorEmailVerification?VerifyMode=Email", "CommonUser");
return(RedirectToAction("TwofactorEmailVerification", "CommonUser", new { VerifyMode = "Email" }));
}
else if (!userVerify.IsPhoneVerified)
{
return(RedirectToAction("TwofactorPhoneVerification", "CommonUser", new { VerifyMode = "Phone" }));
}
//else if (!userVerify.IsOtherVerified) // Maybe verify this in future
// return RedirectToAction("TwofactorPhoneTabVerification", "CommonUser", new { VerifyMode = "PhoneTab" });
}
else
{
Session["IsVerifyTwofactor"] = "Y";
List <long> lstSubmenuId = dbEntities.ETMenuAccesses.Where(n => n.RoleID == loginDetails.RoleID && n.Status).Select(x => x.SubMenuID).ToList();
if (lstSubmenuId.Count > 0)
{
ETSubMenu objSubMenu = dbEntities.ETSubMenus.Where(n => lstSubmenuId.Contains(n.SubMenuID) && n.Status && n.IsMainMenu).OrderBy(x => x.OrderNo).FirstOrDefault();
string Url = objSubMenu.SubMenuUrl;
if (!string.IsNullOrEmpty(Url))
{
string[] urls = Url.Split('/');
if (urls[1] != "" && urls[2] != "")
{
return(RedirectToAction(urls[2], urls[1]));
}
}
}
}
}
}
else
{
//repUser.LogForUserLogin(checkLogin, objLoginDetails.Email);
ViewBag.Error = checkLogin.errorMessage;
return(View());
}
}
return(View());
}
public ActionResult SignUp(SignUp updateUser)
{
TempData["messagealert"] = string.Empty;
var errors = ModelState.Values.SelectMany(v => v.Errors);
if (ModelState.IsValid)
{
UserVal = new ETUser();
if (repUser.LogInNameIsExist(updateUser.LoginName, 0))
{
ViewBag.messagealert = "LogInName already exist";
ViewBag.UserTitles = repUser.getDataValues("Title", "0", Convert.ToInt64(Session["UserID"]), 1); // Need to change
ViewBag.Gender = repUser.getDataValues("Gender", "0", Convert.ToInt64(Session["UserID"]), 1); // Need to change
ViewBag.MaritalStatus = repUser.getDataValues("MaritalStatus", "0", Convert.ToInt64(Session["UserID"]), 1); // Need to change
ViewBag.DeviceType = repUser.getDataValues("DeviceType", "0", Convert.ToInt64(Session["UserID"]), 1); // Need to change
return(View(UserVal));
}
else if (repUser.EmailIsExist(updateUser.Email, 0) || !Common.IsValidEmail(updateUser.Email))
{
if (!Common.IsValidEmail(updateUser.Email))
{
ViewBag.messagealert = "Please Enter Valid Email";
}
else
{
ViewBag.messagealert = "Email already exist";
}
ViewBag.UserTitles = repUser.getDataValues("Title", "0", Convert.ToInt64(Session["UserID"]), 1); // Need to change
ViewBag.Gender = repUser.getDataValues("Gender", "0", Convert.ToInt64(Session["UserID"]), 1); // Need to change
ViewBag.MaritalStatus = repUser.getDataValues("MaritalStatus", "0", Convert.ToInt64(Session["UserID"]), 1); // Need to change
ViewBag.DeviceType = repUser.getDataValues("DeviceType", "0", Convert.ToInt64(Session["UserID"]), 1); // Need to change
return(View(UserVal));
}
else if (repUser.PhoneIsExist(updateUser.Phone, 0))
{
ViewBag.messagealert = "Phone already exist";
ViewBag.UserTitles = repUser.getDataValues("Title", "0", Convert.ToInt64(Session["UserID"]), 1); // Need to change
ViewBag.Gender = repUser.getDataValues("Gender", "0", Convert.ToInt64(Session["UserID"]), 1); // Need to change
ViewBag.MaritalStatus = repUser.getDataValues("MaritalStatus", "0", Convert.ToInt64(Session["UserID"]), 1); // Need to change
ViewBag.DeviceType = repUser.getDataValues("DeviceType", "0", Convert.ToInt64(Session["UserID"]), 1); // Need to change
return(View(UserVal));
}
else
{
//try
//{
UserVal.UserID = repUser.UserIdGeneration();
UserVal.Password = Common.EncryptPassword(updateUser.Password);
UserVal.ConfirmPassword = Common.EncryptPassword(updateUser.ConfirmPassword);
UserVal.UserLevel = "USER";
UserVal.IsActive = true;
UserVal.IsTwoFactor = true;
UserVal.ReportingUser = 1; // Need to change
UserVal.RoleID = 3; // Need to change
UserVal.SourceOfCreation = "Sign Up";
UserVal.Title = updateUser.Title;
UserVal.FirstName = updateUser.FirstName;
UserVal.MiddleName = updateUser.MiddleName;
UserVal.LastName = updateUser.LastName;
UserVal.Email = updateUser.Email;
UserVal.Phone = updateUser.Phone;
UserVal.Gender = updateUser.Gender;
UserVal.MaritalStatus = updateUser.MaritalStatus;
UserVal.DOB = updateUser.DOB;
UserVal.Address = updateUser.Address;
UserVal.LoginName = updateUser.LoginName;
//UserVal.IsTwoFactor = updateUser.IsTwoFactor;
UserVal.DeviceID = updateUser.DeviceID;
UserVal.DeviceType = updateUser.DeviceType;
UserVal.UserField1 = updateUser.UserField1;
UserVal.UserField2 = updateUser.UserField2;
UserVal.UserField3 = updateUser.UserField3;
UserVal.CreatedBy = UserVal.UserID;
UserVal.CreatedDate = DateTime.Now;
UserVal.ModifiedBy = UserVal.UserID;
UserVal.ModifiedDate = DateTime.Now;
dbEntities.ETUsers.Add(UserVal);
dbEntities.SaveChanges();
//dbEntities.Entry(UserVal).State = EntityState.Modified;
//dbEntities.SaveChanges();
ETUserVerified userVerified = new ETUserVerified();
userVerified.UserID = UserVal.UserID;
userVerified.IsEmailVefified = false;
userVerified.IsPhoneVerified = false;
userVerified.IsOtherVerified = false;
userVerified.IsOtherVerified1 = false;
userVerified.IsOtherVerified2 = false;
userVerified.IsOtherVerified3 = false;
userVerified.IsActive = true;
userVerified.CreatedBy = UserVal.UserID;
userVerified.CreatedDate = DateTime.Now;
userVerified.ModifiedBy = UserVal.UserID;
userVerified.ModifiedDate = DateTime.Now;
dbEntities.ETUserVerifieds.Add(userVerified);
dbEntities.SaveChanges();
if (UserVal.UserID != 0)
{
TempData["messagealert"] = Status.Save;
}
//}
//catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
//{
// Exception raise = dbEx;
// foreach (var validationErrors in dbEx.EntityValidationErrors)
// {
// foreach (var validationError in validationErrors.ValidationErrors)
// {
// string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// // raise a new exception nesting
// // the current instance as InnerException
// raise = new InvalidOperationException(message, raise);
// }
// }
// throw raise;
//}
}
return(RedirectToAction("Index", "Login"));
}
return(View());
}
public ActionResult DirectLogin()
{
if (Request.QueryString["RandomID"] != null)
{
LoginDetail objLoginDetails = new LoginDetail();
objLoginDetails.Email = Common.DecryptPassword(Request.QueryString["RandomID"].ToString().Trim());
objLoginDetails.Password = Common.DecryptPassword(Request.QueryString["RandomValue"].ToString().Trim());
string VerifyMode = Common.DecryptPassword(Request.QueryString["VerifyMode"].ToString().Trim());
if (Common.IsValidEmail(objLoginDetails.Email))
{
objLoginDetails.GetTypes = "Email Id";
}
else
{
objLoginDetails.GetTypes = "Usename";
if (dbEntities.ETUsers.Any(x => x.LoginName == objLoginDetails.Email))
{
objLoginDetails.Email = dbEntities.ETUsers.Where(x => x.LoginName == objLoginDetails.Email).Select(x => x.Email).First();
}
}
string DeviceType = "";
if (VerifyMode == "Phone")
{
DeviceType = "P";
}
else if (VerifyMode == "Email")
{
DeviceType = "E";
}
LoginDetailCheck checkLogin = repUser.CheckLoginUserUsingOtp(objLoginDetails, DeviceType);
if (checkLogin.isSuccess && checkLogin.errorMessage == "Valid")
{
ETUser loginDetails = checkLogin.loginDetails;
if (loginDetails != null)
{
List <long> MappedUser = new List <long>();
Session["UserID"] = loginDetails.UserID;
Session["UserName"] = loginDetails.FirstName + " " + loginDetails.MiddleName + " " + loginDetails.LastName;
Session["RoleID"] = loginDetails.RoleID;
Session["RoleName"] = null; //loginDetails.ETRole.RoleName;
Session["LoginName"] = loginDetails.LoginName; // New
Session["Email"] = loginDetails.Email;
Session["Phone"] = loginDetails.Phone;
Session["LastName"] = loginDetails.LastName;
Session["IsTwoFactor"] = loginDetails.IsTwoFactor;
Session["UserLevel"] = loginDetails.UserLevel;
Session["ReportingUser"] = loginDetails.ReportingUser;
MappedUser = dbEntities.ETUsers.Where(x => x.ReportingUser == loginDetails.UserID || x.UserID == loginDetails.UserID).Select(x => x.UserID).Distinct().ToList();
Session["MappedUser"] = MappedUser;
Session.Timeout = 300;
repUser.LogForUserLogin(checkLogin, objLoginDetails.Email);
long UserId = Convert.ToInt64(Session["UserID"]);
var userVerify = dbEntities.ETUserVerifieds.Where(x => x.UserID == UserId && x.IsActive).FirstOrDefault();
if (userVerify != null && (!userVerify.IsEmailVefified || !userVerify.IsPhoneVerified))
{
if (VerifyMode == "Email")
{
userVerify.IsEmailVefified = true;
}
else if (VerifyMode == "Phone")
{
userVerify.IsPhoneVerified = true;
}
userVerify.ModifiedBy = Convert.ToInt64(Session["UserID"]);
userVerify.ModifiedDate = DateTime.Now;
dbEntities.Entry(userVerify).State = EntityState.Modified;
dbEntities.SaveChanges();
}
List <long> lstSubmenuId = dbEntities.ETMenuAccesses.Where(n => n.RoleID == loginDetails.RoleID && n.Status).Select(x => x.SubMenuID).ToList();
if (lstSubmenuId.Count > 0)
{
Session["IsVerifyTwofactor"] = "Y";
ETSubMenu objSubMenu = dbEntities.ETSubMenus.Where(n => lstSubmenuId.Contains(n.SubMenuID) && n.Status && n.IsMainMenu).OrderBy(x => x.OrderNo).FirstOrDefault();
string Url = objSubMenu.SubMenuUrl;
if (!string.IsNullOrEmpty(Url))
{
string[] urls = Url.Split('/');
if (urls[1] != "" && urls[2] != "")
{
return(RedirectToAction(urls[2], urls[1]));
}
}
}
}
}
else if (checkLogin.errorMessage == "Otp")
{
ViewBag.messagealert = "Otp Expired. Please try again.!";
return(RedirectToAction("Logout", "Login"));
}
else if (checkLogin.errorMessage == "Device")
{
ViewBag.messagealert = "Your Device type is Invalid. Please try latest Device Link";
return(RedirectToAction("Logout", "Login"));
}
else if (checkLogin.errorMessage == "Invalid")
{
ViewBag.messagealert = "Invalid OTP. Please Enter correct OTP and try again.!";
return(RedirectToAction("Logout", "Login"));
}
else
{
ViewBag.Error = checkLogin.errorMessage;
ViewBag.messagealert = checkLogin.errorMessage;
return(RedirectToAction("Logout", "Login"));
}
}
ViewBag.messagealert = "Invalid Direct Login Url.";
return(RedirectToAction("Logout", "Login"));
}
public ActionResult User_add(ETUser addUser)
{
TempData["messagealert"] = string.Empty;
ViewBag.messagealert = string.Empty;
if (ModelState.IsValid)
{
if (addUser != null)
{
if (repUsers.LogInNameIsExist(addUser.LoginName, 0))
{
ViewBag.messagealert = "LogInName already exist";
ViewBag.UserTitles = repUsers.getDataValues("Title", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Gender = repUsers.getDataValues("Gender", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.MaritalStatus = repUsers.getDataValues("MaritalStatus", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.UserLevel = repUsers.getDataValues("UserLevel", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.ReportingUser = repUsers.getMappedReportingUser();
ViewBag.DeviceType = repUsers.getDataValues("DeviceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Role = repUsers.getRole();
return(View(addUser));
}
else if (repUsers.EmailIsExist(addUser.Email, 0) || !Common.IsValidEmail(addUser.Email))
{
if (!Common.IsValidEmail(addUser.Email))
{
ViewBag.messagealert = "Please Enter Valid Email";
}
else
{
ViewBag.messagealert = "Email already exist";
}
ViewBag.UserTitles = repUsers.getDataValues("Title", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Gender = repUsers.getDataValues("Gender", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.MaritalStatus = repUsers.getDataValues("MaritalStatus", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.UserLevel = repUsers.getDataValues("UserLevel", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.ReportingUser = repUsers.getMappedReportingUser();
ViewBag.DeviceType = repUsers.getDataValues("DeviceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Role = repUsers.getRole();
return(View(addUser));
}
else if (repUsers.PhoneIsExist(addUser.Phone, 0))
{
ViewBag.messagealert = "Phone already exist";
ViewBag.UserTitles = repUsers.getDataValues("Title", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Gender = repUsers.getDataValues("Gender", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.MaritalStatus = repUsers.getDataValues("MaritalStatus", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.UserLevel = repUsers.getDataValues("UserLevel", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.ReportingUser = repUsers.getMappedReportingUser();
ViewBag.DeviceType = repUsers.getDataValues("DeviceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Role = repUsers.getRole();
return(View(addUser));
}
else
{
//try
//{
addUser.SourceOfCreation = "User Form";
addUser.Password = Common.EncryptPassword(addUser.Password);
addUser.ConfirmPassword = Common.EncryptPassword(addUser.ConfirmPassword);
addUser.UserID = repUsers.UserIdGeneration();
addUser.CreatedBy = Convert.ToInt64(Session["UserID"]);
addUser.CreatedDate = DateTime.Now;
addUser.ModifiedBy = Convert.ToInt64(Session["UserID"]);
addUser.ModifiedDate = DateTime.Now;
dbEntities.ETUsers.Add(addUser);
dbEntities.SaveChanges();
ETUserVerified userVerified = new ETUserVerified();
userVerified.UserID = addUser.UserID;
userVerified.IsEmailVefified = false;
userVerified.IsPhoneVerified = false;
userVerified.IsOtherVerified = false;
userVerified.IsOtherVerified1 = false;
userVerified.IsOtherVerified2 = false;
userVerified.IsOtherVerified3 = false;
userVerified.IsActive = true;
userVerified.CreatedBy = Convert.ToInt64(Session["UserID"]);
userVerified.CreatedDate = DateTime.Now;
userVerified.ModifiedBy = Convert.ToInt64(Session["UserID"]);
userVerified.ModifiedDate = DateTime.Now;
dbEntities.ETUserVerifieds.Add(userVerified);
dbEntities.SaveChanges();
if (addUser.UserID != 0)
{
TempData["messagealert"] = Status.Save;
}
//}
//catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
//{
// Exception raise = dbEx;
// foreach (var validationErrors in dbEx.EntityValidationErrors)
// {
// foreach (var validationError in validationErrors.ValidationErrors)
// {
// string message = string.Format("{0}:{1}",
// validationErrors.Entry.Entity.ToString(),
// validationError.ErrorMessage);
// // raise a new exception nesting
// // the current instance as InnerException
// raise = new InvalidOperationException(message, raise);
// }
// }
// throw raise;
//}
}
}
return(RedirectToAction("Index", "User"));
}
return(View());
}
public ActionResult User_view(long Id)
{
Userval = repUsers.GetUser(Id);
Userval.Password = Common.DecryptPassword(Userval.Password);
return(View(Userval));
}
public ActionResult User_edit(long id, ETUser updateUser)
{
TempData["messagealert"] = string.Empty;
//var errors = ModelState.Values.SelectMany(v => v.Errors);
if (ModelState.IsValid)
{
Userval = new ETUser();
Userval = repUsers.GetUser(id);
if (repUsers.LogInNameIsExist(updateUser.LoginName, id))
{
ViewBag.messagealert = "LogInName already exist";
ViewBag.UserTitles = repUsers.getDataValues("Title", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Gender = repUsers.getDataValues("Gender", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.MaritalStatus = repUsers.getDataValues("MaritalStatus", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.UserLevel = repUsers.getDataValues("UserLevel", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.ReportingUser = repUsers.getMappedReportingUser();
ViewBag.DeviceType = repUsers.getDataValues("DeviceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Role = repUsers.getRole();
return(View(Userval));
}
else if (repUsers.EmailIsExist(updateUser.Email, id) || !Common.IsValidEmail(updateUser.Email))
{
if (!Common.IsValidEmail(updateUser.Email))
{
ViewBag.messagealert = "Please Enter Valid Email";
}
else
{
ViewBag.messagealert = "Email already exist";
}
ViewBag.UserTitles = repUsers.getDataValues("Title", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Gender = repUsers.getDataValues("Gender", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.MaritalStatus = repUsers.getDataValues("MaritalStatus", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.UserLevel = repUsers.getDataValues("UserLevel", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.ReportingUser = repUsers.getMappedReportingUser();
ViewBag.DeviceType = repUsers.getDataValues("DeviceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Role = repUsers.getRole();
return(View(Userval));
}
else if (repUsers.PhoneIsExist(updateUser.Phone, id))
{
ViewBag.messagealert = "Phone already exist";
ViewBag.UserTitles = repUsers.getDataValues("Title", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Gender = repUsers.getDataValues("Gender", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.MaritalStatus = repUsers.getDataValues("MaritalStatus", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.UserLevel = repUsers.getDataValues("UserLevel", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.ReportingUser = repUsers.getMappedReportingUser();
ViewBag.DeviceType = repUsers.getDataValues("DeviceType", Session["UserLevel"].ToString(), Convert.ToInt64(Session["UserID"]), Convert.ToInt64(Session["ReportingUser"]));
ViewBag.Role = repUsers.getRole();
return(View(Userval));
}
else
{
long UserId = Convert.ToInt64(Session["UserID"]);
Userval.Title = updateUser.Title;
Userval.FirstName = updateUser.FirstName;
Userval.MiddleName = updateUser.MiddleName;
Userval.LastName = updateUser.LastName;
Userval.Email = updateUser.Email;
Userval.Phone = updateUser.Phone;
Userval.Gender = updateUser.Gender;
Userval.MaritalStatus = updateUser.MaritalStatus;
Userval.DOB = updateUser.DOB;
Userval.Address = updateUser.Address;
Userval.RoleID = updateUser.RoleID;
Userval.LoginName = updateUser.LoginName;
Userval.Password = Common.EncryptPassword(updateUser.Password);
Userval.ConfirmPassword = Common.EncryptPassword(updateUser.ConfirmPassword);
//Userval.Password = updateUser.Password;
Userval.IsTwoFactor = updateUser.IsTwoFactor;
Userval.UserLevel = updateUser.UserLevel;
Userval.ReportingUser = updateUser.ReportingUser;
//Userval.IsOwner = updateUser.IsOwner;
//Userval.IsAdmin = updateUser.IsAdmin;
//Userval.IsManager = updateUser.IsManager;
Userval.IsActive = updateUser.IsActive;
Userval.DeviceID = updateUser.DeviceID;
Userval.DeviceType = updateUser.DeviceType;
Userval.UserField1 = updateUser.UserField1;
Userval.UserField2 = updateUser.UserField2;
Userval.UserField3 = updateUser.UserField3;
Userval.ModifiedBy = UserId;
Userval.ModifiedDate = DateTime.Now;
dbEntities.Entry(Userval).State = EntityState.Modified;
dbEntities.SaveChanges();
var userVerify = dbEntities.ETUserVerifieds.Where(x => x.UserID == Userval.UserID && x.IsActive).FirstOrDefault();
if (userVerify == null)
{
ETUserVerified userVerified = new ETUserVerified();
userVerified.UserID = Userval.UserID;
userVerified.IsEmailVefified = false;
userVerified.IsPhoneVerified = false;
userVerified.IsOtherVerified = false;
userVerified.IsOtherVerified1 = false;
userVerified.IsOtherVerified2 = false;
userVerified.IsOtherVerified3 = false;
userVerified.IsActive = true;
userVerified.CreatedBy = UserId;
userVerified.CreatedDate = DateTime.Now;
userVerified.ModifiedBy = UserId;
userVerified.ModifiedDate = DateTime.Now;
dbEntities.ETUserVerifieds.Add(userVerified);
dbEntities.SaveChanges();
}
if (Userval.UserID != 0)
{
TempData["messagealert"] = Status.Update;
}
}
return(RedirectToAction("Index", "User"));
}
return(View());
}
