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(); }
}
