public IEnumerable <Tvar_ADD_DTO> GetTvar()
{
using (Priut db = new Priut())
{
db.Configuration.ProxyCreationEnabled = false;
var result = db.Tvar_Add
.Include(t => t.Type)
.Include(c => c.Color)
.Include(b => b.Breed)
.Select(tv => new Tvar_ADD_DTO
{
Id = tv.Id,
Type = tv.Type.NameType,
Breed = tv.Breed.NameBreed,
Nick = tv.Nick,
Age = tv.Age,
Kg = tv.Kg,
Color = tv.Color.NameColor,
DateTime = tv.DateTime,
Vaccination = tv.Vaccination,
Castration = tv.Castration,
Information = tv.Information,
UserId = tv.RegisterUser.Id
}).ToList();
return(result);
}
}
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 bool SingIn(SingInUser User)
{
using (Priut db = new Priut())
{
bool e = db.RegUsers.ToList().Any(w => w.Email == User.EmailSingIn && w.Password == User.PasswordSingIn);
return(e);
}
}
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 IEnumerable <RegUser_DTO> GetUser()
{
using (Priut db = new Priut())
{
var getUser = db.RegUsers.Select(w => new RegUser_DTO
{
Id = w.Id,
Name = w.Name,
SurName = w.SurName,
Email = w.Email,
Tel = w.Tel,
Password = w.Password
}).ToList();
return(getUser);
}
}
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);
}
}