protected void lbtnDelete_Click(object sender, EventArgs e) { try { BLL.ExamScheduleBiz biz = new BLL.ExamScheduleBiz(); GridViewRow gr = (GridViewRow)((LinkButton)sender).Parent.Parent; string ID = ((Label)gr.FindControl("lblAssociationCode")).Text; if (!biz.CheckUsedPlaceGroup(ID).ResultMessage)//false = มีใช้งานไปแล้ว { mpeAssociation.Show(); } else { functionDelete(ID); } // functionDelete(ID); } catch (Exception ex) { UCError.ShowMessageError = ex.Message; UCError.ShowModalError(); } }
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 btnUpdate_Click(object sender, EventArgs e) { try { BLL.DataCenterBiz biz = new BLL.DataCenterBiz(); DTO.ConfigAssociation ent = new DTO.ConfigAssociation(); ent.ASSOCIATION_CODE = txtAssociationCode.Text; ent.ASSOCIATION_NAME = txtAssociationName.Text; ent.UPDATED_BY = base.UserId.ToString(); ent.UPDATED_DATE = DateTime.Now; ent.ACTIVE = "Y"; List <DTO.AssociationLicense> al = new List <DTO.AssociationLicense>(); var res = biz.InsertExamPlaceGroupR(ent, UserProfile, al); if (!res.IsError) { initGridAssociation(); UCSuccess.ShowMessageSuccess = SysMessage.SaveSucess; UCSuccess.ShowModalSuccess(); } else { UCError.ShowMessageError = res.ErrorMsg; UCError.ShowModalError(); } } catch (Exception ex) { UCError.ShowMessageError = ex.Message; UCError.ShowModalError(); } }
protected void lbtnDelete_Click(object sender, EventArgs e) { try { BLL.DataCenterBiz biz = new BLL.DataCenterBiz(); GridViewRow gr = (GridViewRow)((LinkButton)sender).Parent.Parent; string ID = ((Label)gr.FindControl("lblAssociationCode")).Text; var res = biz.DeleteAsscoiation(ID); if (!res.IsError) { initGridAssociation(); UCSuccess.ShowMessageSuccess = SysMessage.DeleteSuccess; UCSuccess.ShowModalSuccess(); } else { UCError.ShowMessageError = res.ErrorMsg; UCError.ShowModalError(); } } catch (Exception ex) { UCError.ShowMessageError = ex.Message; UCError.ShowModalError(); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (txtAssociationCode.Text.Length == 3) { BLL.DataCenterBiz biz = new BLL.DataCenterBiz(); DTO.ConfigAssociation ent = new DTO.ConfigAssociation(); ent.ASSOCIATION_CODE = txtAssociationCode.Text.Trim(); ent.ASSOCIATION_NAME = txtAssociationName.Text.Trim(); if (ddlAgentType.SelectedValue != "") { ent.AGENT_TYPE = ddlAgentType.SelectedValue; } if (ddlCompType.SelectedValue != "") { ent.COMP_TYPE = ddlCompType.SelectedValue; } ent.ACTIVE = "Y"; List <DTO.AssociationLicense> al = new List <DTO.AssociationLicense>(); foreach (ListItem i in chkLicense.Items) { al.Add(new DTO.AssociationLicense { LICENSE_TYPE_CODE = i.Value, ACTIVE = i.Selected ? "Y" : "N" }); } var res = biz.InsertAssociation(ent, UserProfile, al); if (!res.IsError) { initGridAssociation(); UCSuccess.ShowMessageSuccess = SysMessage.SaveSucess; UCSuccess.ShowModalSuccess(); } else { UCError.ShowMessageError = res.ErrorMsg; UCError.ShowModalError(); mpeAssociation.Show(); UplPopUp.Update(); } } else { UCError.ShowMessageError = "รหัสสมาคมต้องมีจำนวน 3 หลักเท่านั้น"; UCError.ShowModalError(); } } catch (Exception ex) { UCError.ShowMessageError = ex.Message; UCError.ShowModalError(); mpeAssociation.Show(); UplPopUp.Update(); } //txtAssociationCode.Text = ""; //txtAssociationName.Text = ""; }
protected void btnUpdate_Click(object sender, EventArgs e) { try { if (CheckBeforeSave()) { if (lblSeatAmountPlace.Text.ToInt() < txtSeatAmount.Text.ToInt()) { UCError.ShowMessageError = "จำนวนที่นั่งของทุกห้องมากเกินกว่า<br>จำนวนที่นั่งที่สนามสอบนี้สามารถรองรับได้"; UCError.ShowModalError(); } else { 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.UpdateExamRoom(ent, UserProfile); if (!res.IsError) { //initGvExamRoom(); UCSuccess.ShowMessageSuccess = SysMessage.SaveSucess; UCSuccess.ShowModalSuccess(); btnSearch_Click(sender, e); UpdatePanelGridviw.Update(); } else { UCError.ShowMessageError = res.ErrorMsg; UCError.ShowModalError(); } } } } catch (Exception ex) { UCError.ShowMessageError = ex.Message; UCError.ShowModalError(); } //ClearControl(); lblSeatAmountPlace.Text = ""; txtCodeRoom.Text = ""; txtNameRoom.Text = ""; txtSeatAmount.Text = ""; uplPopUp.Update(); }
protected void btnSave_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(txtAssociationCode.Text) && !string.IsNullOrEmpty(txtAssociationName.Text)) { if (txtAssociationCode.Text.Length == 3) { BLL.DataCenterBiz biz = new BLL.DataCenterBiz(); var checkid = biz.GetExamPlaceGroupRByCheckID(txtAssociationCode.Text, txtAssociationName.Text); List <DTO.AssociationLicense> al = new List <DTO.AssociationLicense>(); DTO.ConfigAssociation ent = new DTO.ConfigAssociation(); ent.ASSOCIATION_CODE = txtAssociationCode.Text; ent.ASSOCIATION_NAME = txtAssociationName.Text; ent.ACTIVE = "Y"; var res = biz.InsertExamPlaceGroupR(ent, UserProfile, al); if (!res.IsError) { initGridAssociation(); UCSuccess.ShowMessageSuccess = SysMessage.SaveSucess; UCSuccess.ShowModalSuccess(); } else { UCError.ShowMessageError = res.ErrorMsg; UCError.ShowModalError(); } } else { UCError.ShowMessageError = "รหัสหน่วยงานจัดสอบต้องมีจำนวน 3 ตัวอักษรเท่านั้น"; UCError.ShowModalError(); } } else { UCError.ShowMessageError = "กรุณากรอกข้อมูลสมาคมให้ครบถ้วน"; UCError.ShowModalError(); } } catch (Exception ex) { UCError.ShowMessageError = ex.Message; UCError.ShowModalError(); } txtAssociationCode.Text = ""; txtAssociationName.Text = ""; }
protected void btnViewer_Click(object sender, EventArgs e) { if (txtDateStart.Text == "" && txtDateEnd.Text != "") { UCError.ShowMessageError = "กรุณาเลือก วันที่"; UCError.ShowModalError(); } else if (txtDateEnd.Text == "" && txtDateStart.Text != "") { UCError.ShowMessageError = "กรุณาเลือก วันที่สิ้นสุด"; UCError.ShowModalError(); } else { string src = string.Format("'{0}', '{1}', '{2}', '{3}'" , ddlLicenseType.SelectedValue, txtDateStart.Text, txtDateEnd.Text, ddlLicenseType.SelectedItem.Text); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "", "OpenPopupViewer(" + src + ")", true); } }
private void DelThisRoom(string Room) { try { BLL.ExamRoomBiz biz = new BLL.ExamRoomBiz(); if (biz.DelExamRoom(Room).ResultMessage) { UCSuccess.ShowMessageSuccess = SysMessage.SaveSucess; UCSuccess.ShowModalSuccess(); } else { UCError.ShowMessageError = SysMessage.ServerError; UCError.ShowModalError(); } } catch { } }
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 functionDelete(string ID) { BLL.DataCenterBiz biz = new BLL.DataCenterBiz(); DTO.ConfigAssociation ent = new DTO.ConfigAssociation(); List <DTO.AssociationLicense> al = new List <DTO.AssociationLicense>(); ent.ASSOCIATION_CODE = ID; ent.ACTIVE = "N"; var res = biz.InsertExamPlaceGroupR(ent, UserProfile, al); //var res = biz.DeleteAsscoiation(ID); if (!res.IsError) { initGridAssociation(); UCSuccess.ShowMessageSuccess = SysMessage.DeleteSuccess; UCSuccess.ShowModalSuccess(); } else { UCError.ShowMessageError = res.ErrorMsg; UCError.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 ExamScheduleBiz biz = new ExamScheduleBiz(); if (Count) { #region Page var CountPage = biz.GetGVExamRoomByPlaceCode(ddlExamPlace.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(gvExamRoom, totalROWs, Convert.ToInt32(rowPerpage.Text), true); if (Rpage == 0) { NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage); } } else { VisibleGV(gvExamRoom, 0, Convert.ToInt32(rowPerpage.Text), true); if (Rpage == 0) { NPbutton(btnPreviousGvSearch, txtNumberGvSearch, btnNextGvSearch, "", txtTotalPage); } txtTotalPage.Text = "1"; } } #endregion Page } if (ddlExamPlace.SelectedIndex > 0 && ddlExamPlaceGroup.SelectedIndex > 0) { DTO.ResponseService <DataSet> Place = biz.GetGVExamRoomByPlaceCode(ddlExamPlace.SelectedValue.ToString(), resultPage, PageSize, false); gvExamRoom.DataSource = Place.DataResponse; gvExamRoom.DataBind(); gvExamRoom.Visible = true; btnPopUp.Visible = true; if (gvExamRoom.Visible == true) { PanalPage.Visible = true; } else { PanalPage.Visible = false; } } else { UCError.ShowMessageError = SysMessage.ChooseData; UCError.ShowModalError(); btnPopUp.Visible = false; if (gvExamRoom.Visible == true) { PanalPage.Visible = true; } else { PanalPage.Visible = false; } } } catch { } }
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(); }