public void SetTvarina(Tvar_ADD tvar, SingInUser User) { using (Priut db = new Priut()) { var tvUsers = db.RegUsers.FirstOrDefault(w => w.Email == User.EmailSingIn); var tvType = db.Types.FirstOrDefault(w => w.NameType == tvar.Type.NameType); var tvBreed = db.Breeds.FirstOrDefault(w => w.NameBreed == tvar.Breed.NameBreed); var tvColor = db.Colors.FirstOrDefault(w => w.NameColor == tvar.Color.NameColor); if (tvType != null) { tvar.Type = tvType; } if (tvBreed != null) { tvar.Breed = tvBreed; } if (tvColor != null) { tvar.Color = tvColor; } tvar.RegisterUser = tvUsers; db.Tvar_Add.Add(tvar); db.SaveChanges(); } }
public void RemoveTvar(int Id) { int idDel = Id; using (Priut db = new Priut()) { bool auditID = db.Tvar_Add.ToList().Any(w => w.Id == idDel); if (auditID == true) { var del = db.Tvar_Add.Find(idDel); db.Tvar_Add.Remove(del); db.SaveChanges(); } } }
public bool SetUser(RegUser user) { using (Priut db = new Priut()) { bool emailRepeat = db.RegUsers.ToList().Any(w => w.Email == user.Email); if (emailRepeat == true) { return(emailRepeat); } else { db.RegUsers.Add(user); db.SaveChanges(); } return(emailRepeat); } }