void Edit() { try { string id = dgvRFID.SelectedCells[0].OwningRow.Cells["RFID"].Value.ToString(); RFIDManage edit = _db.RFIDManages.Find(id); if (edit != null) { edit.RFID_Name = tbRFIDName.Text; edit.RFID_Address = tbAddress.Text; edit.RFID_Money = int.Parse(tbMoney.Text); edit.RFID_CarID = tbCarID.Text; edit.RFID_LoaiXe = int.Parse(cbLoaiXe.SelectedValue.ToString()); _db.SaveChanges(); MessageBox.Show(@"Edit success", @"Infomation", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadData(); BindingData(); } else { MessageBox.Show(@"Can't not Edit RFID", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception e) { MessageBox.Show(e.Message); } }
void Check(RFIDManage isCar, string click, double?money) { var tienBiTru = (_db.LoaiXes .Join(_db.RFIDManages, u => u.ID, m => m.RFID_LoaiXe, (u, m) => new { u, m }) .Where(@t => @t.m.RFID.Equals(click)) .Select(@t => new { @t.u.SoTien })).SingleOrDefault(); double kk = double.Parse(tienBiTru?.SoTien.ToString() ?? throw new InvalidOperationException()); txtDu.Text = (isCar.RFID_Money - kk).ToString(); RFIDManage edit = _db.RFIDManages.Find(click); if (edit != null) { edit.RFID_Money = double.Parse(txtDu.Text); RFID_User info = new RFID_User { RFID = click, UserID = LoginInfo.UserId, Date = DateTime.Now.ToString() }; _db.RFID_User.Add(info); _db.SaveChanges(); MessageBox.Show(@"Có xe qua trạm", @"Thông tin", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show(@"Can't not Edit RFID", @"Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
void Add() { try { string i = tbRFID.Text; var check = _db.RFIDManages.SingleOrDefault(u => u.RFID.Equals(i)); if (check == null) { RFIDManage newRfid = new RFIDManage { RFID = tbRFID.Text, RFID_Name = tbRFIDName.Text, RFID_Address = tbAddress.Text, RFID_CarID = tbCarID.Text, RFID_Money = double.Parse(tbMoney.Text), RFID_LoaiXe = int.Parse(cbLoaiXe.SelectedValue.ToString()) }; _db.RFIDManages.Add(newRfid); _db.SaveChanges(); MessageBox.Show(@"Add success", @"Infomation", MessageBoxButtons.OK, MessageBoxIcon.Information); LoadData(); BindingData(); } else { MessageBox.Show(@"RFID already!", @"Warring", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception e) { MessageBox.Show(e.Message); } }