private void btnAddTicket_Click(object sender, EventArgs e)
{
User user;
using (var dbContext = new AppContext())
{
user = dbContext.Users.FirstOrDefault(u => u.StudentCode == tbStudentCode1.Text);
if (user != null)
{
ParkingMonthlyTicket ticket = new ParkingMonthlyTicket();
ticket.UserId = user.Id;
ticket.Note = tbNoteTicket.Text;
ticket.DateStart = dtpFromDate.Value;
ticket.DateEnd = dtpToDate.Value;
dbContext.ParkingMonthlyTickets.Add(ticket);
dbContext.SaveChanges();
LoadTicket();
tbStudentCode.Text = "";
tbStudentCode1.Text = "";
dtpFromDate.Value = DateTime.Now;
dtpToDate.Value = DateTime.Now;
}
else
{
MessageBox.Show("Mã sinh viên không hợp lệ", "Cảnh báo", MessageBoxButtons.OK,
MessageBoxIcon.Asterisk);
}
}
}
private void btnOut_Click(object sender, EventArgs e)
{
DateTime now = DateTime.Now;
using (var dbContext = new AppContext())
{
ParkingTurn pt = new ParkingTurn();
pt.Note = rtbNote.Text;
pt.Time = DateTime.Now;
pt.StudentCode = tbStudentCode4.Text;
User user = dbContext.Users.FirstOrDefault(u => u.StudentCode == tbStudentCode4.Text);
if (user != null)
{
if (cbMonthlyTicket.Checked)
{
ParkingMonthlyTicket ticket = dbContext.ParkingMonthlyTickets.FirstOrDefault(t =>
t.DateStart <DateTime.Now && t.DateEnd> DateTime.Now && t.UserId == user.Id);
if (ticket != null)
{
pt.TicketId = ticket.Id;
int num = dbContext.ParkingTurns.Count(p =>
p.StudentCode == pt.StudentCode && EntityFunctions.TruncateTime(p.Time) == now.Date && p.Type == 2);
pt.NumOfTurn = num + 1;
}
else
{
MessageBox.Show("Vé không được tìm thấy", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
else
{
pt.NumOfTurn = 0;
}
pt.Type = 2;
dbContext.ParkingTurns.Add(pt);
dbContext.SaveChanges();
if (pt.NumOfTurn > 2 || pt.TicketId == null)
{
MessageBox.Show("Giá vé là 3000 đồng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("Giá vé là 0 đồng", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
else
{
MessageBox.Show("Mã sinh viên không được tìm thấy", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
}
private void btnDelTicket_Click(object sender, EventArgs e)
{
using (var dbContext = new AppContext())
{
ParkingMonthlyTicket ticket = dbContext.ParkingMonthlyTickets.Find(currentTicketId);
if (ticket != null)
{
dbContext.ParkingMonthlyTickets.Remove(ticket);
dbContext.SaveChanges();
}
}
LoadTicket();
tbStudentCode.Text = "";
tbStudentCode1.Text = "";
dtpFromDate.Value = DateTime.Now;
dtpToDate.Value = DateTime.Now;
}
private void btnUpdateTicket_Click(object sender, EventArgs e)
{
using (var dbContext = new AppContext())
{
User user = dbContext.Users.FirstOrDefault(u => u.StudentCode == tbStudentCode.Text);
ParkingMonthlyTicket ticket = dbContext.ParkingMonthlyTickets.Find(currentTicketId);
if (currentTicketId != null && user != null)
{
ticket.UserId = user.Id;
ticket.Note = tbNoteTicket.Text;
ticket.DateStart = dtpFromDate.Value;
ticket.DateEnd = dtpToDate.Value;
dbContext.ParkingMonthlyTickets.AddOrUpdate(ticket);
dbContext.SaveChanges();
}
}
LoadTicket();
tbStudentCode.Text = "";
tbStudentCode1.Text = "";
dtpFromDate.Value = DateTime.Now;
dtpToDate.Value = DateTime.Now;
}
