public List <Fanni> GetAll() { using (var db = new CarDB()) { return(db.FanniDbSet.ToList()); } }
public Avarez Get(int id) { using (var db = new CarDB()) { return(db.Avarezha.Include(p => p.Car).SingleOrDefault(p => p.Id == id)); } }
public FanniOperation Get(int id) { using (var db = new CarDB()) { return(db.FanniOperations.Include(p => p.Car).SingleOrDefault(p => p.Id == id)); } }
public ActionResult AddCar(CarViewModel newCar, HttpPostedFileBase file) { string fn = ""; if (file != null & file.ContentLength > 0) { string filename = Path.GetFileName(file.FileName); filename = DateTime.Now.ToString("yymmssfff") + filename; string imagePath = Path.Combine(Server.MapPath("~/Static/"), filename); file.SaveAs(imagePath); fn = imagePath; } Guid g = Guid.NewGuid(); var newCarDB = new CarDB() { CarId = g.ToString(), UserId = User.Identity.Name, Make = newCar.Make, Model = newCar.Model, Colour = newCar.Colour, RegNo = newCar.RegNo, PicturePath = fn, }; JJAutosDB.CarDBs.Add(newCarDB); JJAutosDB.SaveChanges(); return(View()); }
public List <FanniOperation> GetAll() { using (var db = new CarDB()) { return(db.FanniOperations.ToList()); } }
public List <Vahed> GetAll() { using (var db = new CarDB()) { return(db.Vahedha.Where(p => !p.Deleted).ToList()); } }
public List <Models.Car> GetAll() { using (var db = new CarDB()) { return(db.Cars.Where(p => !p.Deleted).ToList()); } }
public Tasadof Get(int id) { using (var db = new CarDB()) { return(db.Tasadofat.Find(id)); } }
public List <Driver> GetAll() { using (var db = new CarDB()) { return(db.Drivers.Where(p => !p.Deleted).ToList()); } }
public Driver Get(int id) { using (var db = new CarDB()) { return(db.Drivers.Find(id)); } }
public List <FanniOperationDetail> GetByOperationId(int id) { using (var db = new CarDB()) { return(db.FanniOperationDetails.Where(p => p.FanniOperationId == id).ToList()); } }
public Fuel Get(int id) { using (var db = new CarDB()) { 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 CarDB()) { db.Fuels.Add(t); db.SaveChanges(); } }
public void Create(FanniOperation t) { using (var db = new CarDB()) { db.FanniOperations.Add(t); db.SaveChanges(); } }
public void Create(Tasadof t) { using (var db = new CarDB()) { db.Tasadofat.Add(t); db.SaveChanges(); } }
public List <FuelType> GetAll() { using (var db = new CarDB()) { return(db.FuelTypes. Where(p => !p.Deleted).ToList()); } }
public void Create(Driver t) { using (var db = new CarDB()) { db.Drivers.Add(t); db.SaveChanges(); } }
public Mamoriat Get(int id) { using (var db = new CarDB()) { return(db.Mamoriatha.Include(p => p.Driver).Include(p => p.Car).Include(p => p.User) .SingleOrDefault(p => p.Id == id)); } }
public PersonalCar Get(int id) { using (var db = new CarDB()) { return(db.PersonalCars.Include(p => p.Driver).Include(p => p.Car).Include(p => p.User) .SingleOrDefault(p => p.Id == id)); } }
public TranDataScheduleControl() { conn = new ConnectDB(); car = new Car(); sql = new SQL(); carDb = new CarDB(); }
public void Delete(int id) { using (var db = new CarDB()) { var a = db.Tasadofat.Find(id); db.Tasadofat.Remove(a); db.SaveChanges(); } }
public void Delete(int id) { using (var db = new CarDB()) { var m = db.Mamoriatha.Find(id); m.Deleted = true; db.SaveChanges(); } }
public void Create(Mamoriat t) { using (var db = new CarDB()) { db.Mamoriatha.Add(t); db.SaveChanges(); } }
public void UpdateLoginDate(int uId) { using (var db = new CarDB()) { var u = db.Users.Find(uId); u.LastLoginDateTime = DateTime.UtcNow; db.SaveChanges(); } }
public void Delete(int id) { using (var db = new CarDB()) { var m = db.PersonalCars.Find(id); m.Deleted = true; db.SaveChanges(); } }
public void Create(PersonalCar t) { using (var db = new CarDB()) { db.PersonalCars.Add(t); db.SaveChanges(); } }
public List <Bimeh> GetAll() { using (var db = new CarDB()) { return(db.Bimeha. Include(p => p.Car). Where(p => !p.Deleted).ToList()); } }
public void Delete(int id) { using (var db = new CarDB()) { var b = db.Bimeha.Find(id); b.Deleted = true; db.SaveChanges(); } }
public void Create(Models.Car t) { using (var db = new CarDB()) { db.Cars.Add(t); db.SaveChanges(); } }
public void Delete(int id) { using (var db = new CarDB()) { var f = db.FanniOperations.Find(id); db.FanniOperations.Remove(f); db.SaveChanges(); } }