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