Exemplo n.º 1
0
 public void CreateOrUpdate(ZarplataBindingModel model)
 {
     using (var context = new KursachDatabase())
     {
         Zarplata element = model.Id.HasValue ? null : new Zarplata();
         if (model.Id.HasValue)
         {
             element = context.Zarplatas.FirstOrDefault(rec => rec.Id == model.Id);
             if (element == null)
             {
                 throw new Exception("Элемент не найден");
             }
         }
         else
         {
             element = new Zarplata();
             context.Zarplatas.Add(element);
         }
         element.UserId = model.UserId;
         element.Name   = model.Name;
         element.Summa  = model.Summa;
         element.data   = model.data;
         context.SaveChanges();
     }
 }
Exemplo n.º 2
0
        public void CreateOrUpdate(DogovorBindingModel model)
        {
            using (var context = new KursachDatabase())
            {
                Dogovor element = context.Dogovors.FirstOrDefault(rec => rec.Id != model.Id);

                if (model.Id.HasValue)
                {
                    element = context.Dogovors.FirstOrDefault(rec => rec.Id == model.Id);
                    if (element == null)
                    {
                        throw new Exception("Склад не найден");
                    }
                }
                else
                {
                    element = new Dogovor();
                    context.Dogovors.Add(element);
                    element.ClientId = model.ClientId;
                    element.AgentId  = model.AgentId;
                    element.data     = model.data;
                }
                element.Summa = model.Summa;
                context.SaveChanges();
            }
        }
Exemplo n.º 3
0
 public void CreateOrUpdate(ReisBindingModel model)
 {
     using (var context = new KursachDatabase())
     {
         Reis element = model.Id.HasValue ? null : new Reis();
         if (model.Id.HasValue)
         {
             element = context.Reiss.FirstOrDefault(rec => rec.Id == model.Id);
             if (element == null)
             {
                 throw new Exception("Элемент не найден");
             }
         }
         else
         {
             element = new Reis();
             context.Reiss.Add(element);
         }
         element.Name = model.Name;
         element.Cena = model.Cena;
         element.OfId = model.OfId;
         element.ToId = model.ToId;
         element.Time = model.Time;
         context.SaveChanges();
     }
 }
Exemplo n.º 4
0
 public void CreateOrUpdate(ClientBindingModel model)
 {
     using (var context = new KursachDatabase())
     {
         Client element = model.Id.HasValue ? null : new Client();
         if (model.Id.HasValue)
         {
             element = context.Clients.FirstOrDefault(rec => rec.Id == model.Id);
             if (element == null)
             {
                 throw new Exception("Элемент не найден");
             }
         }
         else
         {
             element = new Client();
             context.Clients.Add(element);
         }
         element.Email       = model.Email;
         element.PhoneNumber = model.PhoneNumber;
         element.UserId      = model.UserId;
         element.Pasport     = model.Pasport;
         element.ClientFIO   = model.ClientFIO;
         context.SaveChanges();
     }
 }
Exemplo n.º 5
0
 public void CreateOrUpdate(AgentBindingModel model)
 {
     using (var context = new KursachDatabase())
     {
         Agent element = model.Id.HasValue ? null : new Agent();
         if (model.Id.HasValue)
         {
             element = context.Agents.FirstOrDefault(rec => rec.Id == model.Id);
             if (element == null)
             {
                 throw new Exception("Элемент не найден");
             }
         }
         else
         {
             element = new Agent();
             context.Agents.Add(element);
         }
         element.Name      = model.Name;
         element.Oklad     = model.Oklad;
         element.UserId    = model.UserId;
         element.Comission = model.Comission;
         context.SaveChanges();
     }
 }
Exemplo n.º 6
0
        public void Delete(ZarplataBindingModel model)
        {
            using (var context = new KursachDatabase())
            {
                Zarplata element = context.Zarplatas.FirstOrDefault(rec => rec.Id == model.Id);

                if (element != null)
                {
                    context.Zarplatas.Remove(element);
                    context.SaveChanges();
                }
                else
                {
                    throw new Exception("Элемент не найден");
                }
            }
        }
Exemplo n.º 7
0
        public void DeleteReisDogovor(Dogovor_ReisBM model)
        {
            using (var context = new KursachDatabase())
            {
                Dogovor_Reis element = context.Dogovor_Reiss.FirstOrDefault(rec => rec.Id == model.Id);

                if (element != null)
                {
                    context.Dogovor_Reiss.Remove(element);
                    context.SaveChanges();
                }
                else
                {
                    throw new Exception("Элемент не найден");
                }
            }
        }
Exemplo n.º 8
0
 public void AddReis(Dogovor_ReisBM model)
 {
     using (var context = new KursachDatabase())
     {
         var werehouseCosmetics = context.Dogovor_Reiss.FirstOrDefault(rec =>
                                                                       rec.DogovorId == model.DogovorId && rec.ReisId == model.ReisId);
         if (werehouseCosmetics == null)
         {
             context.Dogovor_Reiss.Add(new Dogovor_Reis
             {
                 DogovorId    = model.DogovorId,
                 ReisId       = model.ReisId,
                 Obem         = model.Obem,
                 ves          = model.ves,
                 Comm         = model.Comm,
                 NadbavkaCena = model.NadbavkaCena,
                 NadbavkaTime = model.NadbavkaTime
             });
         }
         else
         {
             if (model.Id != 0)
             {
                 werehouseCosmetics.NadbavkaCena = model.NadbavkaCena;
                 werehouseCosmetics.NadbavkaTime = model.NadbavkaTime;
             }
             else
             {
                 werehouseCosmetics.Obem         += model.Obem;
                 werehouseCosmetics.ves          += model.ves;
                 werehouseCosmetics.Comm          = model.Comm;
                 werehouseCosmetics.NadbavkaCena += model.NadbavkaCena;
                 werehouseCosmetics.NadbavkaTime += model.NadbavkaTime;
             }
         }
         Reis element = context.Reiss.FirstOrDefault(rec =>
                                                     rec.Id == model.ReisId);
         context.SaveChanges();
     }
 }
Exemplo n.º 9
0
 public void CreateOrUpdate(UserBindingModel model)
 {
     using (var context = new KursachDatabase())
     {
         User element = model.Id.HasValue ? null : new User();
         if (model.Id.HasValue)
         {
             element = context.Users.FirstOrDefault(rec => rec.Id == model.Id);
             if (element == null)
             {
                 throw new Exception("Элемент не найден");
             }
         }
         else
         {
             element = new User();
             context.Users.Add(element);
         }
         element.Status   = model.Status;
         element.Login    = model.Login;
         element.Password = model.Password;
         context.SaveChanges();
     }
 }