public Driver Get(int id)
{
using (var db = new CarManagementDB())
{
return(db.Drivers.Find(id));
}
}
public Tasadof Get(int id)
{
using (var db = new CarManagementDB())
{
return(db.Tasadofat.Find(id));
}
}
public void OnGet()
{
var lst = CarManagementDB.GetDb().GetCollection <Car>("Car").Find(_ => true).ToList();
foreach (var item in lst)
{
var cv = new CarViewModel();
cv.Transferee = item.Transferee;
cv.Model = item.Model;
cv.Color = item.Color;
cv.Pelak = item.Pelak;
cv.Deleted = item.Deleted;
cv.Name = item.Name;
cv.Id = item.Id;
cv.TransfereeName = CarManagementDB.GetDb().GetCollection <Person>("Person")
.Find(p => p.Id == item.Transferee).FirstOrDefault().Name;
LstCarViewModel.Add(cv);
}
var person = CarManagementDB.GetDb().GetCollection <Person>("Person").Find(_ => true).ToList();
ViewData["transfreeId"] = new SelectList(person, "Id", "Name");
}
public List <Fanni> GetAll()
{
using (var db = new CarManagementDB())
{
return(db.FanniDbSet.ToList());
}
}
public List <Vahed> GetAll()
{
using (var db = new CarManagementDB())
{
return(db.Vahedha.Where(p => !p.Deleted).ToList());
}
}
public List <FanniOperationDetail> GetByOperationId(int id)
{
using (var db = new CarManagementDB())
{
return(db.FanniOperationDetails.Where(p => p.FanniOperationId == id).ToList());
}
}
public FanniOperation Get(int id)
{
using (var db = new CarManagementDB())
{
return(db.FanniOperations.Include(p => p.Car).SingleOrDefault(p => p.Id == id));
}
}
public void OnGet()
{
var person = CarManagementDB.GetDb().GetCollection <Person>("Person").Find(_ => true).ToList();
var car = CarManagementDB.GetDb().GetCollection <Car>("Car").Find(_ => true).ToList();
var mabda = CarManagementDB.GetDb().GetCollection <Vahed>("Vahed").Find(_ => true).ToList();
ViewData["DriverId"] = new SelectList(person, "Id", "Name");
ViewData["MabdaId"] = new SelectList(mabda, "Id", "Name");
ViewData["CarId"] = new SelectList(car, "Id", "Name");
var lm = CarManagementDB.GetDb().GetCollection <Mamoriat>("Mamoriat").Find(_ => true).ToList();
foreach (var item in lm)
{
LstMamoriat.Add(new MamoriatViewModel
{
Mamoriat = item,
CarName = CarManagementDB.GetDb().GetCollection <Car>("Car")
.Find(p => p.Id == item.CarId).FirstOrDefault().Name,
CarPelak = CarManagementDB.GetDb().GetCollection <Car>("Car")
.Find(p => p.Id == item.CarId).FirstOrDefault().Pelak,
DriverName = CarManagementDB.GetDb().GetCollection <Person>("Person")
.Find(p => p.Id == item.DriverId).FirstOrDefault().Name,
MabdaName = CarManagementDB.GetDb().GetCollection <Vahed>("Vahed")
.Find(p => p.Id == item.MabdaId).FirstOrDefault().Name,
UserName = CarManagementDB.GetDb().GetCollection <User>("User")
.Find(p => p.Id == item.UserId).FirstOrDefault().Name
});
}
}
public List <FanniOperation> GetAll()
{
using (var db = new CarManagementDB())
{
return(db.FanniOperations.ToList());
}
}
public List <Driver> GetAll()
{
using (var db = new CarManagementDB())
{
return(db.Drivers.Where(p => !p.Deleted).ToList());
}
}
public void Create(FanniOperationDetail t)
{
using (var db = new CarManagementDB())
{
db.FanniOperationDetails.Add(t);
db.SaveChanges();
}
}
public void Create(Tasadof t)
{
using (var db = new CarManagementDB())
{
db.Tasadofat.Add(t);
db.SaveChanges();
}
}
public void Create(Driver t)
{
using (var db = new CarManagementDB())
{
db.Drivers.Add(t);
db.SaveChanges();
}
}
public Mamoriat Get(int id)
{
using (var db = new CarManagementDB())
{
return(db.Mamoriatha.Include(p => p.Driver).Include(p => p.Car).Include(p => p.User)
.SingleOrDefault(p => p.Id == id));
}
}
public Fuel Get(int id)
{
using (var db = new CarManagementDB())
{
return(db.Fuels.Include(p => p.Car).Include(p => p.FuelType)
.SingleOrDefault(p => p.Id == id));
}
}
public void Create(Fuel t)
{
using (var db = new CarManagementDB())
{
db.Fuels.Add(t);
db.SaveChanges();
}
}
public PersonalCar Get(int id)
{
using (var db = new CarManagementDB())
{
return(db.PersonalCars.Include(p => p.Driver).Include(p => p.Car).Include(p => p.User)
.SingleOrDefault(p => p.Id == id));
}
}
public List <FuelType> GetAll()
{
using (var db = new CarManagementDB())
{
return(db.FuelTypes.
Where(p => !p.Deleted).ToList());
}
}
public void Create(PersonalCar t)
{
using (var db = new CarManagementDB())
{
db.PersonalCars.Add(t);
db.SaveChanges();
}
}
public void Create(Mamoriat t)
{
using (var db = new CarManagementDB())
{
db.Mamoriatha.Add(t);
db.SaveChanges();
}
}
public void Delete(int id)
{
using (var db = new CarManagementDB())
{
var f = db.FanniOperations.Find(id);
db.FanniOperations.Remove(f);
db.SaveChanges();
}
}
public void Delete(int id)
{
using (var db = new CarManagementDB())
{
var m = db.Mamoriatha.Find(id);
m.Deleted = true;
db.SaveChanges();
}
}
public void Delete(int id)
{
using (var db = new CarManagementDB())
{
var m = db.PersonalCars.Find(id);
m.Deleted = true;
db.SaveChanges();
}
}
public void Delete(int id)
{
using (var db = new CarManagementDB())
{
var a = db.Tasadofat.Find(id);
db.Tasadofat.Remove(a);
db.SaveChanges();
}
}
public void DeleteByOperationId(int fId)
{
using (var db = new CarManagementDB())
{
var op = db.FanniOperationDetails.Where(p => p.FanniOperationId == fId);
db.FanniOperationDetails.RemoveRange(op);
db.SaveChanges();
}
}
public List <PersonalCar> GetAll()
{
using (var db = new CarManagementDB())
{
return(db.PersonalCars.
Include(p => p.Car).
Include(p => p.Driver).
Include(p => p.User).
Where(p => !p.Deleted).ToList());
}
}
public List <Mamoriat> GetAll()
{
using (var db = new CarManagementDB())
{
return(db.Mamoriatha.
Include(p => p.Car).
Include(p => p.Driver).
Include(p => p.User).
Where(p => !p.Deleted).ToList());
}
}
public async Task <IActionResult> OnPostDeleteAsync()
{
if (Person.Id == string.Empty)
{
return(Page());
}
await CarManagementDB.GetDb().GetCollection <Person>("Person")
.DeleteOneAsync(x => x.Id == Person.Id);
return(RedirectToPage("./Index"));
}
public void Update(FanniOperation t)
{
using (var db = new CarManagementDB())
{
var f = db.FanniOperations.Find(t.Id);
f.CarId = t.CarId;
f.Description = t.Description;
f.Price = t.Price;
f.Tarikh = t.Tarikh;
db.SaveChanges();
}
}
public void Update(Tasadof t)
{
using (var db = new CarManagementDB())
{
var m = db.Tasadofat.Find(t.Id);
m.CarId = t.CarId;
m.DriverId = t.DriverId;
m.Price = t.Price;
m.Tarikh = t.Tarikh;
db.SaveChanges();
}
}
