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(); }