Esempio n. 1
0
        protected void ProcessWizAddSelectedStudent(string student_id)
        {
            // get data from session
            RegisTransaction reg = (RegisTransaction)Session[SessionVar.CURRENT_REGIS];

            if (reg == null)
            {
                reg = new RegisTransaction();
            }


            DBManager db      = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC);
            Student   student = new Student();

            student.LoadFromDB(db, " student_id=" + student_id);
            db.Close();

            if (student != null)
            {
                reg._student   = student;
                reg._studentID = student._studentID;
            }

            // save back to session
            Session[SessionVar.CURRENT_REGIS] = reg;
        }
Esempio n. 2
0
        protected void ProcessWizAddSelectedCourse(string course_id)
        {
            // get data from session
            RegisTransaction reg = (RegisTransaction)Session[SessionVar.CURRENT_REGIS];

            if (reg == null)
            {
                reg = new RegisTransaction();
            }


            DBManager db     = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC);
            Course    course = new Course();

            course.LoadFromDB(db, " course_id=" + course_id);
            db.Close();

            if (course != null)
            {
                reg.AddCourse(course);
            }

            // save back to session
            Session[SessionVar.CURRENT_REGIS] = reg;
        }
Esempio n. 3
0
        // TODO: Check duplicated registration
        protected void ProcessRegistration(RegisTransaction reg)
        {
            AppUser user = (AppUser)Session[SessionVar.USER];

            // Collect additional variable
            // * User information comes from session NOT DB
            reg._username   = user._username;
            reg._paidMethod = Int32.Parse(Request["paid_method"]);
            if (Session[SessionVar.BRANCH_SELECTED] == null)
            {
                reg._branchID = user._branchID;
            }
            else
            {
                reg._branchID            = Int32.Parse((String)Session[SessionVar.BRANCH_SELECTED]);
                user._branchID           = reg._branchID;
                Session[SessionVar.USER] = user;
            }
            reg._paiddate = StringUtil.getDate(Request["paid_date"]);

            // seat
            for (int i = 0; i < Request.Form.AllKeys.Length; i++)
            {
                if (Request.Form.AllKeys[i].StartsWith("seat_no"))
                {
                    string courseID = Request.Form.AllKeys[i].Substring(7);
                    string seatNo   = Request[Request.Form.AllKeys[i]];
                    try
                    {
                        reg._seatNoMap.Add(courseID, seatNo);
                    }
                    catch (Exception ex) { }
                    continue;
                }
                if (Request.Form.AllKeys[i].StartsWith("note"))
                {
                    string courseID = Request.Form.AllKeys[i].Substring(4);
                    string note     = Request[Request.Form.AllKeys[i]];
                    try
                    {
                        reg._noteMap.Add(courseID, note);
                    }
                    catch (Exception ex) { }
                    continue;
                }
            }

            DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC);

            db.Connect();
            reg.AddToDB(db);
            db.Close();
        }
Esempio n. 4
0
 protected void ProcessPrintAdditionalInfoForm(RegisTransaction reg)
 {
     outBuf = new StringBuilder();
     foreach (Course c in reg._courses)
     {
         string seatName = "seat_no" + c._courseID;
         string noteName = "note" + c._courseID;
         outBuf.AppendLine("<tr><td align=left>" + c._btsCourseID + "</td>");
         outBuf.AppendLine("<td align=center><input type=text class=\"txtbox1\" style=\"width:20px\" maxlength=\"10\" name=\"" + seatName + "\"></td>");
         outBuf.AppendLine("<td align=center><input type=text class=\"txtbox1\" style=\"width:150px\" maxlength=\"200\" name=\"" + noteName + "\"></td></tr>");
     }
 }
Esempio n. 5
0
        protected void ProcessWizRemoveSelectedStudent(string course_id)
        {
            // get data from session
            RegisTransaction reg = (RegisTransaction)Session[SessionVar.CURRENT_REGIS];

            if (reg == null)
            {
                return;
            }

            foreach (Course c in reg._courses)
            {
                if (c._courseID.ToString().Equals(course_id))
                {
                    reg._courses.Remove(c);
                    break;
                }
            }
        }
Esempio n. 6
0
        protected void DiscountCourse(string course_id, string cost)
        {
            // get data from session
            RegisTransaction reg = (RegisTransaction)Session[SessionVar.CURRENT_REGIS];

            if (reg == null)
            {
                reg = new RegisTransaction();
            }

            int cid = Int32.Parse(course_id);

            foreach (Course c in reg._modCourses)
            {
                if (c._courseID == cid)
                {
                    c._discountedCost = Int32.Parse(cost);
                }
            }
        }
