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