private void ImportInsertMode()
{
BLL.ApplicantBiz biz = new BLL.ApplicantBiz();
ApplicantTemp app = new ApplicantTemp();
var result = biz.ApplicantGroupUploadToSubmit(hdfGroupID.Value, base.UserProfile);
if (result.ErrorMsg == null)
{
string strResult = result.DataResponse;
this.MasterSite.ModelSuccess.ShowMessageSuccess = Resources.infoGroupApplicantDetail_001;
this.MasterSite.ModelSuccess.ShowModalSuccess();
pnlImportFile.Visible = false;
CleanData();
ClearControlSingle();
}
else
{
var errorMsg = result.ErrorMsg;
this.MasterSite.ModelError.Visible = true;
ReBindDatainGrid(hdfGroupID.Value);
this.MasterSite.ModelError.ShowMessageError = result.ErrorMsg;
this.MasterSite.ModelError.ShowModalError();
}
}
public void GetAttatchRegisterationFiles()
{
ApplicantBiz biz = new BLL.ApplicantBiz();
DTO.ResponseService <DTO.AttachFileApplicantChangeEntity[]> res = biz.GetAttatchFilesAppChangeByIDCard(idcard.Trim(), Convert.ToInt32(lblChangeid.Text));
//var list = res.DataResponse.ToList();
if (res.DataResponse.Count() > 0)
{
IList <BLL.AttachFilesIAS.AttachFile> ls = BLL.AttachFilesIAS.AttachFileMapper.ConvertToAttachFilesApplicantView(res.DataResponse.ToList());
ucAttachFileControl1.AttachFiles = ls.ToList();
//this.GetAttachFilesType();
this.GetAttachFilesAllType();
ucAttachFileControl1.GridAttachFiles.DataSource = ls.ToList();
ucAttachFileControl1.GridAttachFiles.DataBind();
ucAttachFileControl1EnabledFalse();
}
else
{
this.GetAttachFilesAllType();
ucAttachFileControl1.GridAttachFiles.DataSource = null;
ucAttachFileControl1.GridAttachFiles.DataBind();
}
UpdatePanelSearch.Update();
}
protected void btnTest7_Click(object sender, EventArgs e)
{
var biz = new BLL.ApplicantBiz();
var data = biz.GetApplicantInfo("1", "561178", "10003", 0, 0, false);
gv.DataSource = data.DataResponse.Subjects;
gv.DataBind();
}
protected void btnGetData_Click(object sender, EventArgs e)
{
var biz = new BLL.ApplicantBiz();
//var res = biz.GetApplicantByCriteria("", "","", "1", "", "", null,null, "", "");
//var res = biz.PersonGetApplicantByCriteria("1111111111122");
//var res = biz.GetApplicantByLicenseType("");
//gv.DataSource = res.DataResponse;
//gv.DataBind();
}
private Boolean IsPersonCanApplicant()
{
DTO.IsPersonCanApplicantRequest request = new IsPersonCanApplicantRequest()
{
IdCardNumber = txtIDCard.Text.Trim(), TestingNo = txtExamNumber.Text.Trim()
};
BLL.ApplicantBiz biz = new BLL.ApplicantBiz();
return(biz.IsPersonCanApplicant(request));
}
private void LoadFileSingle(MemoryStream memberStream)
{
bool CanSaveToList = ValidateBeforeSaveList();
if (CanSaveToList)
{
if (true)
{
if (true)
{
BLL.ApplicantBiz biz = new BLL.ApplicantBiz();
var res = biz.UploadData("CSVFileName", memberStream, Convert.ToString(Session["TestingNo"]), ExamPlaceCode, UserId, base.UserProfile);
if (!res.IsError)
{
Session["SummaryReceiveApplicant"] = res.DataResponse;
pnlImportFile.Visible = true;
List <DTO.UploadHeader> headers = new List <UploadHeader>();
headers.Add(res.DataResponse.Header);
gvImportFile.DataSource = headers;
gvImportFile.DataBind();
hdfGroupID.Value = res.DataResponse.UploadGroupNo;
var detail = res.DataResponse.ReceiveApplicantDetails;
gvCheckList.DataSource = res.DataResponse.ReceiveApplicantDetails;
gvCheckList.DataBind();
CanSubmitData();
}
else
{
var errorMsg = res.ErrorMsg;
this.MasterSite.ModelError.ShowMessageError = res.ErrorMsg;
this.MasterSite.ModelError.ShowModalError();
}
}
//check type 15/11/2556
else
{
this.MasterSite.ModelError.ShowMessageError = SysMessage.CannotWrongUploadFile;
this.MasterSite.ModelError.ShowModalError();
}
}
else
{
this.MasterSite.ModelError.ShowMessageError = SysMessage.CannotUploadFile;
this.MasterSite.ModelError.ShowModalError();
}
}
}
protected void btnLoadFile_Click(object sender, EventArgs e)
{
divSingle.Visible = false;
string tempFileName = Path.GetFileName(FuFile.PostedFile.FileName);
bool invalid = validateFileType(tempFileName);
ClearSummaryApplicant();
if (!string.IsNullOrEmpty(FuFile.FileName))
{
if (invalid)
{
BLL.ApplicantBiz biz = new BLL.ApplicantBiz();
var res = biz.UploadData(FuFile.FileName, FuFile.PostedFile.InputStream, TestingNo, ExamPlaceCode, UserId, base.UserProfile);
if (!res.IsError)
{
Session["SummaryReceiveApplicant"] = res.DataResponse;
pnlImportFile.Visible = true;
List <DTO.UploadHeader> headers = new List <UploadHeader>();
headers.Add(res.DataResponse.Header);
gvImportFile.DataSource = headers;
gvImportFile.DataBind();
hdfGroupID.Value = res.DataResponse.UploadGroupNo;
var detail = res.DataResponse.ReceiveApplicantDetails;
gvCheckList.DataSource = res.DataResponse.ReceiveApplicantDetails;
gvCheckList.DataBind();
CanSubmitData();
}
else
{
var errorMsg = res.ErrorMsg;
this.MasterSite.ModelError.ShowMessageError = res.ErrorMsg;
this.MasterSite.ModelError.ShowModalError();
}
}
//check type 15/11/2556
else
{
this.MasterSite.ModelError.ShowMessageError = SysMessage.CannotWrongUploadFile;
this.MasterSite.ModelError.ShowModalError();
}
}
else
{
this.MasterSite.ModelError.ShowMessageError = SysMessage.CannotUploadFile;
this.MasterSite.ModelError.ShowModalError();
}
}
private void ImportInsertMode()
{
BLL.ApplicantBiz biz = new BLL.ApplicantBiz();
var result = biz.ApplicantGroupUploadToSubmit(hdfGroupID.Value, base.UserProfile);
if (!result.IsError)
{
UCModalSuccess.ShowMessageSuccess = Resources.infoGroupApplicantDetail_001;
UCModalSuccess.ShowModalSuccess();
CleanData();
pnlImportFile.Visible = false;
}
else
{
UCModalError.Visible = true;
UCModalError.ShowMessageError = result.ErrorMsg;
UCModalError.ShowModalError();
}
}
private void ReBindDatainGrid(string strGroupUploadNo)
{
BLL.ApplicantBiz biz = new BLL.ApplicantBiz();
var res = biz.GetApplicantGroupUploadByGroupUploadNo(strGroupUploadNo);
if (!res.IsError)
{
gvImportFile.DataSource = res.DataResponse.Header;
gvImportFile.DataBind();
gvCheckList.DataSource = res.DataResponse.Detail;
gvCheckList.DataBind();
}
else
{
var errorMsg = res.ErrorMsg;
this.MasterSite.ModelError.ShowMessageError = res.ErrorMsg;
this.MasterSite.ModelError.ShowModalError();
}
}
public void BindApplicantUploadTempByID(string strGroupID, string strSeqNo)
{
BLL.ApplicantBiz biz = new BLL.ApplicantBiz();
var res = biz.GetApplicantUploadTempById(strGroupID, strSeqNo);
if (res.IsError)
{
var errorMsg = res.ErrorMsg;
AlertMessage.ShowAlertMessage(string.Empty, errorMsg);
}
else
{
txtDetailName.Text = res.DataResponse.NAMES;
ddlDetailTitleName.Text = res.DataResponse.PRE_NAME_CODE;
txtDetailLastName.Text = res.DataResponse.LASTNAME;
txtDetailIdCardNumber.Text = res.DataResponse.ID_CARD_NO;
string strBD = res.DataResponse.BIRTH_DATE == null ? string.Empty : res.DataResponse.BIRTH_DATE.Value.ToString("dd/MM/yyyy");
txtDetailBirthDay.Text = strBD;
string strTestingDate = res.DataResponse.TESTING_DATE == null ? string.Empty : res.DataResponse.TESTING_DATE.Value.ToString("dd/MM/yyyy");
txtDetailExamDate.Text = strTestingDate;
string strED = res.DataResponse.EDUCATION_CODE == null ? string.Empty : res.DataResponse.EDUCATION_CODE.ToString();
ddlDetailEducation.Text = strED;
string strAppCode = res.DataResponse.APPLICANT_CODE == null ? string.Empty : res.DataResponse.APPLICANT_CODE.Value.ToString();
txtDetailPersonExam.Text = strAppCode;
txtDetailExamCode.Text = res.DataResponse.TESTING_NO;
txtDetailYardCode.Text = res.DataResponse.EXAM_PLACE_CODE;
txtDetailAssocExam.Text = res.DataResponse.ACCEPT_OFF_CODE;
txtDetailCompany.Text = res.DataResponse.INSUR_COMP_CODE;
if (res.DataResponse.SEX == "M")
{
txtSex.Text = Resources.propLicenseGroup_Male;
}
else
{
txtSex.Text = Resources.propLicenseGroup_Female;
}
}
}
private void BindDataInGridView(Boolean Count)
{
try
{
PAGE_SIZE = PAGE_SIZE_Key;
string Place = "";
string Asso = "";
string DDLTime = "%";
if (ddlTime.SelectedIndex != 0)
{
DDLTime = ddlTime.SelectedValue.ToString();
}
if (ddlPlaceName.SelectedValue.ToString() != "เลือก")
{
Place = ddlPlaceName.SelectedValue.ToString();
}
if (ddlAsso.SelectedValue.ToString() != "เลือก")
{
Asso = ddlAsso.SelectedValue.ToString();
}
UpdatePanelSearch.Update();
#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 = PAGE_SIZE.ToString();
}
else
{
PAGE_SIZE = Convert.ToInt32(rowPerpage.Text);
}
#endregion page
BLL.ApplicantBiz aBiz = new BLL.ApplicantBiz();
if (Count)
{
#region Page
var CountPage = aBiz.getManageApplicantCourse(ddlLicenseType.SelectedValue,
txtStartExamDate.Text, txtEndExamDate.Text, Asso,
Place, DDLTime,
txtTestNo.Text.Trim(), 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(gvSearch, totalROWs, Convert.ToInt32(rowPerpage.Text), true);
if (Rpage == 0)
{
NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage);
}
}
else
{
VisibleGV(gvSearch, 0, Convert.ToInt32(rowPerpage.Text), true);
if (Rpage == 0)
{
NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage);
}
txtTotalPage.Text = "1";
}
}
#endregion Page
}
var res = aBiz.getManageApplicantCourse(ddlLicenseType.SelectedValue, txtStartExamDate.Text,
txtEndExamDate.Text, Asso, Place,
DDLTime, txtTestNo.Text.Trim(), resultPage, PAGE_SIZE, false);
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
{
divGv1.Visible = true;
gvSearch.Visible = true;
div_totalPage.Visible = true;
boxResult.Visible = true;
if (res != null)
{
if (res.DataResponse.Tables[0].Rows.Count > 0)
{
btnPreviousGvSearch.Enabled = true;
btnNextGvSearch.Enabled = true;
}
else
{
btnPreviousGvSearch.Enabled = false;
btnNextGvSearch.Enabled = false;
}
txtNumberGvSearch.Enabled = false;
gvSearch.DataSource = res.DataResponse;
gvSearch.DataBind();
divGv2.Visible = false;
}
}
}
catch (Exception ex)
{
}
}
private void UpdateApplicantChange()
{
var biz = new BLL.ApplicantBiz();
//var res = biz.GetRequestEditApplicant((DTO.RegistrationType)base.UserProfile.MemberType, txtIdCard.Text, txtTestingNo.Text, base.UserProfile.CompCode);
//DataTable DT = res.DataResponse.Tables[0];
//DataRow DR = DT.Rows[0];
DTO.ApplicantChange AppChange = new DTO.ApplicantChange();
//AppChange.STATUS = Convert.ToInt16(ddlApprove.SelectedValue);
AppChange.CHANGE_ID = Convert.ToInt32(lblChangeid.Text);
AppChange.ASSOCIATION_USER_ID = base.UserId;
AppChange.ASSOCIATION_DATE = DateTime.Today;
if (ddlApprove.SelectedValue == "0")
{
AppChange.ASSOCIATION_RESULT = 1; //ผ่านการพิจารณา
AppChange.STATUS = 1; //ส่งเรื่องให้ OIC Approve
}
else
{
AppChange.ASSOCIATION_RESULT = 2; //ไม่ผ่านการพิจารณา
AppChange.STATUS = 1; //ไม่ส่งเรื่องให้ OIC Approve
if (txtReason.Text == "")
{
txtReason.Text = "ไม่ผ่านการพิจารณาจากสมาคม";
AppChange.CANCEL_REASON = txtReason.Text;
}
else
{
AppChange.CANCEL_REASON = txtReason.Text;
}
}
var insertAppChange = biz.InsertApplicantChange(AppChange);
if (insertAppChange.ResultMessage == true)
{
var res = biz.GetHistoryApplicant((DTO.RegistrationType)base.UserRegType, lblOLdIDCardVisibleF.Text, lblTestingNoVisibleF.Text, base.UserProfile.IdCard, base.UserProfile.CompCode, "", A, Z, false, "", "");
DataTable DT = res.DataResponse.Tables[0];
DataRow DR = DT.Rows[0];
string status = DR["STATUS"].ToString();
string asso = DR["ASSOCIATION_RESULT"].ToString();
string oic = DR["OIC_RESULT"].ToString();
string IDCardCreateBy = DR["CREATE_BY"].ToString();
string OLDidcard = DR["OLD_ID_CARD_NO"].ToString();
string TestingNO = DR["Testing_no"].ToString();
var sendMail = biz.SendMailAppChange(IDCardCreateBy, TestingNO, OLDidcard);//ส่งเมล์
ClearText();
UCModalSuccess.ShowMessageSuccess = "บันทึกสำเร็จ";
UCModalSuccess.ShowModalSuccess();
}
else
{
UCModalError.ShowMessageError = "พบข้อผิดพลาด";
UCModalError.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
var biz = new BLL.ApplicantBiz();
//ApplicantBiz biz = new BLL.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.GetHistoryApplicant((DTO.RegistrationType)base.UserRegType, txtIDCard.Text, txtTestingNo.Text, base.UserProfile.IdCard, base.UserProfile.CompCode, s, resultPage, PageSize, true, 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
}
//stringValue.substr(3, 7); //lo worl
var res = biz.GetHistoryApplicant((DTO.RegistrationType)base.UserRegType, txtIDCard.Text, txtTestingNo.Text, base.UserProfile.IdCard, base.UserProfile.CompCode, s, resultPage, PageSize, false, AS_result, o_result);
string compcode = base.UserProfile.CompCode;
if (res != null)
{
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
{
UCModalError.ShowMessageError = "ไม่พบข้อมูลผู้สมัครสอบ";
UCModalError.ShowModalError();
}
}
catch (Exception ex)
{
}
}
protected void InsertApplicantTLog()
{
var biz = new BLL.ApplicantBiz();
var MaxIDLog = biz.GetApplicantTLogMaxID();
if (MaxIDLog.DataResponse.Tables[0].Rows.Count > 0)
{
DataTable DT = MaxIDLog.DataResponse.Tables[0];
DataRow DR = DT.Rows[0];
string a = DR["applicant_code_log"].ToString();
if (a == "")
{
MaxID = 1;
}
else
{
MaxID = Convert.ToInt32(DR["applicant_code_log"]) + 1;
}
}
var ApplicantT = biz.GetApplicantTtoLog((DTO.RegistrationType)base.UserProfile.MemberType, lblIDCARDVisibleF.Text, lblTestingNOVisibleF.Text, lblCompCodeVisibleF.Text);
DTO.ApplicantTLog appTLog = new DTO.ApplicantTLog();
{
DataTable DTAppT = ApplicantT.DataResponse.Tables[0];
DataRow DRAppT = DTAppT.Rows[0];
appTLog.APPLICANT_CODE_LOG = MaxID;
appTLog.CREATE_BY = base.UserId;
appTLog.CREATE_DATE = DateTime.Today;
appTLog.APPLICANT_CODE = Convert.ToInt32(DRAppT["APPLICANT_CODE"]);
appTLog.TESTING_NO = DRAppT["TESTING_NO"].ToString();
appTLog.EXAM_PLACE_CODE = DRAppT["EXAM_PLACE_CODE"].ToString();
appTLog.ACCEPT_OFF_CODE = DRAppT["ACCEPT_OFF_CODE"].ToString();
appTLog.APPLY_DATE = Convert.ToDateTime(DRAppT["APPLY_DATE"]);
appTLog.ID_CARD_NO = DRAppT["ID_CARD_NO"].ToString();
appTLog.PRE_NAME_CODE = DRAppT["PRE_NAME_CODE"].ToString();
appTLog.NAMES = DRAppT["NAMES"].ToString();
appTLog.LASTNAME = DRAppT["LASTNAME"].ToString();
appTLog.BIRTH_DATE = Convert.ToDateTime(DRAppT["BIRTH_DATE"]);
appTLog.SEX = DRAppT["SEX"].ToString();
appTLog.EDUCATION_CODE = DRAppT["EDUCATION_CODE"].ToString();
appTLog.ADDRESS1 = DRAppT["ADDRESS1"].ToString();
appTLog.ADDRESS2 = DRAppT["ADDRESS2"].ToString();
appTLog.AREA_CODE = DRAppT["AREA_CODE"].ToString();
appTLog.PROVINCE_CODE = DRAppT["PROVINCE_CODE"].ToString();
appTLog.ZIPCODE = DRAppT["ZIPCODE"].ToString();
appTLog.TELEPHONE = DRAppT["TELEPHONE"].ToString();
appTLog.AMOUNT_TRAN_NO = DRAppT["AMOUNT_TRAN_NO"].ToString();
appTLog.PAYMENT_NO = DRAppT["PAYMENT_NO"].ToString();
appTLog.INSUR_COMP_CODE = DRAppT["INSUR_COMP_CODE"].ToString();
appTLog.ABSENT_EXAM = DRAppT["ABSENT_EXAM"].ToString();
appTLog.RESULT = DRAppT["RESULT"].ToString();
if (DRAppT["EXPIRE_DATE"].ToString() != "")
{
appTLog.EXPIRE_DATE = Convert.ToDateTime(DRAppT["EXPIRE_DATE"]);
}
// appTLog.EXPIRE_DATE = Convert.ToDateTime(DRAppT["EXPIRE_DATE"]);
appTLog.LICENSE = DRAppT["LICENSE"].ToString();
appTLog.CANCEL_REASON = DRAppT["CANCEL_REASON"].ToString();
appTLog.RECORD_STATUS = DRAppT["RECORD_STATUS"].ToString();
appTLog.USER_ID = DRAppT["USER_ID"].ToString();
appTLog.USER_DATE = Convert.ToDateTime(DRAppT["USER_DATE"]);
appTLog.EXAM_STATUS = DRAppT["EXAM_STATUS"].ToString();
appTLog.UPLOAD_GROUP_NO = DRAppT["UPLOAD_GROUP_NO"].ToString();
appTLog.HEAD_REQUEST_NO = DRAppT["HEAD_REQUEST_NO"].ToString();
appTLog.GROUP_REQUEST_NO = DRAppT["GROUP_REQUEST_NO"].ToString();
appTLog.UPLOAD_BY_SESSION = DRAppT["UPLOAD_BY_SESSION"].ToString();
appTLog.ID_ATTACH_FILE = DRAppT["ID_ATTACH_FILE"].ToString();
var insertAppTLog = biz.InsertApplicantTLog(appTLog);
if (insertAppTLog.ResultMessage == true)
{
UCModalSuccess.ShowMessageSuccess = "บันทึกลงLog";
UCModalSuccess.ShowModalSuccess();
ClearText();
txtReason.Visible = false;
txtReason.Visible = false;
}
else
{
UCModalError.ShowMessageError = "พบข้อผิดพลาด";
UCModalError.ShowModalError();
}
}
}
private void UpdateApplicantChange()
{
var biz = new BLL.ApplicantBiz();
//var res = biz.GetRequestEditApplicant((DTO.RegistrationType)base.UserProfile.MemberType, txtIdCard.Text, txtTestingNo.Text, base.UserProfile.CompCode);
//DataTable DT = res.DataResponse.Tables[0];
//DataRow DR = DT.Rows[0];
DTO.ApplicantChange AppChange = new DTO.ApplicantChange();
AppChange.CHANGE_ID = Convert.ToInt32(lblChangeid.Text);
AppChange.OIC_USER_ID = base.UserId;
AppChange.OIC_DATE = DateTime.Today;
if (ddlApprove.SelectedValue == "1") //อนุมัติ
{
AppChange.OIC_RESULT = 1; //เก็บ Log แล้ว Update AG_Applicant_T
AppChange.STATUS = 2; //อนุมัติ
InsertApplicantTLog(); //เก็บ Log
}
else//ไม่อนุมัติ
{
AppChange.OIC_RESULT = 2; //ไม่เก็บLog
AppChange.STATUS = 2; //ไม่อนุมัติ
if (txtReason.Text == "")
{
txtReason.Text = "ไม่ผ่านการพิจารณาจากคปภ.";
AppChange.CANCEL_REASON = txtReason.Text;
}
else
{
AppChange.CANCEL_REASON = txtReason.Text;
}
}
AppChange.OLD_ID_CARD_NO = lblIDCARDVisibleF.Text;
AppChange.TESTING_NO = lblTestingNOVisibleF.Text;
AppChange.NEW_ID_CARD_NO = lblNewIDCardVisibleF.Text;
AppChange.NEW_PREFIX = Convert.ToDecimal(lblNewPreName.Text);
AppChange.NEW_FNAME = lblNewFirstName.Text;
AppChange.NEW_LNAME = lblNewLastNames.Text;
AppChange.CANCEL_REASON = txtReason.Text;
var insertAppChange = biz.InsertApplicantChange(AppChange);
if (insertAppChange.ResultMessage == true)
{
var res1 = biz.GetHistoryApplicant((DTO.RegistrationType)base.UserRegType, lblIDCARDVisibleF.Text, lblTestingNOVisibleF.Text, base.UserProfile.IdCard, base.UserProfile.CompCode, "", A, Z, false, "", "");
DataTable DT = res1.DataResponse.Tables[0];
DataRow DR = DT.Rows[0];
string status = DR["STATUS"].ToString();
string assoResult = DR["ASSOCIATION_RESULT"].ToString();
string oicResult = DR["OIC_RESULT"].ToString();
string IDCardCreateBy = DR["CREATE_BY"].ToString();
string OLDidcard = DR["OLD_ID_CARD_NO"].ToString();
string TestingNO = DR["Testing_no"].ToString();
string IDCARDAsso = DR["ASSOCIATION_USER_ID"].ToString();
var sendMail = biz.SendMailAppChange(IDCardCreateBy, TestingNO, OLDidcard);//ส่งเมล์
//if (oicResult == "2")//ไม่อนุมัติ(ส่งให้สมาคมด้วย)
//{
// var sendMailAsso = biz.SendMailAppChange(IDCARDAsso, TestingNO, OLDidcard);//ส่งเมล์
//}
ClearText();
txtReason.Visible = false;
lblReason.Visible = false;
UCModalSuccess.ShowMessageSuccess = "บันทึกสำเร็จ";
UCModalSuccess.ShowModalSuccess();
#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
var res = biz.GetApproveEditApplicant((DTO.RegistrationType)base.UserRegType, txtIDCard.Text, txtTestingNo.Text, base.UserProfile.IdCard, base.UserProfile.CompCode, "", resultPage, PageSize, false, base.UserProfile.MemberType.ToString(), "", "");
res.DataResponse.Clear();
res.DataResponse.Reset();
res.DataResponse.RejectChanges();
}
else
{
UCModalError.ShowMessageError = "พบข้อผิดพลาด";
UCModalError.ShowModalError();
}
}
