/// <summary> /// /// </summary> /// <param name="permission"></param> /// <returns></returns> public async static Task<long> Insert(Permission permission) { string commandText = "Insert into Permissions (Id, Name, Description) values (@id, @name, @description)"; Dictionary<string, object> parameters = new Dictionary<string, object>(); if (permission.Id > 0) { parameters.Add("@id", permission.Id); } else { parameters.Add("@id", null); } parameters.Add("@name", permission.Name); parameters.Add("@description", permission.Description); long results; using (var conn = await DataAccessBase.GetOpenAsync(DataAccessBase.QuangAuthConn)) { var id = await conn.QueryAsync<long>(commandText, parameters); results = (long)id.Single(); } return results; }
public int Insert(Permission permission) { const string commandText = "Insert into Permissions (Id, Name, Description) values (@id, @name, @description)"; var parameters = new Dictionary<string, object>(); if (permission.Id > 0) parameters.Add("@id", permission.Id); else parameters.Add("@id", null); parameters.Add("@name", permission.Name); parameters.Add("@description", permission.Description); return _database.Execute(commandText, parameters); }
public int Update(Permission permission) { return _database.Execute("Update Permissions set Name = @name, Description = @description where Id = @id", new Dictionary<string, object> { { "@id", permission.Id }, { "@name", permission.Name }, { "@description", permission.Description } }); }
/// <summary> /// /// </summary> /// <param name="permission"></param> /// <returns></returns> public async static Task<long> Update(Permission permission) { return await PermissionDal.Update(permission); }
/// <summary> /// /// </summary> /// <param name="permission"></param> /// <returns></returns> public async static Task<long> Insert(Permission permission) { return await PermissionDal.Insert(permission); }
/// <summary> /// /// </summary> /// <param name="permission"></param> /// <returns></returns> public async static Task<long> Update(Permission permission) { string commandText = "Update Permissions set Name = @name, Description = @description where Id = @id"; Dictionary<string, object> parameters = new Dictionary<string, object>(); parameters.Add("@id", permission.Id); parameters.Add("@name", permission.Name); parameters.Add("@description", permission.Description); long results; using (var conn = await DataAccessBase.GetOpenAsync(DataAccessBase.QuangAuthConn)) { var id = await conn.ExecuteAsync(commandText, parameters); results = id; } return results; }
public Permission GetOnePermission(int permissionId) { var permission = (Permission)null; List<Dictionary<string, string>> list = _database.Query("Select * from Permissions where Id = @id", new Dictionary<string, object> { { "@id", permissionId } }); if (list != null && list.Count == 1) { var dictionary = list[0]; permission = new Permission { Id = int.Parse(dictionary["Id"]), Name = string.IsNullOrEmpty(dictionary["Name"]) ? null : dictionary["Name"], Description = string.IsNullOrEmpty(dictionary["Description"]) ? null : dictionary["Description"] }; } return permission; }