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 EditUserDetail(string UserId)
{
DataCollectionModelDataContext db = new DataCollectionModelDataContext();
RankUserViewModel rankUserViewModel = new RankUserViewModel();
RankUser RankUser = db.RankUsers.Where(a => a.UserID == UserId).FirstOrDefault();
rankUserViewModel.RankUser = FormCommonMethods.ToEntityRankUserMap(RankUser);
rankUserViewModel.MenuList = (from post in db.UserMenus
join menu in db.MenuIDs on post.MenuID equals menu.MenuID1
where post.UserID == UserId
select menu.MenuID1).ToArray();
rankUserViewModel.MenuDDLList = db.MenuIDs.Where(a => !(a.IsAdminMenu ?? false)).Select(i => new SelectListItem()
{
Text = i.MenuDetails, Value = i.MenuID1, Selected = rankUserViewModel.MenuList.Contains(i.MenuID1)
}).AsEnumerable();
rankUserViewModel.UserRoleDDLList = db.UserRoles.Select(i => new SelectListItem()
{
Text = i.UserRoleDetails, Value = i.UserRole1
}).AsEnumerable();
rankUserViewModel.UserWorkDDLList = db.UserWorks.Select(i => new SelectListItem()
{
Text = i.UserWorkDetails, Value = i.UserWork1
}).AsEnumerable();
rankUserViewModel.DeptDDLList = db.Depts.Select(i => new SelectListItem()
{
Text = i.DeptName, Value = i.DeptID
}).AsEnumerable();
return(PartialView("EditUserPartial", rankUserViewModel));
}
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));
}
//[ValidateAntiForgeryToken]
public ActionResult Login(LoginViewModel loginViewModel, string ReturnUrl = "")
{
string message = "";
using (DataCollectionModelDataContext db = new DataCollectionModelDataContext())
{
DataCollection.Models.RankUser RankUser = db.RankUsers.Where(a => a.UserID == loginViewModel.UserId.Trim()).FirstOrDefault();
if (RankUser != null)
{
if (string.Compare(FormCommonMethods.Encryptdata(loginViewModel.Password), RankUser.UserPassword) == 0)
{
if (string.IsNullOrWhiteSpace(Convert.ToString(RankUser.UserValid)) || Convert.ToString(RankUser.UserValid).ToUpper().Trim() == "N" || (string.IsNullOrWhiteSpace(RankUser.DeptID) || string.IsNullOrWhiteSpace(RankUser.UserRole) || string.IsNullOrWhiteSpace(RankUser.UserWork)))
{
if (Convert.ToString(RankUser.UserValid).ToUpper().Trim() == "N" && RankUser.UserDisabledOn != null)
{
ViewBag.Message = "Your account is blocked. Please Contact Admin";
ViewBag.Status = false;
}
else if (Convert.ToString(RankUser.UserValid).ToUpper().Trim() == "N" && (!RankUser.IsEmailVerified ?? !false))
{
ViewBag.Message = "Email link sent. kindly click on the link to complete registration";
ViewBag.Status = false;
}
else if (Convert.ToString(RankUser.UserValid).ToUpper().Trim() == "N" && (RankUser.IsEmailVerified ?? false))
{
string href = Url.Action("Index", "Contact", null);
var link = Request.Url.AbsoluteUri.Replace(Request.Url.PathAndQuery, href);
ViewBag.Message = "Activation pending from Admin , IRD-SRIC. Kindly wait for some more time or Contact through <a href='" + link + "'> Contact Us </a>";
ViewBag.Status = false;
}
return(View());
}
int timeout = loginViewModel.RememberMe ? 525600 : 20; // 525600 min = 1 year
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, RankUser.UserName, DateTime.Now, DateTime.Now.AddMinutes(2880), loginViewModel.RememberMe, RankUser.UserRole, FormsAuthentication.FormsCookiePath);
string encrypted = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted);
cookie.Expires = DateTime.Now.AddMinutes(timeout);
cookie.HttpOnly = true;
Response.Cookies.Add(cookie);
SetUserSession(RankUser);
ViewBag.Status = true;
return(Redirect(SessionManager.MenuList.FirstOrDefault().MenuUrl));
}
else
{
message = "Invalid credential provided";
ViewBag.Status = false;
}
}
else
{
message = "Invalid credential provided";
ViewBag.Status = false;
}
}
ViewBag.Message = message;
return(View());
}
public ActionResult LoadEmpData(string EmpNo, string DataCaptYM, bool isFromSave)
{
SessionManager.DataCaptYR = Convert.ToInt32(DataCaptYM);
FormsViewModel dOAA1ViewModel = new FormsViewModel();
dOAA1ViewModel.GetDOAA1Data(Convert.ToInt32(DataCaptYM), Menu.DOFAPEER.ToString());
string MenuPartial = FormCommonMethods.GetMenuPartial(Menu.DOFAPEER.ToString());
if (!string.IsNullOrEmpty(EmpNo))
{
dOAA1ViewModel.dofaPeerViewModel.DofaPeerData = dOAA1ViewModel.dofaPeerViewModel.DofaPeerData.Where(a => a.empNo.Equals(Convert.ToInt32(EmpNo))).ToList();
dOAA1ViewModel.dofaPeerViewModel.EmpNo = Convert.ToInt32(EmpNo);
}
if (dOAA1ViewModel.dofaPeerViewModel.DofaPeerData.Count() <= 0)
{
DofaPeer dofaPeer = new DofaPeer();
dofaPeer.empNo = Convert.ToInt32(EmpNo);
dofaPeer.PeerNo = 1;
dOAA1ViewModel.dofaPeerViewModel.DofaPeerData.Add(dofaPeer);
}
object DataObject = FormCommonMethods.GetDynamicViewModel(Menu.DOFAPEER.ToString(), dOAA1ViewModel);
if (isFromSave)
{
TempData["isSaveSuccessfully"] = true;
TempData["isFailedToSentEmail"] = false;
}
return(PartialView(MenuPartial, DataObject));
}
public string GetTableDetail(string TableName)
{
RankUserRepository rankUser = new RankUserRepository();
DataTable TableDetail = rankUser.GetTableDetail(TableName);
return(FormCommonMethods.ConvertDataTableToHTML(TableDetail));
}
public bool SaveSricDeptData(string action, out string msg)
{
msg = string.Empty;
bool success = false;
if (SricDeptData == null || SricDeptData.Count == 0)
{
return(success);
}
foreach (var item in SricDeptData)
{
item.MenuID = DataAccess.Enum.Menu.SRIC.ToString();
item.DataUser = SessionManager.UserName;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = FormCommonMethods.GetStatusByAction(action);
item.DataValid = "Y";
item.DataLocked = "N";
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
}
try
{
FormsRepository formsRepository = new FormsRepository();
DataTable dt = ToDataTable(SricDeptData);
success = formsRepository.UpdateBulkSricDeptFormData(dt, SessionManager.DataCaptYR);
}
catch (Exception ex)
{
}
return(success);
}
public bool SaveDFNPData(string action, out string msg)
{
msg = string.Empty;
bool success = false;
if (finInfo == null)
{
return(success);
}
finInfo.MenuID = DataAccess.Enum.Menu.DFNP.ToString();
finInfo.DeptID = string.IsNullOrEmpty(finInfo.EmpDept) ? SessionManager.DeptID : finInfo.EmpDept;
finInfo.DeptName = SessionManager.DeptID;
finInfo.DataUser = SessionManager.UserName;
finInfo.DataUpdatedOn = DateTime.Now;
finInfo.DataCaptYM = SessionManager.DataCaptYR;
finInfo.DataStatus = FormCommonMethods.GetStatusByAction(action);
finInfo.DataValid = "Y";
finInfo.DataLocked = "N";
finInfo.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
try
{
FormsRepository formsRepository = new FormsRepository();
DataTable dt = ToDataTable(new List <FinInfo> {
finInfo
});
success = formsRepository.UpdateBulkDFNPData(dt, SessionManager.DataCaptYR);
}
catch (Exception ex)
{
}
return(success);
}
public void SetUserSession(DataCollection.Models.RankUser RankUser)
{
SessionManager.IsUserLogin = true;
SessionManager.UserName = RankUser.UserName;
SessionManager.UserWork = RankUser.UserWork;
SessionManager.UserRole = RankUser.UserRole;
SessionManager.DeptID = RankUser.DeptID;
SessionManager.UserId = RankUser.UserID;
SessionManager.MenuList = FormCommonMethods.GetCurrentUserMenu(RankUser.UserID, RankUser.UserRole);
}
public ActionResult OnDAtaCaptYMChange(int DataCaptYM, string Menu, string DeptId)
{
FormsViewModel dOAA1ViewModel = new FormsViewModel();
SessionManager.DataCaptYR = DataCaptYM;
SessionManager.DeptID = DeptId;
dOAA1ViewModel.GetDOAA1Data(DataCaptYM, Menu);
string MenuPartial = FormCommonMethods.GetMenuPartial(Menu);
object DataObject = FormCommonMethods.GetDynamicViewModel(Menu, dOAA1ViewModel);
return(PartialView(MenuPartial, DataObject));
}
public ActionResult Login(LoginViewModel loginViewModel, string ReturnUrl = "")
{
string message = "";
using (DataCollectionModelDataContext db = new DataCollectionModelDataContext())
{
DataCollection.Models.RankUser RankUser = db.RankUsers.Where(a => a.UserID == loginViewModel.UserId.Trim()).FirstOrDefault();
if (RankUser != null)
{
if (string.Compare(FormCommonMethods.Encryptdata(loginViewModel.Password), RankUser.UserPassword) == 0)
{
if (string.IsNullOrWhiteSpace(Convert.ToString(RankUser.UserValid)) || Convert.ToString(RankUser.UserValid).ToUpper().Trim() == "N" || (string.IsNullOrWhiteSpace(RankUser.DeptID) || string.IsNullOrWhiteSpace(RankUser.UserRole) || string.IsNullOrWhiteSpace(RankUser.UserWork)))
{
if (Convert.ToString(RankUser.UserValid).ToUpper().Trim() == "N" && RankUser.UserDisabledOn != null)
{
ViewBag.Message = "Your account is blocked. Please Contact Admin";
}
else
{
ViewBag.Message = "Your registration is under process";
}
return(View());
}
int timeout = loginViewModel.RememberMe ? 525600 : 20; // 525600 min = 1 year
FormsAuthenticationTicket ticket = new FormsAuthenticationTicket(1, RankUser.UserName, DateTime.Now, DateTime.Now.AddMinutes(2880), loginViewModel.RememberMe, RankUser.UserRole, FormsAuthentication.FormsCookiePath);
string encrypted = FormsAuthentication.Encrypt(ticket);
var cookie = new HttpCookie(FormsAuthentication.FormsCookieName, encrypted);
cookie.Expires = DateTime.Now.AddMinutes(timeout);
cookie.HttpOnly = true;
Response.Cookies.Add(cookie);
SetUserSession(RankUser);
ViewBag.Status = true;
return(Redirect(SessionManager.MenuList.FirstOrDefault().MenuUrl));
}
else
{
message = "Invalid credential provided";
ViewBag.Status = false;
}
}
else
{
message = "Invalid credential provided";
ViewBag.Status = false;
}
}
ViewBag.Message = message;
return(View());
}
public bool SaveSricFAData(string action, out string msg)
{
msg = string.Empty;
bool success = false;
if (SricFAData == null || SricFAData.Count == 0)
{
return(success);
}
if (SricFAData.Any(n => string.IsNullOrWhiteSpace(n.FAName)))
{
msg = "At least Agency Name / Sponsor Name Required.";
return(success);
}
if (SricFAData.GroupBy(n => n.FAName.Trim().ToLower()).Any(c => c.Count() > 1))
{
msg = "Duplicate Organization / Agency Name Exist.! Data saving aborted.";
return(success);
}
foreach (var item in SricFAData)
{
item.FAName = item.FAName.Trim();
item.MenuID = DataAccess.Enum.Menu.SRICFA.ToString();
item.DeptID = SessionManager.DeptID;
item.DataUser = SessionManager.UserName;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = FormCommonMethods.GetStatusByAction(action);
item.DataValid = "Y";
item.DataLocked = "N";
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
}
try
{
FormsRepository formsRepository = new FormsRepository();
DataTable dt = ToDataTable(SricFAData);
success = formsRepository.UpdateBulkSricFAFormData(dt, SessionManager.DataCaptYR, SessionManager.DeptID);
}
catch (Exception ex)
{
}
return(success);
}
public bool SaveDOFAData(string action, out string msg)
{
msg = string.Empty;
bool success = false;
if (DofaData == null || DofaData.Count == 0)
{
return(success);
}
if (DofaData.Any(n => n.empNo <= 0 || string.IsNullOrWhiteSpace(n.empName) || string.IsNullOrWhiteSpace(n.empDEPT)))
{
msg = "Minimum EmpNo, Name, Dept should not be blank";
return(success);
}
if (DofaData.GroupBy(n => n.empNo).Any(c => c.Count() > 1))
{
msg = "Duplicate EmpNo Exist.! Data saving aborted.";
return(success);
}
foreach (var item in DofaData)
{
item.MenuID = DataAccess.Enum.Menu.DOFA.ToString();
item.DeptID = SessionManager.DeptID;
item.DataUser = SessionManager.UserName;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = FormCommonMethods.GetStatusByAction(action);
item.DataValid = "Y";
item.DataLocked = "N";
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
}
try
{
FormsRepository formsRepository = new FormsRepository();
DataTable dt = ToDataTable(DofaData);
success = formsRepository.UpdateBulkDOFAFormData(dt, SessionManager.DataCaptYR, SessionManager.DeptID, EmpDept);
}
catch (Exception ex)
{
}
return(success);
}
public void GetMultiDataByMenuID(int dataCaptYM, string MenuID, string empDept = "")
{
FormsRepository formsRepository = new FormsRepository();
dataCaptYM = SessionManager.DataCaptYR > 0 ? SessionManager.DataCaptYR : (dataCaptYM > 0 ? dataCaptYM : 0);
if (MenuID == DataAccess.Enum.Menu.DOFA.ToString())
{
dofaViewModel = new DofaViewModel();
dofaViewModel.GetDOFAData(dataCaptYM, empDept);
}
else if (MenuID == DataAccess.Enum.Menu.SRICFA.ToString())
{
sricFAViewModel = new SricFAViewModel();
sricFAViewModel.GetSRICFAData(dataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.SRIC.ToString())
{
sricDeptViewModel = new SricDeptViewModel();
sricDeptViewModel.GetSRICData(dataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.DOFAPEER.ToString())
{
dofaPeerViewModel = new DofaPeerViewModel();
dofaPeerViewModel.GetDofaPeerData(dataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.TPDEPT.ToString())
{
tpDeptViewModel = new TPDeptViewModel();
tpDeptViewModel.GetTPDeptData(dataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.INFRA.ToString())
{
infraViewModel = new InfraViewModel();
infraViewModel.GetInfraData(dataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.DFNP.ToString())
{
dfnpViewModel = new DFNPViewModel();
dfnpViewModel.GetDFNPData(dataCaptYM);
dfnpViewModel.finInfo.EmpDept = SessionManager.EmpDeptID;
}
RankMesg rankmesg = FormCommonMethods.GetCurrentRankMesg();
this.rankmsg = rankmesg.Message;
}
public void GetDOAA1Data(int DataCaptYM, string MenuID)
{
FormsRepository formsRepository = new FormsRepository();
DataCaptYM = SessionManager.DataCaptYR > 0 ? SessionManager.DataCaptYR : (DataCaptYM > 0 ? DataCaptYM : 0);
if (MenuID == DataAccess.Enum.Menu.DOAA.ToString())
{
this.info = formsRepository.GetDOAA1FormDataByID(DataCaptYM, SessionManager.DeptID, MenuID);
if (info == null)
{
info = new stInfo();
info.DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
info.DataStatusName = "Data Entry Started by Operator";
info.DataCaptYM = DataCaptYM;
info.DeptName = info.DeptID = SessionManager.DeptID;
}
}
else if (MenuID == DataAccess.Enum.Menu.ADIR.ToString() || MenuID == DataAccess.Enum.Menu.DOSW.ToString())
{
this.info2 = formsRepository.GetADIRFormDataByID(DataCaptYM, SessionManager.DeptID, MenuID);
if (info2 == null)
{
info2 = new stInfo2();
info2.DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
info2.DataStatusName = "Data Entry Started by Operator";
info2.DataCaptYM = DataCaptYM;
info2.DeptName = info2.DeptID = SessionManager.DeptID;
}
}
else if (MenuID == DataAccess.Enum.Menu.LIBFORM.ToString())
{
this.libInfo = formsRepository.GetLibFormDataByID(DataCaptYM, SessionManager.DeptID, MenuID);
if (libInfo == null)
{
libInfo = new LibInfo();
libInfo.DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
libInfo.DataStatusName = "Data Entry Started by Operator";
libInfo.DataCaptYM = DataCaptYM;
libInfo.DeptName = libInfo.DeptID = SessionManager.DeptID;
}
}
RankMesg rankmesg = FormCommonMethods.GetCurrentRankMesg();
this.rankmsg = rankmesg.Message;
}
public void GetDOAA1Data(int DataCaptYM, string MenuID)
{
FormsRepository formsRepository = new FormsRepository();
DataCaptYM = SessionManager.DataCaptYR > 0 ? SessionManager.DataCaptYR : (DataCaptYM > 0 ? DataCaptYM : 0);
if (MenuID == DataAccess.Enum.Menu.DOAA.ToString())
{
string deptID = string.IsNullOrEmpty(SessionManager.EmpDeptID) ? SessionManager.DeptID : SessionManager.EmpDeptID;
this.info = formsRepository.GetDOAA1FormDataByID(DataCaptYM, deptID, MenuID);
if (info == null)
{
info = new stInfo();
info.DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
info.DataStatusName = (DataAccess.Enum.DataStatus.DataEntryStartedbyOperator).GetStringValue();
info.DataCaptYM = DataCaptYM;
info.DeptName = info.DeptID = SessionManager.DeptID;
}
info.EmpDept = SessionManager.EmpDeptID;
}
else if (MenuID == DataAccess.Enum.Menu.ADIR.ToString() || MenuID == DataAccess.Enum.Menu.DOSW.ToString())
{
this.info2 = formsRepository.GetADIRFormDataByID(DataCaptYM, SessionManager.DeptID, MenuID);
if (info2 == null)
{
info2 = new stInfo2();
info2.DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
info2.DataStatusName = (DataAccess.Enum.DataStatus.DataEntryStartedbyOperator).GetStringValue();
info2.DataCaptYM = DataCaptYM;
info2.DeptName = info2.DeptID = SessionManager.DeptID;
}
}
else if (MenuID == DataAccess.Enum.Menu.LIBFORM.ToString())
{
this.libInfo = formsRepository.GetLibFormDataByID(DataCaptYM, SessionManager.DeptID, MenuID);
if (libInfo == null)
{
libInfo = new LibInfo();
libInfo.DataStatus = (int)DataAccess.Enum.DataStatus.DataEntryStartedbyOperator;
libInfo.DataStatusName = (DataAccess.Enum.DataStatus.DataEntryStartedbyOperator).GetStringValue();
libInfo.DataCaptYM = DataCaptYM;
libInfo.DeptName = libInfo.DeptID = SessionManager.DeptID;
}
}
else if (MenuID == DataAccess.Enum.Menu.DOFA.ToString())
{
dofaViewModel = new DofaViewModel();
dofaViewModel.GetDOFAData(DataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.SRICFA.ToString())
{
sricFAViewModel = new SricFAViewModel();
sricFAViewModel.GetSRICFAData(DataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.SRIC.ToString())
{
sricDeptViewModel = new SricDeptViewModel();
sricDeptViewModel.GetSRICData(DataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.DOFAPEER.ToString())
{
dofaPeerViewModel = new DofaPeerViewModel();
dofaPeerViewModel.GetDofaPeerData(DataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.TPDEPT.ToString())
{
tpDeptViewModel = new TPDeptViewModel();
tpDeptViewModel.GetTPDeptData(DataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.INFRA.ToString())
{
infraViewModel = new InfraViewModel();
infraViewModel.GetInfraData(DataCaptYM);
}
else if (MenuID == DataAccess.Enum.Menu.DFNP.ToString())
{
dfnpViewModel = new DFNPViewModel();
dfnpViewModel.GetDFNPData(DataCaptYM);
dfnpViewModel.finInfo.EmpDept = SessionManager.EmpDeptID;
}
RankMesg rankmesg = FormCommonMethods.GetCurrentRankMesg();
this.rankmsg = rankmesg.Message;
}
public bool SaveDofaPeerData(string action, out string msg, out int empNo, out string empName)
{
msg = string.Empty; empNo = 0; empName = string.Empty;
bool success = false;
if (DofaPeerData == null || DofaPeerData.Count == 0)
{
return(success);
}
if (DofaPeerData.Any(n => n.empNo <= 0))
{
msg = "Employee Required";
return(success);
}
DataCollectionModelDataContext db = new DataCollectionModelDataContext();
string empNotExist = string.Empty;
foreach (var item in DofaPeerData)
{
var emp = db.dofaInfos.Where(a => a.empNo == item.empNo).FirstOrDefault();
if (emp != null)
{
item.empNo = item.empNo;
item.MenuID = DataAccess.Enum.Menu.DOFAPEER.ToString();
item.DeptID = SessionManager.DeptID;
item.DataUser = SessionManager.UserName;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = (short)FormCommonMethods.GetStatusByAction(action);
item.DataValid = Convert.ToChar("Y");
item.DataLocked = Convert.ToChar("N");
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
item.PeerRemarks = SessionManager.UserName + " on " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
empNo = emp.empNo;
empName = emp.empName;
}
else
{
if (string.IsNullOrEmpty(empNotExist))
{
empNotExist = Convert.ToString(emp.empNo);
}
else
{
empNotExist = empNotExist + " ," + emp.empNo;
}
}
}
if (!string.IsNullOrEmpty(empNotExist))
{
msg = empNotExist + "Employee Not Exist.";
return(success);
}
try
{
FormsRepository formsRepository = new FormsRepository();
DataTable dt = ToDataTable(DofaPeerData);
success = formsRepository.UpdateBulkDofaPeerFormData(dt, SessionManager.DataCaptYR, SessionManager.DeptID);
}
catch (Exception ex)
{
}
return(success);
}
public ActionResult Registration(RegisterViewModel user)
{
bool Status = true;
string message = "";
// Model Validation
if (!this.IsCaptchaValid("Captcha is not valid"))
{
Status = false;
message = "Captcha is not valid";
}
if (Status && ModelState.IsValid)
{
DataAccess.Entity.RankUser rankUser = new DataAccess.Entity.RankUser();
#region Password Hashing
rankUser.UserPassword = FormCommonMethods.Encryptdata(user.UserPassword);
#endregion
rankUser.UserID = user.UserId;
rankUser.UserEmail = user.UserEmail;
rankUser.UserEmpNo = user.UserEmpNo;
rankUser.UserName = user.UserName;
rankUser.UserMob = user.MobileNo;
rankUser.DeptID = user.DeptID;
rankUser.UserWork = user.UserWork;
rankUser.UserRemarks = user.UserRemarks;
rankUser.UserValid = "N";
rankUser.UserRole = UserRoles.User.ToString();
rankUser.IsEmailVerified = false;
rankUser.ActivationCode = Guid.NewGuid();
#region //Email is already Exist
int isExist = IsEmailExist(rankUser);
if (isExist == 1)
{
ModelState.AddModelError("EmailExist", "Email already exist");
message = "Email already exist";
Status = false;
//return View(user);
}
else if (isExist == 2)
{
ModelState.AddModelError("EmpNo Exist", "EmpNo already exist");
message = "EmpNo already exist";
Status = false;
//return View(user);
}
else if (isExist == 3)
{
ModelState.AddModelError("UserId Exist", "UserId is taken");
message = "UserId is taken";
Status = false;
//return View(user);
}
else if (isExist == 4)
{
ModelState.AddModelError("Mobile Exist", "Mobile already exist");
message = "Mobile already exist";
Status = false;
//return View(user);
}
#endregion
if (Status)
{
#region Save to Database
RankUserRepository rankUserRepository = new RankUserRepository();
Status = rankUserRepository.AddRankUser(rankUser);
if (Status)
{
//Send Email to User
SendVerificationLinkEmail(user.UserEmail, rankUser.ActivationCode.ToString());
user = new RegisterViewModel();
user = LoadRegister();
ModelState.Clear();
message = "Your account has been registered. An Email has been sent to confirm user registration." +
"Kindly check & click on the link given in Email to register your details.";
}
else
{
message = "Your registration failed.";
}
#endregion
}
}
else
{
if (string.IsNullOrWhiteSpace(message))
{
message = "Invalid Request";
}
}
ViewBag.Message = message;
ViewBag.Status = Status;
if (!Status)
{
RegisterViewModel RegisterVM = new RegisterViewModel();
RegisterVM = LoadRegister();
user.UserWorkDDLList = RegisterVM.UserWorkDDLList;
user.DeptDDLList = RegisterVM.DeptDDLList;
}
return(View(user));
}
public Tuple <bool, bool?> SaveUpdateFormData(object objectData, string action, string menu, string needModificationMSG, out string msg)
{
msg = string.Empty;
FormsViewModel formsViewModel = new FormsViewModel();
int DataCaptYM = 0;
string DeptID = string.Empty;
bool? IsEmailSent = null;
if (menu == DataAccess.Enum.Menu.DOSW.ToString() || menu == DataAccess.Enum.Menu.ADIR.ToString())
{
stInfo2 info2 = new stInfo2();
info2 = JsonConvert.DeserializeObject <stInfo2>(objectData.ToString());
info2.DataUpdatedOn = DateTime.Now;
info2.DataStatus = FormCommonMethods.GetStatusByAction(action);
info2.DataUser = SessionManager.UserName;
info2.DeptID = SessionManager.DeptID;
info2.DataValid = "Y";
info2.DataLocked = "N";
info2.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss"); //DateTime.Now.ToString("dd-MM-yyyy hh:mm:ss tt");
DeptID = info2.DeptID;
DataCaptYM = info2.DataCaptYM;
if (menu == DataAccess.Enum.Menu.ADIR.ToString())
{
info2.MenuID = DataAccess.Enum.Menu.ADIR.ToString();
}
else
{
info2.MenuID = DataAccess.Enum.Menu.DOSW.ToString();
}
formsViewModel.info2 = info2;
if (formsViewModel.info2.IDNo > 0)
{
formsViewModel.isSaveSuccessfully = formsViewModel.UdpateADIRAndDOSWForm(formsViewModel);
}
else
{
formsViewModel.isSaveSuccessfully = formsViewModel.SaveADIRAndDOSWForm(formsViewModel);
}
}
else if (menu == DataAccess.Enum.Menu.DOAA.ToString())
{
stInfo info = new stInfo();
info = JsonConvert.DeserializeObject <stInfo>(objectData.ToString());
info.DataUpdatedOn = DateTime.Now;
info.DataStatus = FormCommonMethods.GetStatusByAction(action);
info.DataUser = SessionManager.UserName;
info.DeptID = string.IsNullOrEmpty(info.EmpDept) ? SessionManager.DeptID : info.EmpDept;
info.DataValid = "Y";
info.DataLocked = "N";
info.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
info.MenuID = DataAccess.Enum.Menu.DOAA.ToString();
DataCaptYM = info.DataCaptYM;
DeptID = info.DeptID;
formsViewModel.info = info;
if (formsViewModel.info.IDNo > 0)
{
formsViewModel.isSaveSuccessfully = formsViewModel.UdpateDOAA1Form(formsViewModel);
}
else
{
formsViewModel.isSaveSuccessfully = formsViewModel.SaveDOAA1Form(formsViewModel);
}
}
else if (menu == DataAccess.Enum.Menu.LIBFORM.ToString())
{
LibInfo libInfo = new LibInfo();
libInfo = JsonConvert.DeserializeObject <LibInfo>(objectData.ToString());
libInfo.DataUpdatedOn = DateTime.Now;
libInfo.DataStatus = FormCommonMethods.GetStatusByAction(action);
libInfo.DataUser = SessionManager.UserName;
libInfo.DeptID = SessionManager.DeptID;
libInfo.DataValid = "Y";
libInfo.DataLocked = "N";
libInfo.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
libInfo.MenuID = DataAccess.Enum.Menu.LIBFORM.ToString();
DataCaptYM = libInfo.DataCaptYM;
DeptID = libInfo.DeptID;
formsViewModel.libInfo = libInfo;
if (formsViewModel.libInfo.IDNo > 0)
{
formsViewModel.isSaveSuccessfully = formsViewModel.UdpateLIBForm(formsViewModel);
}
else
{
formsViewModel.isSaveSuccessfully = formsViewModel.SaveLIBForm(formsViewModel);
}
}
else if (menu == DataAccess.Enum.Menu.DOFA.ToString())
{
if (objectData != null && typeof(DofaViewModel) == objectData.GetType())
{
DofaViewModel dvm = (DofaViewModel)objectData;
DataCaptYM = dvm.DataCaptYM;
DeptID = "DOFA";
formsViewModel.isSaveSuccessfully = dvm.SaveDOFAData(action, out msg);
}
else
{
formsViewModel.isSaveSuccessfully = false;
}
}
else if (menu == DataAccess.Enum.Menu.SRICFA.ToString())
{
if (objectData != null && typeof(SricFAViewModel) == objectData.GetType())
{
SricFAViewModel sfvm = (SricFAViewModel)objectData;
DataCaptYM = sfvm.DataCaptYM;
DeptID = "SRIC Agency";
formsViewModel.isSaveSuccessfully = sfvm.SaveSricFAData(action, out msg);
}
else
{
formsViewModel.isSaveSuccessfully = false;
}
}
else if (menu == DataAccess.Enum.Menu.SRIC.ToString())
{
if (objectData != null && typeof(SricDeptViewModel) == objectData.GetType())
{
SricDeptViewModel sdvm = (SricDeptViewModel)objectData;
DataCaptYM = sdvm.DataCaptYM;
DeptID = "SRIC";
formsViewModel.isSaveSuccessfully = sdvm.SaveSricDeptData(action, out msg);
}
else
{
formsViewModel.isSaveSuccessfully = false;
}
}
else if (menu == DataAccess.Enum.Menu.DOFAPEER.ToString())
{
if (objectData != null && typeof(DofaPeerViewModel) == objectData.GetType())
{
DofaPeerViewModel sdvm = (DofaPeerViewModel)objectData;
DataCaptYM = sdvm.DataCaptYM;
DeptID = "DOFA";
int EmpNo = 0;
string EmpName = string.Empty;
formsViewModel.isSaveSuccessfully = sdvm.SaveDofaPeerData(action, out msg, out EmpNo, out EmpName);
if (formsViewModel.isSaveSuccessfully && action.ToLower().Trim() == "save")
{
IsEmailSent = FormCommonMethods.SendEmailOnSaveForDOFAPeer(action, EmpNo, EmpName);
}
}
else
{
formsViewModel.isSaveSuccessfully = false;
}
}
else if (menu == DataAccess.Enum.Menu.TPDEPT.ToString())
{
if (objectData != null && typeof(TPDeptViewModel) == objectData.GetType())
{
TPDeptViewModel sdvm = (TPDeptViewModel)objectData;
DataCaptYM = sdvm.DataCaptYM;
DeptID = "TPDEPT";
formsViewModel.isSaveSuccessfully = sdvm.SaveTPDeptData(action, out msg);
}
else
{
formsViewModel.isSaveSuccessfully = false;
}
}
else if (menu == DataAccess.Enum.Menu.INFRA.ToString())
{
if (objectData != null && typeof(InfraViewModel) == objectData.GetType())
{
InfraViewModel sdvm = (InfraViewModel)objectData;
DataCaptYM = sdvm.DataCaptYM;
DeptID = "INFRA";
formsViewModel.isSaveSuccessfully = sdvm.SaveInfraData(action, out msg);
}
else
{
formsViewModel.isSaveSuccessfully = false;
}
}
else if (menu == DataAccess.Enum.Menu.DFNP.ToString())
{
if (objectData != null && typeof(DFNPViewModel) == objectData.GetType())
{
DFNPViewModel vm = (DFNPViewModel)objectData;
formsViewModel.isSaveSuccessfully = vm.SaveDFNPData(action, out msg);
}
else
{
formsViewModel.isSaveSuccessfully = false;
}
}
if (formsViewModel.isSaveSuccessfully && action.ToLower().Trim() != "save")
{
IsEmailSent = FormCommonMethods.SendFinallizeEmail(action, DataCaptYM, DeptID, needModificationMSG);
}
return(new Tuple <bool, bool?>(formsViewModel.isSaveSuccessfully, IsEmailSent));
}
public bool SaveInfraData(string action, out string msg)
{
msg = string.Empty;
bool success = false, IsInfraInfoVisible = false;
if (InfraDeptData == null || InfraDeptData.Count == 0)
{
return(success);
}
foreach (var item in InfraDeptData)
{
item.MenuID = DataAccess.Enum.Menu.INFRA.ToString();
item.DeptID = SessionManager.DeptID;
item.DataUser = SessionManager.UserName;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = FormCommonMethods.GetStatusByAction(action);
item.DataValid = "Y";
item.DataLocked = "N";
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
}
if (SessionManager.DeptID == "EW")
{
IsInfraInfoVisible = true;
foreach (var item in InfraInfoData)
{
item.MenuID = DataAccess.Enum.Menu.INFRA.ToString();
item.DataUser = SessionManager.UserName;
item.DeptID = SessionManager.DeptID;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = FormCommonMethods.GetStatusByAction(action);
item.DataValid = "Y";
item.DataLocked = "N";
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
item.InfraRemarks = SessionManager.UserName + " on " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
}
}
else
{
IsInfraInfoVisible = false;
InfraInfoData = new List <InfraInfo>();
InfraInfo item = new InfraInfo();
item.DeptID = SessionManager.DeptID;
item.MenuID = DataAccess.Enum.Menu.INFRA.ToString();
item.DataUser = SessionManager.UserName;
item.DataUpdatedOn = DateTime.Now;
item.DataCaptYM = SessionManager.DataCaptYR;
item.DataStatus = FormCommonMethods.GetStatusByAction(action);
item.DataValid = "Y";
item.DataLocked = "N";
item.DataStatusLog = SessionManager.UserName + " " + DateTime.Now.ToString("ddd, dd MMM yyyy HH:mm:ss");
InfraInfoData.Add(item);
}
try
{
FormsRepository formsRepository = new FormsRepository();
DataTable dtInfraInfo = null;
DataTable dtInfraDept = ToDataTable(InfraDeptData);
dtInfraInfo = ToDataTable(InfraInfoData);
success = formsRepository.UpdateBulkInfraFormData(dtInfraDept, dtInfraInfo, SessionManager.DataCaptYR, IsInfraInfoVisible);
}
catch (Exception ex)
{
}
return(success);
}
