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 string Delete(string[] ids, string connectionString) { using (var db = new OrmliteConnection().openConn(connectionString)) { using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted)) { try { foreach (var id in ids) { db.DeleteById <Property>(id); } dbTrans.Commit(); return("true"); } catch { dbTrans.Rollback(); return("false"); } } } }