public async Task <IActionResult> Edit(int id, [Bind("Id,Name,Username,Password,ProfilePicture,Contact,Email,Role,Status,Gender,Address,Extras,CreatedBy,CreatedDate,ModifiedBy,ModifiedDate")] Systemusers systemusers)
{
if (id != systemusers.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(systemusers);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!SystemusersExists(systemusers.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(systemusers));
}
public async Task <IActionResult> Create([Bind("Id,Name,Username,Password,ProfilePicture,Contact,Email,Role,Status,Gender,Address,Extras,CreatedBy,CreatedDate,ModifiedBy,ModifiedDate")] Systemusers systemusers)
{
if (ModelState.IsValid)
{
_context.Add(systemusers);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(systemusers));
}
public IActionResult SignIn(Systemusers systemUser, string returnUrl = null)
{
if (systemUser.UserCode != null && systemUser.UserCode != "")
{
var result = _mainSystemContext.Systemusers.Where(s => s.UserCode == systemUser.UserCode).FirstOrDefault();
if (result != null)
{
string userPass = dbSecurity.MD5(systemUser.UserPassword);
if (result.UserPassword == userPass)
{
HttpContext.Session.SetString("UserCode", result.UserCode);
var _systemuserroles = _mainSystemContext.Systemuserroles.FirstOrDefault(a => a.UserCode == result.UserCode && a.DefaultCompany == 1);
HttpContext.Session.SetString("Role", _systemuserroles.RoleId);
HttpContext.Session.SetString("CompanyCode", _systemuserroles.CompanyCode);
string roles = HttpContext.Session.GetString("Role");
List <Systemusermenu> SystemUserMenus = _mainSystemContext.Systemusermenu.Where(s => s.RoleId == roles && s.CompanyCode == _systemuserroles.CompanyCode).OrderBy(a => a.SeqNo).ToList();
DataSet ds = new DataSet();
ds = ToDataSet(SystemUserMenus);
DataTable table = ds.Tables[0];
DataRow[] parentMenus = table.Select("ParentId = 1");
var sb = new StringBuilder();
string menuString = GenerateUL(parentMenus, table, sb);
HttpContext.Session.SetString("menuString", menuString);
HttpContext.Session.SetString("menus", JsonConvert.SerializeObject(SystemUserMenus));
//get role and object ID
List <Systempermission> systempermissions = _mainSystemContext.Systempermission.Where(a => a.RoleId == roles).ToList();
List <Systemobject> systemobjects = _mainSystemContext.Systemobject.ToList();
HttpContext.Session.SetString("permissions", JsonConvert.SerializeObject(systempermissions));
HttpContext.Session.SetString("object", JsonConvert.SerializeObject(systemobjects));
return(Json(new { status = true, message = "Login Successfull!", returnUrl = returnUrl }));
}
else
{
return(Json(new { status = false, message = "Invalid Password!" }));
}
}
else
{
return(Json(new { status = false, message = "User Not Found!" }));
}
}
else
{
return(Json(new { status = false, message = "Invalid UserName!" }));
}
}
public IActionResult Login(Systemusers U)
{
Systemusers _U = _context.Systemusers.Where(abc => abc.Username == U.Username && abc.Password == U.Password).FirstOrDefault <Systemusers>();
if (_U != null)
{
HttpContext.Session.SetString("Username", _U.Username);
HttpContext.Session.SetString("Role", _U.Role);
Response.Cookies.Append("LLT", DateTime.Now.ToString());
return(RedirectToAction(nameof(Index), "Categories"));
}
else
{
ViewBag.Message = "Invalid Details";
return(View());
}
return(View());
}
