private void frmRingTheBell_Load(object sender, EventArgs e) { field1DTO = new fieldDTO(); field2DTO = new fieldDTO(); fieldBUS = new fieldBUS(); field1DTO.MaSanBanh = "1"; field2DTO.MaSanBanh = "2"; tbTimerField1.BackColor = Color.Green; tbTimerField2.BackColor = Color.Green; loadInfo(); }
public List <fieldDTO> selectedFields() { string query = string.Empty; query += "SELECT tblCHITIETDATSAN.maPhieuDatSan, maSan, ngayDat, gioDat, thoiLuong, tblKHACHHANG.tenKH "; query += "FROM tblCHITIETDATSAN, tblPHIEUDATSAN, tblKHACHHANG "; query += "WHERE tblCHITIETDATSAN.maPhieuDatSan = tblPHIEUDATSAN.maPhieuDatSan " + "and tblKHACHHANG.maKH = tblPHIEUDATSAN.maKH"; List <fieldDTO> lstFields = new List <fieldDTO>(); using (SqlConnection con = new SqlConnection(@"server=" + Dns.GetHostName() + ";Trusted_Connection=yes;database=QLSB;")) { using (SqlCommand cmd = new SqlCommand()) { cmd.Connection = con; cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = query; try { con.Open(); SqlDataReader reader = null; reader = cmd.ExecuteReader(); if (reader.HasRows == true) { while (reader.Read()) { fieldDTO field = new fieldDTO(); field.MaSanBanh = reader["maSan"].ToString(); field.GioDatSan = DateTime.Parse(reader["gioDat"].ToString()); field.NgayDatSan = DateTime.Parse(reader["ngayDat"].ToString()); field.ThoiLuongDatSan = DateTime.Parse(reader["thoiLuong"].ToString()); field.tenKH = reader["tenKH"].ToString(); lstFields.Add(field); } } con.Close(); con.Dispose(); } catch (Exception ex) { con.Close(); return(null); } } } return(lstFields); }
/* to display information about fields */ private void displayInfoField(fieldDTO field) { string bookingDate = field.NgayDatSan.ToShortDateString(); string bookingTime = field.GioDatSan.ToString("HH:mm:ss"); if (field1DTO.MaSanBanh == field.MaSanBanh) { if ("20:00:00" == bookingTime && "3/3/2019" == bookingDate) { tbCustomerField1.Text = field.tenKH; tbTimerField1.Text = field.ThoiLuongDatSan.ToString("HH:mm:ss"); } } if (field2DTO.MaSanBanh == field.MaSanBanh) { if ("20:00:00" == bookingTime && "3/3/2019" == bookingDate) { tbCustomerField2.Text = field.tenKH; tbTimerField2.Text = field.ThoiLuongDatSan.ToString("HH:mm:ss"); } } }