Esempio n. 7
0
        protected void DiscountPromotion(string promotion_id, string cost)
        {
            // get data from session
            RegisTransaction reg = (RegisTransaction)Session[SessionVar.CURRENT_REGIS];

            if (reg == null)
            {
                reg = new RegisTransaction();
            }

            int pid = Int32.Parse(promotion_id);

            foreach (Promotion p in reg._modPromotions)
            {
                if (p._promotionID == pid)
                {
                    p._discountedCost = Int32.Parse(cost);
                }
            }
        }
Esempio n. 8
0
        //    protected System.Web.UI.HtmlControls.HtmlInputFile portrait;


        protected void Page_Load(object sender, EventArgs e)
        {
            // Authentication
            string redirect = VerifyAA.Verify(Session
                                              , Request
                                              , Response
                                              , "NoRight.aspx");

            // Collect paramters
            actPage = Request.Form.Get("actPage");
            if (actPage == null)
            {
                actPage = Request["actPage"];
            }
            targetID = Request.Form.Get("targetID");
            if (targetID == null)
            {
                targetID = Request["targetID"];
            }

            // log
            log.StampLine(Logger.DETAILED, "Request [" + Request["ASP.NET_SessionId"] + "][" + Request.RawUrl + "][actPage=" + actPage + "&targetID=" + targetID + "]");
            log.StampLine(Logger.DEBUG, "Param [" + Request["ASP.NET_SessionId"] + "][" + Request.Params.ToString() + "]");


            if ((actPage == null) || (actPage.Trim().Length == 0) || (actPage.Equals("new")) || (actPage.Equals("select_course")))
            {
                if ((actPage == null) || (actPage.Trim().Length == 0) || (actPage.Equals("new")))
                {
                    // clear session data
                    Session[SessionVar.CURRENT_REGIS] = null;
                }

                // DoListPromotion(Request["qsearch"]);
            }
            else if (actPage.Equals("select_student"))
            {
                RegisTransaction reg = (RegisTransaction)Session[SessionVar.CURRENT_REGIS];
                if ((reg == null) || (reg._courses == null) || (reg._courses.Count == 0))
                {
                    actPage = "select_course";
                    return;
                }
            }
            else if (actPage.Equals("confirm_registration"))
            {
                RegisTransaction reg = (RegisTransaction)Session[SessionVar.CURRENT_REGIS];
                if ((reg == null) || (reg._student == null))
                {
                    actPage = "select_student";
                    return;
                }

                ProcessPrintAdditionalInfoForm(reg);
            }
            else if (actPage.Equals("add_new_student_submit"))
            {
                Student t = ProcessWizAddNewStudent();

                if (t == null)
                {
                    Response.Redirect("RegisterCourse.aspx?actPage=select_student&errorText=" + errorText);
                    return;
                }

                // save to session
                RegisTransaction reg = (RegisTransaction)Session[SessionVar.CURRENT_REGIS];
                reg._student   = t;
                reg._studentID = t._studentID;
                Session[SessionVar.CURRENT_REGIS] = reg;
                // list
                Response.Redirect("RegisterCourse.aspx?actPage=select_student");
            }
            else if (actPage.Equals("submit_registration"))
            {
                RegisTransaction reg = (RegisTransaction)Session[SessionVar.CURRENT_REGIS];
                if ((reg == null) || (reg._courses == null) || (reg._courses.Count == 0))
                {
                    errorText = "ข้อมูลการลงทะเบียนไม่สมบูรณ์ โปรดลองใหม่อีกครั้ง";
                    return;
                }

                ProcessRegistration(reg);
                // clear session data
                Session[SessionVar.CURRENT_REGIS] = null;
                Response.Redirect("RegisterCourse.aspx?actPage=registration_complete&targetId=" + reg._transactionID);
            }
            else if (actPage.Equals("registration_complete"))
            {
                DoInitPrintAll(targetID);
            }
            else if (actPage.Equals("cancel_registration"))
            {
                // clear session data
                Session[SessionVar.CURRENT_REGIS] = null;
                Response.Redirect("Home.aspx");
            }
        }
