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>"); } }
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>"); } }
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>"); } }
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; } }
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; } }
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>"); } }
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; } }
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>"); } }
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>"); } }
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>"); } }
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>"); } }
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>"); } }
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>"); } }
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>"); } }
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>"); } }
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>"); } }
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>"); } }
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>"); } }
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>"); } }
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; } }
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>"); } }
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); }
//[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; } }
//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; } }
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>"); } }