protected void lbtnEdit_Click(object sender, EventArgs e)
{
try
{
BLL.ExamScheduleBiz biz = new ExamScheduleBiz();
GridViewRow gr = (GridViewRow)((LinkButton)sender).Parent.Parent;
txtCodeRoom.Text = ((Label)gr.FindControl("lblCodeRoom")).Text;
txtNameRoom.Text = ((Label)gr.FindControl("lblNameRoom")).Text;
txtSeatAmount.Text = ((Label)gr.FindControl("lblSeatAmount")).Text;
lblOldSeat.Text = txtSeatAmount.Text;
lblSeatAmountPlace.Text = biz.SumSeatFromPlace(ddlExamPlace.SelectedValue.ToString(), txtCodeRoom.Text).DataResponse.ToString();
txtCodeRoom.Enabled = false;
btnUpdate.Visible = true;
btnSave.Visible = false;
uplPopUp.Update();
mpeExamRoom.Show();
}
catch
{
}
}
protected void hplCancel_Click(object sender, EventArgs e)
{
try
{
var gr = (GridViewRow)((LinkButton)sender).NamingContainer;
var lblTimeCode = (Label)gr.FindControl("lblPlaceCode");
string Key = lblTimeCode.Text;
ExamScheduleBiz biz = new ExamScheduleBiz();
DTO.ResponseMessage <bool> DelP = biz.DelPlace(Key, base.UserId.ToString());
Boolean Del_time = DelP.ResultMessage;
if (!Del_time)
{
UCModalSuccess1.ShowMessageSuccess = "บันทึกสำเร็จ";
UCModalSuccess1.ShowModalSuccess();
}
else
{
UCModalError1.ShowMessageError = "ไม่สามารถบันทึกได้";
UCModalError1.ShowModalError();
}
btn_Search_Click(sender, e);
}
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 Init(String userId, DateTime initDate)
{
cldExam.VisibleDate = initDate;
pnlCalendar.Visible = true;
pnlSearch.Visible = true;
pnlTable.Visible = true;
BLL.ExamScheduleBiz examBiz = new ExamScheduleBiz();
DTO.Exams.CarlendarExamInitRequest initRequest = new DTO.Exams.CarlendarExamInitRequest()
{
FirstItemLicenseType = "",
FirstItemExamPlaceGroup = "เลือก",
FirstItemExamPlace = "",
FirstItemExamTime = "เลือก",
UserId = UserIdRequest
};
var res = examBiz.CarlendarExamInit(initRequest);
BindToDDL(ddlTypeLicense, res.DataResponse.LicenseTypes);
BindToDDL(ddlPlaceGroup, res.DataResponse.ExamPlaceGroups);
BindToDDL(ddlTime, res.DataResponse.ExamTimes);
txtYear.Text = cldExam.VisibleDate.ToString("yyyy", System.Globalization.CultureInfo.CreateSpecificCulture("th-TH"));
GetMonth();
}
protected void btnPopUp_Click(object sender, EventArgs e)
{
try
{
BLL.ExamScheduleBiz biz = new ExamScheduleBiz();
lblSeatAmountPlace.Text = biz.SumSeatFromPlace(ddlExamPlace.SelectedValue.ToString(), "").DataResponse.ToString();
// ClearControl();
if (ddlExamPlaceGroup.SelectedIndex > 0 && ddlExamPlace.SelectedIndex > 0)
{
// ddlExamPlace.Enabled = true;
// ddlExamPlaceGroup.Enabled = true;
txtCodeRoom.Enabled = true;
btnUpdate.Visible = false;
btnSave.Visible = true;
ClearControl();
mpeExamRoom.Show();
uplPopUp.Update();
}
else
{
UCError.ShowMessageError = SysMessage.ChooseData;
UCError.ShowModalError();
}
}
catch
{ }
}
protected void BindPopUp(string testingNo, string examPlaceCode)
{
try
{
ExamScheduleBiz biz = new ExamScheduleBiz();
var res = biz.GetExamByTestingNoAndPlaceCode(testingNo, examPlaceCode);
if (res.DataResponse != null)
{
var ent = res.DataResponse;
txtSetTestingNo.Text = string.IsNullOrEmpty(ent.TESTING_NO) ? testingNo : ent.TESTING_NO;
if (!string.IsNullOrEmpty(ent.PRIVILEGE_STATUS))
{
rblSetImport.SelectedValue = ent.PRIVILEGE_STATUS;
}
else
{
rblSetImport.ClearSelection();
}
}
}
catch (Exception ex)
{
//MessageBoxError(ex.Message);
}
}
private double TotalRow()
{
ExamScheduleBiz biz = new ExamScheduleBiz();
var res = biz.GetExamLicenseByCriteria(txtTestingNo.Text, txtDateExam.Text, 0, 0, true).DataResponse;
return(double.Parse(res.Tables[0].Rows[0][0].ToString()));
}
protected void btn_Save_Click(object sender, EventArgs e)
{
try
{
if (ddlPlaceGroup.SelectedValue != "")
{
if (txtSeat.Text.Trim() == "" || txtPlace.Text.Trim() == "" || txtCode.Text.Trim() == "")
{
UCModalError1.ShowMessageError = "กรุณาระบุข้อมูลให้ครบ";
UCModalError1.ShowModalError();
}
else
{
if (txtSeat.Text.ToInt() > 30000)
{
UCModalError1.ShowMessageError = "สนามสอบแต่ละแห่งสามารถรองรับผู้สมัครสอบได้สูงสุด 30,000 คน เท่านั้น";
UCModalError1.ShowModalError();
}
else
{
if (txtCode.Text.Length == 5)
{
Boolean addnew = true;
if (txtCode.Enabled == false)
{
addnew = false;
}
ExamScheduleBiz biz = new ExamScheduleBiz();
DTO.ResponseMessage <bool> SaveOK = biz.SavePlace(ddlPlaceG.SelectedValue.ToString(), ddlProvince.SelectedValue.ToString(), txtCode.Text, txtPlace.Text, txtSeat.Text, chkFree.Checked, base.UserId.ToString(), addnew, ddlPlaceGroup.SelectedValue.ToString());
if (SaveOK.ResultMessage == true)
{
UCModalSuccess1.ShowMessageSuccess = SysMessage.SaveSucess;
UCModalSuccess1.ShowModalSuccess();
btn_Search_Click(sender, e);
btn_Cancle_Click(sender, e);
UpdatePanelUpload.Update();
}
else
{
UCModalError1.ShowMessageError = SaveOK.ErrorMsg;
UCModalError1.ShowModalError();
}
}
else
{
UCModalError1.ShowMessageError = "รหัสสนามสอบต้องมีจำนวน 5 ตัวอักษรเท่านั้น";
UCModalError1.ShowModalError();
}
}
}
}
}
catch
{
}
}
private void BindGrid()
{
TotalRows = TotalRow();
ExamScheduleBiz biz = new ExamScheduleBiz();
txtNumberGvSearch.Text = (txtTotalPage.Text == LastPage().ToString() ? txtNumberGvSearch.Text : "1");
int page = int.Parse(txtNumberGvSearch.Text);
gvCandidateDelay.DataSource = biz.GetExamLicenseByCriteria(txtTestingNo.Text, txtDateExam.Text, page, rowsPerPage(), false).DataResponse;
gvCandidateDelay.DataBind();
SetTextTotlaRows();
}
private Boolean CheckBeforeSave()
{
Boolean BeforeSave = true;
try
{
if (txtSeatAmount.Text.ToInt() == 0)
{
UCError.ShowMessageError = "จำนวนที่นั่งต้องมีค่ามากกว่า 0";
UCError.ShowModalError();
BeforeSave = false;
}
else
{
if (txtSeatAmount.Text.ToInt() > 30000)
{
UCError.ShowMessageError = "ห้องสอบแต่ละห้องสามารถรองรับผู้สมัครสอบได้สูงสุด 30,000 คน เท่านั้น";
UCError.ShowModalError();
BeforeSave = false;
}
else
{
BLL.ExamScheduleBiz biz = new ExamScheduleBiz();
string Room = "";
if (txtCodeRoom.Enabled == false)
{
Room = txtCodeRoom.Text;
}
lblSeatAmountPlace.Text = (lblSeatAmountPlace.Text == "") ? biz.SumSeatFromPlace(ddlExamPlace.SelectedValue.ToString(), Room).DataResponse.ToString() : lblSeatAmountPlace.Text;
lbltotalSeat.Text = biz.SumSeat(ddlExamPlace.SelectedValue.ToString()).DataResponse.ToString();
lbltotalSeat.Text = lbltotalSeat.Text == "" ? "0" : lbltotalSeat.Text;
BeforeSave = true;
}
}
}
catch
{
}
return(BeforeSave);
}
protected void btnSave_Click(object sender, EventArgs e)
{
ExamScheduleBiz biz = new ExamScheduleBiz();
try
{
DTO.ExamSchedule ent = new DTO.ExamSchedule();
ent.TESTING_NO = txtSetTestingNo.Text;
ent.EXAM_PLACE_CODE = hdfExamPlaceCode.Value;
ent.PRIVILEGE_STATUS = rblSetImport.SelectedValue;
var res = biz.UpdateExam(ent);
if (!res.IsError)
{
PopUpLicense.Hide();
this.MasterSite.ModelSuccess.ShowMessageSuccess = SysMessage.SaveSucess;
this.MasterSite.ModelSuccess.ShowModalSuccess();
btnSearch_Click(sender, e);
//uplConditionDelay.Update();
UplPopUp.Update();
}
else
{
PopUpLicense.Show();
this.MasterSite.ModelError.ShowMessageError = res.ErrorMsg;
this.MasterSite.ModelError.ShowModalError();
UplPopUp.Update();
}
}
catch (Exception ex)
{
PopUpLicense.Show();
this.MasterSite.ModelError.ShowMessageError = ex.Message;
this.MasterSite.ModelError.ShowModalError();
UplPopUp.Update();
}
}
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
ExamScheduleBiz biz = new ExamScheduleBiz();
if (Count)
{
#region Page
var CountPage = biz.GetExamPlaceAndDetailFromProvinceAndGroupCode(ddlProvince.SelectedValue.ToString(), ddlPlaceG.SelectedValue.ToString(), ddlPlaceGroup.SelectedValue.ToString(), resultPage, PageSize, true);
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(gvPlace, totalROWs, Convert.ToInt32(rowPerpage.Text), true);
if (Rpage == 0)
{
NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage);
}
}
else
{
VisibleGV(gvPlace, 0, Convert.ToInt32(rowPerpage.Text), true);
if (Rpage == 0)
{
NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage);
}
txtTotalPage.Text = "1";
}
}
#endregion Page
}
if (ddlPlaceG.SelectedIndex > 0 && ddlProvince.SelectedIndex > 0 && ddlPlaceGroup.SelectedValue != "")
{
DTO.ResponseService <DataSet> Place = biz.GetExamPlaceAndDetailFromProvinceAndGroupCode(ddlProvince.SelectedValue.ToString(), ddlPlaceG.SelectedValue.ToString(), ddlPlaceGroup.SelectedValue.ToString(), resultPage, PageSize, false);
if (Place != null)
{
gvPlace.DataSource = Place.DataResponse;
gvPlace.DataBind();
gvPlace.Visible = true;
//int rowcount = res.DataResponse.Tables[0].Rows.Count;
//lblTotal.Text = rowcount.ToString();
div_totalPage.Visible = true;
lblTotal.Visible = true;
btn_Add.Visible = true;
if (gvPlace.Visible == true)
{
PanalPage.Visible = true;
}
else
{
PanalPage.Visible = false;
}
}
//btnPreviousGvSearch.Visible = true;
//txtNumberGvSearch.Visible = true;
//btnNextGvSearch.Visible = true;
//div_totalPage.Visible = true;
}
else
{
UCModalError1.ShowMessageError = SysMessage.ChooseData;
UCModalError1.ShowModalError();
btn_Add.Visible = false;
if (gvPlace.Visible == true)
{
PanalPage.Visible = true;
}
else
{
PanalPage.Visible = false;
}
}
}
catch
{
}
}
private void CreateCSVFile()
{
string strExamNumber = Convert.ToString(Session["ExamNumber"]);
string strExamTime = Convert.ToString(Session["ExamTime"]);
string strExamPlaceGroup = Convert.ToString(Session["ExamPlaceGroup"]);
string strExamPlace = Convert.ToString(Session["ExamPlace"]);
string strProvince = Convert.ToString(Session["Province"]);
string strSeat = Convert.ToString(Session["Seat"]);
string strLicenseTypeName = Convert.ToString(Session["LicenseTypeName"]);
string strExamFee = Convert.ToString(Session["ExamFee"]);
string strAgentType = Convert.ToString(Session["AgentType"]);
string strPlaceCode = Convert.ToString(Session["PlaceCode"]);
string strTestingNo = Convert.ToString(Session["TestingNo"]);
string strTestingDate = Convert.ToString(Session["TestingDate"]);
string strTestTimeCode = Convert.ToString(Session["TestTimeCode"]);
string strLicenseTypeCode = Convert.ToString(Session["LicenseTypeCode"]);
string strProvineCode = Convert.ToString(Session["ProvinceCode"]);
string strExamPlaceGroupCode = Convert.ToString(Session["ExamPlaceGroupCode"]);
DateTime dtTestingDate = Convert.ToDateTime(strTestingDate);
var arrComp = ddlCompany.SelectedValue.Split('[', ']');
ExamScheduleBiz biz = new ExamScheduleBiz();
List <DTO.ExamLicense> lsExamLicense = new List <ExamLicense>();
DTO.ExamLicense examLicense = new ExamLicense();
examLicense.TESTING_DATE = dtTestingDate;
examLicense.TESTING_NO = strTestingNo;
lsExamLicense.Add(examLicense);
DateTime dtStart = DateTime.Today.AddDays(-3);
int iCom = DateTime.Compare(dtStart, dtTestingDate);
if (iCom == 0 || iCom == 1)
{
this.MasterSite.ModelError.ShowMessageError = "ต้องนำเข้าก่อน 3 วันทำการสอบ ";
this.MasterSite.ModelError.ShowModalError();
}
var exam = biz.UpdateExamCondition(lsExamLicense);
if (exam.ResultMessage == false)
{
this.MasterSite.ModelError.ShowMessageError = exam.ErrorMsg;
this.MasterSite.ModelError.ShowModalError();
}
string examfee = biz.GetExamFee().DataResponse;;
using (var stream = new MemoryStream())
{
using (var csvWriter = new StreamWriter(stream, Encoding.UTF8))
{
csvWriter.WriteLine("RECORD TYPE,จังหวัด,รหัสสนามสอบ,ประเภทใบอนุญาต,วัน/เดือน/ปี,จำนวนคน,จำนวนเงินทั้งหมด,เวลาสอบ");
csvWriter.WriteLine("H" + "," + strProvineCode + "," + strExamPlaceGroupCode + "," + strLicenseTypeCode + "," + strTestingDate + "," + "1" + "," + examfee + "," + strTestTimeCode);
csvWriter.WriteLine("เลขที่สอบ,หมายเลขบัตรประชาชน,คำนำหน้า,ชื่อ,นามสกุล,วัน/เดือน/ปี,เพศ,วุฒิการศึกษา,รหัสบริษัท,ที่อยู่,รหัสพื้นที่,หน่วยรับสมัคร");
//csvWriter.WriteLine("1" + "," + txtIDCard.Text + "," + ddlTitle.SelectedItem.Text + "," + txtFirstNane.Text + "," + txtLastName.Text + "," + txtBirthDay.Text + "," + rblSex.SelectedValue + "," + ddlEducation.SelectedValue == "0" ? null : ddlEducation.SelectedValue + "," + arrComp[1] + "," + txtAddress.Text + "," + txtAreaCode.Text);
csvWriter.WriteLine("1" + "," + txtIDCard.Text + "," + ddlTitle.SelectedItem.Text + "," + txtFirstNane.Text + "," + txtLastName.Text + "," + txtBirthDay.Text + "," + rblSex.SelectedValue + "," + ddlEducation.SelectedValue + "," + arrComp[1] + "," + txtAddress.Text + "," + txtAreaCode.Text);
csvWriter.Flush();
}
MemoryStream memoryStream = new MemoryStream(stream.ToArray());
LoadFileSingle(memoryStream);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (CheckBeforeSave())
{
if (lblSeatAmountPlace.Text.ToInt() < txtSeatAmount.Text.ToInt())
{
UCError.ShowMessageError = "จำนวนที่นั่งของทุกห้องมากเกินกว่า<br>จำนวนที่นั่งที่สนามสอบนี้สามารถรองรับได้";
UCError.ShowModalError();
}
else
{
if (txtCodeRoom.Text.Length == 6)
{
BLL.ExamRoomBiz biz = new BLL.ExamRoomBiz();
DTO.ConfigExamRoom ent = new DTO.ConfigExamRoom();
ent.EXAM_ROOM_CODE = txtCodeRoom.Text;
ent.EXAM_ROOM_NAME = txtNameRoom.Text;
ent.SEAT_AMOUNT = txtSeatAmount.Text.ToShort();
ent.EXAM_PLACE_CODE = ddlExamPlace.SelectedValue;
var res = biz.InsertExamRoom(ent, UserProfile);
if (!res.IsError)
{
//initGvExamRoom();
UCSuccess.ShowMessageSuccess = SysMessage.SaveSucess;
UCSuccess.ShowModalSuccess();
btnSearch_Click(sender, e);
UpdatePanelGridviw.Update();
}
else
{
#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
ExamScheduleBiz bizGV = new ExamScheduleBiz();
var Place = bizGV.GetGVExamRoomByPlaceCode(ddlExamPlace.SelectedValue.ToString(), resultPage, PageSize, false);
for (int i = 0; i < Place.DataResponse.Tables[0].Rows.Count; i++)
{
DataTable DT = Place.DataResponse.Tables[0];
DataRow DR = DT.Rows[i];
ExamRoomCode = DR["Exam_room_code"].ToString();
if (ExamRoomCode == txtCodeRoom.Text)
{
break;
}
}
if (ExamRoomCode == txtCodeRoom.Text)
{
UCError.ShowMessageError = res.ErrorMsg;
UCError.ShowModalError();
}
else
{
UCError.ShowMessageError = "ไม่สามารถเพิ่มข้อมูลได้ เนื่องจากมีการยกเลิกการใช้งานรหัสห้องสอบ " + txtCodeRoom.Text + " แล้ว<br>กรุณาใช้รหัสห้องสอบอื่น";
UCError.ShowModalError();
}
}
}
else
{
UCError.ShowMessageError = "รหัสห้องสอบต้องมีจำนวน 6 ตัวอักษรเท่านั้น";
UCError.ShowModalError();
}
}
}
}
catch (Exception ex)
{
UCError.ShowMessageError = ex.Message;
UCError.ShowModalError();
}
// ClearControl();
lblSeatAmountPlace.Text = "";
txtCodeRoom.Text = "";
txtNameRoom.Text = "";
txtSeatAmount.Text = "";
uplPopUp.Update();
}
