/// <summary> /// เพิ่มข้อมูลลงตาราง PREREQUISITE /// </summary> /// <param name="dataInsert">PreRequisite Object</param> /// <returns>Success</returns> public string insertPreRequisite(PreRequisite dataInsert) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Insert into PREREQUISITE (CURRCODE, YEARVERSION, CURRFORMATCODE, CURRTYPECODE, MAJORCODE, COURSEGROUPCODE, CATEGORYCODE, COURSETYPECODE, COURSECODE, PREREQUISITECOURSECODE, PREREQUISITERULE, PREREQUISITEFORMAT) values ('" + dataInsert.CurrCode + "','" + dataInsert.YearVersion + "','" + dataInsert.CurrFormatCode + "','" + dataInsert.CurrTypeCode + "','" + dataInsert.MajorCode + "','" + dataInsert.CourseGroupCode + "','" + dataInsert.CategoryCode + "','" + dataInsert.CourseTypeCode + "','" + dataInsert.CourseCode + "','" + dataInsert.PreRequisiteCourseCode + "','" + dataInsert.PreRequisiteRule + "','" + dataInsert.PreRequisiteFormat + "')"; oracleObj.InsertCommand = sql; try { if (oracleObj.Insert() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "insertPreRequisite: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
protected void btnADD_Click(object sender, EventArgs e) { string sql = "Select * From PREREQUISITE Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSETYPECODE='" + CourseTypeCode + "' And COURSECODE='" + CourseCode + "' And PREREQUISITECOURSECODE='" + txtCOURSECODE.Text + "' And PREREQUISITERULE='" + ddlRuleOrder.SelectedValue + "'"; List <PreRequisite> chkPreRequisite = new PreRequisite().getPreRequisiteManual(sql); if (chkPreRequisite.Count > 0) { Page.ClientScript.RegisterStartupScript(this.GetType(), "ShowBox", "alert('ข้อมูลซ้ำ!');", true); } else { PreRequisite preRequisiteData = new PreRequisite(); preRequisiteData.CurrCode = CurrCode; preRequisiteData.YearVersion = YearVersion; preRequisiteData.CurrFormatCode = CurrFormatCode; preRequisiteData.CurrTypeCode = CurrTypeCode; preRequisiteData.MajorCode = MajorCode; preRequisiteData.CourseGroupCode = CourseGroupCode; preRequisiteData.CategoryCode = CategoryCode; preRequisiteData.CourseTypeCode = CourseTypeCode; preRequisiteData.CourseCode = CourseCode; preRequisiteData.PreRequisiteCourseCode = txtCOURSECODE.Text; preRequisiteData.PreRequisiteRule = ddlRuleOrder.SelectedValue; preRequisiteData.PreRequisiteFormat = ddlRuleFormat.SelectedValue; string insertPreRequisite = new PreRequisite().insertPreRequisite(preRequisiteData); if (insertPreRequisite == "Success") { Response.Redirect("addCOURSE_to_PREREQ.aspx?CurrCode=" + CurrCode + "&YearVersion=" + YearVersion + "&CurrFormatCode=" + CurrFormatCode + "&CurrTypeCode=" + CurrTypeCode + "&MajorCode=" + MajorCode + "&CategoryCode=" + CategoryCode + "&CourseGroupCode=" + CourseGroupCode + "&CourseTypeCode=" + CourseTypeCode + "&CourseCode=" + CourseCode + ""); } } }
/// <summary> /// แก้ไขข้อมูลจากตาราง PREREQUISITE /// </summary> /// <param name="updateData">PreRequisite Object</param> /// <returns>Success</returns> public string updatePreRequisite(PreRequisite updateData) { string response = ""; ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); string sql = "Update PREREQUISITE Set PREREQUISITEFORMAT = '" + updateData.PreRequisiteFormat + "'Where CURRCODE = '" + updateData.CurrCode + "' And YEARVERSION = '" + updateData.YearVersion + "' And CURRFORMATCODE = '" + updateData.CurrFormatCode + "' And CURRTYPECODE = '" + updateData.CurrTypeCode + "' And MAJORCODE = '" + updateData.MajorCode + "' And COURSEGROUPCODE = '" + updateData.CourseGroupCode + "' And CATEGORYCODE = '" + updateData.CourseTypeCode + "' And COURSECODE = '" + updateData.CourseCode + "' And PREREQUISITECOURSECODE = '" + updateData.PreRequisiteCourseCode + "' And PREREQUISITERULE = '" + updateData.PreRequisiteRule + "'"; oracleObj.UpdateCommand = sql; try { if (oracleObj.Update() == 1) { response = "Success"; } } catch (Exception e) { string exception = e.Message; HttpContext.Current.Session["response"] = "updatePreRequisite: " + exception; HttpContext.Current.Response.Redirect("../err_response.aspx"); } return(response); }
/// <summary> /// เรียกดูข้อมูลจากตาราง PREREQUISITE /// </summary> /// <param name="CurrCode">รหัสหลักสูตร(Curriculum)</param> /// <returns>ข้อมูลจากตาราง PREREQUISITE</returns> public PreRequisite getPreRequisite(string CurrCode) { PreRequisite PreRequisiteData = new PreRequisite(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = "Select * From PREREQUISITE Where CURRCODE='" + CurrCode + "'"; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { PreRequisiteData.CurrCode = rowData["CURRCODE"].ToString(); PreRequisiteData.YearVersion = rowData["YEARVERSION"].ToString(); PreRequisiteData.CurrFormatCode = rowData["CURRFORMATCODE"].ToString(); PreRequisiteData.CurrTypeCode = rowData["CURRTYPECODE"].ToString(); PreRequisiteData.MajorCode = rowData["MAJORCODE"].ToString(); PreRequisiteData.CourseGroupCode = rowData["COURSEGROUPCODE"].ToString(); PreRequisiteData.CategoryCode = rowData["CATEGORYCODE"].ToString(); PreRequisiteData.CourseTypeCode = rowData["COURSETYPECODE"].ToString(); PreRequisiteData.CourseCode = rowData["COURSECODE"].ToString(); PreRequisiteData.PreRequisiteCourseCode = rowData["PREREQUISITECOURSECODE"].ToString(); PreRequisiteData.PreRequisiteRule = rowData["PREREQUISITERULE"].ToString(); PreRequisiteData.PreRequisiteFormat = rowData["PREREQUISITEFORMAT"].ToString(); } return(PreRequisiteData); }
/// <summary> /// เรียกดูข้อมูลจากตาราง PREREQUISITE /// </summary> /// <param name="sql">SQL Command</param> /// <returns>ข้อมูลจากตาราง PREREQUISITE</returns> public List <PreRequisite> getPreRequisiteManual(string sql) { List <PreRequisite> PreRequisiteData = new List <PreRequisite>(); ConnectDB db = new ConnectDB(); SqlDataSource oracleObj = db.ConnectionOracle_tqf2(); oracleObj.SelectCommand = sql; DataView allData = (DataView)oracleObj.Select(DataSourceSelectArguments.Empty); foreach (DataRowView rowData in allData) { PreRequisite PreRequisiteRow = new PreRequisite(); PreRequisiteRow.CurrCode = rowData["CURRCODE"].ToString(); PreRequisiteRow.YearVersion = rowData["YEARVERSION"].ToString(); PreRequisiteRow.CurrFormatCode = rowData["CURRFORMATCODE"].ToString(); PreRequisiteRow.CurrTypeCode = rowData["CURRTYPECODE"].ToString(); PreRequisiteRow.MajorCode = rowData["MAJORCODE"].ToString(); PreRequisiteRow.CourseGroupCode = rowData["COURSEGROUPCODE"].ToString(); PreRequisiteRow.CategoryCode = rowData["CATEGORYCODE"].ToString(); PreRequisiteRow.CourseTypeCode = rowData["COURSETYPECODE"].ToString(); PreRequisiteRow.CourseCode = rowData["COURSECODE"].ToString(); PreRequisiteRow.PreRequisiteCourseCode = rowData["PREREQUISITECOURSECODE"].ToString(); PreRequisiteRow.PreRequisiteRule = rowData["PREREQUISITERULE"].ToString(); PreRequisiteRow.PreRequisiteFormat = rowData["PREREQUISITEFORMAT"].ToString(); PreRequisiteData.Add(PreRequisiteRow); } return(PreRequisiteData); }
public ActionResult FinishStep(int id) { PreRequisite step = ContextProcess.Object.PreRequisites.Find(id); MainProcess p = ContextProcess.Object.MainProceses.Find(step.ProcessID); if (p.CurrentStateName == ProcState.Running && p.CurrentStep.ID == id) { History history = p.Current_State.FirstOrDefault(h => h.EventID == id); if (history != null) { string path_to_file; string err; history.Success = step.Check(out err, out path_to_file); if (history.Success.Value) { history.TimeFinish = DateTime.Now; history.ErrorMessage = string.Empty; } else { history.TimeFinish = null; history.ErrorMessage = err; } ContextProcess.Object.SaveChanges(); p.Refresh(); } } return(View("Index", ContextProcess.Object.MainProceses.ToArray())); }
static DemoCollecitonManager() { PreRequisite.NotNullOrWhiteSpace(DemoCollectionId); _clinet = new Lazy <DdbClinet>(DdbClinetFactory.GetInstance); _demoCollection = new Lazy <DocumentCollection>(() => Client.GetCollectionIfNotExistsCreate(DemoCollectionId)); }
protected void btnOK_Click(object sender, EventArgs e) { //เช็คว่ามีข้อมูลอยู่จริงหรือไม่ string sql = "Select * From TQF2SEC3PLANDETAIL Where T2S3NO='" + T2S3No + "' And CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "' And COURSETYPECODE='" + CourseTypeCode + "' And COURSECODE='" + CourseCode + "'"; List <TQF2Sec3PlanDetail> tqf2Sec3PlanDetail = new TQF2Sec3PlanDetail().getTQF2Sec3PlanDetailManual(sql); if (tqf2Sec3PlanDetail.Count > 0) { //ลบข้อมูลในตาราง TQF2SEC3PLANDETAIL string sql2 = "Delete From TQF2SEC3PLANDETAIL Where T2S3NO='" + T2S3No + "' And CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "' And COURSETYPECODE='" + CourseTypeCode + "' And COURSECODE='" + CourseCode + "'"; string deleteTQF2Sec3PlanDetail = new TQF2Sec3PlanDetail().deleteTQF2Sec3PlanDetailManual(sql2); if (deleteTQF2Sec3PlanDetail == "Success") { //เช็คว่ามีข้อมูลอยู่จริงหรือไม่ string sql3 = "Select * From PREREQUISITE Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSETYPECODE='" + CourseTypeCode + "' And COURSECODE='" + CourseCode + "'"; List <PreRequisite> preRequisite = new PreRequisite().getPreRequisiteManual(sql3); if (preRequisite.Count > 0) { //ลบข้อมูลในตาราง PREREQUISITE string sql4 = "Delete From PREREQUISITE Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSETYPECODE='" + CourseTypeCode + "' And COURSECODE='" + CourseCode + "'"; string deletePreRequisite = new PreRequisite().deletePreRequisiteManual(sql4); if (deletePreRequisite == "Success") { //สร้าง session ส่งคืนกลับไปหน้า Faculty_add_CURR6.aspx Session["CurrCode"] = CurrCode; Session["YearVersion"] = YearVersion; //Session["MajorCode"] = MajorCode; Response.Redirect("Faculty_add_CURR6.aspx"); } } else { //สร้าง session ส่งคืนกลับไปหน้า Faculty_add_CURR6.aspx Session["CurrCode"] = CurrCode; Session["YearVersion"] = YearVersion; //Session["MajorCode"] = MajorCode; Response.Redirect("Faculty_add_CURR6.aspx"); } } } else { //สร้าง session ส่งคืนกลับไปหน้า Faculty_add_CURR6.aspx Session["CurrCode"] = CurrCode; Session["YearVersion"] = YearVersion; //Session["MajorCode"] = MajorCode; Response.Redirect("Faculty_add_CURR6.aspx"); } }
protected void btnOK_Click(object sender, EventArgs e) { string sql = "Select * From TQF2SEC3STRUCTUREGROUP Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "'"; List <TQF2Sec3StructureGroup> tqf2Sec3StructureGroup; tqf2Sec3StructureGroup = new TQF2Sec3StructureGroup().getTQF2Sec3StructureGroupManual(sql); if (tqf2Sec3StructureGroup.Count > 0) { //[Step 8] ลบข้อมูลในตาราง TQF2SEC3SEMESTERPLAN string sql8 = "Delete From TQF2SEC3SEMESTERPLAN Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "'"; string deleteTQF2SemesterPlan = new TQF2Sec3SemesterPlan().deleteTQF2Sec3SemesterPlanManual(sql8); //[Step 7] ลบข้อมูลในตาราง TQF2SEC4CURRICULUMMAPPING string sql7 = "Select * From TQF2SEC3PLANDETAIL Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "'"; List <TQF2Sec3PlanDetail> TQF2Sec3PlanDetailData = new TQF2Sec3PlanDetail().getTQF2Sec3PlanDetailManual(sql7); foreach (TQF2Sec3PlanDetail row in TQF2Sec3PlanDetailData) { string sql7_1 = "Delete From TQF2SEC4CURRICULUMMAPPING Where CURRCODE ='" + row.CurrCode + "'"; string deleteTQF2Sec4CurriculumMapping = new TQF2Sec4CurriculumMapping().deleteTQF2Sec4CurriculumMappingManual(sql7_1); } //[Step 6-1] ลบข้อมูลในตาราง PREREQUISITE string sql6 = "Delete From PREREQUISITE Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "'"; string deletePreRequisite = new PreRequisite().deletePreRequisiteManual(sql6); //[Step 6] ลบข้อมูลในตาราง TQF2SEC3PLANDETAIL string sql5 = "Delete From TQF2SEC3PLANDETAIL Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "'"; string deleteTQF2Sec3PlanDetail = new TQF2Sec3PlanDetail().deleteTQF2Sec3PlanDetailManual(sql5); //[Step 5_1] ลบข้อมูลในตาราง TQF2SEC3STRUCTURETYPE string sql4 = "Delete From TQF2SEC3STRUCTURETYPE Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "'"; string deleteTqf2Sec3StructureType = new Tqf2Sec3StructureType().deleteTqf2Sec3StructureTypeManual(sql4); //[Step 5] ลบข้อมูลในตาราง TQF2SEC3STRUCTUREGROUP string sql3 = "Delete From TQF2SEC3STRUCTUREGROUP Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "'"; string deleteTQF2Sec3StructureGroup = new TQF2Sec3StructureGroup().deleteTQF2Sec3StructureGroupManual(sql3); //สร้าง session ส่งคืนกลับไปหน้า Faculty_add_CURR5.aspx Session["CurrCode"] = CurrCode; Session["YearVersion"] = YearVersion; //Session["MajorCode"] = MajorCode; Response.Redirect("Faculty_add_CURR5.aspx"); } else { //สร้าง session ส่งคืนกลับไปหน้า Faculty_add_CURR5.aspx Session["CurrCode"] = CurrCode; Session["YearVersion"] = YearVersion; //Session["MajorCode"] = MajorCode; Response.Redirect("Faculty_add_CURR5.aspx"); } }
public static DdbClinet GetInstance() { PreRequisite.NotNullOrWhiteSpace(EndpointUri); PreRequisite.NotNullOrWhiteSpace(AuthorizationKey); PreRequisite.NotNullOrWhiteSpace(DatabaseName); var policy = CreateConnectionPolicy(ConnectionMode, Protocol); var documentClinet = CreateDocumentClient(EndpointUri, AuthorizationKey, policy); var strategy = GetRetryStrategy(null, RetryCount, RetryInterval, false); return(new DdbClinet(documentClinet.AsReliable(strategy), DatabaseName, FeedOptionMaxItemCount)); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (Request.QueryString["CurrCode"] != "" && Request.QueryString["YearVersion"] != "") { code = Request.QueryString["token"]; CurrCode = Request.QueryString["CurrCode"]; YearVersion = Request.QueryString["YearVersion"]; } else { code = Request.QueryString["token"]; CurrCode = ""; YearVersion = ""; } TQF.Course course = new TQF.Course().getCourse(code); lblCourseName.Text = course.CourseThName + " (" + course.CourseEnName + ")"; lblLevelCode.Text = new Levels().getLevels(course.LevelCode).LevelName; lblCourseCode.Text = course.CourseCode; lblCourseEnShortName.Text = course.CourseEnShortName; lblCourseFlagCode.Text = new CourseFlag().getCourseFlag(course.CourseFlagCode).CourseFlagName; lblCourseTypeCode.Text = new TQF.CourseType().getCourseType(course.CourseTypeCode).CourseTypeThaiName; lblSuFlage.Text = new SuFlage().getSuFlage(course.SuFlage).SuFlageName; lblCourseThDesc.Text = course.CourseThDesc; lblCourseEnDesc.Text = course.CourseEnDesc; lblServiceStatus.Text = new ServiceStatus().getServiceStatus(course.ServiceStatus).ServiceStatusName; lblMinCredits.Text = course.MinCredits; lblDateApprove.Text = course.DateApprove; string sqlPreRequisite = "Select * From PREREQUISITE Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And COURSECODE='" + course.CourseCode + "'"; List <PreRequisite> preRequisite = new PreRequisite().getPreRequisiteManual(sqlPreRequisite); if (preRequisite.Count > 0) { foreach (PreRequisite data in preRequisite) { lblPrequisite.Text += data.PreRequisiteCourseCode + " " + new TQF.Course().getCourse(data.PreRequisiteCourseCode).CourseThName + " (" + new TQF.Course().getCourse(data.PreRequisiteCourseCode).CourseEnName + ")<br>"; } } else { lblPrequisite.Text = "ไม่มี"; } lblComments.Text = course.Comments; } }
public ActionResult RemovePrerequisite(int?CourseId, int?Id) { if (Id == null && CourseId == null) { return(RedirectToAction("AddPrerequisite", new { courseId = CourseId })); } PreRequisite preRequisite = db.PrerequisiteCourses.Where(x => x.ActualCourseId == CourseId && x.RequiredCourseId == Id).FirstOrDefault(); if (preRequisite != null) { db.PrerequisiteCourses.Remove(preRequisite); db.SaveChanges(); } return(RedirectToAction("AddPrerequisite", new { courseId = CourseId })); }
public ActionResult AddPrerequisiteConfirm(int?CourseId, int?Id) { if (Id == null || CourseId == null) { return(RedirectToAction("AddPrerequisite", new { courseId = CourseId })); } PreRequisite preRequisite = new PreRequisite(); preRequisite.ActualCourseId = (int)CourseId; preRequisite.RequiredCourseId = (int)Id; db.PrerequisiteCourses.Add(preRequisite); db.SaveChanges(); return(RedirectToAction("AddPrerequisite", new { courseId = CourseId })); }
public ActionResult StartStep(int id) { PreRequisite step = ContextProcess.Object.PreRequisites.Find(id); MainProcess p = ContextProcess.Object.MainProceses.Find(step.ProcessID); if (p.CurrentStateName == ProcState.Running && p.CurrentStep.ID == id) { History history = new History { SessionID = p.CurrentResult.SessionID, ProcessID = p.ID, EventID = id }; ContextProcess.Object.Historys.Add(history); ContextProcess.Object.SaveChanges(); p.Refresh(); } return(View("Index", ContextProcess.Object.MainProceses.ToArray())); }
protected void btnOK_Click(object sender, EventArgs e) { string sql = "Select * From PREREQUISITE Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSETYPECODE='" + CourseTypeCode + "' And COURSECODE='" + CourseCode + "' And PREREQUISITECOURSECODE='" + PreRequisiteCourseCode + "'"; List <PreRequisite> preRequisite = new PreRequisite().getPreRequisiteManual(sql); if (preRequisite.Count > 0) { string sql2 = "Delete From PREREQUISITE Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSETYPECODE='" + CourseTypeCode + "' And COURSECODE='" + CourseCode + "' And PREREQUISITECOURSECODE='" + PreRequisiteCourseCode + "' And PREREQUISITERULE='" + PreRequisiteRule + "'"; string deletePreRequisite = new PreRequisite().deletePreRequisiteManual(sql2); if (deletePreRequisite == "Success") { Response.Redirect("addCOURSE_to_PREREQ.aspx?CurrCode=" + CurrCode + "&YearVersion=" + YearVersion + "&CurrFormatCode=" + CurrFormatCode + "&CurrTypeCode=" + CurrTypeCode + "&MajorCode=" + MajorCode + "&CategoryCode=" + CategoryCode + "&CourseGroupCode=" + CourseGroupCode + "&CourseTypeCode=" + CourseTypeCode + "&CourseCode=" + CourseCode + ""); } } else { Response.Redirect("addCOURSE_to_PREREQ.aspx?CurrCode=" + CurrCode + "&YearVersion=" + YearVersion + "&CurrFormatCode=" + CurrFormatCode + "&CurrTypeCode=" + CurrTypeCode + "&MajorCode=" + MajorCode + "&CategoryCode=" + CategoryCode + "&CourseGroupCode=" + CourseGroupCode + "&CourseTypeCode=" + CourseTypeCode + "&CourseCode=" + CourseCode + ""); } }
/// <summary> /// Commits the courses, that were moved to the /// pre-reqs listview, to the preReqs table /// </summary> public void CommitPreReqs() { try { using (var context = new SchoolU_DBEntities()) { // Gets all the courses names IList <string> allCourseName = context.Courses.Where(i => i.CourseId != 0).Select(i => i.CourseName).ToList(); // Gets the course id for the course that was recently added int courseAdded = context.Courses.Where(i => i.CourseName == CourseName).Select(i => i.CourseId).Single(); if (SelectedCourseCollection.Any()) { // Stores the PreRequisite objects so they can be added all at the same time using the AddRange method IList <PreRequisite> PreReqList = new List <PreRequisite>(); if (IsPreReqListDifferent()) { for (int i = 0; i < GetPreReqIds().Count; i++) { var newPreReq = new PreRequisite() { CourseId = courseAdded, PrereqId = GetPreReqIds().ElementAt(i) }; PreReqList.Add(newPreReq); } context.PreRequisites.AddRange(PreReqList); } context.SaveChanges(); } } } catch (Exception ex) { //MessageBox.Show(ex.Message); return; } }
public virtual void AddPreRequisites() { PreRequisite preReq = new PreRequisite("Subscription"); preReq.Runnable = () => { foreach (TestClientInfo tci in this.ConsumersInfo) { int expectedMessages = 0; if (this.SubscribeDestinationType != NetAction.DestinationType.TOPIC) { if ((ProducersInfo.Count % ConsumersInfo.Count) != 0) { throw new Exception(String.Format("When not using TOPIC subscriptions, publishers ({0}) must be multiple of consumers ({1}).", ProducersInfo.Count, ConsumersInfo.Count)); } expectedMessages = ProducersInfo.Count / ConsumersInfo.Count; Console.WriteLine("In here.."); } else { expectedMessages = ProducersInfo.Count; } Console.WriteLine("expectedMessages: {0}", expectedMessages); NotificationHandler notificationHandler = new NotificationHandler(tci.brokerClient, this.SubscribeDestinationType, expectedMessages); tci.notificationHandler = notificationHandler; tci.brokerClient.Subscribe(GetSubscription(notificationHandler)); } preReq.Sucess = true; preReq.Done = true; Thread.Sleep(1000);// giving time to subscribe. Not critical, so there's no need for something more sophisticated. }; this.AddPrequisite(preReq); }
protected void htmlGenerateTab5(string MajorCode, string CurrFormatCode, string TotalCredits, string YearVersion, string CurrTypeCode) { string html = ""; html += "<div class=\"box-group-data\">"; html += "<table class=\"table-course\">"; //Body Table List <TQF2Sec3PlanDetail> tqf2Sec3PlanDetail = new TQF2Sec3PlanDetail().getDistinctCourseCodeTQF2Sec3PlanDetail(CurrCode, YearVersion); foreach (TQF2Sec3PlanDetail row in tqf2Sec3PlanDetail) { TQF.Course course = new TQF.Course().getCourse(row.CourseCode); html += "<tr>"; html += "<td><strong>" + course.CourseCode + "</strong></td>"; html += "<td><strong>"; html += course.CourseThName + "<BR>"; html += course.CourseEnName; html += "</strong></td>"; html += "<td><strong>"; html += course.Credit + " (" + course.TheoryHour + "-" + course.PracticeHour + "-" + course.SelfStudyHour + ")"; html += "</strong></td>"; html += "</tr>"; html += "<tr>"; html += "<td> </td>"; html += "<td colspan=\"2\">"; html += "<table class=\"table-description\">"; html += "<tr>"; html += "<td>วิชาบังคับก่อน: </td>"; html += "<td>"; string sqlPreRequisite = "Select * From PREREQUISITE Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And COURSECODE='" + course.CourseCode + "'"; List <PreRequisite> preRequisite = new PreRequisite().getPreRequisiteManual(sqlPreRequisite); foreach (PreRequisite data in preRequisite) { html += data.PreRequisiteCourseCode + " " + new TQF.Course().getCourse(data.PreRequisiteCourseCode).CourseThName + "<br>"; } html += "</td>"; html += "</tr>"; html += "</table>"; html += "</td>"; html += "</tr>"; html += "<tr>"; html += "<td> </td>"; html += "<td colspan=\"2\">"; html += "<table class=\"table-description\">"; html += "<tr>"; html += "<td>PreRequisite: "; html += "<td>"; foreach (PreRequisite data in preRequisite) { html += data.PreRequisiteCourseCode + " " + new TQF.Course().getCourse(data.PreRequisiteCourseCode).CourseEnName + "<br>"; } html += "</td>"; html += "</tr>"; html += "</table>"; html += "</td>"; html += "</tr>"; html += "<tr>"; html += "<td> </td>"; html += "<td colspan=\"2\" class=\"course-description\">" + course.CourseThDesc + "</td>"; html += "</tr>"; html += "<tr>"; html += "<td> </td>"; html += "<td colspan=\"2\" class=\"course-description\">" + course.CourseEnDesc + "</td>"; html += "</tr>"; html += "<tr>"; html += "<td> </td>"; html += "<td> </td>"; html += "<td> </td>"; html += "</tr>"; } html += "</table>"; html += "</div>"; Label lblHTML5 = new Label(); lblHTML5.Text = html; placeHTML5.Controls.Add(lblHTML5); }
//private string FacultyId; protected void Page_Load(object sender, EventArgs e) { CurrCode = Request.QueryString["CurrCode"]; YearVersion = Request.QueryString["YearVersion"]; CurrFormatCode = Request.QueryString["CurrFormatCode"]; CurrTypeCode = Request.QueryString["CurrTypeCode"]; MajorCode = Request.QueryString["MajorCode"]; CourseGroupCode = Request.QueryString["CourseGroupCode"]; CategoryCode = Request.QueryString["CategoryCode"]; CourseTypeCode = Request.QueryString["CourseTypeCode"]; CourseCode = Request.QueryString["CourseCode"]; TQF.Curriculum currTitle = new TQF.Curriculum().getCurriculum(CurrCode, YearVersion); lblHeader1.Text = currTitle.CurrCode + " หลักสูตร" + currTitle.CurrThName; lblHeader2.Text = currTitle.CurrEnName; string currStatus; if (currTitle.CurrStatus == "1") { currStatus = "หลักสูตรใหม่"; lblHeader3.Text = "(" + currStatus + " พ.ศ. " + currTitle.YearVersion + ")"; } if (currTitle.CurrStatus == "2") { currStatus = "หลักปรับปรุง"; lblHeader3.Text = "(" + currStatus + " พ.ศ. " + currTitle.YearVersion + ")"; } lblCurrFormatTitle.Text = new CurrFormat().getCurrFormat(CurrFormatCode).CurrFormatName + " (" + new TQF.Major().getMajor(MajorCode).MajorThName + ")"; TQF.Course course = new TQF.Course().getCourse(CourseCode); lblCourseTitle.Text = course.CourseCode + " " + course.CourseThName + "<br> (" + course.CourseEnName + ")"; // Head Table string[] ar = { "ลำดับเงื่อนไข", "รหัสวิชา", "ชื่อวิชา", "หน่วยกิต", "เรียนก่อน/ร่วม", "ลบ" }; tblCourse.Attributes.Add("class", "table table-striped table-bordered table-hover"); tblCourse.Attributes.Add("id", "dt_basic"); TableHeaderRow tRowHead = new TableHeaderRow(); tRowHead.TableSection = TableRowSection.TableHeader; for (int cellCtr = 1; cellCtr <= ar.Length; cellCtr++) { TableHeaderCell cellHead = new TableHeaderCell(); if (cellCtr == 1) { cellHead.Width = 50; } if (cellCtr == 2 || cellCtr == 4) { cellHead.Width = 80; } if (cellCtr == 5) { cellHead.Width = 120; } if (cellCtr == 6) { cellHead.Width = 60; } cellHead.Text = ar[cellCtr - 1]; tRowHead.Cells.Add(cellHead); } tblCourse.Rows.Add(tRowHead); string sqlPreRequisite = "Select * From PREREQUISITE Where CURRCODE='" + CurrCode + "' And YEARVERSION='" + YearVersion + "' And CURRFORMATCODE='" + CurrFormatCode + "' And CURRTYPECODE='" + CurrTypeCode + "' And MAJORCODE='" + MajorCode + "' And COURSEGROUPCODE='" + CourseGroupCode + "' And CATEGORYCODE='" + CategoryCode + "' And COURSETYPECODE='" + CourseTypeCode + "' And COURSECODE='" + CourseCode + "' Order by PREREQUISITERULE"; List <PreRequisite> preRequisite = new PreRequisite().getPreRequisiteManual(sqlPreRequisite); foreach (PreRequisite data in preRequisite) { TQF.Course courseData = new TQF.Course().getCourse(data.PreRequisiteCourseCode); TableRow tRowBody = new TableRow(); tRowBody.TableSection = TableRowSection.TableBody; //Cell [0] TableCell cellPreRequisiteRule = new TableCell(); cellPreRequisiteRule.Text = data.PreRequisiteRule; cellPreRequisiteRule.CssClass = "text-center"; cellPreRequisiteRule.Width = 50; tRowBody.Cells.Add(cellPreRequisiteRule); //Cell [1] TableCell cellCourseCode = new TableCell(); //string urlShow = "showCOURSE.aspx?token=" + data.PreRequisiteCourseCode; string urlShow = "showCOURSE.aspx?token=" + data.PreRequisiteCourseCode + "&CurrCode=" + data.CurrCode + "&YearVersion=" + data.YearVersion; HyperLink hypShow = new HyperLink(); hypShow.Attributes.Add("data-target", "#showModal"); hypShow.Attributes.Add("data-toggle", "modal"); hypShow.Text = data.PreRequisiteCourseCode; hypShow.NavigateUrl = urlShow; hypShow.ToolTip = "Course details"; cellCourseCode.Controls.Add(hypShow); cellCourseCode.CssClass = "text-center"; cellCourseCode.Width = 80; tRowBody.Cells.Add(cellCourseCode); //Cell [2] TableCell cellCourseThName = new TableCell(); cellCourseThName.Text = courseData.CourseThName + "<BR>" + courseData.CourseEnName; tRowBody.Cells.Add(cellCourseThName); //Cell [3] TableCell cellNumCredit = new TableCell(); cellNumCredit.Text = courseData.Credit + "(" + courseData.TheoryHour + "-" + courseData.PracticeHour + "-" + courseData.SelfStudyHour + ")"; cellNumCredit.Width = 80; tRowBody.Cells.Add(cellNumCredit); //Cell [4] TableCell cellPreRequisiteFormat = new TableCell(); if (data.PreRequisiteFormat == "B") { cellPreRequisiteFormat.Text = "บังคับเรียนก่อน"; } if (data.PreRequisiteFormat == "C") { cellPreRequisiteFormat.Text = "บังคับเรียนร่วมกัน"; } if (data.PreRequisiteFormat == "D") { cellPreRequisiteFormat.Text = "บังคับเรียนก่อน/บังคับเรียนร่วมกัน"; } //cellPreRequisiteFormat.Text = data.PreRequisiteFormat; cellPreRequisiteFormat.Width = 120; tRowBody.Cells.Add(cellPreRequisiteFormat); //Cell [5] TableCell cellDel = new TableCell(); string urlDel = "deletePREREQ.aspx?CurrCode=" + data.CurrCode + "&YearVersion=" + data.YearVersion + "&CurrFormatCode=" + data.CurrFormatCode + "&CurrTypeCode=" + data.CurrTypeCode + "&MajorCode=" + data.MajorCode + "&CategoryCode=" + data.CategoryCode + "&CourseGroupCode=" + data.CourseGroupCode + "&CourseTypeCode=" + data.CourseTypeCode + "&CourseCode=" + data.CourseCode + "&PreRequisiteCourseCode=" + data.PreRequisiteCourseCode + "&PreRequisiteRule=" + data.PreRequisiteRule; HyperLink hypDel = new HyperLink(); hypDel.Attributes.Add("data-target", "#deletePREREQ"); hypDel.Attributes.Add("data-toggle", "modal"); hypDel.Text = "<h4><i class='fa fa-trash-o'></i></h4>"; hypDel.NavigateUrl = urlDel; hypDel.ToolTip = "Delete"; cellDel.Controls.Add(hypDel); cellDel.CssClass = "text-center"; cellDel.Width = 60; tRowBody.Cells.Add(cellDel); tblCourse.Rows.Add(tRowBody); } }