Esempio n. 9
0
        protected void ProcessWizListSelectedStudent()
        {
            outBuf.Append("<br>");
            // get data from session
            RegisTransaction reg = (RegisTransaction)Session[SessionVar.CURRENT_REGIS];

            if (reg == null)
            {
                return;
            }
            if (reg._student == null)
            {
                outBuf.Append("&nbsp&nbspยังไม่ได้เลือกนักเรียน");
                return;
            }

            // Query registration history
            DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC);

            Registration[] reghis = Registration.LoadListFromDBCustom(db, "SELECT rg.*, c.bts_course_id as bts_course_id, c.course_name as course_name FROM registration rg, course c WHERE "
                                                                      + " student_id=" + reg._student._studentID + " AND rg.course_id=c.course_id ORDER BY rg.regis_id ");
            db.Close();
            StringBuilder regHisTxt = new StringBuilder();

            if (reghis.Length > 0)
            {
                for (int i = 0; i < reghis.Length; i++)
                {
                    string statusTxt = Registration.GetStatusText(reghis[i]._status);
                    if (reghis[i]._status == Registration.STATUS_CANCELLED)
                    {
                        statusTxt = "<font color=red>" + statusTxt + "</font>";
                    }

                    regHisTxt.AppendLine("<tr>");
                    regHisTxt.AppendLine("<td>&nbsp" + reghis[i]._regisdate.ToString("dd/MM/yyyy HH:mm", ci) + "</td>");
                    regHisTxt.AppendLine("<td>&nbsp" + "<a href=\"CourseManage.aspx?actPage=view&targetID=" + reghis[i]._courseID + "\" >" + reghis[i]._btsCourseID + " " + reghis[i]._courseName + "</a>" + "</td>");
                    regHisTxt.AppendLine("<td align=center>" + StringUtil.Int2StrComma(reghis[i]._fullCost) + "</td>");
                    regHisTxt.AppendLine("<td align=center>" + StringUtil.Int2StrComma(reghis[i]._discountedCost) + "</td>");
                    regHisTxt.AppendLine("<td align=center>" + statusTxt + "</td>");
                    regHisTxt.AppendLine("<td align=center>" + reghis[i]._note + "</td>");

                    regHisTxt.AppendLine("</tr>");
                }
            }
            else
            {
                regHisTxt.AppendLine("<tr><td colspan=3 align=center>ไม่พบข้อมูลการลงทะเบียน</td></tr>");
            }


            TextReader reader          = new StreamReader(Config.PATH_APP_ROOT + "\\template\\" + AjaxSvc.WIZ_LIST_SELECTED_STUDENT + ".htm");
            String     templateContent = reader.ReadToEnd();

            reader.Close();

            Student s           = reg._student;
            String  htmlContent =
                String.Format(templateContent
                              , Config.URL_PIC_STUDENT + "/" + s._img
                              , Student.GetStudentID(s._studentID)
                              , s._firstname + " " + s._surname + " (" + s._nickname + ")"
                              , s._citizenID
                              , Config.URL_PIC_SYS + (s._sex.Equals("Male") ? "/boy.gif" : "/girl.gif")
                              , s._school
                              , s._birthday.ToString("dd/MM/yyyy", ci)
                              , s._addr
                              , s.GetTel()
                              , s._email
                              , regHisTxt.ToString());


            outBuf.Append(htmlContent);
        }
