public bool SaveRankMessage(string RankMessageId, string RankMessage)
{
DataCollectionModelDataContext db = new DataCollectionModelDataContext();
try
{
if (Convert.ToInt32(RankMessageId) > 0)
{
var RankMesgs = db.RankMesgs.Where(a => a.Id == Convert.ToInt32(RankMessageId)).FirstOrDefault();
if (RankMesgs != null)
{
RankMesgs.Message = RankMessage;
}
db.SubmitChanges();
}
else
{
RankMesg rankMesgs = new RankMesg();
rankMesgs.Message = RankMessage;
db.RankMesgs.InsertOnSubmit(rankMesgs);
db.SubmitChanges();
}
return(true);
}
catch
{
return(false);
}
}
public ActionResult ChangePassword(ManageUserViewModel model)
{
var message = "";
DataCollectionModelDataContext db = new DataCollectionModelDataContext();
var RankUser = db.RankUsers.Where(a => a.UserID == SessionManager.UserId.Trim()).FirstOrDefault();
if (RankUser != null)
{
if (string.Compare(FormCommonMethods.Encryptdata(model.OldPassword), RankUser.UserPassword) == 0)
{
RankUser.UserPassword = FormCommonMethods.Encryptdata(model.NewPassword);
db.SubmitChanges();
message = "Password updated successfully";
//ViewBag.Status = true;
//ViewBag.Message = message;
TempData["Message"] = message;
TempData["Status"] = true;
return(Redirect(SessionManager.MenuList.FirstOrDefault().MenuUrl));
}
else
{
message = "Invalid Old Password";
ViewBag.Status = false;
}
}
ViewBag.Message = message;
return(View(model));
}
public ActionResult ResetPassword(ResetPasswordModel model)
{
var message = "";
if (ModelState.IsValid)
{
using (DataCollectionModelDataContext db = new DataCollectionModelDataContext())
{
var user = db.RankUsers.Where(a => a.ResetPasswordCode == model.ResetCode).FirstOrDefault();
if (user != null)
{
user.UserPassword = FormCommonMethods.Encryptdata(model.NewPassword);
user.ResetPasswordCode = "";
db.SubmitChanges();
message = "New password updated successfully";
//ViewBag.Status = true;
//ViewBag.Message = message;
TempData["Message"] = message;
TempData["Status"] = true;
return(RedirectToAction("Login", "User", null));
}
}
}
else
{
message = "invalid details. Contact System Administrator.";
ViewBag.Status = false;
}
ViewBag.Message = message;
return(View(model));
}
public ActionResult ForgotPassword(string EmailID)
{
//Verify Email ID
//Generate Reset password link
//Send Email
string message = "";
bool status = false;
using (DataCollectionModelDataContext db = new DataCollectionModelDataContext())
{
var account = db.RankUsers.Where(a => a.UserEmail == EmailID).FirstOrDefault();
if (account != null)
{
//Send email for reset password
string resetCode = Guid.NewGuid().ToString();
SendVerificationLinkEmail(account.UserEmail, resetCode, "ResetPassword");
account.ResetPasswordCode = resetCode;
//This line I have added here to avoid confirm password not match issue , as we had added a confirm password property
//in our model class in part 1
db.SubmitChanges();
ModelState.Clear();
message = "Reset password link has been sent to your email id.";
status = true;
}
else
{
message = "Account not found";
}
}
ViewBag.Message = message;
ViewBag.Status = status;
return(View());
}
public ActionResult VerifyAccount(string id)
{
bool Status = false, IsLoginLinkVisible = false;
if (string.IsNullOrEmpty(id))
{
return(RedirectToAction("Login", "User", null));
}
using (DataCollectionModelDataContext db = new DataCollectionModelDataContext())
{
Guid guidResult;
bool isValid = Guid.TryParse(id, out guidResult);
if (!isValid)
{
return(RedirectToAction("Login", "User", null));
}
var v = db.RankUsers.Where(a => a.ActivationCode == new Guid(id)).FirstOrDefault();
if (v != null)
{
if (!v.IsEmailVerified ?? false)
{
v.IsEmailVerified = true;
db.SubmitChanges();
Status = true;
ViewBag.Message = "Your registered details has been verified successfully. Your account will be activated after authorisation by administrator(IRD-SRIC).";
}
else if (v.UserValid.ToString().ToUpper() == "N" && v.UserDisabledOn == null)
{
Status = true;
ViewBag.Message = "Your registered details have been already verified. Please wait for authorisation by administrator(IRD-SRIC)";
}
else if (v.UserValid.ToString().ToUpper() == "Y")
{
ViewBag.Message = "Your registered details have been already verified. Please wait for authorisation by administrator(IRD-SRIC)";
IsLoginLinkVisible = true;
}
}
else
{
ViewBag.Message = "Invalid Request";
}
}
ViewBag.Status = Status;
ViewBag.IsLoginLinkVisible = IsLoginLinkVisible;
return(View());
}
public ActionResult UpdateUserDetail(RankUserViewModel rankUserViewModel, string[] MenuList)
{
bool Status = false;
DataCollectionModelDataContext db = new DataCollectionModelDataContext();
RankUser rankUser = db.RankUsers.Where(a => a.UserID == rankUserViewModel.RankUser.UserID).FirstOrDefault();
if (rankUser != null)
{
rankUser.DeptID = rankUserViewModel.RankUser.DeptID;
rankUser.UserDisabledOn = Convert.ToString(rankUserViewModel.RankUser.UserValid) == "N" ? DateTime.Now : (DateTime?)null;
rankUser.UserEmail = rankUserViewModel.RankUser.UserEmail;
rankUser.UserEmpNo = rankUserViewModel.RankUser.UserEmpNo;
rankUser.UserMob = rankUserViewModel.RankUser.UserMob;
rankUser.UserName = rankUserViewModel.RankUser.UserName;
rankUser.UserRole = rankUserViewModel.RankUser.UserRole;
rankUser.UserValid = Convert.ToChar(rankUserViewModel.RankUser.UserValid ?? null);
rankUser.UserWork = rankUserViewModel.RankUser.UserWork;
db.Connection.Open();
using (db.Transaction = db.Connection.BeginTransaction())
{
try
{
IEnumerable <UserMenu> userMenu = db.UserMenus.Where(a => a.UserID == rankUserViewModel.RankUser.UserID).ToList();
if (userMenu != null)
{
var sa = userMenu.Where(a => !MenuList.Contains(a.MenuID)).ToList();
if (sa.Any())
{
db.UserMenus.DeleteAllOnSubmit(sa);
}
}
List <UserMenu> userMenuList = new List <UserMenu>();
foreach (string item in MenuList)
{
var sa = userMenu.Where(a => a.MenuID == item).FirstOrDefault();
if (sa == null)
{
UserMenu menu = new UserMenu();
menu.MenuID = item;
menu.UserID = rankUserViewModel.RankUser.UserID;
userMenuList.Add(menu);
}
}
if (userMenuList.Any())
{
db.UserMenus.InsertAllOnSubmit(userMenuList);
}
db.SubmitChanges();
db.Transaction.Commit();
Status = true;
ViewBag.Message = "User Updated Successfully.";
ViewBag.Status = true;
try
{
if (rankUserViewModel.RankUser.UserValid == "Y")
{
string body = "Dear " + rankUserViewModel.RankUser.UserName + ",<br /> You have been authorised by admin now. You can access the system by logging in. <br /><br /> Admin <br /> IRD SRIC";
FormServices formServices = new FormServices();
body = body.Replace("\r\n", "<br />");
string subject = "User Authorised by Admin, IRD-SRIC, IITR";
formServices.SendEmail(rankUserViewModel.RankUser.UserEmail, "", subject, body);
}
}
catch (Exception ex) { }
}
catch (Exception ex)
{
db.Transaction.Rollback();
ViewBag.Message = "Failed To Updated User. Error: " + ex.Message;
ViewBag.Status = false;
}
}
}
return(Json(new { success = Status }));
}
