public Result <object> SetDevicesForUpdate(List <long> loginIdList) { var result = new Result <object>(); try { if (loginIdList == null || !loginIdList.Any()) { throw new Exception("Пустой список устройств для обновления"); } using (var ctx = new PolicyProjectEntities()) { foreach (var loginDevice in ctx.tbl_login_devices.Where(x => loginIdList.Contains(x.id_login))) { loginDevice.need_update_device = true; } result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка сохранения списка устройств для обновления. ", ex.Message); } return(result); }
public string UpdateLoginDevicesRest(LoginDevicesDataContract loginDevice) { var result = new Result <object>(); try { using (var ctx = new PolicyProjectEntities()) { var existed = ctx.tbl_login_devices.FirstOrDefault( x => x.id_device == loginDevice.DeviceId && x.id_login == loginDevice.LoginId); if (existed == null) { throw new Exception(string.Concat("Не найдено устройство с ИД ", loginDevice.DeviceId, ", принадлежащий логину с ИД ", loginDevice.LoginId)); } existed.need_update_device = loginDevice.NeedUpdateDevice; result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка обновления статуса устройства. ", ex.Message); } return(JsonConvert.SerializeObject(result)); }
public Result <object> DeletePolicySet(PolicySetDataContract policySet) { var result = new Result <object>(); try { if (policySet == null) { throw new Exception("Hабор политик не задан"); } using (var ctx = new PolicyProjectEntities()) { var delPolicySet = ctx.tbl_policy_set.FirstOrDefault(x => x.id == policySet.PolicySetId); ctx.tbl_policy_set.Remove(delPolicySet); result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка удаления наборa политик. ", ex.Message); } return(result); }
public Result <object> AddUser(UserDataContract user) { var result = new Result <object>(); try { if (user == null) { throw new Exception("Новый пользователь не задан"); } using (var ctx = new PolicyProjectEntities()) { user.UserId = ctx.tbl_user.Any() ? ctx.tbl_user.Max(x => x.id) + 1 : 1; var newUser = UserDataContract.FromUserDataContractToTblUser(user); ctx.tbl_user.Add(newUser); result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка добавления пользователя. ", ex.Message); } return(result); }
public Result <object> AddEventLog(EventLogDataContract eventLog) { var result = new Result <object>(); try { if (eventLog == null) { throw new Exception("Новая запись лога не задана"); } using (var ctx = new PolicyProjectEntities()) { eventLog.EventLogId = ctx.tbl_activity_log.Any() ? ctx.tbl_activity_log.Max(x => x.id) + 1 : 1; var newEventLog = EventLogDataContract.FromEventLogDataContractToTblEventLog(eventLog); newEventLog.log_date = DateTime.Now; ctx.tbl_activity_log.Add(newEventLog); result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка добавления записи лога. ", ex.Message); } return(result); }
public Result <object> DeleteLogin(LoginDataContract login) { var result = new Result <object>(); try { if (login == null) { throw new Exception("Логин не задан"); } using (var ctx = new PolicyProjectEntities()) { var delLogin = ctx.tbl_login.FirstOrDefault(x => x.id == login.LoginId); ctx.tbl_login.Remove(delLogin); result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка удаления логина. ", ex.Message); } return(result); }
public Result <Dictionary <long, long[]> > GetLoginIdAndDeviceIdDct() { var result = new Result <Dictionary <long, long[]> >(); try { using (var ctx = new PolicyProjectEntities()) { var devices = from dev in ctx.tbl_login_devices group dev by dev.id_login into selectedDevice select new { LoginId = selectedDevice.Key, DevIds = selectedDevice.Select(x => x.id_device) }; var resultDct = new Dictionary <long, long[]>(); foreach (var devs in devices) { resultDct.Add(devs.LoginId, devs.DevIds.ToArray()); } result.SomeResult = resultDct; result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка удаления наборa политик. ", ex.Message); } return(result); }
public Result <object> AddPolicySet(PolicySetDataContract policySet) { var result = new Result <object>(); try { if (policySet == null) { throw new Exception("Новый набор политик не задан"); } using (var ctx = new PolicyProjectEntities()) { policySet.PolicySetId = ctx.tbl_policy_set.Any() ? ctx.tbl_policy_set.Max(x => x.id) + 1 : 1; var newPolicySet = PolicySetDataContract.FromPolicySetDataContractToTblPolicySet(policySet); ctx.tbl_policy_set.Add(newPolicySet); result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка добавления набора политик. ", ex.Message); } return(result); }
public Result <object> DeleteDevice(DeviceInfoDataContract device) { var result = new Result <object>(); try { if (device == null) { throw new Exception("Yстройство не задано"); } using (var ctx = new PolicyProjectEntities()) { var delDevice = ctx.tbl_device_info.FirstOrDefault(x => device.DeviceId == x.id); ctx.tbl_device_info.Remove(delDevice); result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка удаления устройствa. ", ex.Message); } return(result); }
public Result <PolicySetDataContract[]> GetPolicySetForGroup(int groupId) { var result = new Result <PolicySetDataContract[]>(); try { using (var ctx = new PolicyProjectEntities()) { result.SomeResult = ctx.tbl_policy_set.Where(x => x.id_group == groupId) .Select( policySetTblData => new PolicySetDataContract { PolicySetId = policySetTblData.id, PolicyId = policySetTblData.id_policy, PolicyParam = policySetTblData.policy_param }).ToArray(); result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения набора политик. ", ex.Message); } return(result); }
public Result <object> AddDevice(DeviceInfoDataContract device) { var result = new Result <object>(); try { if (device == null) { throw new Exception("Новое устройство не задано"); } using (var ctx = new PolicyProjectEntities()) { device.DeviceId = ctx.tbl_device_info.Any() ? ctx.tbl_device_info.Max(x => x.id) + 1 : 1; var newDevice = DeviceInfoDataContract.FromDeviceInfoDataContractToTblDeviceInfo(device); ctx.tbl_device_info.Add(newDevice); result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка добавления устройствa. ", ex.Message); } return(result); }
public Result <object> DeleteEvent(EventDataContract evnt) { var result = new Result <object>(); try { if (evnt == null) { throw new Exception("Событие не задано"); } using (var ctx = new PolicyProjectEntities()) { var delEvent = ctx.tbl_event.FirstOrDefault(x => x.id == evnt.EventId); ctx.tbl_event.Remove(delEvent); result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка удаления события. ", ex.Message); } return(result); }
public Result <object> DeleteUser(UserDataContract user) { var result = new Result <object>(); try { if (user == null) { throw new Exception("Пользователь не задан"); } using (var ctx = new PolicyProjectEntities()) { var delUser = ctx.tbl_user.FirstOrDefault(x => x.id == user.UserId); ctx.tbl_user.Remove(delUser); result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка удаления пользователя. ", ex.Message); } return(result); }
public Result <string[]> GetCertificate(long loginId) { var result = new Result <string[]>(); try { using (var ctx = new PolicyProjectEntities()) { var login = ctx.tbl_login.FirstOrDefault(x => x.id == loginId); if (login == null) { throw new Exception("Логин не найден"); } result.SomeResult = new[] { login.login, login.certificate }; result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения сертификата. ", ex.Message); } return(result); }
public Result <object> DeleteEventLog(DateTime fromDate, DateTime?toDate, int?eventId) { var result = new Result <object>(); try { using (var ctx = new PolicyProjectEntities()) { var finalDate = (toDate ?? DateTime.Now).AddDays(1); var logForDelete = ctx.tbl_activity_log.Where(x => x.log_date >= fromDate && x.log_date <= finalDate); if (eventId != null) { logForDelete = logForDelete.Where(x => x.id_event == eventId); } foreach (var log in logForDelete) { ctx.tbl_activity_log.Remove(log); } result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка удаления лога событий. ", ex.Message); } return(result); }
public Result <object> DeleteGroup(GroupDataContract group) { var result = new Result <object>(); try { if (group == null) { throw new Exception("Группа не задана"); } using (var ctx = new PolicyProjectEntities()) { var delGroup = ctx.tbl_group.FirstOrDefault(x => x.id == group.GroupId); ctx.tbl_group.Remove(delGroup); result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка удаления группы. ", ex.Message); } return(result); }
public Result <DeviceInfoDataContract[]> GetDevice(DeviceInfoDataContract deviceFilter) { var result = new Result <DeviceInfoDataContract[]>(); try { using (var ctx = new PolicyProjectEntities()) { if (deviceFilter == null) { result.SomeResult = ctx.tbl_device_info.Select( deviceTblData => new DeviceInfoDataContract { DeviceId = deviceTblData.id, DeviceName = deviceTblData.device_name, DeviceSerialNumber = deviceTblData.device_serial_number, DevicePlatformId = deviceTblData.device_platform_id, DeviceIpAddress = deviceTblData.device_ip_addr, DeviceMacAddress = deviceTblData.device_mac_addr, DevicePlatformName = ctx.tbl_platform.FirstOrDefault(x => x.id == deviceTblData.device_platform_id) .platform_name }).ToArray(); } else { result.SomeResult = ctx.tbl_device_info.Where(x => x.id == deviceFilter.DeviceId || x.device_serial_number.Equals( deviceFilter.DeviceSerialNumber, StringComparison .InvariantCultureIgnoreCase)) .Select(deviceTblData => new DeviceInfoDataContract { DeviceId = deviceTblData.id, DeviceName = deviceTblData.device_name, DeviceSerialNumber = deviceTblData.device_serial_number, DevicePlatformId = deviceTblData.device_platform_id, DeviceIpAddress = deviceTblData.device_ip_addr, DeviceMacAddress = deviceTblData.device_mac_addr, DevicePlatformName = ctx.tbl_platform.FirstOrDefault(x => x.id == deviceTblData.device_platform_id) .platform_name }) .ToArray(); } result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения списка устройств. ", ex.Message); } return(result); }
public Result <EventLogDataContract[]> GetEventLog(EventLogDataContract eventLogFilter) { var result = new Result <EventLogDataContract[]>(); try { using (var ctx = new PolicyProjectEntities()) { if (eventLogFilter == null) { result.SomeResult = ctx.tbl_activity_log.Select( eventLogTblData => new EventLogDataContract { EventLogId = eventLogTblData.id, EventLogDate = eventLogTblData.log_date, EventId = eventLogTblData.id_event, Login = eventLogTblData.login, Device = eventLogTblData.device, DocumentId = eventLogTblData.id_document, Message = eventLogTblData.message, EventName = ctx.tbl_event.FirstOrDefault(x => x.id == eventLogTblData.id_event).event_name }).ToArray(); } else { result.SomeResult = ctx.tbl_activity_log.Where(x => x.id == eventLogFilter.EventLogId) .Select(eventLogTblData => new EventLogDataContract { EventLogId = eventLogTblData.id, EventLogDate = eventLogTblData.log_date, EventId = eventLogTblData.id_event, Login = eventLogTblData.login, Device = eventLogTblData.device, DocumentId = eventLogTblData.id_document, Message = eventLogTblData.message, EventName = ctx.tbl_event.FirstOrDefault(x => x.id == eventLogTblData.id_event).event_name }) .ToArray(); } result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения лога событий. ", ex.Message); } return(result); }
public Result <PolicySetDataContract[]> GetPolicySet(PolicySetDataContract policySetFilter) { var result = new Result <PolicySetDataContract[]>(); try { using (var ctx = new PolicyProjectEntities()) { if (policySetFilter == null) { result.SomeResult = ctx.tbl_policy_set.Select( policySetTblData => new PolicySetDataContract { PolicySetId = policySetTblData.id, PolicyId = policySetTblData.id_policy, LoginId = policySetTblData.id_login, GroupId = policySetTblData.id_group, Selected = policySetTblData.selected, PolicyParam = policySetTblData.policy_param }) .ToArray(); } else { result.SomeResult = ctx.tbl_policy_set.Where( x => (policySetFilter.PolicyId > 0 && x.id_policy == policySetFilter.PolicyId) || (policySetFilter.LoginId > 0 && x.id_login == policySetFilter.LoginId) || (policySetFilter.GroupId > 0 && x.id_group == policySetFilter.GroupId)) .Select( policySetTblData => new PolicySetDataContract { PolicySetId = policySetTblData.id, PolicyId = policySetTblData.id_policy, LoginId = policySetTblData.id_login, GroupId = policySetTblData.id_group, Selected = policySetTblData.selected, PolicyParam = policySetTblData.policy_param }).ToArray(); } result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения набора политик. ", ex.Message); } return(result); }
public Result <PolicyDataContract[]> GetPolicy(PolicyDataContract policyFilter) { var result = new Result <PolicyDataContract[]>(); try { using (var ctx = new PolicyProjectEntities()) { if (policyFilter == null) { result.SomeResult = ctx.tbl_policy.Select( policyTblData => new PolicyDataContract { PolicyId = policyTblData.id, PolicyName = policyTblData.policy_name, PlatformId = policyTblData.platform_id, PolicyInstruction = policyTblData.policy_instruction, PolicyDefaultParam = policyTblData.policy_default_param, PlatformName = ctx.tbl_platform.FirstOrDefault( platform => platform.id == policyTblData.platform_id).platform_name }).ToArray(); } else { result.SomeResult = ctx.tbl_policy.Where(x => x.id == policyFilter.PolicyId) .Select(policyTblData => new PolicyDataContract { PolicyId = policyTblData.id, PolicyName = policyTblData.policy_name, PlatformId = policyTblData.platform_id, PolicyInstruction = policyTblData.policy_instruction, PolicyDefaultParam = policyTblData.policy_default_param, PlatformName = ctx.tbl_platform.FirstOrDefault(platform => platform.id == policyTblData.platform_id) .platform_name }) .ToArray(); } result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения списка политик. ", ex.Message); } return(result); }
public Result <LoginDevicesDataContract[]> GetLoginDevices(LoginDevicesDataContract loginDevicesFilter) { var result = new Result <LoginDevicesDataContract[]>(); try { using (var ctx = new PolicyProjectEntities()) { if (loginDevicesFilter == null) { result.SomeResult = ctx.tbl_login_devices.Select( loginDevicesTblData => new LoginDevicesDataContract { LoginDeviceId = loginDevicesTblData.id, DeviceId = loginDevicesTblData.id_device, LoginId = loginDevicesTblData.id_login, NeedUpdateDevice = loginDevicesTblData.need_update_device }) .ToArray(); } else { result.SomeResult = ctx.tbl_login_devices.Where( x => (loginDevicesFilter.LoginDeviceId > 0 && x.id == loginDevicesFilter.LoginDeviceId) || (loginDevicesFilter.LoginId > 0 && x.id_login == loginDevicesFilter.LoginId) || (loginDevicesFilter.DeviceId > 0 && x.id_device == loginDevicesFilter.DeviceId)) .Select( loginDevicesTblData => new LoginDevicesDataContract { LoginDeviceId = loginDevicesTblData.id, DeviceId = loginDevicesTblData.id_device, LoginId = loginDevicesTblData.id_login, NeedUpdateDevice = loginDevicesTblData.need_update_device }).ToArray(); } result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения списка устройств. ", ex.Message); } return(result); }
public Result <EventLogDataContract[]> GetFilteredEventLog(DateTime fromDate, DateTime?toDate, int?eventId) { var result = new Result <EventLogDataContract[]>(); try { using (var ctx = new PolicyProjectEntities()) { var finalDate = (toDate ?? DateTime.Now).AddDays(1); var filteredLog = ctx.tbl_activity_log.Where(x => x.log_date >= fromDate && x.log_date <= finalDate); if (eventId != null) { filteredLog = filteredLog.Where(x => x.id_event == eventId); } var res = new List <EventLogDataContract>(); foreach (var activity in filteredLog) { var evntName = ctx.tbl_event.FirstOrDefault(x => x.id == activity.id_event).event_name; res.Add(new EventLogDataContract { EventLogId = activity.id, EventLogDate = activity.log_date, EventId = activity.id_event, Device = activity.device, DocumentId = activity.id_document, Message = activity.message, Login = activity.login, EventName = evntName }); } result.SomeResult = res.ToArray(); result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения лога событий. ", ex.Message); } return(result); }
public Result <UserDataContract[]> GetUser(UserDataContract userFilter) { var result = new Result <UserDataContract[]>(); try { using (var ctx = new PolicyProjectEntities()) { if (userFilter == null) { result.SomeResult = ctx.tbl_user.Select(userTblData => new UserDataContract { UserId = userTblData.id, UserLastName = userTblData.last_name, UserFirstName = userTblData.first_name, UserMiddleName = userTblData.middle_name }).ToArray(); } else { result.SomeResult = ctx.tbl_user.Where(x => x.id == userFilter.UserId) .Select(userTblData => new UserDataContract { UserId = userTblData.id, UserLastName = userTblData.last_name, UserFirstName = userTblData.first_name, UserMiddleName = userTblData.middle_name }) .ToArray(); } result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения списка пользователей. ", ex.Message); } return(result); }
public Result <EventDataContract[]> GetEvent(EventDataContract eventFilter) { var result = new Result <EventDataContract[]>(); try { using (var ctx = new PolicyProjectEntities()) { if (eventFilter == null) { result.SomeResult = ctx.tbl_event.Select( eventTblData => new EventDataContract { EventId = eventTblData.id, EventName = eventTblData.event_name }).ToArray(); } else { result.SomeResult = ctx.tbl_event.Where(x => x.id == eventFilter.EventId) .Select(eventTblData => new EventDataContract { EventId = eventTblData.id, EventName = eventTblData.event_name }) .ToArray(); } result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения списка событий. ", ex.Message); } return(result); }
public Result <GroupDataContract[]> GetGroup(GroupDataContract groupFilter) { var result = new Result <GroupDataContract[]>(); try { using (var ctx = new PolicyProjectEntities()) { if (groupFilter == null) { result.SomeResult = ctx.tbl_group.Select( groupTblData => new GroupDataContract { GroupId = groupTblData.id, GroupName = groupTblData.group_name }).ToArray(); } else { result.SomeResult = ctx.tbl_group.Where(x => x.id == groupFilter.GroupId) .Select(groupTblData => new GroupDataContract { GroupId = groupTblData.id, GroupName = groupTblData.group_name }) .ToArray(); } result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения списка групп. ", ex.Message); } return(result); }
public Result <object> UpdateLogin(LoginDataContract oldLogin, LoginDataContract newLogin) { var result = new Result <object>(); try { if (oldLogin == null) { throw new Exception("Текущий логин не задан"); } if (newLogin == null) { throw new Exception("Новый логин не задан"); } using (var ctx = new PolicyProjectEntities()) { var selected = ctx.tbl_login.FirstOrDefault(x => x.id == oldLogin.LoginId); if (selected == null) { throw new Exception("Текущий логин не найден"); } selected.login = newLogin.Login; selected.pwd = newLogin.Password; selected.certificate = CreateCertificate(); selected.id_user = newLogin.UserId; selected.id_group = newLogin.GroupId; result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка изменения логина. ", ex.Message); } return(result); }
public Result <object> UpdatePolicySet(PolicySetDataContract oldPolicySet, PolicySetDataContract newPolicySet) { var result = new Result <object>(); try { if (oldPolicySet == null) { throw new Exception("Текущий набор политик не задан"); } if (newPolicySet == null) { throw new Exception("Новый набор политик не задан"); } using (var ctx = new PolicyProjectEntities()) { var selected = ctx.tbl_policy_set.FirstOrDefault(x => x.id == oldPolicySet.PolicySetId); if (selected == null) { throw new Exception("Текущий набор политик не найден"); } selected.id_policy = newPolicySet.PolicyId; selected.id_group = newPolicySet.GroupId; selected.id_login = newPolicySet.LoginId; selected.selected = newPolicySet.Selected; selected.policy_param = newPolicySet.PolicyParam; result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка изменения наборa политик. ", ex.Message); } return(result); }
public Result <object> UpdateDevice(DeviceInfoDataContract oldDevice, DeviceInfoDataContract newDevice) { var result = new Result <object>(); try { if (oldDevice == null) { throw new Exception("Текущее устройство не задано"); } if (newDevice == null) { throw new Exception("Новое устройство не задано"); } using (var ctx = new PolicyProjectEntities()) { var selected = ctx.tbl_device_info.FirstOrDefault(x => oldDevice.DeviceId == x.id); if (selected == null) { throw new Exception("Текущее устройство не найдено"); } selected.device_name = newDevice.DeviceName; selected.device_ip_addr = newDevice.DeviceIpAddress; selected.device_serial_number = newDevice.DeviceSerialNumber; selected.device_mac_addr = newDevice.DeviceMacAddress; selected.device_platform_id = newDevice.DevicePlatformId; result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка изменения устройствa. ", ex.Message); } return(result); }
public Result <object> UpdatePolicy(PolicyDataContract oldPolicy, PolicyDataContract newPolicy) { var result = new Result <object>(); try { if (oldPolicy == null) { throw new Exception("Текущая политика не задана"); } if (newPolicy == null) { throw new Exception("Новая политика не задана"); } using (var ctx = new PolicyProjectEntities()) { var selected = ctx.tbl_policy.FirstOrDefault(x => x.id == oldPolicy.PolicyId); if (selected == null) { throw new Exception("Текущая политика не найдена"); } selected.policy_name = newPolicy.PolicyName; selected.platform_id = newPolicy.PlatformId; selected.policy_instruction = newPolicy.PolicyInstruction; selected.policy_default_param = newPolicy.PolicyDefaultParam; result.BoolRes = ctx.SaveChanges() > 0; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка изменения политики. ", ex.Message); } return(result); }
public Result <PlatformDataContract[]> GetPlatform(PlatformDataContract platformFilter) { var result = new Result <PlatformDataContract[]>(); try { using (var ctx = new PolicyProjectEntities()) { if (platformFilter == null) { result.SomeResult = ctx.tbl_platform.Select( platformTblData => new PlatformDataContract { PlatformId = platformTblData.id, PlatformName = platformTblData.platform_name }).ToArray(); } else { result.SomeResult = ctx.tbl_platform.Where(x => x.id == platformFilter.PlatformId) .Select(platformTblData => new PlatformDataContract { PlatformId = platformTblData.id, PlatformName = platformTblData.platform_name }) .ToArray(); } result.BoolRes = true; } } catch (Exception ex) { result.BoolRes = false; result.ErrorRes = string.Concat("Ошибка получения списка платформ. ", ex.Message); } return(result); }