public ActionResult AddUserToGroup(int id, string data) { IDbConnection db = new OrmliteConnection().openConn(); try { // Delete All User in Role db.Delete<Auth_UserInRole>(p => p.RoleID == id); // Add User Role if (!string.IsNullOrEmpty(data)) { string[] arr = data.Split(','); foreach (string item in arr) { var detail = new Auth_UserInRole(); detail.UserID = item; detail.RoleID = id; detail.RowCreatedAt = DateTime.Now; detail.RowCreatedBy = currentUser.UserID; db.Insert<Auth_UserInRole>(detail); } } return Json(new { success = true }); } catch (Exception e) { return Json(new { success = false, message = e.Message }); } finally { db.Close(); } }
public ActionResult AddUserToGroup(int id, string data) { IDbConnection db = new OrmliteConnection().openConn(); try { // Delete All User in Role db.Delete <Auth_UserInRole>(p => p.RoleID == id); // Add User Role if (!string.IsNullOrEmpty(data)) { string[] arr = data.Split(','); foreach (string item in arr) { var detail = new Auth_UserInRole(); detail.UserID = item; detail.RoleID = id; detail.RowCreatedAt = DateTime.Now; detail.RowCreatedBy = currentUser.UserID; db.Insert <Auth_UserInRole>(detail); } } return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult AddUserToGroup(string id, string data) { IDbConnection db = new OrmliteConnection().openConn(); try { // Delete All Group of User if (string.IsNullOrEmpty(id)) { return(Json(new { success = false, message = "Chọn người dùng trước khi thêm nhóm." })); } db.DeleteById <Auth_UserInRole>(id); // Add User Group if (!string.IsNullOrEmpty(data)) { string[] arr = data.Split(','); foreach (string item in arr) { var detail = new Auth_UserInRole(); detail.UserID = id; detail.RoleID = int.Parse(item); detail.RowCreatedAt = DateTime.Now; detail.RowCreatedBy = currentUser.UserID; db.Insert <Auth_UserInRole>(detail); } } return(Json(new { success = true })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult AddUserToGroup(string id, string data) { IDbConnection db = new OrmliteConnection().openConn(); try { // Delete All Group of User if (string.IsNullOrEmpty(id)) { return Json(new { success = false, message = "Chọn người dùng trước khi thêm nhóm."}); } db.DeleteById<Auth_UserInRole>(id); // Add User Group if (!string.IsNullOrEmpty(data)) { string[] arr = data.Split(','); foreach (string item in arr) { var detail = new Auth_UserInRole(); detail.UserID = id; detail.RoleID = int.Parse(item); detail.RowCreatedAt = DateTime.Now; detail.RowCreatedBy = currentUser.UserID; db.Insert<Auth_UserInRole>(detail); } } return Json(new { success = true }); } catch (Exception e) { return Json(new { success = false, message = e.Message }); } finally { db.Close(); } }
public ActionResult Registry(RegistryModel item) { IDbConnection db = new OrmliteConnection().openConn(); try { var isExist = db.FirstOrDefault <Auth_User>(p => p.UserID == item.UserName); item.Phone = !string.IsNullOrEmpty(item.Phone) ? item.Phone : ""; item.Email = !string.IsNullOrEmpty(item.Email) ? item.Email : ""; item.UserName = !string.IsNullOrEmpty(item.UserName) ? item.UserName : ""; if (isExist != null) { return(Json(new { success = false, message = "Người dùng đã tồn tại" })); } var user = new Auth_User(); user.UserID = item.UserName; user.DisplayName = item.UserName; user.Phone = item.Phone; user.Email = item.Email; user.IsActive = true; user.FullName = item.UserName; user.Password = SqlHelper.GetMd5Hash(item.Password); user.RowCreatedAt = DateTime.Now; user.RowCreatedBy = "CustomerRegistry"; user.Note = ""; db.Insert <Auth_User>(user); var detail = new Auth_UserInRole(); detail.UserID = item.UserName; detail.RoleID = 3; detail.RowCreatedAt = DateTime.Now; detail.RowCreatedBy = "CustomerRegistry"; db.Insert <Auth_UserInRole>(detail); return(Json(new { success = true, message = "Đăng ký thành công" })); } catch (Exception e) { return(Json(new { success = false, message = e.Message })); } finally { db.Close(); } }
public ActionResult Registry(RegistryModel item) { IDbConnection db = new OrmliteConnection().openConn(); try { var isExist = db.FirstOrDefault<Auth_User>(p => p.UserID == item.UserName); item.Phone = !string.IsNullOrEmpty(item.Phone) ? item.Phone : ""; item.Email = !string.IsNullOrEmpty(item.Email) ? item.Email : ""; item.UserName = !string.IsNullOrEmpty(item.UserName) ? item.UserName : ""; if (isExist != null) return Json(new { success = false, message = "Người dùng đã tồn tại" }); var user = new Auth_User(); user.UserID = item.UserName; user.DisplayName = item.UserName; user.Phone = item.Phone; user.Email = item.Email; user.IsActive = true; user.FullName = item.UserName; user.Password = SqlHelper.GetMd5Hash(item.Password); user.RowCreatedAt = DateTime.Now; user.RowCreatedBy = "CustomerRegistry"; user.Note = ""; db.Insert<Auth_User>(user); var detail = new Auth_UserInRole(); detail.UserID = item.UserName; detail.RoleID = 3; detail.RowCreatedAt = DateTime.Now; detail.RowCreatedBy = "CustomerRegistry"; db.Insert<Auth_UserInRole>(detail); return Json(new { success = true, message = "Đăng ký thành công" }); } catch (Exception e) { return Json(new { success = false, message = e.Message }); } finally { db.Close(); } }