public async Task <IActionResult> GetReportDetail(int reportId)
{
//// GET REPORT WITH KEY, IF KEY NOT EXIST RETURN STATUS 404
var report = await _context.Reports.FindAsync(reportId);
if (report == null)
{
return(NotFound(new ApiNotFoundResponse($"Cannot found report with key {reportId}")));
}
var user = await _context.Users.FindAsync(report.ReportUserId);
//// GIVE INFORMATIONS TO ReportVm (JUST SHOW FIELD NEEDED
var reportVm = new ReportVm()
{
Id = report.Id,
Content = report.Content,
CreateDate = report.CreateDate,
KnowledgeBaseId = report.KnowledgeBaseId,
LastModifiedDate = report.LastModifiedDate,
IsProcessed = report.IsProcessed,
ReportUserId = report.ReportUserId,
ReportUserName = user.FirstName + " " + user.LastName
};
return(Ok(reportVm));
}
public ServiceResult <List <ReportVm> > GetReport()
{
var Persons = _repository.Person.GetAll();
var result = new List <ReportVm>();
foreach (var person in Persons)
{
var relations = person.Relations;
if (person.Relation != null)
{
relations.Add(person.Relation);
}
var personRelations = relations.GroupBy(x => x.RelationType).Select(g => new { name = g.Key, count = g.Count() }).ToList();
foreach (var rel in personRelations)
{
var reportVm = new ReportVm
{
PersonFullName = $"{person.FirstName} {person.LastName}",
RelationType = rel.name,
Count = rel.count
};
result.Add(reportVm);
}
}
return(new ServiceResult <List <ReportVm> >
{
Status = ServiceResultStatus.Success,
Result = result
});
}
internal IncomeVm GetIncomeVmByReportVm(ReportVm reportVm)
{
decimal totalIncome = 0;
decimal totalSales = 0;
decimal totalPurchase = 0;
List <Sale> sales = _reportDal.GetSalesByReportVm(reportVm);
List <Purchase> purchase = _reportDal.GetPurchasesByReportVm(reportVm);
if (sales != null)
{
foreach (var item in sales)
{
totalSales = totalSales + item.Total;
}
}
if (purchase != null)
{
foreach (var item in purchase)
{
totalPurchase = totalPurchase + item.Total;
}
}
totalIncome = totalSales - totalPurchase;
IncomeVm incomeVm = new IncomeVm();
incomeVm.Sales = sales;
incomeVm.Purchases = purchase;
incomeVm.SalesTotal = totalSales;
incomeVm.PurchasesTotal = totalPurchase;
incomeVm.TotalIncome = totalIncome;
return(incomeVm);
}
public static ReportContainerVm GetContainer(ReportRequestVm _reportRequestVm, IPartnerServiceIntegration _partnerIntegration, IDlsIntegration _dlsIntegration)
{
var reportContainer = ReportContainerHelper.GetStagedContainer(ReportType.DailyTranDetail, _partnerIntegration, _reportRequestVm);
//DomainTranformation
var userReportRequest = _reportRequestVm.ToUserReportsRequestModel();
var userReport = new ReportVm(BusinessReportsConstants.Common.USER_REPORT_NAME);
var userReportResponseList = _partnerIntegration.GetUserReportsInfo(userReportRequest);
foreach (UserReportsInfoResponse userReportsResponse in userReportResponseList.UserReportsInfoList)
{
var row = new Dictionary <string, string>();
row.Add(BusinessReportsConstants.UserDetails.ACTIVE_USER_FLAG, string.IsNullOrEmpty(userReportsResponse.ActiveUserFlag) ? string.Empty : userReportsResponse.ActiveUserFlag);
row.Add(BusinessReportsConstants.UserDetails.ACTIVITY_TYPE, string.IsNullOrEmpty(userReportsResponse.ActivityType) ? string.Empty : userReportsResponse.ActivityType);
row.Add(BusinessReportsConstants.UserDetails.AGENT_ID, Convert.ToString(userReportsResponse.AgentId));
row.Add(BusinessReportsConstants.UserDetails.AGENT_NAME, string.IsNullOrEmpty(userReportsResponse.AgentName) ? string.Empty : userReportsResponse.AgentName);
row.Add(BusinessReportsConstants.UserDetails.DEVICE_NAME, string.IsNullOrEmpty(userReportsResponse.DeviceName) ? string.Empty : userReportsResponse.DeviceName);
row.Add(BusinessReportsConstants.UserDetails.EDIR_GUID, string.IsNullOrEmpty(userReportsResponse.EdirGuid) ? string.Empty : userReportsResponse.EdirGuid);
row.Add(BusinessReportsConstants.UserDetails.FIRST_NAME, string.IsNullOrEmpty(userReportsResponse.FirstName) ? string.Empty : userReportsResponse.FirstName);
row.Add(BusinessReportsConstants.UserDetails.LAST_LOGON_LCL_DATE, (userReportsResponse.LastLogonLclDate == null) ? string.Empty : userReportsResponse.LastLogonLclDate.ToString("yyyy MMM dd"));
row.Add(BusinessReportsConstants.UserDetails.LAST_NAME, string.IsNullOrEmpty(userReportsResponse.LastName) ? string.Empty : userReportsResponse.LastName);
row.Add(BusinessReportsConstants.UserDetails.LDAP_USER_ID, string.IsNullOrEmpty(userReportsResponse.LdapUserId) ? string.Empty : userReportsResponse.LdapUserId);
row.Add(BusinessReportsConstants.UserDetails.POS_NUMBER, userReportsResponse.PosNumber.ToString());
userReport.Rows.Add(row);
}
reportContainer.Reports.Add(userReport);
return(reportContainer);
}
internal IncomeVm GetIncomeVmByReportVm(ReportVm reportVm)
{
decimal TotalIncome = 0;
decimal TotalSales = 0;
decimal TotalPurchase = 0;
List <Sale> Sales = reportDal.GetSalesByReportVm(reportVm);
List <Purchase> Purchase = reportDal.GetPurchasesByReportVm(reportVm);
if (Sales != null)
{
foreach (var item in Sales)
{
TotalSales = TotalSales + item.Total;
}
}
if (Purchase != null)
{
foreach (var item in Purchase)
{
TotalPurchase = TotalPurchase + item.Total;
}
}
TotalIncome = TotalSales - TotalPurchase;
IncomeVm incomeVm = new IncomeVm();
incomeVm.Sales = Sales;
incomeVm.Purchases = Purchase;
incomeVm.SalesTotal = TotalSales;
incomeVm.PurchasesTotal = TotalPurchase;
incomeVm.TotalIncome = TotalIncome;
return(incomeVm);
}
internal List <StockVm> GetStockReportList(ReportVm reportVm)
{
List <Sale> Sales = reportDal.GetSalesByReportVm(reportVm);
List <Purchase> Purchases = reportDal.GetPurchasesByReportVm(reportVm);
if (Purchases != null)
{
foreach (var item in Purchases)
{
foreach (var itemDes in item.PurchaseDetail)
{
StockVm stockVm = new StockVm();
if (StockReportList.Any(m => m.ItemName == itemDes.Item.Name) == false)
{
stockVm.ItemName = itemDes.Item.Name;
stockVm.StockQuantity = common.GetItemStockById(itemDes.Item.Id);
stockVm.CategoryFullPath = GetCategoryFullPathById(itemDes.Item.Id);
stockVm.Price = itemDes.Item.CostPrice;
StockReportList.Add(stockVm);
}
}
}
}
return(StockReportList.ToList());
}
public ActionResult IncomeReport(ReportVm reportVm)
{
IncomeVm incomeVm = reportBll.GetIncomeVmByReportVm(reportVm);
incomeVmForPdf = incomeVm;
ViewBag.OutletId = reportBll.GetOutlet();
return(View(incomeVm));
}
public ActionResult StockReport(ReportVm reportVm)
{
List <StockVm> StockReportList = reportBll.GetStockReportList(reportVm);
StockReportListPdf = StockReportList;
ViewBag.OutletId = reportBll.GetOutlet();
return(View(StockReportList));
}
public ActionResult Expense(ReportVm reportVm)
{
List <Expense> Expenses = reportBll.GetExpensesByReportVm(reportVm);
ExpensesPdf = Expenses;
ViewBag.OutletId = reportBll.GetOutlet();
return(View(Expenses));
}
public ActionResult PurchaseReport(ReportVm reportVm)
{
List <Purchase> Purchases = reportBll.GetPurchasesByReportVm(reportVm);
PurchasesPdf = Purchases;
ViewBag.OutletId = reportBll.GetOutlet();
return(View(Purchases));
}
public ActionResult SalesReport(ReportVm reportVm)
{
List <Sale> Sales = reportBll.GetSalesByReportVm(reportVm);
SalesPdf = Sales;
ViewBag.OutletId = reportBll.GetOutlet();
return(View(Sales));
}
public ViewResult Index()
{
CurrentPage = PageTypes.Report;
var model = new ReportVm();
model.RefreshCandidates();
return(View(model));
}
public IActionResult Add([FromBody] ReportVm reportVm)
{
try
{
var report = Mapper.Map <Report>(reportVm);
_unitOfWork.Reports.Add(report);
return(Ok());
}
catch (Exception ex)
{
Guid errorId = Guid.NewGuid();
_logger.LogError("Error #{0}", errorId);
_logger.LogError(ex.ToString());
return(StatusCode((int)HttpStatusCode.BadRequest, errorId));
}
}
public static ReportContainerVm GetContainer(ReportRequestVm _reportRequestVm, IPartnerServiceIntegration _partnerIntegration, IDlsIntegration _dlsIntegration)
{
var reportContainer = ReportContainerHelper.GetStagedContainer(ReportType.DailyTranDetail, _partnerIntegration, _reportRequestVm);
//DomainTranformation
var tranExceedRequest = _reportRequestVm.ToTransactionExceedRequestModel();
var transactionExceedReport = new ReportVm(BusinessReportsConstants.Common.TRANEXCEED_REPORT_NAME);
//Call repo
var transactionExceedInfoResponse = _partnerIntegration.GetTransactionExceedInfo(tranExceedRequest);
foreach (TransactionExceedReportsInfo item in transactionExceedInfoResponse.transactionExceedReportsInfoList)
{
var row = new Dictionary <string, string>();
row.Add(BusinessReportsConstants.TransactionExceedDetails.AGENT_ID, Convert.ToString(item.AgentId));
row.Add(BusinessReportsConstants.TransactionExceedDetails.AGENT_NAME, string.IsNullOrEmpty(item.AgentName) ? string.Empty : item.AgentName);
row.Add(BusinessReportsConstants.TransactionExceedDetails.CITY, string.IsNullOrEmpty(item.City) ? string.Empty : item.City);
row.Add(BusinessReportsConstants.TransactionExceedDetails.POS_ID, string.IsNullOrEmpty(item.PosId) ? string.Empty : item.PosId);
row.Add(BusinessReportsConstants.TransactionExceedDetails.FIRST_NAME, string.IsNullOrEmpty(item.FirstName) ? string.Empty : item.FirstName);
row.Add(BusinessReportsConstants.TransactionExceedDetails.LAST_NAME, string.IsNullOrEmpty(item.LastName) ? string.Empty : item.LastName);
row.Add(BusinessReportsConstants.TransactionExceedDetails.LDAP_USER_ID, string.IsNullOrEmpty(item.LdapUserId) ? string.Empty : item.LdapUserId);
row.Add(BusinessReportsConstants.TransactionExceedDetails.EVENT_TRAN_CODE, string.IsNullOrEmpty(item.EventTranCode) ? string.Empty : item.EventTranCode);
row.Add(BusinessReportsConstants.TransactionExceedDetails.EVENT_TRAN_NAME, string.IsNullOrEmpty(item.EventTranName) ? string.Empty : item.EventTranName);
row.Add(BusinessReportsConstants.TransactionExceedDetails.TRAN_REF_ID, string.IsNullOrEmpty(item.TranRefId) ? string.Empty : item.TranRefId);
row.Add(BusinessReportsConstants.TransactionExceedDetails.TRAN_LIM_CODE, Convert.ToString(item.TranLimCode));
row.Add(BusinessReportsConstants.TransactionExceedDetails.TRAN_LIM_BSNS_DESC, string.IsNullOrEmpty(item.TranLimBsnsDesc) ? string.Empty : item.TranLimBsnsDesc);
row.Add(BusinessReportsConstants.TransactionExceedDetails.EVENT_FACE_TRAN_AMT, Convert.ToString(item.EventFaceTranAmt));
row.Add(BusinessReportsConstants.TransactionExceedDetails.TRAN_LIM_USD_AMT, Convert.ToString(item.TranLimUsdAmt));
row.Add(BusinessReportsConstants.TransactionExceedDetails.MGR_FIRST_NAME, string.IsNullOrEmpty(item.MgrFirstName) ? string.Empty : item.MgrFirstName);
row.Add(BusinessReportsConstants.TransactionExceedDetails.MGR_LAST_NAME, string.IsNullOrEmpty(item.MgrLastName) ? string.Empty : item.MgrLastName);
row.Add(BusinessReportsConstants.TransactionExceedDetails.MGR_LDAP_USER_ID, string.IsNullOrEmpty(item.MgrLdapUserId) ? string.Empty : item.MgrLdapUserId);
row.Add(BusinessReportsConstants.TransactionExceedDetails.EVENT_TRAN_EVENT_DATE, (item.EventTranEvntDate == null) ? string.Empty : item.EventTranEvntDate.ToString("yyyy MMM dd"));
row.Add(BusinessReportsConstants.TransactionExceedDetails.EVENT_TRAN_EVENT_LCL_DATE_FIELD, (item.EventTranEvntLclDateField == null) ? string.Empty : item.EventTranEvntLclDateField.ToString("yyyy MMM dd"));
transactionExceedReport.Rows.Add(row);
}
reportContainer.Reports.Add(transactionExceedReport);
return(reportContainer);
}
internal List <Purchase> GetPurchasesByReportVm(ReportVm reportVm)
{
var purchases = _db.Purchases.AsQueryable();
if (reportVm.OutletId != null)
{
purchases = purchases.Where(m => m.OutletId == reportVm.OutletId && m.IsDeleted == false).AsQueryable();
}
if (reportVm.Code != null)
{
purchases = purchases.Where(m => m.Id == reportVm.Code && m.IsDeleted == false).AsQueryable();
}
if (reportVm.FromDate != null)
{
purchases = purchases.Where(m => m.PurchaseDate >= reportVm.FromDate && m.IsDeleted == false).AsQueryable();
}
if (reportVm.ToDate != null)
{
purchases = purchases.Where(m => m.PurchaseDate <= reportVm.ToDate && m.IsDeleted == false).AsQueryable();
}
return(purchases.ToList());
}
public async Task <IActionResult> GetReportDetail(int reportId)
{
var report = await _context.Reports.FindAsync(reportId);
if (report == null)
{
return(NotFound());
}
var reportVm = new ReportVm()
{
Id = report.Id,
Content = report.Content,
CreateDate = report.CreateDate,
KnowledgeBaseId = report.KnowledgeBaseId,
LastModifiedDate = report.LastModifiedDate,
IsProcessed = report.IsProcessed,
ReportUserId = report.ReportUserId
};
return(Ok(reportVm));
}
internal List <Sale> GetSalesByReportVm(ReportVm reportVm)
{
var sales = _db.Sales.AsQueryable();
if (reportVm.OutletId != null)
{
sales = sales.Where(m => m.OutletId == reportVm.OutletId && m.IsDeleted == false).AsQueryable();
}
if (reportVm.Code != null)
{
sales = sales.Where(m => m.Id == reportVm.Code && m.IsDeleted == false).AsQueryable();
}
if (reportVm.FromDate != null)
{
sales = sales.Where(m => m.SaleDate >= reportVm.FromDate && m.IsDeleted == false).AsQueryable();
}
if (reportVm.ToDate != null)
{
sales = sales.Where(m => m.SaleDate <= reportVm.ToDate && m.IsDeleted == false).AsQueryable();
}
return(sales.ToList());
}
internal List <Expense> GetExpensesByReportVm(ReportVm reportVm)
{
var expenses = _db.Expenses.AsQueryable();
if (reportVm.OutletId != null)
{
expenses = expenses.Where(m => m.OutletId == reportVm.OutletId && m.IsDeleted == false).AsQueryable();
}
if (reportVm.Code != null)
{
expenses = expenses.Where(m => m.Id == reportVm.Code && m.IsDeleted == false).AsQueryable();
}
if (reportVm.FromDate != null)
{
expenses = expenses.Where(m => m.ExpenseDate >= reportVm.FromDate && m.IsDeleted == false).AsQueryable();
}
if (reportVm.ToDate != null)
{
expenses = expenses.Where(m => m.ExpenseDate <= reportVm.ToDate && m.IsDeleted == false).AsQueryable();
}
return(expenses.ToList());
}
public static BaseViewModelMain GetView(string s)
{
BaseViewModelMain viewContent = null;
switch (s)
{
case "Control": viewContent = new ControlVm(); break;
case "Report": viewContent = new ReportVm(); break;
case "Route": viewContent = new RouteVm(); break;
case "Train": viewContent = new TrainVm(); break;
case "Station": viewContent = new StationVm(); break;
case "PinLocation": viewContent = new PinLocationVm(); break;
case "TimeTable": viewContent = new TimeTableVm(); break;
case "User": viewContent = new UserVm(); break;
}
return(viewContent);
}
public CompanyWorkReportView(CGRect bounds)
{
_reportVm = ServiceLocator.Current.GetInstance <ReportVm>();
_bounds = bounds;
BuildInterface();
}
//public PartialViewResult GuardianInfo(string studentNumber)
//{
// var GuardianInfoes = Db.Guardians.Include(p => p.Student).Where(s => s.GuardianEmail.Contains(studentNumber));
// return PartialView(GuardianInfoes);
//}
#region Result Display
public async Task <ActionResult> PrintSecondTerm(string id, string term, string sessionName)
{
_resultCommand = new ResultCommandManager(id, term, sessionName, userSchool);
var reportModel = new ReportVm();
var newCalist = new List <ContinuousAssesmentVm>();
foreach (var ca in _resultCommand._studentCa)
{
var caVm = new ContinuousAssesmentVm
{
SubjectName = ca.Subject.SubjectName,
SubjectPosition = _resultCommand.FindSubjectPosition(ca.SubjectId),
SubjectHighest = _resultCommand.SubjectHighest(ca.SubjectId),
SubjectLowest = _resultCommand.SubjectLowest(ca.SubjectId),
ClassAverage = await _resultCommand.CalculateClassAverage(ca.SubjectId),
FirstCa = ca.FirstCa,
SecondCa = ca.SecondCa,
ThirdCa = ca.ThirdCa,
ForthCa = ca.ForthCa,
FifthCa = ca.FifthCa,
SixthCa = ca.SixthCa,
SeventhCa = ca.SeventhCa,
EightCa = ca.EightCa,
NinthtCa = ca.NinthtCa,
ExamCa = ca.ExamCa,
Total = ca.Total,
Grading = ca.Grading,
Remark = ca.Remark,
StaffName = ca.StaffName
};
newCalist.Add(caVm);
}
reportModel.ContinuousAssesmentVms = newCalist;
reportModel.NoOfStudentPerClass = await _resultCommand.NumberOfStudentPerClass();
reportModel.NoOfSubjectOffered = await _resultCommand.SubjectOfferedByStudent();
reportModel.AggregateScore = _resultCommand.TotalScorePerStudent();
reportModel.Average = await _resultCommand.CalculateAverage();
reportModel.OverAllGrade = _gradeRemark.Grading(reportModel.Average, _resultCommand._className, userSchool);
var myOtherSkills = await Db.Psychomotors.AsNoTracking().Where(s => s.StudentId.Contains(id) &&
s.TermName.Contains(term) &&
s.SessionName.Contains(sessionName) &&
s.ClassName.Equals(_resultCommand._className))
.Select(c => c.Id).FirstOrDefaultAsync();
reportModel.BehaviorCategory = await Db.BehaviorSkillCategories.AsNoTracking()
.Where(s => s.SchoolId.Equals(userSchool))
.Select(x => x.Name).ToListAsync();
reportModel.AssignBehaviors = await Db.AssignBehaviors.Where(s => s.SchoolId.Equals(userSchool) &&
s.StudentId.Contains(id) &&
s.TermName.Contains(term) &&
s.SessionName.Contains(sessionName)).ToListAsync();
reportModel.AssignBehavior = reportModel.AssignBehaviors.FirstOrDefault();
reportModel.ReportCard = await Db.ReportCards.FirstOrDefaultAsync(x => x.SchoolId.Equals(userSchool) &&
x.TermName.ToUpper().Equals(term) &&
x.SessionName.Equals(sessionName));
//ViewBag.Class =
reportModel.PrincipalComment = _gradeRemark.PrincipalRemark(reportModel.Average, _resultCommand._className, userSchool);
reportModel.TermName = term;
reportModel.SessionName = sessionName;
reportModel.ClassName = _resultCommand._className;
reportModel.Student = await Db.Students.FindAsync(id);
reportModel.CaSetUp = await Db.CaSetUps.AsNoTracking().Where(x => x.IsTrue.Equals(true) &&
x.Class.FullClassName.Equals(_resultCommand._className))
.OrderBy(o => o.CaOrder).ToListAsync();
reportModel.CaSetUpCount = reportModel.CaSetUp.Count();
var myAggregateList = new List <AggregateList>();
var classMate = Db.AssignedClasses.AsNoTracking().Where(x => x.ClassName.Equals(_resultCommand._className))
.Select(s => s.StudentId).ToList();
foreach (var student in classMate)
{
var aggregateList = new AggregateList()
{
Score = await Db.CaLists.AsNoTracking().Where(x => x.SchoolId.Equals(userSchool) && x.StudentId.Equals(student) &&
x.ClassName.Equals(_resultCommand._className) &&
x.TermName.Equals(term) && x.SessionName.Equals(sessionName))
.SumAsync(s => s.Total),
StudentId = student
};
myAggregateList.Add(aggregateList);
}
reportModel.AggregatePosition = _resultCommand.FindAggregatePosition(myAggregateList);
//return View(reportModel);
return(new ViewAsPdf("PrintSecondTerm", reportModel));
}
public UserStatusReportView(CGRect bounds)
{
_reportsVm = ServiceLocator.Current.GetInstance <ReportVm>();
_bounds = bounds;
BuildInterface();
}
public UsersPerStateViewController()
{
_reportVm = ServiceLocator.Current.GetInstance <ReportVm>();
_navigationService = ServiceLocator.Current.GetInstance <INavigationService>();
BuildInterface();
}
public ReportUc()
{
InitializeComponent();
_reportVm = ReportVm;
}
public UserTableSource()
{
_reportVm = ServiceLocator.Current.GetInstance <ReportVm>();
_navigationService = ServiceLocator.Current.GetInstance <INavigationService>();
}
public static ReportContainerVm GetContainer(ReportRequestVm _reportRequestVm, IPartnerServiceIntegration _partnerIntegration, IDlsIntegration _dlsIntegration, string[] strPosIdList)
{
var reportContainer = ReportContainerHelper.GetStagedContainer(ReportType.DailyTranSales, _partnerIntegration, _reportRequestVm);
//Domain Tranformation
var dailyTranLookupReq = _reportRequestVm.ToDailyTranDetailLookupModel();
var tranType = string.Empty;
//Add all the report(s)
ReportVm rpt = new ReportVm(BusinessReportsConstants.Common.SR_NAME);
// Map from ViewModel->Domain
var tranDetailLookupResp = _dlsIntegration.DailyTransactionDetailLookup(dailyTranLookupReq);
if (tranDetailLookupResp == null || tranDetailLookupResp.GetDailyTransactionDetailLookupResultList == null)
{
return(reportContainer);
}
foreach (TransactionDetailLookupResult item in tranDetailLookupResp.GetDailyTransactionDetailLookupResultList)
{
Dictionary <string, string> DataInfo = new Dictionary <string, string>();
DataInfo.Add(BusinessReportsConstants.DailyTranSales.AGENT_ID, dailyTranLookupReq.AgentId);
DataInfo.Add(BusinessReportsConstants.DailyTranSales.ISO_CURRENCY_CODE, (string.IsNullOrEmpty(item.IsoCurrencyCode)) ? "-" : item.IsoCurrencyCode);
DataInfo.Add(BusinessReportsConstants.DailyTranSales.AGENT_LOCAL_TIME, (string.IsNullOrEmpty(item.AgentLocalTime)) ? "" : Convert.ToDateTime(item.AgentLocalTime).ToString("HH:mm"));
DataInfo.Add(BusinessReportsConstants.DailyTranSales.EMPLOYEE_NUMBER, string.Empty);
DataInfo.Add(BusinessReportsConstants.DailyTranSales.RECEIVER_NAME, (string.IsNullOrEmpty(item.ReceiverName)) ? "-" : item.ReceiverName);
DataInfo.Add(BusinessReportsConstants.DailyTranSales.REFERENCE_ID, (string.IsNullOrEmpty(item.ReferenceId)) ? "-" : item.ReferenceId);
var serialNumber = "";
foreach (string sItem in item.SerialNumberArray)
{
serialNumber += sItem + "-";
}
if (!string.IsNullOrEmpty(serialNumber))
{
serialNumber = serialNumber.Substring(0, serialNumber.Length - 1);
}
DataInfo.Add(BusinessReportsConstants.DailyTranSales.SERIAL_NUMBER, serialNumber);
tranType = string.Empty;
if (item.ProductId.Equals(BusinessReportsConstants.Common.UTILITY_BILL_PAYMENT_PRODUCT_ID))
{
tranType = BusinessReportsConstants.Common.TRAN_TYPE_UP;
}
else if (item.ProductId.Equals(BusinessReportsConstants.Common.EXPRESS_PAYMENT_PRODUCT_ID))
{
tranType = BusinessReportsConstants.Common.TRAN_TYPE_EP;
}
else if (item.ProductId.Equals(BusinessReportsConstants.Common.MT_PRODUCT_ID) && item.EventCode.Equals(DLSActivityTypeCode.SEN.ToString()))
{
tranType = BusinessReportsConstants.Common.TRAN_TYPE_SEND;
}
else if (item.ProductId.Equals(BusinessReportsConstants.Common.MT_PRODUCT_ID) && item.EventCode.Equals(DLSActivityTypeCode.REC.ToString()))
{
tranType = BusinessReportsConstants.Common.TRAN_TYPE_RECEIVE;
}
else if (item.EventCode.Equals(DLSActivityTypeCode.RSN.ToString()))
{
tranType = BusinessReportsConstants.Common.TRAN_TYPE_CANCEL;
}
else if (item.EventCode.Equals(DLSActivityTypeCode.RRC.ToString()))
{
tranType = BusinessReportsConstants.Common.TRAN_TYPE_REVERSAL;
}
DataInfo.Add(BusinessReportsConstants.DailyTranSales.TRANSACTION_TYPE, tranType);
DataInfo.Add(BusinessReportsConstants.DailyTranSales.AMOUNT, (string.IsNullOrEmpty(item.FaceAmount)) ? "-" : string.Format(BusinessReportsConstants.Common.AMT_FORMAT, double.Parse(item.FaceAmount)));
DataInfo.Add(BusinessReportsConstants.DailyTranSales.EXCHANGE_RATE, (string.IsNullOrEmpty(item.FxConsumerRate)) ? "-" : item.FxConsumerRate);
DataInfo.Add(BusinessReportsConstants.DailyTranSales.FEE, (string.IsNullOrEmpty(item.FeeAmount)) ? "-" : string.Format(BusinessReportsConstants.Common.AMT_FORMAT, double.Parse(item.FeeAmount)));
DataInfo.Add(BusinessReportsConstants.DailyTranSales.SENDER, (string.IsNullOrEmpty(item.SenderName)) ? "-" : item.SenderName);
//Get user based on mainofficeid and operatorid
var operatorId = (string.IsNullOrEmpty(item.OperatorId)) ? "" : item.OperatorId.ToLower();
string userId = null;
userId = SupplementalValuesHelper.GetUserId(operatorId, _partnerIntegration);
DataInfo.Add(BusinessReportsConstants.DailyTranSales.USERNAME, (userId == null) ? "-" : userId);
if (item.FeeAmount != null)
{
var faceAmount = double.Parse(item.FaceAmount);
var fee = double.Parse(item.FeeAmount);
var total = faceAmount + fee;
DataInfo.Add(BusinessReportsConstants.DailyTranSales.TOTAL, string.Format(BusinessReportsConstants.Common.AMT_FORMAT, total));
}
else
{
DataInfo.Add(BusinessReportsConstants.DailyTranSales.TOTAL, string.Format(BusinessReportsConstants.Common.AMT_FORMAT, double.Parse(item.FaceAmount)));
}
if (item.PosId == null || !item.PosId.Equals("0"))
{
DataInfo.Add(BusinessReportsConstants.DailyTranSales.POS_ID, (item.PosId == null) ? "-" : item.PosId);
}
else
{
DataInfo.Add(BusinessReportsConstants.DailyTranSales.POS_ID, BusinessReportsConstants.Common.SUPER_AGENT);
}
//Filter by Pos ID
foreach (string posid in strPosIdList)
{
if (item.PosId == posid)
{
rpt.Rows.Add(DataInfo);
}
}
}
reportContainer.Reports.Add(rpt);
return(reportContainer);
}
public ChartAssignmentsDelegate()
{
_assignmentVm = ServiceLocator.Current.GetInstance <AssignmentVm>();
_reportVm = ServiceLocator.Current.GetInstance <ReportVm>();
_navigationService = ServiceLocator.Current.GetInstance <INavigationService>();
}
internal List <Expense> GetExpensesByReportVm(ReportVm reportVm)
{
List <Expense> Expenses = reportDal.GetExpensesByReportVm(reportVm);
return(Expenses);
}
internal List <Purchase> GetPurchasesByReportVm(ReportVm reportVm)
{
List <Purchase> Purchases = reportDal.GetPurchasesByReportVm(reportVm);
return(Purchases);
}
internal List <Sale> GetSalesByReportVm(ReportVm reportVm)
{
List <Sale> Sales = reportDal.GetSalesByReportVm(reportVm);
return(Sales);
}
