void dataGridView1_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Delete) { if (this.dgvListForm.SelectedRows.Count == 1) { if (MessageBox.Show("Do you want delete this?") == System.Windows.Forms.DialogResult.OK) { XeView selected = (XeView)this.dgvListForm.SelectedRows[0].DataBoundItem; var db = new WorkerFileEntities(); Xe deleted = db.Xes.Find(selected.License_Plates); db.Xes.Remove(deleted); db.SaveChanges(); string bienSoXe = selected.License_Plates; string tenXe = selected.Name; int hangXe = business.ReManufacure(selected.Manufacture); DateTime time = DateTime.Parse(selected.Time_Parking); business.AddBikes(bienSoXe, tenXe, hangXe, time); MessageBox.Show("Successfully deleted"); this.OnLoad(null); } } } }
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(); }
void btnRestore_Click(object sender, EventArgs e) { XeView selected = (XeView)this.dgvRecycle.SelectedRows[0].DataBoundItem; var db = new WorkerFileEntities(); XeDeleted restored = db.XeDeleteds.Find(selected.License_Plates); db.XeDeleteds.Remove(restored); db.SaveChanges(); string bienSoXe = selected.License_Plates; string tenXe = selected.Name; int hangXe = business.ReManufacure(selected.Manufacture); DateTime time = DateTime.Parse(selected.Time_Parking); business.AddBike(bienSoXe, tenXe, hangXe, time); MessageBox.Show("Restore Successfully"); this.OnLoad(null); }
void dgvRecycle_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Delete) { if (this.dgvRecycle.SelectedRows.Count == 1) { if (MessageBox.Show("Are you sure?") == System.Windows.Forms.DialogResult.OK) { XeView selected = (XeView)this.dgvRecycle.SelectedRows[0].DataBoundItem; var db = new WorkerFileEntities(); XeDeleted deleted = db.XeDeleteds.Find(selected.License_Plates); db.XeDeleteds.Remove(deleted); db.SaveChanges(); MessageBox.Show("Successfully deleted"); this.OnLoad(null); } } } }
public XeDeleted[] GetDeletedBike() { WorkerFileEntities db = new WorkerFileEntities(); return(db.XeDeleteds.ToArray()); }
public Xe GetBike(string bienSO) { WorkerFileEntities db = new WorkerFileEntities(); return(db.Xes.Find(bienSO)); }