public void AddElement(ModelDirectory model)
{
ModelDirectory element = new ModelDirectory
{
ContractId = model.ContractId,
ServiceId = model.ServiceId,
Data = model.Data
};
context.Directories.Add(element);
context.SaveChanges();
}
public int AddElement(ModelContractClient model)
{
ModelContractClient element = new ModelContractClient
{
Id = model.Id,
AgentId = model.AgentId,
ClientId = model.ClientId,
Sum = model.Sum,
DateStart = model.DateStart,
DateEnd = model.DateEnd
};
context.ContractClients.Add(element);
context.SaveChanges();
return(element.Id);
}
public void AddElement(ModelServices model)
{
ModelServices element = context.Services.AsEnumerable().FirstOrDefault(rec => rec.NameService == model.NameService);
if (element != null)
{
throw new Exception("Уже есть услуга с таким Названием");
}
element = new ModelServices
{
Id = model.Id,
NameService = model.NameService,
Price = model.Price
};
context.Services.Add(element);
context.SaveChanges();
}
public void AddElement(ModelClient model)
{
ModelClient element = context.Clients.FirstOrDefault(rec => rec.FIO == model.FIO);
if (element != null)
{
throw new Exception("Уже есть клиент с таким ФИО");
}
element = new ModelClient
{
FIO = model.FIO,
Date = model.Date,
Passport = model.Passport
};
context.Clients.Add(element);
context.SaveChanges();
}
public void AddElement(ModelUser model)
{
ModelUser element = context.Users.FirstOrDefault(rec => rec.Login == model.Login);
if (element != null)
{
throw new Exception("Уже есть пользователь с таким Логином");
}
element = new ModelUser
{
Id = model.Id,
FIO = model.FIO,
Login = model.Login,
Password = model.Password,
Role = model.Role
};
context.Users.Add(element);
context.SaveChanges();
}
public async Task SaveToJsonAsync(string fileName)
{
DataContractJsonSerializer formatterClient = new DataContractJsonSerializer(typeof(List <ModelClient>));
MemoryStream msClient = new MemoryStream();
formatterClient.WriteObject(msClient, await context.Clients.ToListAsync());
msClient.Position = 0;
StreamReader srClient = new StreamReader(msClient);
string ClientJSON = srClient.ReadToEnd();
srClient.Close();
msClient.Close();
DataContractJsonSerializer formatterContractClient = new DataContractJsonSerializer(typeof(List <ModelContractClient>));
MemoryStream msContractClient = new MemoryStream();
formatterContractClient.WriteObject(msContractClient, await context.ContractClients.ToListAsync());
msContractClient.Position = 0;
StreamReader srContractClient = new StreamReader(msContractClient);
string ContractClientJSON = srContractClient.ReadToEnd();
srContractClient.Close();
msContractClient.Close();
DataContractJsonSerializer formatterDirection = new DataContractJsonSerializer(typeof(List <ModelContractClient>));
MemoryStream msDirection = new MemoryStream();
formatterDirection.WriteObject(msDirection, await context.ContractClients.ToListAsync());
msDirection.Position = 0;
StreamReader srDirection = new StreamReader(msDirection);
string DirectionJSON = srDirection.ReadToEnd();
srDirection.Close();
msDirection.Close();
File.WriteAllText(fileName, "{\n" +
" \"Client\": " + ClientJSON + ", \n" +
" \"ContractClient\": " + ContractClientJSON + ", \n" +
" \"Direction\": " + DirectionJSON + ", \n" +
"}");
List <ModelContractClient> result = context.ContractClients.AsEnumerable().Where(rec => rec.DateEnd.Month < DateTime.Now.Month && rec.DateEnd.Year == DateTime.Now.Year)
.Select(recCI => new ModelContractClient
{
Id = recCI.Id,
}).ToList();
foreach (var item in result)
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
ModelContractClient element = context.ContractClients.FirstOrDefault(rec => rec.Id == item.Id);
if (element != null)
{
//context.ContractClients.Remove(element);
context.SaveChanges();
}
else
{
throw new Exception("Элемент не найден");
}
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
throw;
}
}
}
}
