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