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