public int ReManufacure(string id) { WorkerFileEntities db = new WorkerFileEntities(); int data = db.HangXes.Where(item => item.Name.Equals(id)).Select(item => item.ID).FirstOrDefault(); db.Dispose(); return(data); }
public string GetManufacture(int id) { WorkerFileEntities db = new WorkerFileEntities(); string data = db.HangXes.Where(item => item.ID.Equals(id)).Select(item => item.Name).FirstOrDefault(); db.Dispose(); return(data); }
public ChuXe[] Owners() { WorkerFileEntities db = new WorkerFileEntities(); ChuXe[] result = db.ChuXes.ToArray(); db.Dispose(); return(result); }
public Xe[] GetBikes() { WorkerFileEntities db = new WorkerFileEntities(); Xe[] result = db.Xes.ToArray(); db.Dispose(); return(result); }
public HangXe[] GetManufactures() { WorkerFileEntities db = new WorkerFileEntities(); HangXe[] result = db.HangXes.ToArray(); db.Dispose(); return(result); }
public void thayDoi(string bienSo, string tenXe, int hangXe, DateTime guiXe) { WorkerFileEntities db = new WorkerFileEntities(); var soXe = db.Xes.Find(bienSo); soXe.Name = tenXe; soXe.Manufacture = hangXe; soXe.Time_Parking = guiXe; db.SaveChanges(); db.Dispose(); }
public void AddBikes(string bienSo, string tenXe, int hangXe, DateTime guiXe) { WorkerFileEntities db = new WorkerFileEntities(); XeDeleted xed = new XeDeleted(); xed.License_Plates = bienSo; xed.Name = tenXe; xed.Manufacture = hangXe; xed.Time_Parking = guiXe; db.XeDeleteds.Add(xed); db.SaveChanges(); db.Dispose(); }
public void AddOwners(string cMND, string hoVaTen, DateTime ngaySinh, string bienSoXe) { WorkerFileEntities db = new WorkerFileEntities(); ChuXe chuxe = new ChuXe(); chuxe.CMND = cMND; chuxe.Name = hoVaTen; chuxe.Birthday = ngaySinh; chuxe.License_Plates = bienSoXe; db.ChuXes.Add(chuxe); db.SaveChanges(); db.Dispose(); }