public void DeleteLogin(string login, Exception exc) { StaticLog.LogServiceCall(string.Format("DeleteLogin({0})", login)); try { using (var context = new VkContext()) { var exist = context.VkLogins.FirstOrDefault(x => x.Login == login); if (exist == null) { throw new Exception("Данный логин не существует : " + login); } context.VkLogins.Remove(exist); context.SaveChanges(); } } catch (Exception e) { StaticLog.LogException(e); exc = e; } }
public void AddSearchFilter(FilterModel newFilter, string newName) { StaticLog.LogServiceCall(string.Format("AddSearchFilter({0})", newFilter)); try { using (var ctx = new VkContext()) { var exist = ctx.VkSearchFilters.FirstOrDefault(x => x.Name == newFilter.Name); if (exist != null) { throw new Exception("Фильтр с заданным именем уже существует : " + newFilter.Name); } var newVkSearchFilter = new VkSearchFilter(newFilter); newVkSearchFilter.Name = newName; ctx.VkSearchFilters.Add(newVkSearchFilter); ctx.SaveChanges(); } } catch (Exception e) { StaticLog.LogException(e); } }
public void DeleteSearchFilterByName(string name) { StaticLog.LogServiceCall(string.Format("DeleteSearchFilterByName({0})", name)); try { using (var ctx = new VkContext()) { var exist = ctx.VkSearchFilters.FirstOrDefault(x => x.Name == name); if (exist == null) { throw new Exception("Фильтра с заданным именем не найден : " + name); } ctx.VkSearchFilters.Remove(exist); ctx.SaveChanges(); } } catch (Exception e) { StaticLog.LogException(e); } }
public void UpdateSearchFilter(FilterModel filter) { StaticLog.LogServiceCall(string.Format("UpdateSearchFilter({0})", filter)); try { using (var ctx = new VkContext()) { var exist = ctx.VkSearchFilters.FirstOrDefault(x => x.Name == filter.Name); if (exist == null) { throw new Exception("Фильтра с заданным именем не найден : " + filter.Name); } exist.CopyProps(filter); ctx.SaveChanges(); } } catch (Exception e) { StaticLog.LogException(e); } }
public void CreateNewLogin(string login, string password, string vkUrlPage, Exception exc) { var log = string.Format("CreateNewLogin({0}, {1}, {2})", login, password, vkUrlPage); try { exc = null; using (var context = new VkContext()) { var exists = context.VkLogins.FirstOrDefault(x => x.Login == login); if (exists != null) { exists.Password = password; exists.VkUrlPage = vkUrlPage; log += "; change Password"; } else { context.VkLogins.Add(new VkLogin() { Login = login, Password = password, VkUrlPage = vkUrlPage, }); } context.SaveChanges(); } } catch (Exception e) { StaticLog.LogException(e); exc = e; } StaticLog.LogServiceCall(log); }