public IEnumerable <comboboxdata> GetAll()
{
using (var db = new VSMSContext())
{
var model = db.comboboxdatas.ToList();
return(model);
}
}
public customer Create(customer newCustomer)
{
using (var db = new VSMSContext())
{
db.customers.Add(newCustomer);
db.SaveChanges();
}
return(newCustomer);
}
public user Create(user newuser)
{
using (var db = new VSMSContext())
{
db.users.Add(newuser);
db.SaveChanges();
}
return(newuser);
}
public vehicle Create(vehicle newVehicle)
{
using (var db = new VSMSContext())
{
db.vehicles.Add(newVehicle);
db.SaveChanges();
}
return(newVehicle);
}
public comboboxdata Create(comboboxdata newcomboboxdata)
{
using (var db = new VSMSContext())
{
db.comboboxdatas.Add(newcomboboxdata);
db.SaveChanges();
}
return(newcomboboxdata);
}
public void Update(int id_of_car, int sellPrice) //selling a vehicle
{
using (var db = new VSMSContext())
{
var toBeUpdated = db.vehicles.Where(c => c.vehicleId == id_of_car).First();
toBeUpdated.sprice = sellPrice;
toBeUpdated.status = "Sold";
db.SaveChanges();
}
}
public bool Delete(int rowId)
{
using (var db = new VSMSContext())
{
var toBeDeleted = db.vehicles.SingleOrDefault(c => c.vehicleId == rowId);
db.vehicles.Remove(toBeDeleted);
db.SaveChanges();
}
return(true);
}
public int IsExist(string uname, string pass)
{
using (var db = new VSMSContext())
{
var count = db.users.Count(t => t.userName == uname && t.userPass == pass && t.userType == "Admin");
var count2 = db.users.Count(t => t.userName == uname && t.userPass == pass && t.userType == "Employee");
if (count > 0)
{
return(1);
}
else if (count2 > 0)
{
return(2);
}
return(0);
}
}
public IEnumerable <soldVehicleViewModel> GetSoldView()
{
using (var db = new VSMSContext())
{
var Customerid = db.customers.Where(a => a.vehicle.status.Equals("Sold")).Select(a => new soldVehicleViewModel
{
CustomerId = a.customerId,
CustomerName = a.fName + " " + a.lName,
DateSold = a.invoiceDate,
CarId = a.vehicleId,
PriceBought = a.vehicle.bprice,
Pricesold = a.vehicle.sprice,
Mobile = a.mobile
}).ToList();
return(Customerid);
}
}
public IEnumerable <vehicleViewModel> GetAllViewModel()
{
using (var db = new VSMSContext())
{
var vehicleid = db.vehicles.Select(a => new vehicleViewModel
{
vehicleId = a.vehicleId,
model = a.model,
chasisNo = a.chasisNo,
brand = a.brand,
manufacturer = a.manufacturer,
Made_Year = a.mYear,
color = a.color,
engineNo = a.engineNo,
status = a.status,
image = a.image
}).ToList();
return(vehicleid);
}
}