Esempio n. 10
0
        protected void ProcessWizListSelectedCourse(string enableAction, bool recalculatePromotion)
        {
            bool enableAct;

            Boolean.TryParse(enableAction, out enableAct);

            outBuf.Append("<br>");
            // get data from session
            RegisTransaction reg = (RegisTransaction)Session[SessionVar.CURRENT_REGIS];

            if (reg == null)
            {
                return;
            }
            if (reg._courses.Count == 0)
            {
                outBuf.Append("&nbsp&nbspยังไม่ได้เลือกคอร์ส");
            }

            if (recalculatePromotion)
            {
                // copy to temp list
                Course[] courses = new Course[reg._courses.Count];
                reg._courses.CopyTo(courses, 0);
                LinkedList <Course> copyCourses = new LinkedList <Course>(courses);

                // find matching promotions
                DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC);

                PromotionMatcher matcher = Promotion.LoadFromDBByMatchingCourses(db, reg._courses);
                db.Close();

                // store back to reg
                reg._modCourses    = (matcher._matchedCourses != null) ? matcher._matchedCourses : new LinkedList <Course>();
                reg._modPromotions = (matcher._matchedPromotions != null) ? matcher._matchedPromotions : new LinkedList <Promotion>();
                Session[SessionVar.CURRENT_REGIS] = reg;
            }

            // print
            Promotion[] proArray = new Promotion[reg._modPromotions.Count];
            reg._modPromotions.CopyTo(proArray, 0);

            int sumCost     = 0;
            int sumFullCost = 0;

            outBuf.Append("<table>");
            for (int i = 0; i < proArray.Length; i++)
            {
                sumCost += proArray[i]._discountedCost;
                outBuf.Append("<tr valign=middle><td>&nbsp&nbsp&nbsp</td><td>" + Promotion.GetPromotionID(proArray[i]._promotionID) + " " + proArray[i]._promotionName);
                string costTxt = StringUtil.Int2StrComma(proArray[i]._discountedCost);
                if (!enableAct)
                {
                    costTxt = " <a href=\"javascript:modifyPCost(" + proArray[i]._promotionID + "," + proArray[i]._discountedCost + ")\" >" + StringUtil.Int2StrComma(proArray[i]._discountedCost) + "</a>";
                }
                if (proArray[i]._cost != proArray[i]._discountedCost)
                {
                    costTxt = " <strike>" + StringUtil.Int2StrComma(proArray[i]._cost) + "</strike> &nbsp ลดพิเศษเหลือ " + costTxt;
                }

                outBuf.Append(" ( <strike>" + StringUtil.Int2StrComma(proArray[i].GetFullCost()) + "</strike> &nbsp" + costTxt + " )</td></tr>");
                for (int j = 0; j < proArray[i]._courses.Length; j++)
                {
                    Course c = proArray[i]._courses[j];
                    sumFullCost += c._cost;
                    string jsShowDiv  = " onmouseover=\"queryCourseDetail(" + c._courseID + ");showDivAt('divdetail')\" onmouseout=\"hideDiv('divdetail')\" ";
                    string icon       = "<img style=\"cursor:pointer\" border=0 src=\"" + Config.URL_PIC_SYS + "/info.gif\" " + jsShowDiv + ">";
                    string courseLine = c._btsCourseID + "&nbsp" + c._courseName;
                    string costLine   = " ( <strike>" + StringUtil.Int2StrComma(c._cost) + "</strike> )";

                    if (enableAct)
                    {
                        courseLine = "<a href=\"javascript:removeCourse('" + c._courseID + "')\">" + courseLine + "</a>";
                    }
                    outBuf.Append("<tr valign=middle><td>&nbsp&nbsp" + icon + "</td><td>&nbsp&nbsp&nbsp" + courseLine + costLine + "</td></tr>");
                    // remove from copied list
                    //copyCourses.Remove(c);
                }
            }

            // print no promotion
            foreach (Course c in reg._modCourses)
            {
                sumCost     += c._discountedCost;
                sumFullCost += c._cost;
                string jsShowDiv  = " onmouseover=\"queryCourseDetail(" + c._courseID + ");showDivAt('divdetail')\" onmouseout=\"hideDiv('divdetail')\" ";
                string icon       = "<img style=\"cursor:pointer\" border=0 src=\"" + Config.URL_PIC_SYS + "/info.gif\" " + jsShowDiv + ">";
                string courseLine = c._btsCourseID + "&nbsp" + c._courseName;
                if (enableAct)
                {
                    courseLine = "<a href=\"javascript:removeCourse('" + c._courseID + "')\">" + courseLine + "</a>";
                }

                string costTxt = " ( ";
                if (c._cost != c._discountedCost)
                {
                    costTxt = costTxt + " <strike>" + StringUtil.Int2StrComma(c._cost) + "</strike> &nbsp ลดพิเศษเหลือ ";
                }
                if (!enableAct)
                {
                    costTxt = costTxt + "<a href=\"javascript:modifyCCost(" + c._courseID + "," + c._discountedCost + ")\" >" + StringUtil.Int2StrComma(c._discountedCost) + "</a> )";
                }
                else
                {
                    costTxt = costTxt + StringUtil.Int2StrComma(c._discountedCost) + " )";
                }

                outBuf.Append("<tr valign=middle><td>&nbsp&nbsp" + icon + "</td><td>" + courseLine + costTxt + "</td></tr>");
            }
            outBuf.Append("</table><br><br>");
            outBuf.Append("&nbsp&nbsp<b>รวมค่าใช้จ่ายทั้งหมด <strike>" + StringUtil.Int2StrComma(sumFullCost) + "</strike>&nbsp<font size=2 color=red>" + StringUtil.Int2StrComma(sumCost) + "</font> บาท</b>");
        }