public tbl_UserRole AddRole(tbl_UserRole role)
{
role.CreatedUtc = Clock.UtcDateTime;
_context.Set<tbl_UserRole>().Add(role);
return role;
}
public ActionResult userRoleDelete(int id = 0)
{
tbl_UserRole bc1 = db.tbl_UserRole.FirstOrDefault(s => s.UserRoleID == id);
db.tbl_UserRole.Remove(bc1);
db.SaveChanges();
return(RedirectToAction("userRoleList"));
}
public static Role Map(tbl_UserRole role)
{
Role ret = new User.Role();
ret.Deleted = role.Deleted;
ret.ID = role.ID;
ret.Name = role.Name;
return(ret);
}
public tbl_UserRole Map()
{
tbl_UserRole ret = new tbl_UserRole();
ret.ID = this.ID;
ret.Name = this.Name;
ret.Deleted = this.Deleted;
return(ret);
}
public ActionResult addUserRole(tbl_UserRole userRole)
{
if (ModelState.IsValid)
{
db.tbl_UserRole.Add(userRole);
db.SaveChanges();
return(RedirectToAction("userRoleList"));
}
return(View(userRole));
}
internal int UpdateRole(tbl_UserRole userRoleObj, int roleId)
{
int rId = Convert.ToInt32(roleId);
tbl_UserRole roleObj = _context.tbl_UserRole.First(x => x.RoleID == rId);
roleObj.RoleName = userRoleObj.RoleName;
roleObj.EditDate = userRoleObj.EditDate;
roleObj.EditUser = userRoleObj.EditUser;
_context.SaveChanges();
return(1);
}
public ActionResult userRoleUpdate(int id = 0)
{
userRolId = id;
tbl_UserRole bc = db.tbl_UserRole.FirstOrDefault(s => s.UserRoleID == userRolId);
if (bc == null)
{
return(HttpNotFound());
}
ViewBag.GetUserRoleName = bc.UserRoleName;
return(View(bc));
}
public ActionResult userRoleUpdate(tbl_UserRole bc, int id = 0)
{
tbl_UserRole bc1 = db.tbl_UserRole.FirstOrDefault(s => s.UserRoleID == userRolId);
bc1.UserRoleName = bc.UserRoleName;
if (bc1 == null)
{
return(HttpNotFound());
}
db.SaveChanges();
ViewBag.Message = "Update Succesfully";
return(View(bc1));
}
internal int SaveRole(tbl_UserRole userRoleObj)
{
try
{
_context.tbl_UserRole.AddObject(userRoleObj);
_context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
public ActionResult Signup(UserViewModel uvm)
{
tbl_User tb = new tbl_User();
tb.username = uvm.username;
tb.password = uvm.password;
tb.email = uvm.email;
tb.fullname = uvm.fullname;
_db.tbl_User.Add(tb);
_db.SaveChanges();
tbl_UserRole utb = new tbl_UserRole();
int userID = tb.userID;
int roleID = 2;
utb.userID = userID;
utb.roleID = roleID;
_db.tbl_UserRole.Add(utb);
_db.SaveChanges();
return(RedirectToAction("Login"));
}
public ActionResult Signup(UserViewModel uv)
{
tbl_User tbl = _db.tbl_User.Where(u => u.username == uv.username).FirstOrDefault();
if (tbl != null)
{
return(Json(new { success = false, message = "User Already Register" }, JsonRequestBehavior.AllowGet));
}
else
{
tbl_User tb = new tbl_User();
tb.username = uv.username;
tb.password = uv.password;
_db.tbl_User.Add(tb);
_db.SaveChanges();
tbl_UserRole ud = new tbl_UserRole();
ud.userID = tb.userID;
ud.userroleID = 2;
_db.tbl_UserRole.Add(ud);
_db.SaveChanges();
return(Json(new { success = true, message = "User Register Successfully" }, JsonRequestBehavior.AllowGet));
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
tbl_UserRole userRoleObj = new tbl_UserRole();
userRoleObj.RoleName = txtbxRoleName.Text;
userRoleObj.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
userRoleObj.EditDate = DateTime.Now;
if (BtnSave.Text == "Save Role")
{
int result = roleDal.SaveRole(userRoleObj);
if (result == 1)
{
// lblStatus.Text = "Data Save Successfully";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Saved Successfully')", true);
}
}
else
{
int roleId = Convert.ToInt32(hidRoleId.Value);
int result = roleDal.UpdateRole(userRoleObj, roleId);
if (result == 1)
{
// lblStatus.Text = "Data Update Successfully";
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Data Update Successfully')", true);
}
}
getRoles();
txtbxRoleName.Text = "";
BtnSave.Text = "Save Role";
}
catch (Exception)
{
throw;
}
}
public tbl_UserRole RemoveRole(tbl_UserRole role)
{
_context.Set<tbl_UserRole>().Remove(role);
return role;
}
public ActionResult EditUser(string id, tbl_User tbl_User, string selectedItems)
{
using (var _context = new Entities())
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
if (!ModelState.IsValid)
{
UserRoleViewModel vm = new UserRoleViewModel()
{
RolesModel_list = _context.tbl_Role.Select(x => new RolesModel
{
RoleId = x.RoleId,
Name = x.Name,
}).ToList(),
_tbl_Unit = _context.tbl_Unit.ToList(),
};
return(PartialView("_CreateUser", vm));
}
List <UserRoleModel> items = (new JavaScriptSerializer()).Deserialize <List <UserRoleModel> >(selectedItems);
if (tbl_User.Pno != null)
{
string password = string.Empty;
using (var newCOntext = new Entities())
{
var previousUser = newCOntext.tbl_User.FirstOrDefault(x => x.UserId == tbl_User.Pno);
password = previousUser.Password;
}
string pwd = password;
tbl_User.UserId = tbl_User.Pno;
tbl_User.Password = pwd;
_context.Entry(tbl_User).State = EntityState.Modified;
_context.SaveChanges();
_context.tbl_UserRole.RemoveRange(_context.tbl_UserRole.Where(x => x.UserId == id));
_context.SaveChanges();
if (items[0].RoleId != "")
{
foreach (var data in items)
{
if (data != null)
{
var obj = new tbl_UserRole()
{
UserId = tbl_User.UserId,
RoleId = data.RoleId,
IsDefault = data.IsDefault
};
_context.tbl_UserRole.Add(obj);
}
}
_context.SaveChanges();
}
#region User Injection
var UserName = tbl_User.UserId;
ApplicationUser result = UserManager.FindById(UserName);
// Was a password sent across?
if (result != null && !string.IsNullOrEmpty(tbl_User.Password))
{
// Remove current password
var removePassword = UserManager.RemovePassword(result.Id);
if (removePassword.Succeeded)
{
// Add new password
var AddPassword =
UserManager.AddPassword(
result.Id,
tbl_User.Password
);
if (AddPassword.Succeeded)
{
transaction.Commit();
}
else
{
transaction.Rollback();
throw new Exception(AddPassword.Errors.FirstOrDefault());
}
}
else
{
transaction.Rollback();
throw new Exception("Some error occured.");
}
}
else
{
transaction.Commit();
}
#endregion
}
return(RedirectToAction("UserIndex"));
}
catch (Exception ex)
{
transaction.Rollback();
return(RedirectToAction("UserIndex"));
}
}
}
}
public ActionResult CreateUser(tbl_User tbl_User, tbl_Role tbl_Role)
{
using (var _context = new Entities())
{
using (var transaction = _context.Database.BeginTransaction())
{
try
{
string password = string.Empty;
if (tbl_User.Pno != null)
{
password = "******" + tbl_User.Pno.Trim();
}
if (!ModelState.IsValid)
{
UserRoleViewModel vm = new UserRoleViewModel()
{
_tbl_Role = _context.tbl_Role.ToList(),
_tbl_Unit = _context.tbl_Unit.ToList(),
};
return(PartialView("_CreateUser", vm));
}
if (tbl_User.Pno != null)
{
tbl_User.UserId = tbl_User.Pno;
tbl_User.Password = password;
_context.tbl_User.Add(tbl_User);
_context.SaveChanges();
if (tbl_Role.RoleId != null)
{
var obj = new tbl_UserRole()
{
UserId = tbl_User.UserId,
RoleId = tbl_Role.RoleId,
IsDefault = 1,
IsActive = 1,
};
_context.tbl_UserRole.Add(obj);
_context.SaveChanges();
}
}
#region User Injection
var UserName = tbl_User.UserId;
var Password = password;
var objNewAdminUser = new ApplicationUser {
Id = tbl_User.UserId, UserName = tbl_User.UserId, Email = tbl_User.UserId
};
var AdminUserCreateResult = UserManager.Create(objNewAdminUser, Password);
if (AdminUserCreateResult.Succeeded)
{
transaction.Commit();
}
else
{
transaction.Rollback();
}
#endregion
return(RedirectToAction("UserIndex"));
}
catch (Exception ex)
{
transaction.Rollback();
// Exception(ex);
// Alert("Their is something went wrong!!!", NotificationType.error);
return(RedirectToAction("UserIndex"));
}
}
}
}
