public async Task <IActionResult> Edit(int id, [Bind("Id_rol,Rol,Descripcion")] tbl_Roles tbl_Roles)
{
if (id != tbl_Roles.Id_rol)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(tbl_Roles);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!tbl_RolesExists(tbl_Roles.Id_rol))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(tbl_Roles));
}
public void UpdateRole(RoleViewModel roleViewModel)
{
try
{
tbl_Roles tblRoles = new tbl_Roles();
tblRoles.RoleID = roleViewModel.roleId;
tblRoles.RoleName = roleViewModel.rolename;
if (!roleViewModel.status)
{
tblRoles.Active = false;
}
else
{
tblRoles.Active = true;
}
tblRoles.EntityState = DA.DomainModel.EntityState.Modified;
RoleManager roleManager = new RoleManager();
roleManager.UpdateRoles(tblRoles);
}
catch (Exception)
{
throw;
}
}
public ActionResult View(Guid id)
{
tbl_Roles role = _dataContext.tbl_Roles.Where(x => x.RoleName == "Employee").FirstOrDefault();
tbl_Users employee = _dataContext.tbl_Users.Where(x => x.Fk_RoleId == role.Pk_RoleId && x.Pk_UserId == id).FirstOrDefault();
return(View("~/Areas/user/Views/EmployeeList/ViewEmployee.cshtml", employee));
}
public ActionResult Index()
{
tbl_Roles role = _dataContext.tbl_Roles.Where(x => x.RoleName == "Employee").FirstOrDefault();
List <tbl_Users> lstUsers = _dataContext.tbl_Users.Where(x => x.Fk_RoleId == role.Pk_RoleId).ToList();
return(View(lstUsers));
}
public ActionResult View(Guid?id)
{
//check view client role
tbl_Roles role = _dataContext.tbl_Roles.Where(x => x.RoleName == "Client").FirstOrDefault();
tbl_Users client = _dataContext.tbl_Users.Where(x => x.Fk_RoleId == role.Pk_RoleId && x.Pk_UserId == id).FirstOrDefault();
return(View("~/Areas/user/Views/ClientList/ViewClient.cshtml", client));
}
public async Task <IActionResult> Create([Bind("Id_rol,Rol,Descripcion")] tbl_Roles tbl_Roles)
{
if (ModelState.IsValid)
{
_context.Add(tbl_Roles);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(tbl_Roles));
}
public void UpdateRoles(tbl_Roles tblRoles)
{
try
{
IGenericDataRepository <tbl_Roles> repository = new GenericDataRepository <tbl_Roles>();
repository.Update(tblRoles);
}
catch (Exception)
{
throw;
}
}
public tbl_Roles FindRoles(int?roleId)
{
try
{
IGenericDataRepository <tbl_Roles> repository = new GenericDataRepository <tbl_Roles>();
tbl_Roles roles = repository.GetSingle(c => c.RoleID == roleId);
return(roles);
}
catch (Exception)
{
throw;
}
}
public tbl_Roles FindRoleName(string roleName)
{
try
{
IGenericDataRepository <tbl_Roles> repository = new GenericDataRepository <tbl_Roles>();
tbl_Roles tblRole = repository.GetSingle(c => c.RoleName.ToUpper() == roleName.ToUpper());
return(tblRole);
}
catch (Exception)
{
throw;
}
}
public ActionResult activate(Guid id)
{
tbl_Users user = _dataContext.tbl_Users.Where(s => s.Pk_UserId == id).SingleOrDefault();
if (user != null)
{
user.IsActive = !(user.IsActive);
user.cpassword = user.Password;
if (ModelState.IsValid)
{
try
{
// save changes
_dataContext.SaveChanges();
}
catch (DbEntityValidationException dbValEx)
{
var outputLines = new StringBuilder();
foreach (var eve in dbValEx.EntityValidationErrors)
{
outputLines.AppendFormat("{0}: Entity of type \"{1}\" in state \"{2}\" has the following validation errors:"
, DateTime.Now, eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
outputLines.AppendFormat("- Property: \"{0}\", Error: \"{1}\""
, ve.PropertyName, ve.ErrorMessage);
}
}
throw new DbEntityValidationException(string.Format("Validation errors\r\n{0}"
, outputLines.ToString()), dbValEx);
}
}
}
tbl_Roles role = _dataContext.tbl_Roles.Where(x => x.RoleName == "Client").FirstOrDefault();
List <tbl_Users> lstUsers = _dataContext.tbl_Users.Where(x => x.Fk_RoleId == role.Pk_RoleId).ToList();
return(View("~/Areas/user/Views/ClientList/Index.cshtml", lstUsers));
}
public ActionResult Login(loginmodel userLogin)
{
// this is test code
var model = _dataContext.tbl_Users.Where(s => s.EmailId == userLogin.email && s.Password == userLogin.password && s.IsActive == true && s.IsBlocked == false).SingleOrDefault();
if (model == null)
{
TempData["LoginError"] = "Invalid username or password";
return(View());
}
else
{
clsSession.SessionID = Session.SessionID;
clsSession.UserID = model.Pk_UserId;
clsSession.RoleID = new Guid(model.Fk_RoleId.ToString());
clsSession.UserName = model.FirstName + " " + model.LastName;
clsSession.CityID = Convert.ToInt32(model.Fk_CityId);
clsSession.ImagePath = model.UserImage;
tbl_Roles role = _dataContext.tbl_Roles.Where(s => s.Pk_RoleId == model.Fk_RoleId).FirstOrDefault();
clsSession.RoleName = role.RoleName;
if (role.RoleName == "Employee")
{
return(RedirectToRoute("Employee_Home"));
}
if (role.RoleName == "Client")
{
return(RedirectToRoute("Client_Home"));
}
if (role.RoleName == "Admin")
{
return(RedirectToRoute("Admin_Home"));
}
return(RedirectToRoute("Employee_Home"));
}
}
public ActionResult Signup(tbl_Users model, FormCollection fc, HttpPostedFileBase profilephoto, HttpPostedFileBase Gov_IssueId, HttpPostedFileBase PoliceVerification, HttpPostedFileBase EligibleWorkId)
{
string type = Convert.ToString(fc["type"]);
if (type == "Employer")
{
tbl_Roles role = _dataContext.tbl_Roles.Where(s => s.RoleName == "Employee").FirstOrDefault();
model.Fk_RoleId = role.Pk_RoleId;
}
if (type == "Client")
{
tbl_Roles role = _dataContext.tbl_Roles.Where(s => s.RoleName == "Client").FirstOrDefault();
model.Fk_RoleId = role.Pk_RoleId;
}
model.Pk_UserId = Guid.NewGuid();
model.IsActive = false;
model.IsBlocked = false;
model.CreatedDate = DateTime.Now;
model.ModifiedDate = DateTime.Now;
model.Fk_CountryId = 38;
model.Country = "Canada";
model.State = _dataContext.StateMasters.Where(s => s.ID == model.Fk_StateId).SingleOrDefault().Name;
model.City = _dataContext.CityMasters.Where(s => s.ID == model.Fk_CityId).SingleOrDefault().Name;
if (ModelState.IsValid)
{
if (profilephoto != null)
{
var Image = Guid.NewGuid().ToString().Replace("-", "");
string extension = Path.GetExtension(profilephoto.FileName);
var path = Path.Combine(Server.MapPath("~/profile_photo/"), Image + extension);
profilephoto.SaveAs(path);
model.UserImage = Image + extension;
}
if (Gov_IssueId != null)
{
var Image = Guid.NewGuid().ToString().Replace("-", "");
string extension = Path.GetExtension(Gov_IssueId.FileName);
var path = Path.Combine(Server.MapPath("~/user_doc/"), Image + extension);
Gov_IssueId.SaveAs(path);
model.Gov_IssueId = Image + extension;
}
if (PoliceVerification != null)
{
var Image = Guid.NewGuid().ToString().Replace("-", "");
string extension = Path.GetExtension(PoliceVerification.FileName);
var path = Path.Combine(Server.MapPath("~/user_doc/"), Image + extension);
PoliceVerification.SaveAs(path);
model.PoliceVerification = Image + extension;
}
if (EligibleWorkId != null)
{
var Image = Guid.NewGuid().ToString().Replace("-", "");
string extension = Path.GetExtension(EligibleWorkId.FileName);
var path = Path.Combine(Server.MapPath("~/user_doc/"), Image + extension);
EligibleWorkId.SaveAs(path);
model.EligibleWorkId = Image + extension;
}
_dataContext.tbl_Users.Add(model);
_dataContext.SaveChanges();
}
else
{
ViewBag.StateList = _dataContext.StateMasters.Where(s => s.CountryID == 38).ToList().Select(s => new SelectListItem {
Text = s.Name, Value = s.ID.ToString()
});
return(View(model));
}
//For Send Mail...!!!
MailMessage message = new MailMessage(
"*****@*****.**", // From field
model.EmailId, // Recipient field
"Register Successfully", // Subject of the email message
PopulateBody(model.FirstName + "" + model.LastName) // Email message body
);
_sendemail.SendEmail(message);
return(RedirectToRoute("ThankYou"));
}
