public Product[] GetProductByUserId(int id)
{
using (var db = new RentContext())
{
return(db.Products.Include(m => m.User).Include(m => m.Category).Where(m => m.UserId == id && m.IsDeleted == false).ToArray());
}
}
public User GetUserById(int id)
{
using (var db = new RentContext())
{
return(db.Users.FirstOrDefault(m => m.Id == id));
}
}
public Order LastOrderByUserId(int id)
{
using (var db = new RentContext())
{
return(db.Orders.Include(m => m.User).FirstOrDefault(m => m.UserId == id && m.IsDeleted == false));
}
}
public TakenProduct GetTakenProductById(int takenProductId)
{
using (var db = new RentContext())
{
return(db.TakenProducts.FirstOrDefault(m => m.Id == takenProductId));
}
}
public Category GetCategoryById(int id)
{
using (var db = new RentContext())
{
return(db.Categories.FirstOrDefault(m => m.Id == id));
}
}
public TakenProduct[] GetAllListMyTakenProduct(int userId)
{
using (var db = new RentContext())
{
return(db.TakenProducts.Include(m => m.User).Include(m => m.Product).Where(m => m.IsDeleted == false && m.UserId == userId).ToArray());
}
}
public User GetUserByLogin(string login)
{
using (var db = new RentContext())
{
return(db.Users.FirstOrDefault(m => m.Login == login));
}
}
public bool RegistrationCreateUser(RegisterTag registerTag)
{
var user = new User()
{
Login = registerTag.Email,
Password = registerTag.Password,
Name = registerTag.Name,
Surname = registerTag.Surname,
PhotoUrl = registerTag.PhotoUrl,
City = registerTag.City,
Street = registerTag.Street,
Home = registerTag.Home,
Longitude = registerTag.Longitude,
Latitude = registerTag.Latitude,
PhoneNumber = registerTag.PhoneNumber,
IsDeleted = false,
RoleId = 2,
SumMoney = 0
};
using (var db = new RentContext())
{
var userIsLive = db.Users.FirstOrDefault(m => m.Login == registerTag.Email);
if (userIsLive != null)
{
return(false);
}
db.Users.AddOrUpdate(user);
db.SaveChanges();
return(true);
}
}
public Order GetOrderById(int id)
{
using (var db = new RentContext())
{
return(db.Orders.Include(m => m.User).FirstOrDefault(m => m.Id == id));
}
}
public Category[] GetAllGategories()
{
using (var db = new RentContext())
{
return(db.Categories.Where(m => m.IsDeleted == false).ToArray());
}
}
public User[] GetAllUsers()
{
using (var db = new RentContext())
{
return(db.Users.Where(m => m.IsDeleted == false).ToArray());
}
}
public NieruchomosciWindow()
{
InitializeComponent();
baza = new BazaNieruchomosci();
db = new RentContext();
gridNieruchomosci.ItemsSource = db.Nieruchomosci.ToList();
//Nieruchomosci.ItemsSource = baza.nieruchomosci;
}
public Product GetProductById(int id)
{
using (var db = new RentContext())
{
var product = db.Products.Include(m => m.Category).Include(m => m.User).FirstOrDefault(m =>
m.IsDeleted == false && m.IsTaken == false && m.Id == id);
return(product);
}
}
public bool UpdateCategory(Category category)
{
using (var db = new RentContext())
{
db.Categories.AddOrUpdate(category);
db.SaveChanges();
return(true);
}
}
public bool UpdateProduct(Product product)
{
using (var db = new RentContext())
{
db.Products.AddOrUpdate(product);
db.SaveChanges();
return(true);
}
}
public bool UpdateOrder(Order order)
{
using (var db = new RentContext())
{
db.Orders.AddOrUpdate(order);
db.SaveChanges();
return(true);
}
}
public bool updateUser(User updateUser)
{
using (var db = new RentContext())
{
db.Users.AddOrUpdate(updateUser);
db.SaveChanges();
return(true);
}
}
public bool CreateTakenProduct(TakenProduct takenProduct)
{
using (var db = new RentContext())
{
db.TakenProducts.AddOrUpdate(takenProduct);
db.SaveChanges();
return(true);
}
}
public void DeleteTakenProductById(int id, int userId)
{
using (var db = new RentContext())
{
var takenProduct = db.TakenProducts.FirstOrDefault(m => m.Id == id && m.Product.UserId == userId);
takenProduct.IsDeleted = true;
db.TakenProducts.AddOrUpdate(takenProduct);
db.SaveChanges();
}
}
private void Form1_Load(object sender, EventArgs e)
{
RentContext context = new RentContext();
IEnumerable <Arac> araclar = context.Araclar.ToList();
foreach (var gelen in araclar)
{
comboBox1.Items.Add(gelen.Model + "-Km:" + gelen.Kilometre);
}
}
public Product[] GetAllProducts()
{
using (var db = new RentContext())
{
return(db.Products
.Where(m => m.IsDeleted == false && m.IsTaken == false)
.Include(m => m.Category)
.Include(m => m.User)
.ToArray());
}
}
public bool VerifyUserByLoginAndPassword(LoginTag loginModel)
{
using (var db = new RentContext())
{
var user = db.Users.FirstOrDefault(m => m.Login == loginModel.Login && m.Password == loginModel.Password);
if (user != null)
{
return(true);
}
return(false);
}
}
public bool DeleteUserById(int id)
{
using (var db = new RentContext())
{
var user = db.Users.FirstOrDefault(m => m.Id == id && m.IsDeleted == false);
if (user == null)
{
return(false);
}
user.IsDeleted = true;
db.Users.AddOrUpdate(user);
db.SaveChanges();
return(true);
}
}
public bool CheckedTenantProof(int idProof, int UserId)
{
using (var db = new RentContext())
{
var takenProduct = db.TakenProducts.FirstOrDefault(m => m.Id == idProof && m.UserId == UserId && m.IsDeleted == false);
if (takenProduct == null)
{
return(false);
}
takenProduct.TenantProof = true;
db.TakenProducts.AddOrUpdate(takenProduct);
db.SaveChanges();
return(true);
}
}
public bool CheckedNoIsTakenProductByProductId(int id)
{
using (var db = new RentContext())
{
var product = db.Products.Include(m => m.User).FirstOrDefault(m => m.Id == id);
if (product == null)
{
return(false);
}
product.IsTaken = false;
db.Products.AddOrUpdate(product);
db.SaveChanges();
return(true);
}
}
public bool PayMoneyForUserByLogin(decimal money, string login)
{
using (var db = new RentContext())
{
var user = db.Users.FirstOrDefault(m => m.Login == login);
if (user == null)
{
return(false);
}
user.SumMoney += money;
db.Users.AddOrUpdate(user);
db.SaveChanges();
return(true);
}
}
public bool DeleteProductById(int id)
{
using (var db = new RentContext())
{
var product = db.Products.FirstOrDefault(m => m.Id == id && m.IsDeleted == false);
if (product == null)
{
return(false);
}
product.IsDeleted = true;
db.Products.AddOrUpdate(product);
db.SaveChanges();
return(true);
}
}
public bool RemoveUserById(int id)
{
using (var db = new RentContext())
{
var user = GetUserById(id);
if (user == null)
{
return(false);
}
user.IsDeleted = true;
db.Users.AddOrUpdate(user);
db.SaveChanges();
return(true);
}
}
public static void Main(string[] args)
{
CreateWebHostBuilder(args).Build().Run();
using (var context = new RentContext()) {
var std = new Owner()
{
FirstName = "aaa"
};
context.Owner.Add(std);
context.SaveChanges();
}
Console.WriteLine("ssssssssssssssss");
}
public bool DeleteCategoryById(int id)
{
using (var db = new RentContext())
{
var category = db.Categories.FirstOrDefault(m => m.Id == id && m.IsDeleted == false);
if (category == null)
{
return(false);
}
category.IsDeleted = true;
db.Categories.AddOrUpdate(category);
db.SaveChanges();
return(true);
}
}
