public async Task <RoleListDTO> GetSavedModelAsync(RoleListDTO model)
{
var newModel = new RoleListDTO
{
Caption = model.Caption,
IsActive = model.IsActive
};
var newId = DataService.Add <Role>(newModel);
//await DataService.SaveChangesAsync();
var roleRightList = await DataService.GetDtoAsync <RoleRightListDTO>(x => x.RoleId == model.Id);
foreach (var roleRight in roleRightList)
{
DataService.Add <RoleRight>(new RoleRightListDTO()
{
RoleId = newId,
RightId = roleRight.RightId
});
}
await DataService.SaveChangesAsync();
var savedModel = (await DataService.GetDtoAsync <RoleListDTO>(x => x.Id == newId)).FirstOrDefault();
return(savedModel);
}
public void tblRoleList_insert(RoleListDTO dt)
{
string sql = "INSERT INTO tblRoleList(roleId, roleName) " +
"VALUES(@roleId, @roleName)";
SqlCommand cmd = new SqlCommand(sql, ConnectionData._MyConnection);
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@roleId", SqlDbType.Int).Value = dt.roleId;
cmd.Parameters.Add("@roleName", SqlDbType.Int).Value = dt.roleName;
cmd.ExecuteNonQuery();
cmd.Dispose();
}
public void tblRoleList_insert(RoleListDTO dt)
{
rlDao.tblRoleList_insert(dt);
}
