Пример #1
0
        public string ApplyAccountNewRepaymentByIntroducer(string InstallationID, string soapusername, string soappassword,
                                                           string IntroducerID, string FacilityNo, string AccountNo,
                                                           string Newrepaymentdate, string NewRepaymentfrequency, string NewMinPaymentAmount, string NewNominateAmount, string NewAdditionalAmount)
        {
            try
            {
                OriginatorBiz oBiz = new OriginatorBiz(InstallationID, soapusername, soappassword, IntroducerID, FacilityNo, AccountNo);

                DateTime newrepaymentdate    = Convert.ToDateTime(Newrepaymentdate);
                Decimal  newMinPaymentAmount = Convert.ToDecimal(NewMinPaymentAmount);
                Decimal? newNominateAmount   = null;
                if (NewNominateAmount != "")
                {
                    newNominateAmount = Convert.ToDecimal(NewNominateAmount);
                }
                Decimal newAdditionalAmount = Convert.ToDecimal(NewAdditionalAmount);

                FacilityDAL fdal      = new FacilityDAL();
                DataSet     myDataSet = fdal.ApplyAccountNewRepaymentByIntroducer(
                    oBiz.InstallationID, oBiz.LWIntroducerID, oBiz.AccountFacilityID.Value, oBiz.AccountID.Value,
                    newrepaymentdate, NewRepaymentfrequency, newMinPaymentAmount, newNominateAmount, newAdditionalAmount);

                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #2
0
        public string CreateStatementByIntroducer(string InstallationID,
                                                  string soapusername, string soappassword,
                                                  string IntroducerID, string FacilityNo, string AccountNo, string StartDate, string EndDate)
        {
            try
            {
                DateTime startDate, endDate;

                if (StartDate == "" || EndDate == "")
                {
                    throw new Exception("Missing Date range");
                }

                OriginatorBiz oBiz = new OriginatorBiz(InstallationID, soapusername, soappassword, IntroducerID, FacilityNo, AccountNo);
                startDate = Convert.ToDateTime(StartDate);
                endDate   = Convert.ToDateTime(EndDate);

                GenerateStatementBiz generateStatement = new GenerateStatementBiz();
                Int64 AccountTemplateDocumentID        = generateStatement.GenerateStatement(
                    Convert.ToInt64(InstallationID), Convert.ToInt64(FacilityNo), Convert.ToInt64(AccountNo), 0, startDate, endDate);

                return("<accountdocumentid>" + LWTSafeTypes.SafeString(AccountTemplateDocumentID) + "</accountdocumentid>");

                //DataSet myDataSet = (new FacilityDAL()).GetStatementByIntroducer(
                //    oBiz.InstallationID, oBiz.LWIntroducerID, oBiz.AccountFacilityID.Value, oBiz.AccountID.Value, startDate, endDate);
                //return myDataSet.GetXml();
            }
            catch (Exception ex)
            {
                return("<error>" + ex.Message.ToString() + "</error>");
            }
        }
Пример #3
0
        public string CreateStatementByCustomer(string InstallationID,
                                                string soapusername, string soappassword,
                                                string CustomerID, string FacilityNo, string AccountNo, string StartDate, string EndDate)
        {
            try
            {
                DateTime startDate, endDate;

                if (StartDate == "" || EndDate == "")
                {
                    throw new Exception("Missing Date range");
                }

                CustomerBiz oBiz = new CustomerBiz(InstallationID, soapusername, soappassword, CustomerID, FacilityNo, AccountNo);
                startDate = Convert.ToDateTime(StartDate);
                endDate   = Convert.ToDateTime(EndDate);

                GenerateStatementBiz generateStatement = new GenerateStatementBiz();
                Int64 AccountTemplateDocumentID        = generateStatement.GenerateStatement(
                    Convert.ToInt64(InstallationID), Convert.ToInt64(FacilityNo), Convert.ToInt64(AccountNo), 0, startDate, endDate);

                return("<accountdocumentid>" + LWTSafeTypes.SafeString(AccountTemplateDocumentID) + "</accountdocumentid>");
            }
            catch (Exception ex)
            {
                return("<error>" + ex.Message.ToString() + "</error>");
            }
        }
Пример #4
0
        public void AccountMakeNewPayment(Int64 AccountFacilityID, Int64 AccountID, double Amount, DateTime date, string freqcode,
                                          out Int64 PaymentID, out Int64 TransID)
        {
            try
            {
                DbCommand DbCommand = database.GetStoredProcCommand("lmsAccountAdditionalPaymentSave");
                database.AddInParameter(DbCommand, "@InstallationID", DbType.Int32, System.Web.HttpContext.Current.Application["installationid"]);
                database.AddInParameter(DbCommand, "@UserID", DbType.Int64, -2);
                database.AddInParameter(DbCommand, "@AccountFacilityID", DbType.Int64, AccountFacilityID);
                database.AddInParameter(DbCommand, "@AccountID", DbType.Int64, AccountID);
                database.AddInParameter(DbCommand, "@AdditionalPaymentAmount", DbType.Double, Amount);
                database.AddInParameter(DbCommand, "@PaymentFrequency ", DbType.String, freqcode);
                database.AddInParameter(DbCommand, "@StartDate", DbType.Date, date);

                database.AddOutParameter(DbCommand, "@RepaymentJournalID", DbType.Int64, 20);
                database.AddOutParameter(DbCommand, "@RepaymentID", DbType.Int64, 20);
                InternalExecuteNonQuery(database, DbCommand, null);

                TransID   = LWTSafeTypes.SafeInt64(database.GetParameterValue(DbCommand, "@RepaymentJournalID"));
                PaymentID = LWTSafeTypes.SafeInt64(database.GetParameterValue(DbCommand, "@RepaymentID"));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #5
0
        public byte[] DownloadStatamentFile(Int64 AccountDocumentTemplateID)
        {
            System.IO.FileStream fs1 = null;
            string fileName          = @"AttachmentFile\AccountStatement";
            string LocalDocPath      = Path.Combine(HostingEnvironment.ApplicationHost.GetPhysicalPath(), fileName);
            string destinationFile   = "";

            try
            {
                loanServ.DAL.AccountDocumentTemplate DAL = new loanServ.DAL.AccountDocumentTemplate();
                DAL.AccountTemplateDocumentID = AccountDocumentTemplateID;

                DataSet dataSet = DAL.GetAccountTemplateDocumentByKey();

                DataTable dataTable = (DataTable)dataSet.Tables[0];

                DataRow dataRow                   = dataTable.Rows[0];
                string  OriginalFilename          = LWTSafeTypes.SafeString(dataRow["OriginalFilename"].ToString());
                string  SystemFilename            = LWTSafeTypes.SafeString(dataRow["SystemFilename"].ToString());
                string  FullSystemFilenamePath    = LWTSafeTypes.SafeString(dataRow["FullSystemFilenamePath"].ToString());
                string  FullPDFSystemFilenamePath = LWTSafeTypes.SafeString(dataRow["FullPDFSystemFilenamePath"].ToString());
                string  ServerFileRootPath        = CommonMethod.GetGlobalSetting("BOTH", "PATH_FILE_ROOT");

                string sourceFile = FullPDFSystemFilenamePath;

                LWT.Common.Files.CreateDirectory(LocalDocPath);

                if (sourceFile == "")
                {
                    sourceFile = FullSystemFilenamePath;
                }

                sourceFile = Path.Combine(ServerFileRootPath, sourceFile);

                string destinationFileName = Path.GetFileName(sourceFile);
                destinationFile = Path.Combine(LocalDocPath, destinationFileName);

                //if (File.Exists(sourceFile))
                //    File.Copy(sourceFile, destinationFile, true);
                //fs1 = System.IO.File.Open(destinationFile, FileMode.Open, FileAccess.Read);
                fs1 = System.IO.File.Open(sourceFile, FileMode.Open, FileAccess.Read);
                byte[] b1 = new byte[fs1.Length];
                fs1.Read(b1, 0, (int)fs1.Length);
                fs1.Close();
                return(b1);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #6
0
 public string GetSecurityDetailByCustomer(string InstallationID, string soapusername, string soappassword, string CustomerID, string FacilityNo, string AccountNo)
 {
     try
     {
         CustomerBiz oBiz      = new CustomerBiz(InstallationID, soapusername, soappassword, CustomerID, FacilityNo, "");
         DataSet     myDataSet = (new FacilityByCustomerDAL()).GetSecurityDetailByCustomer(
             oBiz.InstallationID, oBiz.CustomerID, oBiz.AccountFacilityID.Value);
         return(myDataSet.GetXml());
     }
     catch (Exception ex)
     {
         return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
     }
 }
Пример #7
0
 public override void Initialisation()
 {
     try
     {
         lblClubName.Text = LWTSafeTypes.SafeString(Request.QueryString["ClubName"]);
         ClubID           = LWTSafeTypes.SafeString(Request.QueryString["ClubID"]);
         ReleaseDate      = DateTime.Now;
         Sender           = LWTSafeTypes.SafeString(Request.QueryString["UserID"]);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Пример #8
0
        public string GetCustomerDetails(string InstallationID, string soapusername, string soappassword, string CustomerID)
        {
            try
            {
                CustomerBiz oBiz      = new CustomerBiz(InstallationID, soapusername, soappassword, CustomerID, "", "");
                DataSet     myDataSet = (new FacilityByCustomerDAL()).GetCustomerDetails(oBiz.CustomerID);

                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #9
0
        public string GetSecurityQuestionList(string InstallationID, string soapusername, string soappassword)
        {
            try
            {
                CustomerBiz oBiz = new CustomerBiz(soapusername, soappassword);

                DataSet myDataSet = oBiz.GetSecurityQuestionList(InstallationID);

                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #10
0
        public string ValidateCustomerPortalLogin(string InstallationID, string soapusername, string soappassword,
                                                  string CustomerLogin, string CustomerPassword)
        {
            try
            {
                CustomerBiz oBiz = new CustomerBiz(soapusername, soappassword);

                DataSet myDataSet = oBiz.ValidateCustomerPortalLogin(InstallationID, CustomerLogin, CustomerPassword);

                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #11
0
 public string GetAccountTransactionsByIntroducer(string InstallationID,
                                                  string soapusername, string soappassword,
                                                  string IntroducerID, string FacilityNo, string AccountNo)
 {
     try
     {
         OriginatorBiz oBiz      = new OriginatorBiz(InstallationID, soapusername, soappassword, IntroducerID, FacilityNo, AccountNo);
         DataSet       myDataSet = (new FacilityDAL()).GetAccountTransactionsByIntroducer(
             oBiz.InstallationID, oBiz.LWIntroducerID, oBiz.AccountFacilityID.Value, oBiz.AccountID.Value);
         return(myDataSet.GetXml());
     }
     catch (Exception ex)
     {
         return("<error>" + LWTSafeTypes.SafeXml(ex.ToString()) + "</error>");
     }
 }
Пример #12
0
        public string CustomerAcceptTermsAndConditions(string InstallationID, string soapusername, string soappassword,
                                                       string CustomerID)
        {
            try
            {
                CustomerBiz oBiz = new CustomerBiz(InstallationID, soapusername, soappassword, CustomerID, "", "");

                FacilityByCustomerDAL DAL = new FacilityByCustomerDAL();
                DAL.CustomerAcceptTermsAndConditions(oBiz.InstallationID, oBiz.CustomerID);

                return("");
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #13
0
        public string GetAccountRegularRepaymentListByCustomer(string InstallationID, string soapusername, string soappassword,
                                                               string CustomerID, string FacilityNo, string AccountNo)
        {
            try
            {
                CustomerBiz oBiz = new CustomerBiz(InstallationID, soapusername, soappassword, CustomerID, FacilityNo, AccountNo);

                FacilityByCustomerDAL fdal = new FacilityByCustomerDAL();
                DataSet myDataSet          = fdal.GetAccountRegularRepaymentListByCustomer(
                    oBiz.InstallationID, oBiz.CustomerID, oBiz.AccountFacilityID.Value, oBiz.AccountID.Value);

                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #14
0
        public string GetFacilityAccountListByIntroducer(string InstallationID, string soapusername, string soappassword,
                                                         string IntroducerID, string FacilityNo, string AccountNo, string borrowerFirstName, string borrowerLastName, string companyTrustName,
                                                         string streetNo, string streetName, string suburb, string state, string postcode)
        {
            try
            {
                OriginatorBiz oBiz = new OriginatorBiz(InstallationID, soapusername, soappassword, IntroducerID, FacilityNo, AccountNo);

                DataSet myDataSet = (new FacilityDAL()).GetFacilityAccountListByIntroducer(
                    oBiz.InstallationID, oBiz.LWIntroducerID, oBiz.AccountFacilityID, oBiz.AccountID,
                    borrowerFirstName, borrowerLastName, companyTrustName,
                    streetNo, streetName, suburb, state, postcode);
                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #15
0
        public string GetEmailMobile(string InstallationID, string soapusername, string soappassword, string CustomerID, string CustomerDOB, string AccountFacilityID, string AccountNo)
        {
            try
            {
                DateTime    customerdob;
                CustomerBiz oBiz = new CustomerBiz(InstallationID, soapusername, soappassword, CustomerID, AccountFacilityID, AccountNo);

                //customerdob = Convert.ToDateTime(CustomerDOB);
                customerdob = Convert.ToDateTime(GetFormatDate(CustomerDOB));

                DataSet myDataSet = (new FacilityByCustomerDAL()).GetEmailMobile(oBiz.InstallationID, oBiz.CustomerID, customerdob, oBiz.AccountFacilityID.Value, oBiz.AccountID.Value);

                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #16
0
        public string SubmitChangePassword(string InstallationID, string soapusername, string soappassword, string CustomerID, string OriginPage, string CustomerDOB, string AccountFacilityID, string AccountNo,
                                           string CurrentPassword, string NewPassword, string TranType)
        {
            try
            {
                DateTime    customerdob;
                CustomerBiz oBiz = new CustomerBiz(InstallationID, soapusername, soappassword, CustomerID, AccountFacilityID, AccountNo);

                //customerdob = Convert.ToDateTime(CustomerDOB);
                customerdob = Convert.ToDateTime(GetFormatDate(CustomerDOB));

                DataSet myDataSet = (new FacilityByCustomerDAL()).SubmitChangePassword(oBiz.InstallationID, oBiz.CustomerID, OriginPage, customerdob, oBiz.AccountFacilityID.Value, oBiz.AccountID.Value, CurrentPassword, NewPassword, TranType);

                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #17
0
        public string AccountUpdateDDRByIntroducer(string InstallationID, string soapusername, string soappassword,
                                                   string IntroducerID, string FacilityNo, string AccountNo,
                                                   string DDRBSB, string DDRAccountNumber, string DDRAccountName, string DDRInstitution)
        {
            try
            {
                OriginatorBiz oBiz = new OriginatorBiz(InstallationID, soapusername, soappassword, IntroducerID, FacilityNo, AccountNo);

                FacilityDAL fdal      = new FacilityDAL();
                DataSet     myDataSet = fdal.AccountUpdateDDRByIntroducer(
                    oBiz.InstallationID, oBiz.LWIntroducerID, oBiz.AccountFacilityID.Value,
                    oBiz.AccountID.Value, DDRBSB, DDRAccountNumber, DDRAccountName, DDRInstitution);

                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #18
0
        public string CalculateAccountNewRepaymentByIntroducer(string InstallationID, string soapusername, string soappassword,
                                                               string IntroducerID, string FacilityNo, string AccountNo, string Newrepaymentdate, string NewRepaymentfrequency)
        {
            try
            {
                OriginatorBiz oBiz = new OriginatorBiz(InstallationID, soapusername, soappassword, IntroducerID, FacilityNo, AccountNo);

                DateTime newrepaymentdate = Convert.ToDateTime(Newrepaymentdate);

                FacilityDAL fdal      = new FacilityDAL();
                DataSet     myDataSet = fdal.CalculateAccountNewRepaymentByIntroducer(
                    oBiz.InstallationID, oBiz.LWIntroducerID, oBiz.AccountFacilityID.Value, oBiz.AccountID.Value, newrepaymentdate, NewRepaymentfrequency);

                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #19
0
        public string AccountTransferProcessTransferByIntroducer(string InstallationID, string soapusername, string soappassword,
                                                                 string IntroducerID, string FacilityNo, string FromAccountNo, string ToAccountNo, string TransferAmount)
        {
            try
            {
                OriginatorBiz oBiz           = new OriginatorBiz(InstallationID, soapusername, soappassword, IntroducerID, FacilityNo, FromAccountNo);
                Int64         toAccountNo    = Convert.ToInt64(ToAccountNo);
                Decimal       transferAmount = Convert.ToDecimal(TransferAmount);

                FacilityDAL fdal      = new FacilityDAL();
                DataSet     myDataSet = fdal.AccountTransferProcessTransferByIntroducer(
                    oBiz.InstallationID, oBiz.LWIntroducerID, oBiz.AccountFacilityID.Value,
                    oBiz.AccountID.Value, toAccountNo, transferAmount);

                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #20
0
 public Int64 AccountAdditionalPaymentCancel(Int64 AccountFacilityID, Int64 AccountID, Int64 PaymentID, Int64 CustomerID) //[2][110.2] #1870
 {
     try
     {
         DbCommand DbCommand = database.GetStoredProcCommand("lmsAccountAdditionalPaymentDelete");
         database.AddInParameter(DbCommand, "@InstallationID", DbType.Int32, System.Web.HttpContext.Current.Application["installationid"]);
         database.AddInParameter(DbCommand, "@UserID", DbType.Int64, -2);
         database.AddInParameter(DbCommand, "@AccountFacilityID", DbType.Int64, AccountFacilityID);
         database.AddInParameter(DbCommand, "@AccountID", DbType.Int64, AccountID);
         database.AddInParameter(DbCommand, "@RepaymentID", DbType.Int64, PaymentID);
         database.AddInParameter(DbCommand, "@FootPrintID", DbType.Int64, CustomerID); //[2][110.2] #1870
         database.AddInParameter(DbCommand, "@FootPrintType", DbType.Int64, 1);        //[2][110.2] #1870
         database.AddOutParameter(DbCommand, "@RepaymentJournalID", DbType.Int64, 20);
         InternalExecuteNonQuery(database, DbCommand, null);
         return(LWTSafeTypes.SafeInt64(database.GetParameterValue(DbCommand, "@RepaymentJournalID")));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Пример #21
0
        public string CancelFacilityAccountOnceOffPaymentByIntroducer(string InstallationID, string soapusername, string soappassword,
                                                                      string IntroducerID, string FacilityNo, string AccountNo, string PaymentID)
        {
            try
            {
                OriginatorBiz oBiz = new OriginatorBiz(InstallationID, soapusername, soappassword, IntroducerID, FacilityNo, AccountNo);

                FacilityDAL fdal = new FacilityDAL();
                fdal.CancelFacilityAccountOnceOffPaymentByIntroducer(
                    oBiz.InstallationID, oBiz.LWIntroducerID, oBiz.AccountFacilityID.Value, oBiz.AccountID.Value,
                    Convert.ToInt64(PaymentID));

                DataSet myDataSet = fdal.GetFacilityAccountOnceOffPaymentListByIntroducer(
                    oBiz.InstallationID, oBiz.LWIntroducerID, oBiz.AccountFacilityID.Value, oBiz.AccountID.Value);

                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }
Пример #22
0
        public string GetErrorListSearch()
        {
            DataTable dataTable = null;

            try
            {
                cErrMsg = "";
                StoreDataToDataLayer();
                dataTable = error.GetErrorListSearch();
                if (dataTable.Rows.Count == 1)
                {
                    cErrCode = LWTSafeTypes.SafeString(dataTable.Rows[0]["cErrCode"].ToString());
                    cErrMsg  = LWTSafeTypes.SafeString(dataTable.Rows[0]["cErrMsg"].ToString());
                    cAction  = LWTSafeTypes.SafeString(dataTable.Rows[0]["cAction"].ToString());
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }

            return(cErrMsg);
        }
Пример #23
0
        //[3][107.21] end

        public Int64 ProcessAccountRequestTransfer(Int64 AccountFacilityID, Int64 AccountID, Int64 AccountIDTo, Decimal TransferAmount)
        {
            try
            {
                DbCommand DbCommand = database.GetStoredProcCommand("lmsCustomerPortalProcessRequestTransfer");
                database.AddInParameter(DbCommand, "@InstallationID", DbType.Int32, System.Web.HttpContext.Current.Application["installationid"]);
                database.AddInParameter(DbCommand, "@UserID", DbType.Int64, -2);
                database.AddInParameter(DbCommand, "@AccountFacilityID", DbType.Int64, AccountFacilityID);
                database.AddInParameter(DbCommand, "@AccountID", DbType.Int64, AccountID);
                database.AddInParameter(DbCommand, "@AccountIDTo", DbType.Int64, AccountIDTo);
                database.AddInParameter(DbCommand, "@CreditTransfer", DbType.Int64, TransferAmount);

                database.AddOutParameter(DbCommand, "@TranID", DbType.Int64, 20);

                InternalExecuteNonQuery(database, DbCommand, null);

                return(LWTSafeTypes.SafeInt64(database.GetParameterValue(DbCommand, "@TranID")));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #24
0
        //return  lmsAccountStatementSummary.AccountTemplateDocumentID
        public Int64 GetAccountStatement(Int64 InstallationID, Int64 AccountFacilityID, Int64 AccountNo, Int64 CustomerID,
                                         DateTime StartDate, DateTime EndDate, Int64 AccountTemplateDocumentID)
        {
            try
            {
                DbCommand DbCommand = database.GetStoredProcCommand("lmsAccountStatementGet");
                database.AddInParameter(DbCommand, "@InstallationID", DbType.Int64, InstallationID);
                database.AddInParameter(DbCommand, "@AccountFacilityID", DbType.Int64, AccountFacilityID);
                database.AddInParameter(DbCommand, "@AccountID", DbType.Int64, AccountNo);
                database.AddInParameter(DbCommand, "@CustomerID", DbType.Int64, CustomerID);
                database.AddInParameter(DbCommand, "@InputAccountTemplateDocumentID", DbType.Int64, AccountTemplateDocumentID);
                database.AddInParameter(DbCommand, "@StatementFrom", DbType.DateTime, StartDate);
                database.AddInParameter(DbCommand, "@StatementTo", DbType.DateTime, EndDate);
                database.AddOutParameter(DbCommand, "@AccountTemplateDocumentID", DbType.Int64, 20);
                database.ExecuteNonQuery(DbCommand);

                return(LWTSafeTypes.SafeInt64(database.GetParameterValue(DbCommand, "@AccountTemplateDocumentID")));
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #25
0
        public string SaveRedrawByCustomer(string InstallationID, string soapusername, string soappassword,
                                           string CustomerID, string FacilityNo, string AccountNo, string RedrawtDate, string RedrawAmount)
        {
            try
            {
                CustomerBiz oBiz = new CustomerBiz(InstallationID, soapusername, soappassword, CustomerID, FacilityNo, AccountNo);

                DateTime redrawDate        = Convert.ToDateTime(RedrawtDate);
                Decimal  redrawamount      = Convert.ToDecimal(RedrawAmount);
                FacilityByCustomerDAL fdal = new FacilityByCustomerDAL();
                fdal.SaveFacilityRedrawByCustomer(
                    oBiz.InstallationID, oBiz.CustomerID, oBiz.AccountFacilityID.Value, oBiz.AccountID.Value, redrawDate, redrawamount);

                DataSet myDataSet = fdal.GetFacilityAccountRedrawByCustomer(
                    oBiz.InstallationID, oBiz.CustomerID, oBiz.AccountFacilityID.Value, oBiz.AccountID.Value);

                return(myDataSet.GetXml());
            }
            catch (Exception ex)
            {
                return("<error>" + LWTSafeTypes.SafeXml(ex.Message.ToString()) + "</error>");
            }
        }