// GET: WEBUSERS
public async Task<ActionResult> Index()
{
RegViewModel vModel = new RegViewModel();
var branchSql = await (from a in db.M_BRANCH select a).ToListAsync();
var regionSql = await (from b in db.M_REGION select b).ToListAsync();
//vModel._list = new Dictionary<string, string>();
//vModel._listRegion = new Dictionary<string, string>();
GlobalVar.BranchList = new Dictionary<string, string>();
GlobalVar.RegionList = new Dictionary<string, string>();
foreach (var r in branchSql)
{
GlobalVar.BranchList.Add(r.BRANCH_CODE, r.BRANCH_NAME);
}
foreach (var rw in regionSql)
{
GlobalVar.RegionList.Add(rw.CODE, rw.REGION_NAME);
}
vModel._list = GlobalVar.BranchList;
vModel._listRegion = GlobalVar.RegionList;
vModel.isError = 0;
return View(vModel);
}
public async Task<ActionResult> Index(string uname, string password)
{
if (string.IsNullOrEmpty(uname) || string.IsNullOrEmpty(password))
{
ViewBag.errMessage = "Invalid Credentials";
return View();
}
myEncrypt.lscryptoKey = "ITDept6953069";
string tempPass = myEncrypt.psEncrypt(password, myElement).ToString();
var userSQL = await (from a in db.TBL_WEBUSERS where (a.USERNAME == uname && a.PASSWORD == tempPass && a.ACTIVE == true && a.COMP == "MLY") || (a.USERNAME == uname && a.SHA_PASSWORD == password && a.ACTIVE == true && a.COMP == "MLY") select a).ToListAsync();
if (userSQL.Count > 0)
{
if (!string.IsNullOrEmpty(userSQL[0].PASSWORD))
{
if (userSQL[0].PASSWORD == password)
{
Session["UName"] = userSQL[0].USERNAME;
Session["LoggedUserId"] = userSQL[0].USER_ID;
Session["LName"] = userSQL[0].FIRSTNAME;
Session["LoggedRegion"] = userSQL[0].REGION;
Session["BranchCode"] = userSQL[0].BRANCH_CODE;
Session["UserType"] = userSQL[0].USER_TYPE;
return RedirectToAction("Index", "Home");
}
}
else
{
if (userSQL[0].SHA_PASSWORD == password)
{
Session["UName"] = userSQL[0].USERNAME;
Session["LoggedUserId"] = userSQL[0].USER_ID;
Session["LName"] = userSQL[0].FIRSTNAME;
Session["LoggedRegion"] = userSQL[0].REGION;
Session["BranchCode"] = userSQL[0].BRANCH_CODE;
Session["UserType"] = userSQL[0].USER_TYPE;
return RedirectToAction("Index", "Home");
}
}
Session["UName"] = userSQL[0].USERNAME;
Session["LoggedUserId"] = userSQL[0].USER_ID;
Session["LName"] = userSQL[0].FIRSTNAME;
Session["LoggedRegion"] = userSQL[0].REGION;
Session["BranchCode"] = userSQL[0].BRANCH_CODE;
Session["UserType"] = userSQL[0].USER_TYPE;
return RedirectToAction("Index", "Home");
}
else
{
RegViewModel vmod = new RegViewModel();
vmod._list = GlobalVar.BranchList;
vmod._listRegion = GlobalVar.RegionList;
vmod.isError = 2;
vmod.errMessage = "Invalid Credentials";
ViewBag.errMessage = "Invalid Credentials";
return View(vmod);
}
}
public async Task<ActionResult> Create(RegViewModel tblUser) //[Bind(Include = "lastname,firstname,middlename,address,username,contactno,email,region,city")
//string lname, string fname, string mname, string nostreet, string city, string region, string uname, string password, string cpassword, string email
{
RegViewModel vmodel = new RegViewModel();
TBL_WEBUSERS tbl = new TBL_WEBUSERS();
if (ModelState.IsValid)
{
TBL_WEBUSERS ifExist = await db.TBL_WEBUSERS.FirstOrDefaultAsync(m => m.USERNAME == tblUser.username);
if (!(ifExist == null))
{
vmodel._list = GlobalVar.BranchList;
vmodel._listRegion = GlobalVar.RegionList;
vmodel.isError = 2;
vmodel.errMessage = "Username already taken. Kindly choose different username.";
return View(vmodel);
}
ifExist = await db.TBL_WEBUSERS.FirstOrDefaultAsync(m => m.EMAIL == tblUser.email);
if (!(ifExist == null))
{
vmodel._list = GlobalVar.BranchList;
vmodel._listRegion = GlobalVar.RegionList;
vmodel.isError = 2;
vmodel.errMessage = "Email already registered. Please choose different email address or use password recovery system.";
return View(vmodel);
}
tbl.LASTNAME = tblUser.lastname;
tbl.FIRSTNAME = tblUser.firstname;
tbl.MIDDLENAME = tblUser.middlename;
tbl.MAILING_ADDRESS = tblUser.address;
tbl.CITY = tblUser.city;
tbl.COMP = "MLY";
tbl.REGION = tblUser.region;
tbl.USERNAME = tblUser.username;
tbl.CONTACT_NUMBER = tblUser.contactno;
//tbl.PASSWORD = password;
tbl.USER_CODE = Yfunction.generateSerial(9, "ITDept6953069");
tbl.SHA_PASSWORD = Yfunction.generateRandomString(12, "ITDept6953069");
if (!string.IsNullOrEmpty(tblUser.email))
{
tbl.EMAIL = tblUser.email;
//shaPass = Yfunction.generateRandomString(12, myElement);
}
DateTime now = DateTime.Now;
tbl.DATE_REGISTERED = now;
//tbl.BRANCH_CODE = tblUser.bCode;
tbl.USER_TYPE = "CLIENT";
tbl.BRANCH_CODE = "HardCoded Branch Code";
db.TBL_WEBUSERS.Add(tbl);
await db.SaveChangesAsync();
string tempname = tbl.FIRSTNAME + " " + tbl.LASTNAME;
string _bod = string.Format("Dear Sir/Madam {0}, <BR/><BR/> Your account is now registered to RCTPL Web App. Thank you. <BR/> Please click on the link to activate your registration: <a href=\"https://" + WebConfigurationManager.AppSettings["ServerIP"] + "/WEBUSERS/CompletingRegistration/{1}/{2}\">Activate Registration</a> <br/><br/>Username: {3} <br/>Password: {4} <br/><br/> Kindly replace your temporary password as soon as you login. <br/>Thank you!", tempname, tbl.USERNAME, tbl.SHA_PASSWORD, tbl.USERNAME, tbl.SHA_PASSWORD);
sendEmail("RCTPL Web Registration", "Registration Confirmation", _bod, tblUser.email);
vmodel._list = GlobalVar.BranchList;
vmodel._listRegion = GlobalVar.RegionList;
vmodel.isError = 1;
return View(vmodel);
}
vmodel._list = GlobalVar.BranchList;
vmodel._listRegion = GlobalVar.RegionList;
vmodel.isError = 2;
vmodel.errMessage = "Something went wrong. Please click Register again for details.";
return View(vmodel);
}
// GET: Registration of new user
public ActionResult Create()
{
RegViewModel vModel = new RegViewModel();
vModel._list = GlobalVar.BranchList;
vModel._listRegion = GlobalVar.RegionList;
vModel.isError = 0;
return View(vModel);
}