public ContainerVisitor GetLastUserNo()
{
var result = new ContainerVisitor();
using (var ctx = new BIG_VMSEntities())
{
var reTrnVisitor = ctx.TRN_VISITOR.Where(o => o.MONTH == DateTime.Today.Month && o.YEAR == DateTime.Today.Year).OrderByDescending(x => x.NO).FirstOrDefault();
if (reTrnVisitor != null)
{
result.TRN_VISITOR = reTrnVisitor;
result.Status = true;
}
else
{
TRN_VISITOR visit = new TRN_VISITOR()
{
AUTO_ID = 0,
NO = 0,
};
result.TRN_VISITOR = visit;
result.Status = true;
}
}
return(result);
}
public ContainerVisitor GetItem(ContainerVisitor obj)
{
var result = new ContainerVisitor();
try
{
using (var ctx = new BIG_VMSEntities())
{
var reTrnVisitor = ctx.TRN_VISITOR.OrderByDescending(x => x.NO).FirstOrDefault();
if (reTrnVisitor != null)
{
result.TRN_VISITOR = reTrnVisitor;
result.Status = true;
}
else
{
TRN_VISITOR visit = new TRN_VISITOR()
{
AUTO_ID = 0,
NO = 0,
};
result.TRN_VISITOR = visit;
result.Status = true;
}
}
}
catch (Exception ex)
{
result.Status = false;
result.ExceptionMessage = ex.Message;
}
return(result);
}
private void gridAppointmentList_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex > -1)
{
if (e.ColumnIndex == 0 && gridAppointmentList.Rows[e.RowIndex].Cells["STATUS"].Value.ToString() != "เข้าพบแล้ว")
{
var id = Convert.ToInt32(gridAppointmentList.Rows[e.RowIndex].Cells["AUTO_ID"].Value);
ContainerAppointment container = new ContainerAppointment();
var filter = new AppointmentFilter();
TRN_VISITOR visitorObj = new TRN_VISITOR();
filter.AUTO_ID = id;
container.Filter = filter;
var obj = _service.GetItem(container);
visitorObj.CONTACT_EMPLOYEE_ID = obj.TRN_APPOINTMENT.CONTACT_EMPLOYEE_ID;
visitorObj.FIRST_NAME = obj.TRN_APPOINTMENT.REQUEST_FIRST_NAME;
visitorObj.LAST_NAME = obj.TRN_APPOINTMENT.REQUEST_LAST_NAME;
visitorObj.ID_CARD = obj.TRN_APPOINTMENT.REQUEST_ID_CARD;
visitorObj.REASON_ID = obj.TRN_APPOINTMENT.REASON_ID;
visitorObj.MAS_EMPLOYEE = obj.TRN_APPOINTMENT.MAS_EMPLOYEE;
visitorObj.MAS_REASON = obj.TRN_APPOINTMENT.MAS_REASON;
frmVisitor frm = new frmVisitor();
frm.visitorObj = visitorObj;
frm.formMode = FormMode.Add;
frm.visitorMode = VisitorMode.Appointment;
if (frm.ShowDialog() == DialogResult.OK)
{
var res = _service.UpdateStatus(id);
if (res.Status)
{
//MessageBox.Show(Message.MSG_SAVE_COMPLETE, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information);
ResetScreen();
}
else
{
MessageBox.Show(res.ExceptionMessage, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
//var res = _service.UpdateStatus(id);
//if (res.Status)
//{
// MessageBox.Show(Message.MSG_SAVE_COMPLETE, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information);
// ResetScreen();
//}
//else
//{
// MessageBox.Show(res.ExceptionMessage, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information);
//}
}
}
}
private TRN_VISITOR GetObjectfromControl()
{
try
{
var obj = new TRN_VISITOR
{
NO = Convert.ToInt32(txtNo.Text),
ID_CARD = txtIDCard.Text.Trim(),
FIRST_NAME = txtFirstName.Text.Trim(),
LAST_NAME = txtLastName.Text.Trim(),
LICENSE_PLATE = txtLicense.Text.Trim(),
STATUS = 1,
CONTACT_EMPLOYEE_ID = contactEmployeeId,
CAR_TYPE_ID = carModelId,
REASON_ID = reasonId,
CREATED_DATE = DateTime.Now,
UPDATED_DATE = DateTime.Now,
YEAR = DateTime.Now.Year,
MONTH = DateTime.Now.Month,
BY_PASS = "******"
};
if (provinceId == 0)
{
obj.LICENSE_PLATE_PROVINCE_ID = null;
}
else
{
obj.LICENSE_PLATE_PROVINCE_ID = provinceId;
}
if (formMode == FormMode.Add)
{
obj.CREATED_BY = LOGIN;
obj.UPDATED_BY = LOGIN;
}
if (formMode == FormMode.Edit)
{
obj.UPDATED_BY = LOGIN;
obj.AUTO_ID = visitorObj.AUTO_ID;
if (isChangePhoto || isChangeCardPhoto || isChangePass)
{
var attachment = new TRN_ATTACHEDMENT();
if (isChangePhoto)
{
attachment.CONTACT_PHOTO = ImageToByte(picPhoto);
}
else
{
if (visitorObj.TRN_ATTACHEDMENT.Count > 0)
{
attachment.CONTACT_PHOTO = visitorObj.TRN_ATTACHEDMENT.FirstOrDefault().CONTACT_PHOTO;
}
}
if (isChangeCardPhoto)
{
attachment.ID_CARD_PHOTO = ImageToByte(picCard);
}
else
{
if (visitorObj.TRN_ATTACHEDMENT.Count > 0)
{
attachment.ID_CARD_PHOTO = visitorObj.TRN_ATTACHEDMENT.FirstOrDefault().ID_CARD_PHOTO;
}
}
obj.TRN_ATTACHEDMENT = new List <TRN_ATTACHEDMENT>();
obj.TRN_ATTACHEDMENT.Add(attachment);
}
}
return(obj);
}
catch (Exception)
{
throw;
}
}
public ContainerVisitor GetVisitorForOutByID(int id)
{
var result = new ContainerVisitor();
try
{
using (var ctx = new BIG_VMSEntities())
{
var isAlreadyOut = ctx.TRN_VISITOR.Any(o => (o.STATUS == 2) && (o.AUTO_ID == id));
if (isAlreadyOut)
{
TRN_VISITOR visit = new TRN_VISITOR()
{
AUTO_ID = 0,
NO = 0,
};
result.TRN_VISITOR = visit;
result.Status = true;
result.Message = "หมายเลขนี้ได้ออกไปแล้ว";
}
else
{
var reTrnVisitor = ctx.TRN_VISITOR
.Include("MAS_PROVINCE")
.Include("TRN_ATTACHEDMENT")
.Where(o => o.AUTO_ID == id && (o.TYPE == "In" || o.TYPE == "Appointment"))
.OrderByDescending(x => x.NO).ToList();
if (reTrnVisitor.Count > 0)
{
if (reTrnVisitor.Any(o => o.STATUS == 2))
{
TRN_VISITOR visit = new TRN_VISITOR()
{
AUTO_ID = 0,
NO = 0,
};
result.TRN_VISITOR = visit;
result.Status = true;
result.Message = "หมายเลขนี้ได้ออกไปแล้ว";
}
else
{
result.TRN_VISITOR = reTrnVisitor.FirstOrDefault();
result.Status = true;
}
}
else
{
TRN_VISITOR visit = new TRN_VISITOR()
{
AUTO_ID = 0,
NO = 0,
};
result.TRN_VISITOR = visit;
result.Status = true;
result.Message = "ไม่พบข้อมูล";
}
}
}
}
catch (Exception ex)
{
result.Status = false;
result.ExceptionMessage = ex.Message;
}
return(result);
}
public ContainerVisitor GetVisitorForOutByNo(int no)
{
var result = new ContainerVisitor();
try
{
using (var ctx = new BIG_VMSEntities())
{
DateTime today = DateTime.Today;
DateTime endOfMonth = new DateTime(today.Year, today.Month, 1).AddMonths(1).AddDays(-1);
var startMonth = DateTime.Now.Month;
var year = DateTime.Now.Year;
var endMonth = DateTime.Now.Month;
if (today == endOfMonth)
{
endMonth = endMonth - 1;
}
var startDate = DateTime.Now.AddDays(-1.5);
var endDate = DateTime.Now.AddDays(1.5);
var isAlreadyOut = ctx.TRN_VISITOR.Any(o => (o.STATUS == 2) && (o.NO == no && (o.TYPE == "In" || o.TYPE == "Appointment")) && (o.CREATED_DATE >= startDate && o.CREATED_DATE <= endDate) && (o.YEAR == year));
if (isAlreadyOut)
{
TRN_VISITOR visit = new TRN_VISITOR()
{
AUTO_ID = 0,
NO = 0,
};
result.TRN_VISITOR = visit;
result.Status = true;
result.Message = "หมายเลขนี้ได้ออกไปแล้ว";
}
else
{
var reTrnVisitor = ctx.TRN_VISITOR
.Include("MAS_PROVINCE")
.Include("TRN_ATTACHEDMENT")
.Where(o => o.NO == no && (o.TYPE == "In" || o.TYPE == "Appointment"))
.Where(o => (o.CREATED_DATE >= startDate && o.CREATED_DATE <= endDate) && o.YEAR == year)
.OrderByDescending(x => x.NO).ToList();
if (reTrnVisitor.Count > 0)
{
if (reTrnVisitor.Any(o => o.STATUS == 2))
{
TRN_VISITOR visit = new TRN_VISITOR()
{
AUTO_ID = 0,
NO = 0,
};
result.TRN_VISITOR = visit;
result.Status = true;
result.Message = "หมายเลขนี้ได้ออกไปแล้ว";
}
else
{
result.TRN_VISITOR = reTrnVisitor.FirstOrDefault();
result.Status = true;
}
}
else
{
TRN_VISITOR visit = new TRN_VISITOR()
{
AUTO_ID = 0,
NO = 0,
};
result.TRN_VISITOR = visit;
result.Status = true;
result.Message = "ไม่พบข้อมูล";
}
}
}
}
catch (Exception ex)
{
result.Status = false;
result.ExceptionMessage = ex.Message;
}
return(result);
}
private void Save()
{
try
{
if (_container.TRN_VISITOR != null)
{
var res = new ContainerVisitor();
if (outFlag)
{
res = _service.UpdateVisitorOutByID(_container);
}
else
{
res = _service.UpdateVisitorOut(_container);
}
if (res.Status)
{
res = _service.GetItem(_container);
if (res.Status)
{
var org_obj = _container.TRN_VISITOR;
int no = Convert.ToInt32(res.TRN_VISITOR.NO);
var obj = new TRN_VISITOR()
{
NO = org_obj.NO,
ID_CARD = org_obj.ID_CARD,
TYPE = org_obj.TYPE == "Appointment" ? "AppointmentOut" : "Out",
FIRST_NAME = org_obj.FIRST_NAME,
LAST_NAME = org_obj.LAST_NAME,
CAR_TYPE_ID = org_obj.CAR_TYPE_ID,
LICENSE_PLATE = org_obj.LICENSE_PLATE,
LICENSE_PLATE_PROVINCE_ID = org_obj.LICENSE_PLATE_PROVINCE_ID,
REASON_ID = org_obj.REASON_ID,
CONTACT_EMPLOYEE_ID = org_obj.CONTACT_EMPLOYEE_ID,
STATUS = 2,
CREATED_BY = LOGIN,
UPDATED_BY = LOGIN,
CREATED_DATE = DateTime.Now,
UPDATED_DATE = DateTime.Now,
YEAR = org_obj.YEAR,
MONTH = org_obj.MONTH,
TRN_ATTACHEDMENT = org_obj.TRN_ATTACHEDMENT,
};
if (isChangePhoto)
{
if (obj.TRN_ATTACHEDMENT.Count > 0)
{
obj.TRN_ATTACHEDMENT.FirstOrDefault().VISITOR_ID = 0;
obj.TRN_ATTACHEDMENT.FirstOrDefault().AUTO_ID = 0;
obj.TRN_ATTACHEDMENT.FirstOrDefault().TRN_VISITOR = null;
obj.TRN_ATTACHEDMENT.FirstOrDefault().CONTACT_PHOTO = ImageToByte(picSlip);
}
else
{
var attach = new TRN_ATTACHEDMENT();
attach.CONTACT_PHOTO = ImageToByte(picSlip);
obj.TRN_ATTACHEDMENT = new List <TRN_ATTACHEDMENT>();
obj.TRN_ATTACHEDMENT.Add(attach);
}
}
else
{
if (obj.TRN_ATTACHEDMENT.Count > 0)
{
obj.TRN_ATTACHEDMENT.FirstOrDefault().VISITOR_ID = 0;
obj.TRN_ATTACHEDMENT.FirstOrDefault().AUTO_ID = 0;
obj.TRN_ATTACHEDMENT.FirstOrDefault().TRN_VISITOR = null;
obj.TRN_ATTACHEDMENT.FirstOrDefault().CONTACT_PHOTO = org_obj.TRN_ATTACHEDMENT.FirstOrDefault().CONTACT_PHOTO;
}
}
var container = new ContainerVisitor {
TRN_VISITOR = obj
};
res = _service.Create(container);
if (res.Status)
{
string dir = DIRECTORY_OUT + "\\" + obj.NO + "\\";
Directory.CreateDirectory(dir);
if (obj.TRN_ATTACHEDMENT.Count > 0)
{
SaveImage(picImage, dir + "PHOTO.jpg");
SaveImage(picCard, dir + "ID_CARD.jpg");
}
if (isChangePhoto)
{
SaveImage(picSlip, dir + "SLIP.jpg");
}
MessageBox.Show(Message.MSG_SAVE_COMPLETE, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
MessageBox.Show(res.ExceptionMessage, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(res.ExceptionMessage, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(res.ExceptionMessage, "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show("ไม่มีข้อมูล", "แจ้งเตือน", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
}
}