private void AlertMessage_Load(object sender, EventArgs e)
{
showuser_panel.BackColor = Color.FromArgb(100, 255, 255, 255);
VisitorClass vc = new VisitorClass();
DataTable visitorOut = vc.checkVititorNotOut();
FunctionClass fn = new FunctionClass();
string Message = "";
if (visitorOut.Rows.Count > 0)
{
foreach (DataRow v in visitorOut.Rows)
{
Message = "ชื่อ " + v["visit_name"] + ", เวลาเข้า " + fn.ConvertDate(v["visit_datetime_in"].ToString()) + ", เลขที่ " + v["visit_id"] + "\r\n";
showList.Items.Add(Message);
}
if (Message != "")
{
Message = "ยังไม่มีเวลาออก กรุณาตรวจสอบ";
showList.Items.Add(Message);
}
}
}
private void ViewVisitHistoryForm_Load(object sender, EventArgs e)
{
if (ViewVisitHistoryForm.VisitID != "")
{
FunctionClass fn = new FunctionClass();
VisitorClass vc = new VisitorClass();
DataTable visitorDT = vc.getVisitorInfoById(VisitID);
if (visitorDT.Rows.Count < 1)
{
MessageBox.Show(this, "ไม่พบข้อมูลที่ค้นหา กรุณาตรวจสอบอีกครั้ง", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.Close();
return;
}
else
{
//this.OutVisitID = visitorDT.Rows[0]["visit_id"].ToString();
out_visitid_tb.Text = visitorDT.Rows[0]["visit_id"].ToString();
out_indate_tb.Text = fn.ConvertDate(visitorDT.Rows[0]["visit_datetime_in"].ToString());
if (visitorDT.Rows[0]["visit_datetime_out"].ToString() == "")
{
out_dateout_tb.Text = "-";
}
else
{
out_dateout_tb.Text = fn.ConvertDate(visitorDT.Rows[0]["visit_datetime_out"].ToString());
}
out_fullname_tb.Text = visitorDT.Rows[0]["visit_name"].ToString();
out_idcard_tb.Text = visitorDT.Rows[0]["id_card"].ToString();
out_carid_tb.Text = visitorDT.Rows[0]["car_id"].ToString();
out_company_tb.Text = visitorDT.Rows[0]["com_name"].ToString();
out_cartype_tb.Text = visitorDT.Rows[0]["cartype_name"].ToString();
out_objective_tb.Text = visitorDT.Rows[0]["obt_name"].ToString();
out_contact_tb.Text = visitorDT.Rows[0]["contact_name"].ToString();
out_comment_tb.Text = visitorDT.Rows[0]["comment"].ToString();
visitor_amount_tb.Text = visitorDT.Rows[0]["visitor_amount"].ToString();
if (visitorDT.Rows[0]["image_1"].ToString() != "")
{
if (System.IO.File.Exists(VariableDB.PathImage + visitorDT.Rows[0]["image_1"].ToString()))
{
Image img = fn.resizeImage(Image.FromFile(VariableDB.PathImage + visitorDT.Rows[0]["image_1"].ToString()), new Size(450, 350));
Image imgClone = (Image)img.Clone();
out_image1_pb.Image = img;
}
}
//if (visitorDT.Rows[0]["image_2"].ToString() != "")
//{
// out_image2_pb.Image = Image.FromFile(VariableDB.PathImage + visitorDT.Rows[0]["image_2"].ToString());
//}
if (visitorDT.Rows[0]["idcard_image"].ToString() != "")
{
if (System.IO.File.Exists(VariableDB.PathImage + visitorDT.Rows[0]["image_1"].ToString()))
{
out_idcardpic_pb.Image = Image.FromFile(VariableDB.PathIdCardImage + visitorDT.Rows[0]["idcard_image"].ToString());
}
}
DataTable blDT = vc.checkBlacklist(visitorDT.Rows[0]["id_card"].ToString());
if (blDT.Rows.Count > 0)
{
blacklist_logo_pb.Visible = true;
}
}
}
}
