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); } }