protected void DoViewTeacher(string teacherID) { outBuf = new StringBuilder(); DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); theTeacher = new Teacher(); theTeacher.LoadFromDB(db, " teacher_id=" + teacherID); PaidGroup[] memberInGroup = theTeacher.LoadAssosicatedPaidGroup(db); // Query payment // Payment[] pays1 = Payment.LoadListFromDBbyTeacherID(db, teacherID); // Payment[] pays2 = Payment.LoadListFromDBbyTeacherIDInPaidGroup(db, teacherID); db.Close(); // List out all paid group that the teacher is member StringBuilder memberGroupTxt = new StringBuilder(); for (int i = 0; i < memberInGroup.Length; i++) { memberGroupTxt.Append("  " + PaidGroup.GetPaidGroupID(memberInGroup[i]._paidGroupID) + " " + memberInGroup[i]._name + "<br>"); } /* * // Only teach by himself * int sumAllCost = 0; * int sumMaxPayable = 0; * int sumPaidCost = 0; * StringBuilder pay1Txt = new StringBuilder(); * for (int i = 0; i < pays1.Length; i++) * { * sumAllCost += pays1[i]._sumAllCost; * sumMaxPayable += pays1[i]._sumMaxPayable; * sumPaidCost += pays1[i]._sumPaidCost; * string courseTxt = "<a href=\"CourseManage.aspx?actPage=view&targetID=" + pays1[i]._courseID + "\" >" + pays1[i]._btsCourseID + " " + pays1[i]._courseName + "</a>"; * * pay1Txt.AppendLine("<tr>"); * pay1Txt.AppendLine("<td align=left> " + courseTxt + "</td>"); * pay1Txt.AppendLine("<td align=center> " + pays1[i]._courseStartDate.ToString("dd/MM/yyyy", ci) + " - " + pays1[i]._courseEndDate.ToString("dd/MM/yyyy", ci) + "</td>"); * pay1Txt.AppendLine("<td align=center> " + StringUtil.Int2StrComma(pays1[i]._sumAllCost) + "</td>"); * pay1Txt.AppendLine("<td align=center> " + StringUtil.Int2StrComma(pays1[i]._sumMaxPayable) + "</td>"); * pay1Txt.AppendLine("<td align=center> " + StringUtil.Int2StrComma(pays1[i]._sumPaidCost) + "</td>"); * pay1Txt.AppendLine("</tr>"); * } * // Summary * pay1Txt.AppendLine("<tr>"); * pay1Txt.AppendLine("<td align=center colspan=2 > <b>รวม </b></td>"); * pay1Txt.AppendLine("<td align=center><b> " + StringUtil.Int2StrComma(sumAllCost) + "</b></td>"); * pay1Txt.AppendLine("<td align=center><b> " + StringUtil.Int2StrComma(sumMaxPayable) + "</b></td>"); * pay1Txt.AppendLine("<td align=center><b> " + StringUtil.Int2StrComma(sumPaidCost) + "</b></td>"); * pay1Txt.AppendLine("</tr>"); * * // All in paidgroup * int sumAllCost2 = 0; * int sumMaxPayable2 = 0; * int sumPaidCost2 = 0; * StringBuilder pay2Txt = new StringBuilder(); * for (int i = 0; i < pays2.Length; i++) * { * sumAllCost2 += pays2[i]._sumAllCost; * sumMaxPayable2 += pays2[i]._sumMaxPayable; * sumPaidCost2 += pays2[i]._sumPaidCost; * string courseTxt = "<a href=\"CourseManage.aspx?actPage=view&targetID=" + pays2[i]._courseID + "\" >" + pays2[i]._btsCourseID + " " + pays2[i]._courseName + "</a>"; * * pay2Txt.AppendLine("<tr>"); * pay2Txt.AppendLine("<td align=left> " + courseTxt + "</td>"); * pay2Txt.AppendLine("<td align=center> " + pays2[i]._courseStartDate.ToString("dd/MM/yyyy", ci) + " - " + pays2[i]._courseEndDate.ToString("dd/MM/yyyy", ci) + "</td>"); * pay2Txt.AppendLine("<td align=center> " + StringUtil.Int2StrComma(pays2[i]._sumAllCost) + "</td>"); * pay2Txt.AppendLine("<td align=center> " + StringUtil.Int2StrComma(pays2[i]._sumMaxPayable) + "</td>"); * pay2Txt.AppendLine("<td align=center> " + StringUtil.Int2StrComma(pays2[i]._sumPaidCost) + "</td>"); * pay2Txt.AppendLine("</tr>"); * } * // Summary * pay2Txt.AppendLine("<tr>"); * pay2Txt.AppendLine("<td align=center colspan=2 > <b>รวม </b></td>"); * pay2Txt.AppendLine("<td align=center><b> " + StringUtil.Int2StrComma(sumAllCost2) + "</b></td>"); * pay2Txt.AppendLine("<td align=center><b> " + StringUtil.Int2StrComma(sumMaxPayable2) + "</b></td>"); * pay2Txt.AppendLine("<td align=center><b> " + StringUtil.Int2StrComma(sumPaidCost2) + "</b></td>"); * pay2Txt.AppendLine("</tr>"); */ /* * StringBuilder rateTxt = new StringBuilder(); * int currentRate = theTeacher._paidGroup.GetCurrentRate(sumAllCost2); * PaidRateInfo[] rate = theTeacher._paidGroup._rateInfo; * for (int i = 0; i < rate.Length; i++) * { * string bgcolor = ""; * if (currentRate == rate[i]._percent) * { * bgcolor = " bgcolor=\"#FFB148\" "; * } * * rateTxt.AppendLine("<tr>"); * rateTxt.AppendLine("<td align=center " + bgcolor + "> " + StringUtil.Int2StrComma(rate[i]._bound) + " </td>"); * rateTxt.AppendLine("<td align=center " + bgcolor + "> " + rate[i]._percent + "% </td>"); * rateTxt.AppendLine("</tr>"); * } */ TextReader reader = new StreamReader(Config.PATH_APP_ROOT + "\\template\\teacher_view.htm"); String templateContent = reader.ReadToEnd(); reader.Close(); String htmlContent = String.Format(templateContent , Config.URL_PIC_TEACHER + "/" + theTeacher._img , Teacher.GetTeacherID(theTeacher._teacherID) , theTeacher._firstname + " " + theTeacher._surname , theTeacher._subject , Config.URL_PIC_SYS + (theTeacher._sex.Equals("Male") ? "/boy.gif" : "/girl.gif") , theTeacher._birthday.ToString("dd/MM/yyyy", ci) , theTeacher._citizenID , theTeacher._addr , theTeacher._tel , theTeacher._email , memberGroupTxt.ToString() , "" // pay1Txt.ToString() , "" //pay2Txt.ToString() ); outBuf.Append(htmlContent); }
protected void DoViewCourse(string courseID) { DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); theCourse = new Course(); theCourse.LoadFromDB(db, " course_id=" + courseID); theCourse.LoadTeacher(db); theCourse.LoadPaidGroup(db); db.Close(); TextReader reader = new StreamReader(Config.PATH_APP_ROOT + "\\template\\course_view.htm"); String templateContent = reader.ReadToEnd(); reader.Close(); String[,] students = LoadStudentList(db, courseID); StringBuilder stdTxt = new StringBuilder(); int numStudent = (students.Length / 9); int numCancel = 0; for (int i = 0; i < numStudent; i++) { stdTxt.Append("<tr>"); for (int j = 0; j < 9; j++) { // edit registration if (j == 8) { stdTxt.Append("<td>  <a href=\"javascript:jumpToEditRegistration(" + students[i, j] + ")\"><img src=\"img/sys/edit.gif\" border=\"0\" alt=\"Edit\"></a></td>"); continue; } stdTxt.Append("<td>  " + students[i, j] + "</td>"); if ((j == 6) && (students[i, j].Equals("ยกเลิก"))) { numCancel++; } } stdTxt.Append("</tr>"); } String courseScheduleDetail = "-"; if (theCourse._courseType == "คอร์สสด") { courseScheduleDetail = theCourse._startdate.ToString("dd/MM/yyyy", ci) + " - " + theCourse._enddate.ToString("dd/MM/yyyy", ci) + "<br>" + theCourse._dayOfWeek + " " + theCourse._opentime; } String htmlContent = String.Format(templateContent , Config.URL_PIC_COURSE + "/" + theCourse._img , theCourse._btsCourseID + " " + theCourse._courseName , theCourse._shortName , theCourse._courseType , theCourse._category , courseScheduleDetail , theCourse._teacher._firstname + " " + theCourse._teacher._surname , PaidGroup.GetPaidGroupID(theCourse._paidGroupID) + " " + theCourse._paidGroup._name , StringUtil.Int2StrComma(theCourse._cost) , theCourse._seatLimit.ToString() , theCourse._bankRegisLimit.ToString() , (numStudent - numCancel).ToString() , theCourse._courseDesc , "สมัคร " + numStudent + " คน ยกเลิก " + (numCancel) + " คน คงเหลือ " + (numStudent - numCancel) + " คน" , stdTxt.ToString()); outBuf.Append(htmlContent); }
protected void DoListPaidGroup(string searchStr) { // get Page int pg = 1; if (Request["pg"] != null) { pg = Int32.Parse(Request["pg"]); } string[,] bgclass = new string[, ] { { "class=\"spec\"", "class=\"td1\"" }, { "class=\"specalt\"", "class=\"alt\"" } }; DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); int numRec = db.QueryCount("SELECT Count(*) FROM paid_group " + GetQSearchSQL(searchStr)); OdbcDataReader reader = db.Query("SELECT * FROM paid_group " + GetQSearchSQL(searchStr) + " LIMIT " + Config.TBRECORD_PER_PAGE + " OFFSET " + (((pg - 1) * Config.TBRECORD_PER_PAGE))); int i = 0; while (reader.Read()) { PaidGroup group = BTS.Entity.PaidGroup.CreateForm(reader); // teacher member list Teacher[] memberList = group.LoadMemberTeachers(db); StringBuilder memberTxt = new StringBuilder(); for (int j = 0; j < memberList.Length; j++) { String txt = Teacher.GetTeacherID(memberList[j]._teacherID) + " " + memberList[j]._firstname + " " + memberList[j]._surname; memberTxt.Append("<a href=\"TeacherManage.aspx?actPage=view&targetID=" + memberList[j]._teacherID + "\">" + txt + "<br>"); } outBuf.Append("<tr>"); outBuf.Append("<th scope=\"row\" abbr=\"Model\" " + bgclass[i % 2, 0] + ">" + PaidGroup.GetPaidGroupID(group._paidGroupID) + "</th>"); outBuf.Append("<td " + bgclass[i % 2, 1] + " >" + group._name + " </td>"); outBuf.Append("<td " + bgclass[i % 2, 1] + " >" + group._rawRateInfo + " </td>"); outBuf.Append("<td " + bgclass[i % 2, 1] + " align=left >" + memberTxt + " </td>"); outBuf.Append("<td " + bgclass[i % 2, 1] + " align=center> "); outBuf.Append("<a href=\"javascript:setVal('actPage','edit');setVal('targetID','" + group._paidGroupID + "');doSubmit()\"><img src=\"img/sys/edit.gif\" border=0 alt=\"Edit\"></a> "); outBuf.Append("<a href=\"javascript:if (confirm('Delete this user?')) { setVal('actPage','delete');setVal('targetID','" + group._paidGroupID + "');doSubmit(); }\"><img src=\"img/sys/delete.gif\" border=0 alt=\"Delete\"></a> "); outBuf.Append("</td>"); outBuf.Append("</tr>\n"); i++; } db.Close(); // calculate max page int maxpg = numRec / Config.TBRECORD_PER_PAGE; if (maxpg < 1) { maxpg = 1; } else if (maxpg % Config.TBRECORD_PER_PAGE > 0) { maxpg++; } // Generate Page Navi HTML outBuf2.Append("<b>Page</b> "); for (i = 1; i <= maxpg; i++) { if (i == pg) { outBuf2.Append("<b>" + i + "</b> "); } else { outBuf2.Append(String.Format("<a href=\"PaidGroupManage.aspx?pg={0}\">{1}</a> ", i.ToString(), i.ToString())); } } // <a href="#">1</a> <b>2</b> <a href="#">3</a> <a href="#">4</a> }
protected void DoListPaymentByTeacher(string teacherID, string searchStr, bool isNewSearch) { DBManager db; db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); db.Connect(); listTeacher = Teacher.LoadListFromDB(db, " WHERE is_active=1 ORDER BY firstname "); if (teacherID == null) { return; } // get Page int pg = 1; if ((!isNewSearch) && (Request["pg"] != null)) { pg = Int32.Parse(Request["pg"]); } string[,] bgclass = new string[, ] { { "class=\"spec\"", "class=\"td1\"", "class=\"td1_grey\"", "class=\"td1_red\"" }, { "class=\"specalt\"", "class=\"alt\"", "class=\"td1_grey\"", "class=\"td1_red\"" } }; string grey = "class=\"thspec_grey\""; string red = "class=\"thspec_red\""; listPayment = new List <Payment>(); AppUser user = (AppUser)Session[SessionVar.USER]; filterPayment = Request["filter_payment"]; if (filterPayment == null) { filterPayment = "0"; // by default } string whereSQL = " pm.course_id=c.course_id AND c.teacher_id=t.teacher_id AND c.room_id = r.room_id "; // only admin can view all payment if (!user.IsAdmin()) { whereSQL = whereSQL + " AND r.branch_id=" + user._branchID; } // filter only payable courses if (filterPayment.Equals("0")) { whereSQL = whereSQL + " AND sum_max_payable<>sum_paid_cost "; } int numRec = db.QueryCount("SELECT Count(*) FROM payment pm, course c, teacher t, room r WHERE " + whereSQL); OdbcDataReader reader = db.Query("SELECT pm.course_id as course_id ,c.bts_course_id as bts_course_id ,c.course_name as course_name, t.paid_group_id as paid_group_id" + ", pm.sum_all_cost as sum_all_cost, pm.sum_max_payable as sum_max_payable, pm.sum_paid_cost as sum_paid_cost " + "FROM payment pm, course c, teacher t, room r WHERE " + whereSQL + " LIMIT " + Config.TBRECORD_PER_PAGE + " OFFSET " + (((pg - 1) * Config.TBRECORD_PER_PAGE))); int i = 0; while (reader.Read()) { Payment payment = Payment.CreateForm(reader); string chbname = "course" + payment._courseID; int sumPayable = payment._sumMaxPayable - payment._sumPaidCost; int n = 1; if (sumPayable == 0) { n = 2; } else if (sumPayable < 0) { n = 3; } string bgcolor = (sumPayable == 0) ? grey : red; outBuf.Append("<tr>"); outBuf.Append("<th scope=\"row\" abbr=\"Model\" " + (sumPayable > 0 ? bgclass[i % 2, 0] : bgcolor) + ">" + payment._btsCourseID + "</th>"); outBuf.Append("<td " + bgclass[i % 2, n] + " align=center ><input type=\"checkbox\" name=\"" + chbname + "\" id=\"" + chbname + "\" />" + "</td>"); outBuf.Append("<td " + bgclass[i % 2, n] + " ><a href=\"CourseManage.aspx?actPage=view&targetID=" + payment._courseID + "\" >" + payment._courseName + "</a></td>"); outBuf.Append("<td " + bgclass[i % 2, n] + " align=center >" + PaidGroup.GetPaidGroupID(payment._paidGroupID) + "</td>"); outBuf.Append("<td " + bgclass[i % 2, n] + " align=center ><b>" + StringUtil.Int2StrComma(payment._sumAllCost) + "</b></td>"); outBuf.Append("<td " + bgclass[i % 2, n] + " align=center ><b><font color=blue>" + StringUtil.Int2StrComma(payment._sumMaxPayable) + "</font></b></td>"); outBuf.Append("<td " + bgclass[i % 2, n] + " align=center ><b><font color=red>" + StringUtil.Int2StrComma(payment._sumPaidCost) + "</font></b></td>"); outBuf.Append("<td " + bgclass[i % 2, n] + " align=center ><b><font color=green>" + StringUtil.Int2StrComma(sumPayable) + "</font></b></td>"); /* outBuf.Append("<td " + bgclass[i % 2, n] + " align=center>" + payment._lastPaidDate.ToString("dd/MM/yyyy HH:mm", ci) + " </td>"); */ outBuf.Append("<td " + bgclass[i % 2, n] + " align=center> "); outBuf.Append("<a href=\"javascript:setVal('actPage','view');setVal('targetID','" + payment._courseID + "');doSubmit()\"><img src=\"img/sys/view.gif\" border=0 alt=\"View detail\"></a> "); // outBuf.Append("<a href=\"javascript:if (confirm('Delete this payment?')) { setVal('actPage','delete');setVal('targetID','" + payment._paymentID + "');doSubmit(); }\"><img src=\"img/sys/delete.gif\" border=0 alt=\"Delete\"></a> "); outBuf.Append("</td>"); outBuf.Append("</tr>\n"); i++; } db.Close(); // calculate max page int maxpg = numRec / Config.TBRECORD_PER_PAGE; if (maxpg < 1) { maxpg = 1; } else if (numRec % Config.TBRECORD_PER_PAGE > 0) { maxpg++; } // Generate Page Navi HTML outBuf2.Append("<b>Page</b> "); for (i = 1; i <= maxpg; i++) { if (i == pg) { outBuf2.Append("<b>" + i + "</b> "); } else { outBuf2.Append(String.Format("<a href=\"PaymentManage.aspx?pg={0}&filter_payment={1}&qsearch={1}\">{0}</a> ", i.ToString(), filterPayment, searchStr)); } } // <a href="#">1</a> <b>2</b> <a href="#">3</a> <a href="#">4</a> }
protected void DoViewPayment(string courseID) { DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); db.Connect(); thePayment = new Payment(); thePayment.LoadFromDB(db, " course_id=" + courseID); thePayment.LoadHistory(db); thePayment.LoadCourse(db); Course c = thePayment._course; c.LoadTeacher(db); c.LoadPaidGroup(db); // preload all branches Dictionary <int, Branch> branches = Branch.LoadListFromDBAsMap(db, ""); PaidGroup pg = new PaidGroup(); pg.LoadFromDB(db, " paid_group_id=" + c._paidGroupID); // Load teachers in this group listTeacher = pg.LoadMemberTeachers(db); // Generate HTML content TextReader reader = new StreamReader(Config.PATH_APP_ROOT + "\\template\\payment_view.htm"); String templateContent = reader.ReadToEnd(); reader.Close(); // Construct Teacher List StringBuilder teachTxt = new StringBuilder(); for (int i = 0; i < listTeacher.Length; i++) { string link = "TeacherManage.aspx?actPage=edit&targetID=" + listTeacher[i]._teacherID; teachTxt.Append("<a href=\"" + link + "\" >" + listTeacher[i]._firstname + " " + listTeacher[i]._surname + "</a><br>"); } // Construct RaitInfo List StringBuilder rinfoTxt = new StringBuilder(); for (int i = 0; i < pg._rateInfo.Length; i++) { rinfoTxt.Append("มากกว่า " + StringUtil.Int2StrComma(pg._rateInfo[i]._bound) + " บาท ได้รับ " + pg._rateInfo[i]._percent + " %<br>"); } // Construct Paid history StringBuilder phTxt = new StringBuilder(); foreach (PaymentHistory ph in thePayment._historyList) { ph.LoadReceiver(db); ph.LoadUser(db); Branch b = branches[ph._branchID]; string link = "TeacherManage.aspx?actPage=edit&targetID=" + ph._receiverTeacherID; phTxt.AppendLine("<tr><td align=center>" + PaymentHistory.GetPaymentHistoryID(ph._paymentID) + "</td>"); phTxt.AppendLine("<td align=center>" + StringUtil.ConvertYearToEng(ph._paidDate, "yyyy/MM/dd HH:mm:ss") + "</td>"); phTxt.AppendLine("<td align=center>" + StringUtil.Int2StrComma(ph._paidCost) + "</td>"); phTxt.AppendLine("<td align=center><a href=\"" + link + "\" >" + ph._receiverTeacher._firstname + " " + ph._receiverTeacher._surname + "</a></td>"); phTxt.AppendLine("<td align=center>" + ph._user._firstname + " " + ph._user._surname + "</td>"); phTxt.AppendLine("<td align=center>" + b._branchName + "</td>"); phTxt.AppendLine("<td align=center><a href=\"javascript:doInitPrint(" + ph._paymentID + ")\"><img src=\"" + Config.URL_PIC_SYS + "/view.gif\" border=0></a> </td>"); } String htmlContent = String.Format(templateContent , c._courseName , "<a href=\"TeacherManage.aspx?actPage=edit&targetID=" + c._teacherID + "\" >" + c._teacher._firstname + " " + c._teacher._surname + "</a>" , PaidGroup.GetPaidGroupID(c._paidGroupID) + " " + c._paidGroup._name , teachTxt.ToString() , rinfoTxt.ToString() , StringUtil.Int2StrComma(thePayment._sumAllCost) , StringUtil.Int2StrComma(thePayment._sumMaxPayable) , StringUtil.Int2StrComma(thePayment._sumPaidCost) , StringUtil.Int2StrComma(thePayment._sumMaxPayable - thePayment._sumPaidCost) , phTxt.ToString() ); outBuf.Append(htmlContent); db.Close(); }
protected void DoInitPrintReceiptPaymentData(string paymentID) { DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC); db.Connect(); PaymentHistory pm = new PaymentHistory(); pm.LoadFromDB(db, " payment_id=" + paymentID); pm.LoadCourse(db); pm._course.LoadTeacher(db); pm._course.LoadPaidGroup(db); // load teacher in this group Teacher[] listTeacher = pm._course._paidGroup.LoadMemberTeachers(db); pm.LoadReceiver(db); // preload all branches Dictionary <int, Branch> branches = Branch.LoadListFromDBAsMap(db, ""); // Load PaymentHistory BEFORE this PaymentHistory[] pmList = PaymentHistory.LoadListFromDB(db, " WHERE course_id='" + pm._courseID + "' and payment_id<='" + pm._paymentID + "' ORDER BY payment_id"); // Construct Teacher List StringBuilder teachTxt = new StringBuilder(); for (int i = 0; i < listTeacher.Length; i++) { string link = "TeacherManage.aspx?actPage=edit&targetID=" + listTeacher[i]._teacherID; teachTxt.Append(listTeacher[i]._firstname + " " + listTeacher[i]._surname + "<br>"); } // Construct Paid history StringBuilder phTxt = new StringBuilder(); for (int i = 0; i < pmList.Length; i++) { PaymentHistory ph = pmList[i]; ph.LoadReceiver(db); ph.LoadUser(db); Branch b = branches[ph._branchID]; string link = "TeacherManage.aspx?actPage=edit&targetID=" + ph._receiverTeacherID; phTxt.AppendLine("<tr><td align=center>" + PaymentHistory.GetPaymentHistoryID(ph._paymentID) + "</td>"); phTxt.AppendLine("<td align=center>" + StringUtil.ConvertYearToEng(ph._paidDate, "yyyy/MM/dd HH:mm:ss ") + "</td>"); phTxt.AppendLine("<td align=center>" + StringUtil.Int2StrComma(ph._paidCost) + "</td>"); phTxt.AppendLine("<td align=center>" + ph._receiverTeacher._firstname + " " + ph._receiverTeacher._surname + "</td>"); phTxt.AppendLine("<td align=center>" + ph._user._firstname + " " + ph._user._surname + "</td>"); phTxt.AppendLine("<td align=center>" + b._branchName + "</td>"); } // User AppUser user = new AppUser(); user.LoadFromDB(db, " username='******'"); // Generate HTML content TextReader reader = new StreamReader(Config.PATH_APP_ROOT + "\\template\\payment_print.htm"); String templateContent = reader.ReadToEnd(); reader.Close(); String htmlContent = String.Format(templateContent , StringUtil.ConvertYearToEng(pm._paidDate, "yyyy/MM/dd HH:mm:ss") , pm._receiverTeacher._firstname + " " + pm._receiverTeacher._surname , pm._course._btsCourseID + " \"" + pm._course._courseName + "\"" , StringUtil.Int2StrComma(pm._paidCost) , pm._course._teacher._firstname + " " + pm._course._teacher._surname , PaidGroup.GetPaidGroupID(pm._course._paidGroup._currentRound) , teachTxt.ToString() , StringUtil.Int2StrComma(pm._sumMaxPayable) , StringUtil.Int2StrComma(pm._sumPaidCost + pm._paidCost) , phTxt.ToString() , user._firstname + " " + user._surname ); outBuf.Append(htmlContent); db.Close(); }