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