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