private void ValidateBeforeSubmit()
{
DTO.ResponseService <DTO.SummaryReceiveApplicant> res = new DTO.ResponseService <DTO.SummaryReceiveApplicant>();
res.DataResponse = (DTO.SummaryReceiveApplicant)Session["SummaryReceiveApplicant"];
List <DTO.ApplicantTemp> lst = new List <ApplicantTemp>();
res.DataResponse.ReceiveApplicantDetails.ToList().ForEach(x =>
{
DTO.ApplicantTemp app = new ApplicantTemp();
app.APPLICANT_CODE = x.APPLICANT_CODE;
app.TESTING_NO = x.TESTING_NO;
app.TESTING_DATE = x.TESTING_DATE;
app.EXAM_PLACE_CODE = x.EXAM_PLACE_CODE;
app.APPLY_DATE = DateTime.Today;
app.INSUR_COMP_CODE = x.INSUR_COMP_CODE;
app.USER_ID = base.UserId;
app.ID_CARD_NO = base.IdCard;
app.APPLY_DATE = x.APPLY_DATE;
//app.RUN_NO = Convert.ToString(x + 1);
lst.Add(app);
});
ApplicantBiz biz = new ApplicantBiz();
var checkBeforeSubmit = biz.ValidateApplicantSingleBeforeSubmit(lst);
if (checkBeforeSubmit.ResultMessage == true)
{
ModalPopupExtenderListExam.Show();
}
else
{
ImportInsertMode();
}
}
protected void btnGetOut_Click(object sender, EventArgs e)
{
try
{
if (Manage_App.ToArray().Count() > 0)
{
BLL.ApplicantBiz abiz = new ApplicantBiz();
var res = abiz.CancleExamApplicantManage(Manage_App.ToArray(), selectRoom.Text);
if (res.ResultMessage == false)
{
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
}
else
{
ClickView("");
UCModalSuccess.ShowMessageSuccess = SysMessage.SaveSucess;
UCModalSuccess.ShowModalSuccess();
}
Manage_App = null;
UpdatePanelSearch.Update();
}
else
{
UCModalError.ShowMessageError = "กรุณาเลือกผู้สมัครสอบก่อนทำรายการ";
UCModalError.ShowModalError();
}
}
catch
{
}
}
private bool ValidateBeforeSaveList()
{
string strPlaceCode = Session["ExamPlaceCode"].ToString();
string strExamNumber = Session["TestingNo"].ToString();
string strLicenseTypeCode = Session["LicenseTypeCode"].ToString();
string strTestTimeCode = Session["TestTimeCode"].ToString();
DateTime dtTestingDate = Convert.ToDateTime(Session["TestingDate"].ToString());
bool check = true;
ApplicantBiz abiz = new ApplicantBiz();
var checkIsDup = abiz.CheckApplicantIsDuplicate(txtExamNumber.Text, base.UserProfile.IdCard, dtTestingDate, strTestTimeCode, strPlaceCode);
// สอบซ้ำ
if (checkIsDup.ResultMessage == true)
{
this.MasterSite.ModelError.ShowMessageError = "ทำรายการสอบซ้ำ";
this.MasterSite.ModelError.ShowModalError();
return(check = false);
}
ExamScheduleBiz ebiz = new ExamScheduleBiz();
DTO.ResponseMessage <bool> IsCanSeat = ebiz.IsCanSeatRemainSingle(strExamNumber, strPlaceCode);
// จำนวนคนเกินรอบสอบ
if (!IsCanSeat.ResultMessage)
{
this.MasterSite.ModelError.ShowMessageError = "ห้องเต็ม";
this.MasterSite.ModelError.ShowModalError();
return(check = false);
}
return(check);
}
protected void btnAddIn_Click(object sender, EventArgs e)
{
try
{
if (Manage_App.ToArray().Count() > 0)
{
BLL.ApplicantBiz abiz = new ApplicantBiz();
var res = abiz.SaveExamAppRoom(Manage_App.ToArray(), ddlroom.Text, selectRoom.Text, "", false, base.UserId);
if (res.ResultMessage)//save OK
{
ClickView(selectRoom.Text);
UCModalSuccess.ShowMessageSuccess = SysMessage.SaveSucess;
UCModalSuccess.ShowModalSuccess();
}
else
{
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
}
Manage_App = null;
UpdatePanelSearch.Update();
}
else
{
UCModalError.ShowMessageError = "กรุณาเลือกผู้สมัครสอบก่อนทำรายการ";
UCModalError.ShowModalError();
}
}
catch
{
}
}
private void GetExamPlace()
{
try
{
BLL.ApplicantBiz appB = new ApplicantBiz();
var res = appB.GetExamPlaceByLicenseAndOwner(ddlAsso.SelectedValue.ToString(), ddlLicenseType.SelectedValue.ToString());
ddlPlaceName.DataValueField = "ID";
ddlPlaceName.DataTextField = "NAME";
ddlPlaceName.DataSource = res.DataResponse;
ddlPlaceName.DataBind();
ddlPlaceName.Items.Insert(0, SysMessage.DefaultSelecting);
}
catch
{
}
}
private void GetRoom()
{
try
{
string PlaceName = "%";
if ((ddlPlaceName.SelectedValue.ToString() != "เลือก") && (ddlPlaceName.SelectedValue.ToString() != ""))
{
PlaceName = ddlPlaceName.SelectedValue.ToString();
}
BLL.ApplicantBiz abiz = new ApplicantBiz();
var res = abiz.GetExamRoomByTestingNoforManage(selectRoom.Text, PlaceName);
ddlroom.DataValueField = "Id";
ddlroom.DataTextField = "Name";
ddlroom.DataSource = res.DataResponse;
ddlroom.DataBind();
}
catch
{
}
}
protected void BindDataInGridView2(Boolean count)
{
try
{
PAGE_SIZE = PAGE_SIZE_Key;
BLL.ApplicantBiz Abiz = new ApplicantBiz();
#region page
int Rpage = (txtNumberGvSearch2.Text.Trim() == "") ? 0 : txtNumberGvSearch2.Text.Trim().ToInt();
int resultPage = (Rpage == 0) ? 1 : txtNumberGvSearch2.Text.Trim().ToInt();
resultPage = resultPage == 0 ? 1 : resultPage;
if ((rowPerpage2.Text.Trim() == null) || (rowPerpage2.Text.Trim() == "") || (rowPerpage2.Text.ToInt() == 0))
{
rowPerpage2.Text = PAGE_SIZE.ToString();
}
else
{
PAGE_SIZE = Convert.ToInt32(rowPerpage2.Text);
}
#endregion page
string ConSQL = ddlEvent.SelectedValue.ToString() == "in"?"":"out";
if (count)
{
#region Page
var CountPage = Abiz.GetApplicantFromTestingNoForManageApplicant(selectRoom.Text, ConSQL, resultPage, PAGE_SIZE, true);
if (CountPage.DataResponse != null)
{
if (CountPage.DataResponse.Tables[0].Rows.Count > 0)
{
Int32 totalROWs = Convert.ToInt32(CountPage.DataResponse.Tables[0].Rows[0]["CCount"].ToString());
VisibleGV(gvSearch2, totalROWs, Convert.ToInt32(rowPerpage2.Text), true);
if (Rpage == 0)
{
NPbutton(btnPreviousGvSearch2, txtNumberGvSearch2, btnNextGvSearch2, "", txtTotalPage2);
}
}
else
{
VisibleGV(gvSearch2, 0, Convert.ToInt32(rowPerpage2.Text), true);
if (Rpage == 0)
{
NPbutton(btnPreviousGvSearch2, txtNumberGvSearch2, btnNextGvSearch2, "", txtTotalPage2);
}
txtTotalPage2.Text = "1";
}
}
#endregion Page
}
var res = Abiz.GetApplicantFromTestingNoForManageApplicant(selectRoom.Text, ConSQL, resultPage, PAGE_SIZE, false);
if (res.IsError)
{
btnNextGvSearch2.Visible = false;
btnPreviousGvSearch2.Visible = false;
txtNumberGvSearch2.Visible = false;
txtTotalPage2.Visible = false;
TXTrowperpage2.Visible = false;
lblParaPage2.Visible = false;
rowPerpage2.Visible = false;
pageGo2.Visible = false;
manageApp.Visible = false;
divAddIn.Visible = false;
divGetOut.Visible = false;
div_totalPage2.Visible = false;
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
}
else
{
if (res != null)
{
if (res.DataResponse.Tables[0].Rows.Count > 0)
{
btnPreviousGvSearch2.Enabled = true;
btnNextGvSearch2.Enabled = true;
#region ManageRoom
manageApp.Visible = true;
if (ddlEvent.SelectedValue.ToString() == "in")
{
divAddIn.Visible = true;
divGetOut.Visible = false;
btnAddIn.Visible = true;
btnGetOut.Visible = false;
}
else
{
divAddIn.Visible = false;
divGetOut.Visible = true;
btnAddIn.Visible = false;
btnGetOut.Visible = true;
}
#endregion ManageRoom
}
else
{
btnPreviousGvSearch2.Enabled = false;
btnNextGvSearch2.Enabled = false;
divAddIn.Visible = false;
divGetOut.Visible = false;
}
txtNumberGvSearch2.Enabled = false;
gvSearch2.DataSource = res.DataResponse;
gvSearch2.DataBind();
gvSearch2.Visible = true;
}
}
UpdatePanelSearch.Update();
}
catch
{
}
}
private void SaveListExam()
{
string group = string.Empty;
ApplicantBiz biz = new ApplicantBiz();
string strAmount = biz.GetQuantityBillPerPageByConfig();
if (ListApplicant.Count != 0 && ListApplicant.Count <= Convert.ToInt32(strAmount))
{
List <DTO.ApplicantTemp> lst = new List <ApplicantTemp>();
for (int i = 0; i < ListApplicant.Count; i++)
{
DTO.ApplicantTemp app = new ApplicantTemp();
app.TESTING_NO = ListApplicant[i].ExamNumber;
app.TESTING_DATE = ListApplicant[i].ExamDate;
app.EXAM_PLACE_CODE = ListApplicant[i].ExamPlaceCode;
app.APPLY_DATE = DateTime.Today;
app.INSUR_COMP_CODE = ListApplicant[i].InSurCompCode;
app.USER_ID = UserProfile.Id; // base.UserId; 140324110012352
app.ID_CARD_NO = UserProfile.IdCard; // base.IdCard; 4199682095940
app.APPLY_DATE = ListApplicant[i].ApplyDate;
app.TEST_TIME_CODE = ListApplicant[i].TestTimeCode;
app.RUN_NO = Convert.ToString(i + 1);
lst.Add(app);
}
string passGroup = string.Empty;
//Check
// var checkBeforeSubmit = biz.GeneralValidateApplicantSingleBeforeSubmit(lst);
//if (checkBeforeSubmit.ResultMessage == true)
//{
// UCModalError1.ShowMessageError = "รอบสอบที่คุณเลือกในรายการมีรายการที่คุณได้สมัครสอบแล้ว";
// UCModalError1.ShowModalError();
//}
//
//else
//{
var res = biz.InsertSingleApplicant(lst, base.UserId);
if (res.IsError)
{
UCModalError1.ShowMessageError = res.ErrorMsg;
UCModalError1.ShowModalError();
}
else
{
ListApplicant = new List <AddApplicant>();
this.ModalListExam.Hide();
Session["lstApplicant"] = null;
UCModalSuccess1.ShowMessageSuccess = SysMessage.SuccessInsertApplicant;
UCModalSuccess1.ShowModalSuccess();
group = res.DataResponse;
passGroup = group + " " + base.UserId;
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "", "OpenPopupSingle('" + passGroup + "')", true);
}
//}
}
else
{
UCModalError1.ShowMessageError = "กรุณาตรวจสอบจำนวนรายการที่สอบ";
UCModalError1.ShowModalError();
ModalListExam.Show();
}
}
// ทุกๆครั้งที่เลือกรายการสอบแบบปฏิทิน
protected void lnkExamNumber_Click(object sender, EventArgs e)
{
var gr = (GridViewRow)((LinkButton)sender).NamingContainer;
var strPlaceCode = (Label)gr.FindControl("lblPlaceCode");
var lblExamNumber = (Label)gr.FindControl("ExamNumberNo");
var lblExamDate = (Label)gr.FindControl("lblExamDate");
var lblExamTime = (Label)gr.FindControl("lblExamTime");
var lblExamPlaceGroup = (Label)gr.FindControl("lblGroupExamYard");
var lblExamPlace = (Label)gr.FindControl("lblPlaceName");
var lblProvince = (Label)gr.FindControl("lblProvice");
var lblSeat = (Label)gr.FindControl("lblExamAdmission");
var lblLicenseTypeName = (Label)gr.FindControl("lblLicenseTypeName");
var lblExamFee = (Label)gr.FindControl("lblExamFee");
var lblAgentType = (Label)gr.FindControl("lblAgentType");
var lblPlaceCode = (Label)gr.FindControl("lblPlaceCode");
var lblTestTimeCode = (Label)gr.FindControl("lblTestTimeCode");
var lblLicenseTypeCode = (Label)gr.FindControl("lblLicenseTypeCode");
var lblProvineCode = (Label)gr.FindControl("lblProvinceCode");
var lblExamPlaceGroupCode = (Label)gr.FindControl("lblExamPlaceGroupCode");
var lblExamOwnerName = (Label)gr.FindControl("lblExamOwnerName");
if (ListApplicant.Find(x => x.ExamDate == Convert.ToDateTime(lblExamDate.Text) && x.ExamTime == lblExamTime.Text) != null)
{
UCModalError1.ShowMessageError = "ได้มีการสมัครในวันและเวลาสอบนี้แล้วไม่สามารถสมัครสอบได้ กรุณาทำการสมัครสอบในวันพรุ่งนี้";
UCModalError1.ShowModalError();
}
else if (ListApplicant.Find(x => x.ExamNumber == lblExamNumber.Text) == null)
{
txtDetailExamCode.Text = lblExamNumber.Text;
txtDetailDateExam.Text = lblExamDate.Text;
txtTestTime.Text = lblExamTime.Text;
txtExamPlaceName.Text = lblExamPlaceGroup.Text;
txtProvincePopup.Text = lblProvince.Text;
txtLicenseTypeName.Text = lblLicenseTypeName.Text;
txtDetailPlaceCode.Text = lblExamPlace.Text;
txtExamOwner.Text = lblExamOwnerName.Text;
Session["ExamNumber"] = lblExamNumber.Text;
Session["ExamDate"] = lblExamDate.Text;
Session["ExamTime"] = lblExamTime.Text;
Session["ExamPlaceGroup"] = lblExamPlaceGroup.Text;
Session["ExamPlace"] = lblExamPlace.Text;
Session["Province"] = lblProvince.Text;
Session["Seat"] = lblSeat.Text;
Session["LicenseTypeName"] = lblLicenseTypeName.Text;
Session["ExamFee"] = lblExamFee.Text;
Session["AgentType"] = lblAgentType.Text;
Session["PlaceCode"] = lblPlaceCode.Text;
Session["ExamPlaceCode"] = strPlaceCode.Text;
Session["TestingNo"] = lblExamNumber.Text;
Session["TestingDate"] = lblExamDate.Text;
Session["TestTimeCode"] = lblTestTimeCode.Text;
Session["LicenseTypeCode"] = lblLicenseTypeCode.Text;
Session["ProvinceCode"] = lblProvineCode.Text;
Session["ExamPlaceGroupCode"] = lblExamPlaceGroupCode.Text;
var list = new List <DTO.ApplicantTemp>();
list.Add(new ApplicantTemp()
{
APPLICANT_CODE = 0,
TESTING_NO = lblExamNumber.Text,
TESTING_DATE = Convert.ToDateTime(lblExamDate.Text),
EXAM_PLACE_CODE = lblPlaceCode.Text,
APPLY_DATE = DateTime.Today,
USER_ID = UserProfile.Id,
ID_CARD_NO = UserProfile.IdCard
});
DateTime dtTestingDate = Convert.ToDateTime(lblExamDate.Text);
ApplicantBiz biz = new ApplicantBiz();
DTO.ResultValidateApplicant res = biz.ValidateApplicantBeforeSaveList(lblExamNumber.Text, UserProfile.IdCard, dtTestingDate, lblTestTimeCode.Text, strPlaceCode.Text, lblExamTime.Text, ListApplicant);
if (res.IsConfirm)
{
ModalPopupExtenderListExam.Show();
lblConfirmExam.Text = res.ValidateMessage;
return;
}
if (!res.IsCanExam)
{
UCModalError1.ShowMessageError = res.ValidateMessage;
UCModalError1.ShowModalError();
return;
}
var checkBeforeSubmit = biz.GeneralValidateApplicantSingleBeforeSubmit(list);
if (checkBeforeSubmit.ResultMessage == true)
{
UCModalError1.ShowMessageError = "สมัครสอบซ้ำ";
UCModalError1.ShowModalError();
}
else
{
if (ddlTypeLicense.SelectedValue == "03" || ddlTypeLicense.SelectedValue == "04" || ddlTypeLicense.SelectedValue == "11" || ddlTypeLicense.SelectedValue == "12")
{
lblDetailCompanyCode.Visible = false;
ddlCompanyCode.Visible = false;
}
else
{
lblDetailCompanyCode.Visible = true;
ddlCompanyCode.Visible = true;
GetCompany(ddlTypeLicense.SelectedValue);
}
ModSingleApplicant.Show();
}
}
else
{
ModalListExam.Show();
UCModalError1.ShowMessageError = "รอบสอบนี้คุณได้เลือกเข้าไปในรายการแล้ว";
UCModalError1.ShowModalError();
}
}
protected void BindData(Boolean Count)
{
try
{
#region page
int Rpage = (txtNumberGvSearch.Text.Trim() == "") ? 0 : txtNumberGvSearch.Text.Trim().ToInt();
int resultPage = (Rpage == 0) ? 1 : txtNumberGvSearch.Text.Trim().ToInt();
resultPage = resultPage == 0 ? 1 : resultPage;
if ((rowPerpage.Text.Trim() == null) || (rowPerpage.Text.Trim() == "") || (rowPerpage.Text.ToInt() == 0))
{
rowPerpage.Text = PageSize.ToString();
}
else
{
PageSize = Convert.ToInt32(rowPerpage.Text);
}
#endregion page
ApplicantBiz biz = new ApplicantBiz();
string a;
string s;
string AS_result;
string o_result;
a = ddlStatus.SelectedValue;
if (a != "")
{
var stringValue = a;
s = stringValue.Substring(0, 1);
AS_result = stringValue.Substring(1, 1);
o_result = stringValue.Substring(2, 1);
}
else
{
s = "";
AS_result = "";
o_result = "";
}
if (Count)
{
#region Page
var CountPage = biz.GetApproveEditApplicant((DTO.RegistrationType)base.UserRegType, txtIDCard.Text, txtTestingNo.Text, base.UserProfile.IdCard, base.UserProfile.CompCode, s, resultPage, PageSize, true, base.UserProfile.MemberType.ToString(), AS_result, o_result);
if (CountPage.DataResponse != null)
{
if (CountPage.DataResponse.Tables[0].Rows.Count > 0)
{
Int64 totalROWs = Convert.ToInt32(CountPage.DataResponse.Tables[0].Rows[0]["CCount"].ToString());
VisibleGV(gvDetail, totalROWs, Convert.ToInt32(rowPerpage.Text), true);
if (Rpage == 0)
{
NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage);
}
}
else
{
VisibleGV(gvDetail, 0, Convert.ToInt32(rowPerpage.Text), true);
if (Rpage == 0)
{
NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage);
}
txtTotalPage.Text = "1";
}
}
#endregion Page
}
string aaa = base.UserProfile.MemberType.ToString();
var res = biz.GetApproveEditApplicant((DTO.RegistrationType)base.UserRegType, txtIDCard.Text, txtTestingNo.Text, base.UserProfile.IdCard, base.UserProfile.CompCode, s, resultPage, PageSize, false, base.UserProfile.MemberType.ToString(), AS_result, o_result);
if (res.IsError)
{
btnNextGvSearch.Visible = false;
btnPreviousGvSearch.Visible = false;
txtNumberGvSearch.Visible = false;
txtTotalPage.Visible = false;
TXTrowperpage.Visible = false;
lblParaPage.Visible = false;
rowPerpage.Visible = false;
pageGo.Visible = false;
div_totalPage.Visible = false;
UCModalError.ShowMessageError = res.ErrorMsg;
UCModalError.ShowModalError();
}
else if (res != null)
{
if (res.DataResponse.Tables[0].Rows.Count > 0)
{
PnlDetailSearchGridView.Visible = true;
bludDiv1.Visible = true;
gvDetail.DataSource = res.DataResponse;
gvDetail.DataBind();
//int rowcount = res.DataResponse.Tables[0].Rows.Count;
//lblTotal.Text = rowcount.ToString();
div_totalPage.Visible = true;
lblTotal.Visible = true;
}
else
{
PnlDetailSearchGridView.Visible = true;
bludDiv1.Visible = true;
div_totalPage.Visible = true;
lblTotal.Visible = true;
gvDetail.DataSource = res.DataResponse;
gvDetail.DataBind();
txtNumberGvSearch.Enabled = false;
btnPreviousGvSearch.Enabled = false;
btnNextGvSearch.Enabled = false;
}
}
else
{
UCModalError.ShowMessageError = "ไม่พบข้อมูลผู้สมัครสอบ";
UCModalError.ShowModalError();
}
}
catch (Exception ex)
{
}
}
