public MtCbsinfo ConvertBatchUpdateParameterToMtCbsinfoModel(BatchUpdateModel model)
{
MtCbsinfo aMtCbsinfo = null;
StringBuilderService builder = new StringBuilderService();
var changeBy = builder.ExtractText(Convert.ToString(model.Param), "changeby", "}");
aMtCbsinfo = new MtCbsinfo
{
Mphone = builder.ExtractText(Convert.ToString(model.Param), "mobnum", ","),
Custid = builder.ExtractText(Convert.ToString(model.Param), "custid", ","),
Name = builder.ExtractText(Convert.ToString(model.Param), "name", ","),
Accno = builder.ExtractText(Convert.ToString(model.Param), "accno", ","),
Branch = builder.ExtractText(Convert.ToString(model.Param), "branch", ","),
Class = builder.ExtractText(Convert.ToString(model.Param).ToLower(), "class", ","),
Frozen = builder.ExtractText(Convert.ToString(model.Param), "frozen", ","),
Dorm = builder.ExtractText(Convert.ToString(model.Param), "dorm", ","),
Mobnum = builder.ExtractText(Convert.ToString(model.Param), "mobnum", ","),
Nationid = builder.ExtractText(Convert.ToString(model.Param), "nationid", "}"),
Accstat = builder.ExtractText(Convert.ToString(model.Param), "accstat", ","),
MakeStatus = "A",
EntryBy = changeBy,
MakeBy = changeBy,
CheckStatus = "P"
};
return(aMtCbsinfo);
}
public object SendVeriCodeToEmailAfterChecking([FromBody] ForgotPassReset forgotPassResetModel)
{
try
{
if (emailService.IsCheckExist(forgotPassResetModel))
{
Email objEmail = new Email();
objEmail.EMAIL = forgotPassResetModel.OfficialEmail;
objEmail.TEMPLETE = "1";
//objEmail.DATA1 = "Email Verification Code for OK Wallet Application User";
StringBuilderService stringBuilderService = new StringBuilderService();
int randromNumber = stringBuilderService.RandomNumber(1000, 9999);
string md5Password = stringBuilderService.GenerateMD5Hash(randromNumber.ToString());
objEmail.DATA1 = randromNumber.ToString();
//objEmail.DATA2 = "Your email verification code for OK Wallet Application User is : " + randromNumber.ToString();
emailService.SendVeriCodeToEmail(objEmail);
return(md5Password);
}
else
{
return("");
}
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
public object KycCommission(ReportModel model)
{
try
{
StringBuilderService builder = new StringBuilderService();
string reportName = builder.ExtractText(Convert.ToString(model.ReportOption), "reportName", ",");
string regFromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "regFromDate", ",");
string regToDate = builder.ExtractText(Convert.ToString(model.ReportOption), "regToDate", ",");
string commissionStatus = builder.ExtractText(Convert.ToString(model.ReportOption), "commissionStatus", ",");
string authFromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "authFromDate", ",");
string authToDate = builder.ExtractText(Convert.ToString(model.ReportOption), "authToDate", ",");
string agentNo = builder.ExtractText(Convert.ToString(model.ReportOption), "agentNo", "}");
string distributorNo = builder.ExtractText(Convert.ToString(model.ReportOption), "distributorNo", ",");
string transNo = builder.ExtractText(Convert.ToString(model.ReportOption), "transNo", ",");
ReportViewer reportViewer = new ReportViewer();
List <KycCommission> kycCommissions = new List <KycCommission>();
kycCommissions = service.GetRptkycCommissionsList(reportName, regFromDate, regToDate, commissionStatus, authFromDate, authToDate, distributorNo, agentNo, transNo);
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTKycCom.rdlc");
reportViewer.LocalReport.SetParameters(GenerateParamKycCom(regFromDate, regToDate, reportName));
ReportDataSource A = new ReportDataSource("KycCommission", kycCommissions);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public byte[] LankaBanglaDpsPaymentDetails(ReportModel model)
{
StringBuilderService builder = new StringBuilderService();
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", "}");
List <LankaBangla> dpsDeilsReports = service.GetDpsDetailsInfo(fromDate, toDate);
ReportViewer reportViewer = new ReportViewer();
if (model.FileType == "EXCEL")
{
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPT_Lb_Dps_Dtl_Excel.rdlc"); //Request.RequestUri("");
}
else
{
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPT_Lb_Dps_Dtl.rdlc"); //Request.RequestUri("");
}
reportViewer.LocalReport.SetParameters(GetDpsDetailsInfoRptParameter(fromDate, toDate));
ReportDataSource A = new ReportDataSource("LankaBangla", dpsDeilsReports);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
public object DormantAgent(ReportModel model)
{
try
{
StringBuilderService builder = new StringBuilderService();
string type = builder.ExtractText(Convert.ToString(model.ReportOption), "type", ",");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", "}");
ReportViewer reportViewer = new ReportViewer();
List <DormantAgent> dormantAgentList = new List <DormantAgent>();
dormantAgentList = service.GetDormantAgentList(fromDate, toDate, type);
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTDormantAgent.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(GenerateParamEmerchantSettlementInfo(fromDate, toDate));
ReportDataSource A = new ReportDataSource("DormantAgent", dormantAgentList);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public object MerchantBankInfo(ReportModel model)
{
try
{
StringBuilderService builder = new StringBuilderService();
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string accNo = builder.ExtractText(Convert.ToString(model.ReportOption), "accNo", ",");
string catId = builder.ExtractText(Convert.ToString(model.ReportOption), "catId", "}");
ReportViewer reportViewer = new ReportViewer();
List <MerchantBankInfo> merchantBankInfos = new List <MerchantBankInfo>();
merchantBankInfos = service.MerchantBankInfoReport(fromDate, toDate, accNo, catId);
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTMerchantBankInfo.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(GetReportParameterForChannelBankInfoReport(fromDate, toDate, catId));
ReportDataSource A = new ReportDataSource("MerchantBank", merchantBankInfos);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public List <MtCbsinfo> ConvertBatchUpdateModelToMtCbsinfoModelForCheck(BatchUpdateModel model)
{
MtCbsinfo aMtCbsinfo = null;
StringBuilderService builder = new StringBuilderService();
List <MtCbsinfo> mtCbsinfos = new List <MtCbsinfo>();
var changeBy = model.Param;
foreach (var item in model.List)
{
aMtCbsinfo = new MtCbsinfo
{
Mphone = item.MOBNUM,
Custid = item.CUSTID,
Name = item.NAME,
Accno = item.ACCNO,
Branch = item.BRANCH,
Mobnum = item.MOBNUM,
Nationid = item.NATIONID,
Accstat = item.ACCSTAT,
CheckBy = changeBy,
CheckTime = DateTime.Now,
CheckStatus = item.CHECK_STATUS
};
aMtCbsinfo.MakeStatus = item.MAKE_STATUS == "Active" ? "A" : "I";
aMtCbsinfo.Status = item.STATUS == "Active" ? "A" : "I";
aMtCbsinfo.Frozen = item.FROZEN == "Yes" ? "Y" : "N";
aMtCbsinfo.Dorm = item.DORM == "Yes" ? "A" : "N";
mtCbsinfos.Add(aMtCbsinfo);
}
return(mtCbsinfos);
}
public object CommissionReport(ReportModel model)
{
try
{
StringBuilderService builder = new StringBuilderService();
string mphone = builder.ExtractText(Convert.ToString(model.ReportOption), "mphone", "}");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
ReportViewer reportViewer = new ReportViewer();
List <CommissionReport> commissionReports = new List <CommissionReport>();
commissionReports = service.CommissionReport(mphone, fromDate, toDate);
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTCommssion.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(GetGenerateCommissionReportParameter(fromDate, toDate, mphone));
ReportDataSource A = new ReportDataSource("Commission", commissionReports);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public object SourseWiseRegistration(ReportModel model)
{
try
{
StringBuilderService builder = new StringBuilderService();
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string regStatus = builder.ExtractText(Convert.ToString(model.ReportOption), "regStatus", ",");
string status = builder.ExtractText(Convert.ToString(model.ReportOption), "status", ",");
string regSource = builder.ExtractText(Convert.ToString(model.ReportOption), "regSource", ",");
string branchCode = builder.ExtractText(Convert.ToString(model.ReportOption), "branchCode", "}");
ReportViewer reportViewer = new ReportViewer();
List <SourceWiseRegistration> SourceWiseRegistrationList = new List <SourceWiseRegistration>();
SourceWiseRegistrationList = service.SourceWiseRegistration(fromDate, toDate, regStatus, status, regSource, branchCode);
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTSourceWiseRegistration.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(GetReportParameterForSourceWiseRegistration(fromDate, toDate));
ReportDataSource A = new ReportDataSource("SourceWiseRegistration", SourceWiseRegistrationList);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public object CashBackReport(ReportModel model)
{
try
{
StringBuilderService builder = new StringBuilderService();
string mphone = builder.ExtractText(Convert.ToString(model.ReportOption), "mphone", ",");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string options = builder.ExtractText(Convert.ToString(model.ReportOption), "reportType", ",");
string cbType = builder.ExtractText(Convert.ToString(model.ReportOption), "cbType", "}");
ReportViewer reportViewer = new ReportViewer();
List <CashBackReport> cashBackReports = new List <CashBackReport>();
if (options == "dtl")
{
cashBackReports = service.CashBackDetails(mphone, fromDate, toDate, cbType);
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTCashBackDtl.rdlc"); //Request.RequestUri("");
}
if (options == "sum")
{
cashBackReports = service.CashBackSummaryReport(mphone, fromDate, toDate, cbType);
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTCashBackSum.rdlc"); //Request.RequestUri("");
}
reportViewer.LocalReport.SetParameters(GetGenerateCashBackParameter(fromDate, toDate, cbType));
ReportDataSource A = new ReportDataSource("CashBack", cashBackReports);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
catch (Exception ex)
{
return(ex.ToString());
}
}
public byte[] CustomerRegistration(ReportModel model)
{
StringBuilderService builder = new StringBuilderService();
string mphone = builder.ExtractText(Convert.ToString(model.ReportOption), "mphone", ",");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string agentNo = builder.ExtractText(Convert.ToString(model.ReportOption), "agentNo", "}");
if (!string.IsNullOrEmpty(agentNo))
{
var agentInfo = (Reginfo)kycService.GetClientInfoByMphone(agentNo);
if (agentInfo.Pmphone != mphone)
{
return(null);
}
}
List <CustomerRegDistPort> customerRegDistPorts = service.CustomerRegistration(mphone, fromDate, toDate, agentNo);
ReportViewer reportViewer = new ReportViewer();
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTDist_CustReg.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(CustomerRegistrationRptParameter(mphone, fromDate, toDate, agentNo));
ReportDataSource A = new ReportDataSource("CustomerRegDistPort", customerRegDistPorts);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
public byte[] EmsReport(ReportModel model)
{
StringBuilderService builder = new StringBuilderService();
string transNo = builder.ExtractText(Convert.ToString(model.ReportOption), "transNo", ",");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string studentId = builder.ExtractText(Convert.ToString(model.ReportOption), "studentId", ",");
string branchCode = builder.ExtractText(Convert.ToString(model.ReportOption), "branchCode", "}");
string schoolId = builder.ExtractText(Convert.ToString(model.ReportOption), "schoolId", ",");
string dateType = builder.ExtractText(Convert.ToString(model.ReportOption), "dateType", ",");
List <EmsReport> emsReports = emsService.GetEmsReport(fromDate, toDate, transNo, studentId, schoolId, branchCode, dateType);
ReportViewer reportViewer = new ReportViewer();
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTEmsInfo.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(GetEmsRptParameter(fromDate, toDate, transNo, studentId, schoolId));
ReportDataSource A = new ReportDataSource("EmsReport", emsReports);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
public GenerateScriptModule(MssqlDbService mssqlDbService, PgDbService pgDbService, StringBuilderService stringBuilderService, IOptions <TableOptions> tableOptions, IOptions <MssqlConnectOptions> mssqlConnectOptions)
{
_mssqlDbService = mssqlDbService;
_pgDbService = pgDbService;
_stringBuilderService = stringBuilderService;
_mssqlConnectOptions = mssqlConnectOptions.Value;
_tableOptions = tableOptions.Value;
}
public object GetMd5Password(string verificationCode)
{
try
{
StringBuilderService stringBuilderService = new StringBuilderService();
string md5Password = stringBuilderService.GenerateMD5Hash(verificationCode);
return(md5Password);
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
private object ChangePassword(DisbursementUser userDetails, ChangePasswordModel model)
{
try
{
StringBuilderService stringBuilderService = new StringBuilderService();
userDetails.Md5Password = stringBuilderService.GenerateMD5Hash(model.NewPassword);
userDetails.Sha1Password = stringBuilderService.GenerateSha1Hash(model.NewPassword);
userDetails.SecurityStamp = Guid.NewGuid().ToString();
userDetails.Pstatus = "Y";
return(Save(userDetails));
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
public object BranchWiseCount(ReportModel model)
{
try
{
StringBuilderService builder = new StringBuilderService();
string branchCode = builder.ExtractText(Convert.ToString(model.ReportOption), "branchCode", ",");
string userId = builder.ExtractText(Convert.ToString(model.ReportOption), "userId", ",");
string option = builder.ExtractText(Convert.ToString(model.ReportOption), "option", ",");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", "}");
if (branchCode == "null")
{
branchCode = null;
}
if (userId == "null")
{
userId = null;
}
if (fromDate == "null")
{
fromDate = DateTime.Now.AddYears(-99).ToString("yyyy/MM/dd");
}
if (toDate == "null")
{
toDate = DateTime.Now.ToString("yyyy/MM/dd");
}
ReportViewer reportViewer = new ReportViewer();
List <BranchWiseCount> BranchWiseCountList = new List <BranchWiseCount>();
BranchWiseCountList = service.BranchWiseCount(branchCode, userId, option, fromDate, toDate);
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTBranchWiseCount.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(GetReportParameterForSourceWiseRegistration(fromDate, toDate));
ReportDataSource A = new ReportDataSource("BranchWiseCount", BranchWiseCountList);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
catch (Exception ex)
{
return(ex.ToString());
}
}
// private bool validatePassword(DisbursementUser userDetails, ChangePasswordModel model)
private string validatePassword(DisbursementUser userDetails, ChangePasswordModel model)
{
try
{
StringBuilderService stringBuilderService = new StringBuilderService();
if (userDetails.Sha1Password == stringBuilderService.GenerateSha1Hash(model.OldPassword))
{
//add more validation
PasswordPolicy objPasswordPolicy = disbursementUserService.GetPasswordPolicy();
if (model.NewPassword.Length < objPasswordPolicy.PassMinLength)
{
return("Password can't less than " + objPasswordPolicy.PassMinLength.ToString() + " characters");
}
else if (model.NewPassword.Length > objPasswordPolicy.PassMaxLength)
{
return("Password can't more than " + objPasswordPolicy.PassMaxLength.ToString() + " characters");
}
else if (objPasswordPolicy.PassAlphaLower == "Y" && !model.NewPassword.Any(char.IsLower))
{
return("Password must contain a lower case letter");
}
else if (objPasswordPolicy.PassAlphaUpper == "Y" && !model.NewPassword.Any(char.IsUpper))
{
return("Password must contain a upper case letter");
}
else if (objPasswordPolicy.PassNumber == "Y" && !model.NewPassword.Any(char.IsDigit))
{
return("Password must contain a digit");
}
else if (objPasswordPolicy.PassSpecialChar == "Y" && !model.NewPassword.Any(ch => !char.IsLetterOrDigit(ch)))
{
return("Password must contain a special character");
}
return("Valid");
}
return("Invalid");
}
catch (Exception ex)
{
errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString());
throw;
}
}
private MerchantUser generateSecuredCredentials(MerchantUser model)
{
try
{
StringBuilderService stringBuilderService = new StringBuilderService();
model.PlainPassword = model.PlainPassword;
model.Md5Password = stringBuilderService.GenerateMD5Hash(model.PlainPassword);
model.Sha1Password = stringBuilderService.GenerateSha1Hash(model.PlainPassword);
model.SecurityStamp = Guid.NewGuid().ToString();
return(model);
}
catch (Exception ex)
{
errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString());
throw;
}
}
public byte[] GetAgentDsrListByPmphone(ReportModel model)
{
StringBuilderService builder = new StringBuilderService();
string mphone = builder.ExtractText(Convert.ToString(model.ReportOption), "mphone", "}");
List <AgentDsrList> registrationReports = service.GetAgentDsrListByPmphone(mphone);
ReportViewer reportViewer = new ReportViewer();
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTAgentDsr.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(GetAgentDsrListByPmphoneRptParameter(mphone));
ReportDataSource A = new ReportDataSource("AgentDsrList", registrationReports);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
private bool validatePasswordForClient(MerchantUser userDetails, ChangePasswordModel model)
{
try
{
StringBuilderService stringBuilderService = new StringBuilderService();
if (userDetails.Sha1Password == stringBuilderService.GenerateSha1Hash(model.OldPassword))
{
return(true);
}
return(false);
}
catch (Exception ex)
{
errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString());
throw;
}
}
public object OutletSumTransReportByTranDate(ReportModel model)
{
try
{
StringBuilderService builder = new StringBuilderService();
string mphone = builder.ExtractText(Convert.ToString(model.ReportOption), "mphone", ",");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string dateType = builder.ExtractText(Convert.ToString(model.ReportOption), "dateType", "}");
var clientInfo = (Reginfo)kycService.GetClientInfoByMphone(mphone);
if (clientInfo.CatId != "M")
{
return("NOTM");
}
double totalTransAmt = 0;
double totalTransCount = 0;
List <MerchantTransactionSummary> merchantTransactionList = new List <MerchantTransactionSummary>();
merchantTransactionList = childMerchantService.ChainMerTransSummReportByTd(mphone, fromDate, toDate).ToList();
if (merchantTransactionList.Count() > 0)
{
totalTransCount = merchantTransactionList.Count();
totalTransAmt = merchantTransactionList.Sum(x => x.TransAmt);
}
ReportViewer reportViewer = new ReportViewer();
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTChainMerTranSumByTd.rdlc");
reportViewer.LocalReport.SetParameters(GetReportParameterMerchantSummary(mphone, fromDate, toDate, merchantTransactionList.Count() > 1 ? merchantTransactionList[1].MerchantCode : null, merchantTransactionList.Count() > 1 ? merchantTransactionList[1].MerchantName : null, totalTransCount, totalTransAmt));
ReportDataSource A = new ReportDataSource("MerchantTransferSummary", merchantTransactionList);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
catch (Exception ex)
{
throw;
}
}
public object RegistrationReportSummary(ReportModel model)
{
StringBuilderService builder = new StringBuilderService();
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string options = builder.ExtractText(Convert.ToString(model.ReportOption), "options", "}");
List <RegistrationSummary> registrationReports = service.GetRegistrationReportSummary(fromDate, toDate, options);
ReportViewer reportViewer = new ReportViewer();
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTRegistrationSummary.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(GetRegistrationRptParameter(fromDate, toDate, options));
ReportDataSource A = new ReportDataSource("RegistrationSummary", registrationReports);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
public object SendVeriCodeToEmail(string toEmailId)
{
try
{
Email objEmail = new Email();
objEmail.EMAIL = toEmailId;
objEmail.TEMPLETE = "1";
//objEmail.DATA1 = "Email verification code";
StringBuilderService stringBuilderService = new StringBuilderService();
int randromNumber = stringBuilderService.RandomNumber(1000, 9999);
string md5Password = stringBuilderService.GenerateMD5Hash(randromNumber.ToString());
objEmail.DATA1 = randromNumber.ToString();
//objEmail.DATA2 = "Your email verification code: " + randromNumber.ToString();
emailService.SendVeriCodeToEmail(objEmail);
return(md5Password);
}
catch (Exception ex)
{
return(errorLogService.InsertToErrorLog(ex, MethodBase.GetCurrentMethod().Name, Request.Headers["UserInfo"].ToString()));
}
}
public object KycBalance(ReportModel model)
{
StringBuilderService builder = new StringBuilderService();
string regStatus = builder.ExtractText(Convert.ToString(model.ReportOption), "regStatus", "}");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string accNo = builder.ExtractText(Convert.ToString(model.ReportOption), "accNo", ",");
string options = builder.ExtractText(Convert.ToString(model.ReportOption), "options", ",");
string accCategory = builder.ExtractText(Convert.ToString(model.ReportOption), "accCategory", ",");
List <KycBalance> kycBalances = service.GetKycBalance(regStatus, fromDate, toDate, accNo, options, accCategory);
ReportViewer reportViewer = new ReportViewer();
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTKycBalance.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(GetKycBalanceRptParameter(regStatus, fromDate, toDate, accNo, options, accCategory));
ReportDataSource A = new ReportDataSource("KycBalance", kycBalances);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
public object AgentInformation(ReportModel model)
{
StringBuilderService builder = new StringBuilderService();
string accCategorySub = builder.ExtractText(Convert.ToString(model.ReportOption), "subAccCategory", ",");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string options = builder.ExtractText(Convert.ToString(model.ReportOption), "options", ",");
string accCategory = builder.ExtractText(Convert.ToString(model.ReportOption), "accCategory", "}");
List <AgentInformation> registrationReports = service.GetAgentInfo(fromDate, toDate, options, accCategory, accCategorySub);
ReportViewer reportViewer = new ReportViewer();
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTAgentInformation.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(GetKycInformationRptParameter(fromDate, toDate, options, accCategory));
ReportDataSource A = new ReportDataSource("AgentInformation", registrationReports);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
public object DailySumReport(ReportModel model)
{
try
{
StringBuilderService builder = new StringBuilderService();
string mphone = builder.ExtractText(Convert.ToString(model.ReportOption), "mphone", ",");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string dateType = builder.ExtractText(Convert.ToString(model.ReportOption), "dateType", "}");
//var clientInfo = (Reginfo)kycService.GetClientInfoByMphone(mphone);
var childMerchantCode = chainMerchantService.GetChainMerchantCodeByMphone(mphone);
List <OutletDailySummaryTransaction> merchantTransactionList = new List <OutletDailySummaryTransaction>();
merchantTransactionList = childMerchantService.ChildMerDailySumReport(mphone, childMerchantCode, fromDate, toDate, dateType).ToList();
string merchantName = merchantTransactionList[0].OutletName;
string merchantCode = merchantTransactionList[0].OutletId;
ReportViewer reportViewer = new ReportViewer();
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTChildOutletDailySummaryTrans.rdlc");
reportViewer.LocalReport.SetParameters(GetReportParameterDailySumReport(mphone, fromDate, toDate, merchantName, merchantCode));
ReportDataSource A = new ReportDataSource("OutletDailyTransaction", merchantTransactionList);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
catch (Exception ex)
{
throw;
}
}
public List <MtCbsinfo> ConvertBatchUpdateModelToMtCbsinfoModel(BatchUpdateModel model)
{
MtCbsinfo aMtCbsinfo = null;
StringBuilderService builder = new StringBuilderService();
List <MtCbsinfo> mtCbsinfos = new List <MtCbsinfo>();
var changeBy = builder.ExtractText(Convert.ToString(model.Param), "changeby", "}");
var ubranch = builder.ExtractText(Convert.ToString(model.Param), "ubranch", ",");
foreach (var item in model.List)
{
aMtCbsinfo = new MtCbsinfo
{
Mphone = item.mobnum,
Custid = item.custid,
Name = item.name,
Accno = item.accno,
Branch = item.branch,
Class = builder.ExtractText(Convert.ToString(item), "class", ","),
Frozen = item.frozen,
Dorm = item.dorm,
Mobnum = item.mobnum,
Nationid = item.nationid,
Accstat = item.accstat,
EntryBy = changeBy,
MakeBy = changeBy,
Ubranch = ubranch,
CheckStatus = "P"
};
if (item.status != null)
{
aMtCbsinfo.Status = item.status;
}
aMtCbsinfo.MakeStatus = item.make_status_dump == 1 ? "A" : "I";
mtCbsinfos.Add(aMtCbsinfo);
}
return(mtCbsinfos);
}
public byte[] AuditTrailReport(ReportModel model)
{
StringBuilderService builder = new StringBuilderService();
string branchCode = builder.ExtractText(Convert.ToString(model.ReportOption), "branchCode", ",");
string user = builder.ExtractText(Convert.ToString(model.ReportOption), "user", ",");
string parentMenu = builder.ExtractText(Convert.ToString(model.ReportOption), "parentMenu", ",");
string action = builder.ExtractText(Convert.ToString(model.ReportOption), "action", ",");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string auditId = builder.ExtractText(Convert.ToString(model.ReportOption), "auditId", "}");
List <AuditTrailReport> auditTrailReports = reportShareService.GetAuditTrailReport(branchCode, user, parentMenu, action, fromDate, toDate, auditId);
ReportViewer reportViewer = new ReportViewer();
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTAuditTrail.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(GetAuditTrailReportParameter(branchCode, user, parentMenu, action, fromDate, toDate, auditId));
ReportDataSource A = new ReportDataSource("AuditTrail", auditTrailReports);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
public byte[] ApplicationUserReport(ReportModel model)
{
StringBuilderService builder = new StringBuilderService();
string branchCode = builder.ExtractText(Convert.ToString(model.ReportOption), "branchCode", ",");
string userName = builder.ExtractText(Convert.ToString(model.ReportOption), "userName", ",");
string name = builder.ExtractText(Convert.ToString(model.ReportOption), "name", ",");
string mobileNo = builder.ExtractText(Convert.ToString(model.ReportOption), "mobileNo", ",");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string roleName = builder.ExtractText(Convert.ToString(model.ReportOption), "roleName", "}");
List <ApplicationUserReport> applicationUserReports = reportShareService.GetApplicationUserReports(branchCode, userName, name, mobileNo, fromDate, toDate, roleName);
ReportViewer reportViewer = new ReportViewer();
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTApplicationUser.rdlc"); //Request.RequestUri("");
reportViewer.LocalReport.SetParameters(GetApplicationUserRptParameter(branchCode, userName, name, mobileNo, fromDate, toDate, roleName));
ReportDataSource A = new ReportDataSource("ApplicationUserReport", applicationUserReports);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
public object OutletDetailsTransReport(ReportModel model)
{
try
{
StringBuilderService builder = new StringBuilderService();
string mphone = builder.ExtractText(Convert.ToString(model.ReportOption), "mphone", ",");
string fromDate = builder.ExtractText(Convert.ToString(model.ReportOption), "fromDate", ",");
string toDate = builder.ExtractText(Convert.ToString(model.ReportOption), "toDate", ",");
string dateType = builder.ExtractText(Convert.ToString(model.ReportOption), "dateType", "}");
var clientInfo = (Reginfo)kycService.GetClientInfoByMphone(mphone);
if (clientInfo.CatId != "M")
{
return("NOTM");
}
List <ChildMerchantTransaction> merchantTransactionList = new List <ChildMerchantTransaction>();
merchantTransactionList = childMerchantService.GetChildMerchantTransactionReport(mphone, fromDate, toDate).ToList();
ReportViewer reportViewer = new ReportViewer();
reportViewer.LocalReport.ReportPath = HostingEnvironment.MapPath("~/Reports/RDLC/RPTChildMerchantTransaction.rdlc");
reportViewer.LocalReport.SetParameters(GetReportParameterChildMerchant(mphone, fromDate, toDate, merchantTransactionList.Count() > 1 ? merchantTransactionList[1].MerchantName : null, merchantTransactionList.Count() > 1 ? merchantTransactionList[1].MerchantCode : null));
ReportDataSource A = new ReportDataSource("ChildMerchantTransaction", merchantTransactionList);
reportViewer.LocalReport.DataSources.Add(A);
ReportUtility reportUtility = new ReportUtility();
MFSFileManager fileManager = new MFSFileManager();
return(reportUtility.GenerateReport(reportViewer, model.FileType));
}
catch (Exception ex)
{
throw;
}
}
