예제 #1
0
    public ArrayList SearchPaymentAdviceByCriteria(long idPAList,
        StringSearchPredicate[] aryS, IntegerSearchPredicate[] aryI,
        string lockKey)
    {
        ApasSearchManager s = new ApasSearchManager(lockKey);

        List<SearchPredicate> c = new List<SearchPredicate>();

        foreach (StringSearchPredicate ps in aryS)
        {
            ps.PredicateTemplate = " {0} like '%'+{1}+'%' ";
            c.Add(ps);
        }

        foreach (IntegerSearchPredicate pi in aryI)
        {
            pi.PredicateTemplate = " {0} = {1} ";
            c.Add(pi);
        }

        return s.SearchPaymentAdviceByCriteria(idPAList,c);
    }
예제 #2
0
        public string GenerateSMSSpreadSheet(HttpResponse response)
        {
            if (_CurrentPAList == null)
                throw new ApasInvaidOperationException(
                "System Error: No payment advice list exists for SMS text generation.");

            lock (criticalSection)
            {
                BCBranch[] aryBranch = BCBranch.getAllBranches();

                ApasSearchManager sMgr = new ApasSearchManager(PALockKey);

                //hold all PAs, halt if unsuccessful
                writeResponse("lblPreparation", "Acquiring exclusive access...",
                    "blueMessage", response);

                PALockManager lMgr = new PALockManager(
                    Apas.Security.ApasAccessControlManager.GetCurrentInstance().LogonUser.Id,
                    PALockKey);

                List<BCAspenUser> oUsers = lMgr.HoldPAListExclusive(_CurrentPAList.Id);

                if (oUsers.Count > 0)
                {
                    String oUserStr = "";
                    foreach (BCAspenUser oUser in oUsers)
                    {
                        oUserStr += oUser.FullName + ", ";
                    }
                    oUserStr = oUserStr.Substring(0,oUserStr.Length - 2);

                    writeResponse("lblPreparation",
                    "Failed",
                    "redMessage", response);

                    foreach (BCBranch objBranch in aryBranch)
                    {
                        writeResponse("lbl" + objBranch.Name.Trim(),
                        "Canceled",
                        "redMessage", response);
                    }

                    writeResponse("lblFinalization",
                   "Canceled",
                   "redMessage", response);

                    return "Failed to acquire exclusive access. " + oUserStr +
                    " is/are currently holding some records.";
                }

                writeResponse("lblPreparation", "Updating records...",
                    "blueMessage", response);
                //resync the PAs
                NHibernateManager.GetCurrentSession().Evict(_CurrentPAList);//remove it before reloading
                _CurrentPAList.Load(_CurrentPAList.Id, false);   //reload to get updated records
                if (_CurrentPAList.IsFrozen == 1)
                    _CurrentPAList.StaticSynchronizePaymentAdvices(PALockKey);
                else
                    _CurrentPAList.SyncPaymentAdvices(PALockKey);

                writeResponse("lblPreparation", "Initializing Excel...",
                    "blueMessage",response);

                ApasExcelManager xl=new ApasExcelManager();
                xl.InitExcelApplication();

                writeResponse("lblPreparation", "Successful",
                    "blueMessage", response);

                String[] aryDay = {"Monday", "Tuesday", "Wednesday", "Thursday",
                    "Friday", "Saturday", "Sunday"};
                //String[] aryDay = { "Monday" };

                int classCount;
                int completeCount;

                foreach (BCBranch objBranch in aryBranch)
                {
                    writeResponse("lbl" + objBranch.Name.Trim(), "Initializing...",
                        "blueMessage", response);

                    String strFile = "/APAS/tmp Excel Files/" +
                        _CurrentPAList.Month.ToString("yyyyMM") +
                        " SMS " + objBranch.Name.Trim() + ".xls";
                    String strLocalFile = HttpContext.Current.Server.MapPath("~"+strFile);

                    xl.CreateNewFile(strLocalFile);

                    foreach (String day in aryDay)
                    {
                        writeResponse("lbl" + objBranch.Name.Trim(),
                            "Processing "+ day +": Acquiring data...",
                            "blueMessage", response);

                        ArrayList result = sMgr.SearchPaymentAdviceByDay(
                            CurrentPAList.Id,
                            day, objBranch.Id);

                        xl.AddNewWorkSheet(day);
                        xl.WriteHeading(
                            "Student Id",
                             "Class Id",
                            "Student Name",
                            "Guardian Name",
                            "Class Description",
                            "Credit Payable",
                            "Amount Payable",
                            "SMS Text",
                            "Contact Number"
                        );

                        classCount = result.Count;
                        completeCount=1;
                        foreach (ApasRegularView objReg in result)
                        {

                            writeResponse("lbl" + objBranch.Name.Trim(),
                            "Processing " + day + ": "+ completeCount +" of "+ classCount  +" classes...",
                            "blueMessage", response);

                            foreach (PaymentAdviceView objPA in objReg.PaymentAdvices)
                            {
                                //don't include in SMS if excluced
                                if (objPA.IsExcluded )
                                    continue;

                                foreach (ClassFeeView objCF in objPA.ClassFees)
                                {
                                    if (objCF.IsExcluded )
                                        continue;

                                    xl.WriteRow(
                                    Convert.ToString(objPA.Student.Id),
                                    Convert.ToString(objCF.RegularClass.Id),
                                    objPA.Student.FullName,
                                    objPA.Student.Guardian.Name.Trim(),
                                    String.Format("{0} {1} {2} - {3}",
                                        objCF.RegularClass.Level,
                                        objCF.RegularClass.Subject,
                                        objCF.RegularClass.TimeStart,
                                        objCF.RegularClass.TimeEnd),
                                    Convert.ToString(objCF.PayableCredit),
                                    Convert.ToString(objCF.PayableFee),
                                    objCF.PaymentAdviceText,
                                    String.IsNullOrEmpty(objPA.Student.Guardian.ContactMobile) ?
                                        objPA.Student.ContactMobile : objPA.Student.Guardian.ContactMobile
                                    );

                                }//objCF

                                foreach (OtherFeeView objOF in objPA.OtherFees)
                                {
                                    if (objOF.IsExcluded)
                                        continue;

                                    xl.WriteRow(
                                    Convert.ToString(objPA.Student.Id),
                                    "N.A",
                                    objPA.Student.FullName,
                                    objPA.Student.Guardian.Name.Trim(),
                                    objOF.OtherFeeType,
                                    "N.A",
                                    "N.A",
                                    objOF.PaymentAdviceText,
                                    String.IsNullOrEmpty(objPA.Student.Guardian.ContactMobile) ?
                                        objPA.Student.ContactMobile : objPA.Student.Guardian.ContactMobile
                                    );
                                }//objOF

                            }//objPA

                            completeCount++;
                        }//objReg

                        xl.FinalizeWorkSheet();

                    }//day

                    writeResponse("lbl" + objBranch.Name.Trim(),
                    "Finalizing...",
                    "blueMessage", response);

                    xl.SaveFile();

                    writeResponse("lbl" + objBranch.Name.Trim(),
                    "Successful : <a href=" + MyUtils.EncodeJsString(HttpContext.Current.Request.ApplicationPath+strFile) + " target=\"_blank\">Download Link</a>",
                    "blueMessage", response);

                }//branch

                writeResponse("lblFinalization", "Closing excel...",
                   "blueMessage", response);
                xl.CloseExcelApplication();

                writeResponse("lblFinalization", "Updating records...",
                   "blueMessage", response);

                //has to reload. Dunno why
                NHibernateManager.GetCurrentSession().Evict(_CurrentPAList);//remove it before reloading
                _CurrentPAList.Load(_CurrentPAList.Id, false);   //reload to get updated records
                CurrentPAList.FreezePaymentAdvices(PALockKey);

                CurrentPAList.SMSGenTime = DateTime.Now;
                CurrentPAList.LastAction = "SMS Text Generated";
                CurrentPAList.LastModifiedBy =
                    ApasAccessControlManager.GetCurrentInstance().LogonUser.Id;
                CurrentPAList.LastModifiedTime = DateTime.Now;
                CurrentPAList.Save();

                lMgr.Release("", new List<SqlParameter>());

                writeResponse("lblFinalization", "Successful",
                   "blueMessage", response);

            }//critial section

            return "success";
        }
예제 #3
0
 public ArrayList SearchPaymentAdviceByDay(long idPAList, string strDay, int branchId, string lockKey)
 {
     ApasSearchManager s = new ApasSearchManager(lockKey);
     return s.SearchPaymentAdviceByDay(idPAList,strDay, branchId);
 }