public void CalculateReport_AtleastOneRequestFound_And_ActualMonth_ReturnsAReportFilledInWithEstimates()
{
const string specificId = "BBCED7DB-6972-46D4-B6CF-D2C733E4B23D";
var reportServiceMock = new Mock <IRequestCounterService>();
reportServiceMock
.Setup(moq =>
moq._api_requests_year_month_getAsync(It.IsAny <int>(), It.IsAny <int>()))
.Returns(
Task.FromResult <Requests>(
new Requests()
{
Requests1 = new List <Request>()
{
new Request()
{
SubscriptionId = specificId,
Requested = DateTime.Now.ToString()
}
}
}));
var service = new ReportCalculatorService(reportServiceMock.Object);
MonthlyReport result = service.CalculateReport(specificId, DateTime.Now.Year, DateTime.Now.Month).Result;
Assert.AreNotEqual(result.EstimatesForMonth, null);
}
public void CalculateReport_AtleastOneRequestFound_ReturnsAReportFilledIn()
{
const string specificId = "BBCED7DB-6972-46D4-B6CF-D2C733E4B23D";
var reportServiceMock = new Mock <IRequestCounterService>();
reportServiceMock
.Setup(moq =>
moq._api_requests_year_month_getAsync(It.IsAny <int>(), It.IsAny <int>()))
.Returns(
Task.FromResult <Requests>(
new Requests()
{
Requests1 = new List <Request>()
{
new Request()
{
SubscriptionId = specificId
}
}
}));
var service = new ReportCalculatorService(reportServiceMock.Object);
MonthlyReport result = service.CalculateReport(specificId, 1, 1).Result;
Assert.IsTrue(result.TotalNumberOfRequests > 0);
Assert.AreEqual(result.SubscriptionId, specificId);
Assert.IsTrue(result.StartDate.CompareTo(new DateTime(1, 1, 1)) == 0);
Assert.IsTrue(result.EndDate.CompareTo(new DateTime(1, 1, 31)) == 0);
Assert.AreNotEqual(result.Costs, null);
Assert.AreEqual(result.EstimatesForMonth, null);
}
public async Task <IActionResult> PutMonthlyReport(long id, MonthlyReport monthlyReport)
{
if (id != monthlyReport.Id)
{
return(BadRequest());
}
_context.Entry(monthlyReport).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!MonthlyReportExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public MonthlyReport GetMonthlyReport(int pastureID, int year, int month)
{
MonthlyReport report = new MonthlyReport();
DateTime reportDate = (new DateTime(year, month, 1)).AddMonths(1).AddDays(-1);//取本月最后一天
DailyReportBLL drBLL = new DailyReportBLL(pastureID);
//取该月日报
List <DailyReport> dailyReports = drBLL.GetDailyReport(pastureID, new DateTime(year, month, 1), reportDate);
var sorted = dailyReports.OrderByDescending(a => a.ReportDate);
dailyReports = sorted.ToList();
DailyReport latestDailyReport = dailyReports.First();
//牛群结构按最后一天
report.CalfNumber = latestDailyReport.CalfNumber;
report.BredCattleNumber = latestDailyReport.BredCattleNumber;
report.NullParityNumber = latestDailyReport.NullParityNumber;
report.MultiParityNumber = latestDailyReport.MultiParityNumber;
report.DryCowNumber = latestDailyReport.DryCowNumber;
report.MilkCowNumber = latestDailyReport.MilkCowNumber;
report.ReportMonth = month;
report.ReportYear = year;
int calvingNum = 0, maleCalf = 0, femaleCalf = 0;
float saleMilk = 0, milkForCalf = 0, abnormal = 0, badMilk = 0, leftMilk = 0, amount = 0;
int soldCow = 0, deadCow = 0, eliminatedCow = 0;
foreach (DailyReport item in dailyReports)
{
calvingNum = calvingNum + item.CalvingNumber;
maleCalf = maleCalf + item.MaleCalfNumber;
femaleCalf = femaleCalf + item.FemaleCalfNumber;
saleMilk = saleMilk + item.SaleMilk;
milkForCalf = milkForCalf + item.MilkForCalf;
abnormal = abnormal + item.AbnormalSaleMilk;
badMilk = badMilk + item.BadMilk;
leftMilk = leftMilk + item.LeftMilk;
amount = amount + item.Amount;
soldCow = soldCow + item.SoldCowNum;
deadCow = deadCow + item.DeadCowNum;
eliminatedCow = eliminatedCow + item.ElimintedCowNum;
}
report.CalfNumber = calvingNum;
report.MaleCalfNumber = maleCalf;
report.FemaleCalfNumber = femaleCalf;
report.SaleMilk = saleMilk;
report.AbnormalSaleMilk = abnormal;
report.MilkForCalf = milkForCalf;
report.LeftMilk = leftMilk;
report.Amount = amount;
//离群
report.SoldCowNum = soldCow;
report.DeadCowNum = deadCow;
report.ElimintedCowNum = eliminatedCow;
return(report);
}
public List <DictionaryVmodel> GetSummaryRptDataSource(ReportInstance RptModel, bool IsTargetPlan)
{
_Target = RptModel._Target;
Report = RptModel.Report;
_System = RptModel._System;
FinYear = RptModel.FinYear;
FinMonth = RptModel.FinMonth;
ReportDetails = RptModel.ReportDetails;
string MonthlyReportIDs = "";
ReportDetails.GroupBy(x => x.MonthlyReportID).Select(x => x.Key).ToList().ForEach(x => MonthlyReportIDs += "," + x);
MonthlyReportIDs = MonthlyReportIDs.Trim(',');
if (ReportDetails != null && ReportDetails.Count() > 0)
{
_System = StaticResource.Instance[_System.ID, ReportDetails[0].CreateTime];
_Target = StaticResource.Instance.GetTargetList(_System.ID, ReportDetails[0].CreateTime).ToList();
}
List <MonthReportSummaryViewModel> listMRSVM = GetMonthlyReportDetailSummaryList();
//List<B_Attachment> listAtt = GetListAtt(_System.ID);
List <B_Attachment> listAtt = GetListAtt(MonthlyReportIDs);
List <DictionaryVmodel> listMonthReportSummary = new List <DictionaryVmodel>();
string strReportDescription = "";
if (Report != null)
{
strReportDescription = Report.Description;
}
listMonthReportSummary.Add(new DictionaryVmodel("ReportInstance", RptModel));
listMonthReportSummary.Add(new DictionaryVmodel("月报说明", strReportDescription));
listMonthReportSummary.Add(new DictionaryVmodel("月度经营报告", listMRSVM, "", GetSummaryMonthlyReportHtmlTemplate(_System.Configuration)));
listMonthReportSummary.Add(new DictionaryVmodel("附件", listAtt));
listMonthReportSummary.Add(new DictionaryVmodel("完成情况明细查询条件", SpliteCompanyPropertyXml("Search", _System.Configuration)));
return(listMonthReportSummary);
}
public void CalculateReport_AtleastOneRequestFound_ReturnsAReportCreated()
{
var reportServiceMock = new Mock <IRequestCounterService>();
reportServiceMock
.Setup(moq =>
moq._api_requests_year_month_getAsync(It.IsAny <int>(), It.IsAny <int>()))
.Returns(
Task.FromResult <Requests>(
new Requests()
{
Requests1 = new List <Request>()
{
new Request()
{
SubscriptionId = Guid.Empty.ToString()
}
}
}));
var service = new ReportCalculatorService(reportServiceMock.Object);
MonthlyReport result = service.CalculateReport(Guid.Empty.ToString(), 1, 1).Result;
Assert.AreNotEqual(result, null);
}
protected virtual MonthlyReportCollection ConvertToYearMonthResult(int year, MonthlyReportCollection reports)
{
MonthlyReportCollection rv = new MonthlyReportCollection();
DateTime today = DateTime.Today;
int months;
if (today.Year == year)
{
months = today.Month;
}
else
{
months = 12;
}
for (int i = months; i > 0; i--)
{
MonthlyReport report = reports.TryGetItem(year, i);
if (report == null)
{
report = new MonthlyReport();
report.IsEmpty = true;
report.ItemID = -i;
report.TaskID = -1;
report.Date = new DateTime(year, i, 1);
}
rv.Add(report);
report["Month"] = i;
}
return(rv);
}
private async Task <IActionResult> GetReportInResult(string subscriptionId, int year, int month)
{
MonthlyReport report = null;
try
{
report = await _requestCounterService.CalculateReport(subscriptionId, year, month);
}
catch (ApiException <Error> error)
{
if (error.StatusCode == 400)
{
return(BadRequest(error.Message));
}
if (error.StatusCode == 404)
{
return(NotFound(error.Message));
}
}
catch (ApiException)
{
throw new ApplicationException("Unexpected error orrured, please contact an administrator of the service");
}
if (report == null)
{
return(NotFound("There were no related service request in the given month"));
}
return(Ok(report));
}
public async Task <ActionResult <MonthlyReport> > PostMonthlyReport(MonthlyReport monthlyReport)
{
_context.MonthlyReports.Add(monthlyReport);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetMonthlyReport", new { id = monthlyReport.Id }, monthlyReport));
}
public async Task <MonthlyReport> CalculateReport(string subscriptionId, int year, int month)
{
if (DateTime.Now.Year < year ||
(DateTime.Now.Year == year && DateTime.Now.Month < month))
{
return(null);
}
var allRequests = await _requestCounterService._api_requests_year_month_getAsync(year, month);
var requestsForSubscription =
RequestsOfSubscription(subscriptionId, allRequests)
.ToArray();
MonthlyReport result = null;
if (requestsForSubscription.Any())
{
IEnumerable <CostPerService> calculatedCosts =
CalculateCostPerServices(requestsForSubscription)
.ToArray();
IEnumerable <CostPerService> estimatesForMonth = null;
if (DateTime.Now.Year == year && DateTime.Now.Month == month)
{
estimatesForMonth =
calculatedCosts
.Select(costPerService =>
{
double multiplier =
MultiplierForAllMonth(requestsForSubscription.Select(request => DateTime.Parse(request.Requested)));
return(new CostPerService()
{
ServiceName = costPerService.ServiceName,
NumberOfRequests = (int)Math.Ceiling(costPerService.NumberOfRequests * multiplier),
TotalPrice = Math.Ceiling(costPerService.TotalPrice * (decimal)multiplier)
});
})
.ToArray();
}
var startDate = new DateTime(year, month, 1);
result =
new MonthlyReport()
{
TotalNumberOfRequests = requestsForSubscription.Count(),
SubscriptionId = requestsForSubscription.First().SubscriptionId,
StartDate = startDate,
EndDate = LastDateOfMonth(startDate),
Costs = calculatedCosts,
EstimatesForMonth = estimatesForMonth
};
}
return(result);
}
public List <DictionaryVmodel> GetSummaryRptDataSource(ReportInstance RptModel, bool IsTargetPlan)
{
_Target = RptModel._Target;
Report = RptModel.Report;
_System = RptModel._System;
FinYear = RptModel.FinYear;
FinMonth = RptModel.FinMonth;
ReportDetails = RptModel.ReportDetails;
string MonthlyReportIDs = "";
ReportDetails.GroupBy(x => x.MonthlyReportID).Select(x => x.Key).ToList().ForEach(x => MonthlyReportIDs += "," + x);
MonthlyReportIDs = MonthlyReportIDs.Trim(',');
//这里对系统和指标再次做一次验证
//if (ReportDetails != null && ReportDetails.Count() > 0)
//{
// B_MonthlyReport bm = B_MonthlyreportOperator.Instance.GetMonthlyreport(RptModel.ReportDetails[0].MonthlyReportID);
// _System = StaticResource.Instance[_System.ID, bm.CreateTime];
// _Target = StaticResource.Instance.GetTargetList(_System.ID, bm.CreateTime).ToList();
//}
List <MonthReportSummaryViewModel> listMRSVM = GetMonthlyReportDetailSummaryList(IsTargetPlan);
// List<B_Attachment> listAtt = GetListAtt(_System.ID);
List <B_Attachment> listAtt = GetListAtt(MonthlyReportIDs);
List <DictionaryVmodel> listMonthReportSummary = new List <DictionaryVmodel>();
string strReportDescription = "";
#region 月报说明
if (RptModel.ReportDetails.Any())
{
XElement element = _System.Configuration;
if (element.Elements("Report").Elements("Rgroup") != null)
{
strReportDescription = element.Element("Report").GetElementValue("Rgroup", "");
if (!string.IsNullOrEmpty(strReportDescription))
{
System.Collections.Hashtable p = MonthDescriptionValueEngine.MonthDescriptionValueService.GetMonthDescriptionValue(RptModel.ReportDetails, _System.ID, RptModel.CurrentLoginName);
foreach (string key in p.Keys)
{
strReportDescription = strReportDescription.Replace("【" + key + "】", p[key].ToString());
}
}
}
}
#endregion
//if (Report != null)
//{
// strReportDescription = Report.Description;
//}
listMonthReportSummary.Add(new DictionaryVmodel("ReportInstance", RptModel));
listMonthReportSummary.Add(new DictionaryVmodel("月报说明", strReportDescription));
listMonthReportSummary.Add(new DictionaryVmodel("月度经营报告", listMRSVM, "", GetSummaryMonthlyReportHtmlTemplate(_System.Configuration)));
listMonthReportSummary.Add(new DictionaryVmodel("附件", listAtt));
listMonthReportSummary.Add(new DictionaryVmodel("完成情况明细查询条件", SpliteCompanyPropertyXml("Search", _System.Configuration)));
listMonthReportSummary.Add(new DictionaryVmodel("是否包含区域", StaticResource.Instance.GetSystem_Regional(_System.ID)));
return(listMonthReportSummary);
}
public void update(MonthlyReport report, DateTime date)
{
report.setMonth(updateMonth(date));
financeSystem funds = retrieveFinances(new DateTime(date.Year, date.Month, 1), new DateTime(date.Year, date.Month, DateTime.DaysInMonth(date.Year, date.Month)));
double amountOwedIHSP = 0;
double amountOwedOHSP = 0;
report.setBasicEnrollNum(funds.numBasicEnrollees);
report.setExtendedErollNum(funds.numExtendedEnrollees);
report.setBasicTotalIncome(funds.totalBasicIncome);
report.setExtendTotalIncome(funds.totalExtendedIncome);
report.setTotalEnrolleePayments(funds.numEnrolleeBills);
report.setIHSPNumHospBills(funds.numIHSPHospitalBills);
report.setOHSPNumHospBills(funds.numOHSPHospitalBills);
report.setIHSPNumPhysBills(funds.numIHSPPhysicianBills);
report.setOHSPNumPhysBills(funds.numOHSPPhysicianBills);
report.setIHSPNumOtherBills(funds.numIHSPOtherBills);
report.setOHSPNumOtherBills(funds.numOHSPOtherBills);
report.setHospitalIHSP(funds.IHSPhospitalCosts);
report.setHospitalOHSP(funds.OHSPhospitalCosts);
amountOwedIHSP += funds.IHSPhospitalCosts;
amountOwedOHSP += funds.OHSPhospitalCosts;
report.setPhysicianIHSP(funds.IHSPPhysicianCosts);
report.setPhysicianOHSP(funds.OHSPPhysicianCosts);
amountOwedIHSP += funds.IHSPPhysicianCosts;
amountOwedOHSP += funds.OHSPPhysicianCosts;
report.setOtherIHSP(funds.IHSPOtherCosts);
report.setOtherOHSP(funds.OHSPOtherCosts);
amountOwedIHSP += funds.IHSPOtherCosts;
amountOwedOHSP += funds.OHSPOtherCosts;
report.setAmountOwedIHSP(amountOwedIHSP);
report.setAmountOwedOHSP(amountOwedOHSP);
double paidPercentage = 0;
paidPercentage = (amountOwedIHSP + amountOwedOHSP) / (2000 * funds.numIHSPHospitalBills + 150 * funds.numIHSPPhysicianBills
+ 300 * funds.numIHSPOtherBills + amountOwedOHSP);
paidPercentage = paidPercentage * 100;
report.setMaxPercentBillable(paidPercentage);
double totalCosts = 0;
totalCosts += amountOwedIHSP;
totalCosts += amountOwedOHSP;
report.setTotalCosts(totalCosts);
}
public virtual object GetTeamReports(HttpContext context)
{
YZRequest request = new YZRequest(context);
string myaccount = request.GetString("account", YZAuthHelper.LoginUserAccount);
DateTime date = request.GetDateTime("date");
BPMObjectNameCollection accounts = new BPMObjectNameCollection();
accounts.Add(myaccount);
using (BPMConnection bpmcn = new BPMConnection())
{
bpmcn.WebOpen();
MemberCollection positions = OrgSvr.GetUserPositions(bpmcn, myaccount);
foreach (Member position in positions)
{
DirectXSCollection xss = position.GetDirectXSs(bpmcn);
foreach (DirectXS xs in xss)
{
if (!accounts.Contains(xs.UserAccount))
{
accounts.Add(xs.UserAccount);
}
}
}
MonthlyReportCollection rv = new MonthlyReportCollection();
foreach (string account in accounts)
{
MonthlyReport monthlyReport;
using (IYZDbProvider provider = YZDbProviderManager.DefaultProvider)
{
using (IDbConnection cn = provider.OpenConnection())
{
monthlyReport = MonthlyReportManager.TryGetReport(provider, cn, account, date);
if (monthlyReport == null)
{
monthlyReport = new MonthlyReport();
monthlyReport.Account = account;
monthlyReport.Date = date;
}
rv.Add(monthlyReport);
}
}
User user = User.TryGetUser(bpmcn, account);
monthlyReport["ShortName"] = user == null ? "" : user.ShortName;
}
return(rv);
}
}
public void 正しい日付にセットされているか()
{
int userID = this.getUserID(testLoginNo);
MonthlyReport _mr = new MonthlyReport(2013, userID);
_mr.setMonth(12);
DataSet _ds = _mr.getMonthlyWorkReport();
Assert.AreEqual(1.0, _ds.Tables[this.listTableName].Rows[1]["overtime125"]);
}
public void 年月の文字列生成のテスト()
{
int userID = this.getUserID(testLoginNo);
MonthlyReport _mr = new MonthlyReport(2013, userID);
_mr.setMonth(4);
Assert.AreEqual("2013年04月", _mr.getStringYearMonth());
_mr.setMonth(11);
Assert.AreEqual("2013年11月", _mr.getStringYearMonth());
_mr.setMonth(3);
Assert.AreEqual("2014年03月", _mr.getStringYearMonth());
}
public void 祝日のデータセットを取得できるか()
{
int userID = this.getUserID(testLoginNo);
MonthlyReport _mr = new MonthlyReport(2013, userID);
_mr.setMonth(12);
DataSet _ds = _mr.getHolidayListDs();
Assert.AreEqual(1, _ds.Tables[0].Rows[0]["day"]);
Assert.AreEqual(7, _ds.Tables[0].Rows[1]["day"]);
Assert.AreEqual(8, _ds.Tables[0].Rows[2]["day"]);
Assert.AreEqual(12, _ds.Tables[0].Rows.Count);
}
public void ユーザID異常系のテスト()
{
// コンストラクタで落とす
MonthlyReport _mr = new MonthlyReport(2013, -1);
// 例外を出さずに返ること
Assert.AreEqual("不明なユーザ", _mr.getUserName());
// 例外を出さずに返ること
_mr.setMonth(12);
DataSet _ds = _mr.getMonthlyWorkReport();
Assert.AreEqual(1, _ds.Tables[this.listTableName].Rows[0]["day"]);
}
internal static int GetMonthlyStockbalanceByMonthAndItemId(string m, int id)
{
MonthlyReport monthlyreport = new MonthlyReport();
int mstockbalance = 0;
using (var db = new ADDbContext())
{
if (db.MonthlyReport.Where(x => x.date.Equals(m) && x.itemId == id).Any())
{
mstockbalance = db.MonthlyReport.Where(x => x.date.Equals(m) && x.itemId == id).FirstOrDefault().stockbalance;
}
}
return(mstockbalance);
}
public void 前の月があるかのテスト()
{
int userID = this.getUserID(testLoginNo);
MonthlyReport _mr = new MonthlyReport(2013, userID);
_mr.setMonth(3);
Assert.AreEqual(true, _mr.existsPrevMonth());
_mr.setMonth(1);
Assert.AreEqual(true, _mr.existsPrevMonth());
_mr.setMonth(12);
Assert.AreEqual(true, _mr.existsPrevMonth());
_mr.setMonth(4);
Assert.AreEqual(false, _mr.existsPrevMonth());
}
public int GetAccumulatedHours(string enrollment)
{
MonthlyReport monthlyReports = new MonthlyReport();
try
{
monthlyReports = _context.Set <MonthlyReport>().OrderByDescending(Reports => Reports.DeliveryDate).First(Reports => Reports.Enrollment == enrollment);
}
catch (InvalidOperationException)
{
monthlyReports.HoursCumulative = 0;
}
return(monthlyReports.HoursCumulative);
}
public void 月カウントアップのテスト()
{
int userID = this.getUserID(testLoginNo);
MonthlyReport _mr = new MonthlyReport(2013, userID);
_mr.setMonth(11);
_mr.incrMonth();
Assert.AreEqual("2013年12月", _mr.getStringYearMonth());
_mr.incrMonth();
Assert.AreEqual("2014年01月", _mr.getStringYearMonth());
// はみ出してもカウントせず、エラーにもならないこと
_mr.setMonth(3);
_mr.incrMonth();
Assert.AreEqual("2014年03月", _mr.getStringYearMonth());
}
internal static void CreateMonthlyReport(int itemId, string dt, int mcons, int sbalance)
{
MonthlyReport monthlyreport = new MonthlyReport();
using (var db = new ADDbContext())
{
monthlyreport.date = dt;
monthlyreport.itemId = itemId;
monthlyreport.consumption = mcons;
monthlyreport.stockbalance = sbalance;
db.MonthlyReport.Add(monthlyreport);
db.SaveChanges();
}
}
public void カレンダーイヤー計算のテスト()
{
int userID = this.getUserID(testLoginNo);
MonthlyReport _mr = new MonthlyReport(2013, userID);
_mr.setMonth(4);
Assert.AreEqual(2013, _mr.getCalYear());
_mr.setMonth(12);
Assert.AreEqual(2013, _mr.getCalYear());
_mr.setMonth(1);
Assert.AreEqual(2014, _mr.getCalYear());
_mr.setMonth(2);
Assert.AreEqual(2014, _mr.getCalYear());
_mr.setMonth(3);
Assert.AreEqual(2014, _mr.getCalYear());
}
void WriteMonthlyReport(MonthlyReport toDisplay)
{
scrollableMonthlyReport.text = "";
scrollableMonthlyReport.text += "Report ending: " + toDisplay.currentMonth.month + " " +toDisplay.currentMonth.year;
scrollableMonthlyReport.text += "\n" + "Hotel Occupancy: "+toDisplay.occupancy().ToString()+"%";
scrollableMonthlyReport.text += "\n" + "Restaurant Revenue: $" + toDisplay.restaurantTake.ToString();
scrollableMonthlyReport.text += "\n" + "Standard Rooms: $" + toDisplay.revenueRoomLvl1.ToString();
scrollableMonthlyReport.text += " " + "Number: " + toDisplay.numbRoomLvl1.ToString();
scrollableMonthlyReport.text += " " + "Occupancy: " + toDisplay.occupancyRoomLvl1().ToString()+"%";
scrollableMonthlyReport.text += " " + "Number Of Bookings: " + toDisplay.numbRoomLvl1Booked.ToString();
scrollableMonthlyReport.text += "\n" + "Double Rooms: $" + toDisplay.revenueRoomLvl2.ToString();
scrollableMonthlyReport.text += " " + "Number: " + toDisplay.numbRoomLvl2.ToString();
scrollableMonthlyReport.text += " " + "Number Of Bookings: " + toDisplay.numbRoomLvl2Booked.ToString();
scrollableMonthlyReport.text += " " + "Occupancy: " + toDisplay.occupancyRoomLvl2().ToString()+"%";
scrollableMonthlyReport.text += "\n" + "Deluxe Rooms: $" + toDisplay.revenueRoomLvl3.ToString();
scrollableMonthlyReport.text += " " + "Number: " + toDisplay.numbRoomLvl3.ToString();
scrollableMonthlyReport.text += " " + "Number Of Bookings: " + toDisplay.numbRoomLvl3Booked.ToString();
scrollableMonthlyReport.text += " " + "Occupancy: " + toDisplay.occupancyRoomLvl3().ToString()+"%";
scrollableMonthlyReport.text += "\n" + "Suites: $" + toDisplay.revenueRoomLvl4.ToString();
scrollableMonthlyReport.text += " " + "Number: " + toDisplay.numbRoomLvl4.ToString();
scrollableMonthlyReport.text += " " + "Number Of Bookings: " + toDisplay.numbRoomLvl4Booked.ToString();
scrollableMonthlyReport.text += " " + "Occupancy: " + toDisplay.occupancyRoomLvl4().ToString()+"%";
scrollableMonthlyReport.text += "\n" + "Master Suites: $" + toDisplay.revenueRoomLvl5.ToString();
scrollableMonthlyReport.text += " " + "Number: " + toDisplay.numbRoomLvl5.ToString();
scrollableMonthlyReport.text += " " + "Number Of Bookings: " + toDisplay.numbRoomLvl5Booked.ToString();
scrollableMonthlyReport.text += " " + "Occupancy: " + toDisplay.occupancyRoomLvl5().ToString()+"%";
scrollableMonthlyReport.text += "\n" + "Staff: ";
scrollableMonthlyReport.text += "\n" + "Department Heads: "+toDisplay.numbDepartmentHead.ToString();
scrollableMonthlyReport.text += "\n" + "Service Staff: "+toDisplay.numbHotelServicesStaff.ToString();
scrollableMonthlyReport.text += "\n" + "Food And Beverage: "+toDisplay.numbFoodAndBeverageStaff.ToString();
scrollableMonthlyReport.text += "\n" + "Front Desk: "+toDisplay.numbFrontDeskStaff.ToString();
scrollableMonthlyReport.text += "\n" + "Conference: "+toDisplay.numbConferenceStaff.ToString();
scrollableMonthlyReport.text += "\n" + "Other: "+toDisplay.numbOtherStaff.ToString();
scrollableMonthlyReport.text += "\n" + "Expenses: ";
scrollableMonthlyReport.text += "\n" + "Staffing: "+toDisplay.expenseEmployeeTotal().ToString();
scrollableMonthlyReport.text += "\n" + "Repairs: "+toDisplay.expenseRepairCost.ToString();
scrollableMonthlyReport.text += "\n" + "Upgrade: "+toDisplay.expenseUpgradeCost.ToString();
}
internal static int GetMonthlyConsByMonthAndItemId(string m, int id)
{
MonthlyReport monthlyreport = new MonthlyReport();
int mcons = 0;
using (var db = new ADDbContext())
{
if (db.MonthlyReport.Where(x => x.date.Equals(m) && x.itemId == id).Any())
{
mcons = db.MonthlyReport.Where(x => x.date.Equals(m) && x.itemId == id).FirstOrDefault().consumption;
}
else
{
mcons = 0;//it's not the end of the month, monthly consumption is not available.
}
}
return(mcons);
}
public void ValidInformationTest()
{
MonthlyReport monthlyReport = new MonthlyReport
{
IdMonthlyReport = 1,
DeliveryDate = DateTime.Now,
PerformedActivities = "Acordar con la organización vinculada las tareas que se realizarán",
ResultsObtained = "Documento de calendario de actividades",
HoursReported = 20,
HoursCumulative = 20,
Enrollment = "zS18012124",
IdProject = 1
};
MonthlyReportValidator monthlyReportValidator = new MonthlyReportValidator();
ValidationResult validationResult = monthlyReportValidator.Validate(monthlyReport);
Assert.IsTrue(validationResult.IsValid);
}
public void InvalidInformationTest()
{
MonthlyReport monthlyReport = new MonthlyReport
{
IdMonthlyReport = 1,
DeliveryDate = DateTime.Now,
PerformedActivities = null,
ResultsObtained = null,
HoursCumulative = 20,
Enrollment = "zS18012124",
IdProject = 1
};
MonthlyReportValidator monthlyReportValidator = new MonthlyReportValidator();
ValidationResult validationResult = monthlyReportValidator.Validate(monthlyReport);
int errors = validationResult.Errors.Count;
Assert.AreNotEqual(errors, 0);
}
public async Task <WrapperMonthProductionListVM> MonthlyProduction(MonthlyReport vm)
{
vm.To = vm.To.ToLocalTime();
vm.From = vm.From.ToLocalTime();
WrapperMonthProductionListVM returnData = new WrapperMonthProductionListVM();
Task <List <Production> > prodT = _repositoryWrapper
.Production
.FindAll()
.Where(x => x.EntryDate >= vm.From)
.Where(x => x.EntryDate <= vm.To)
.Where(x => x.FactoryId == vm.FactoryId)
// .Where(x => x.Month == vm.Month)
.Include(x => x.Item)
.Include(x => x.ItemCategory)
.Include(x => x.Staff)
.ToListAsync();
await Task.WhenAll(prodT);
List <MonthlyProduction> monthlyProductions = new List <MonthlyProduction>();
monthlyProductions = _utilService.Mapper.Map <List <Production>, List <MonthlyProduction> >(prodT.Result.ToList());
returnData.TotalRecords = monthlyProductions.ToList().Count();
returnData.ListOfData = monthlyProductions;
MonthlyProduction lastRow = new MonthlyProduction();
lastRow.TotalAmount = returnData.ListOfData.Sum(x => (x.Quantity));
returnData.ListOfData = monthlyProductions
.OrderByDescending(x => x.CreatedDateTime)
.Skip((vm.PageNumber - 1) * (vm.PageSize))
.Take(vm.PageSize)
.ToList();
returnData.Total_TillNow = lastRow.TotalAmount;
returnData.Total_Monthly = returnData.ListOfData.Sum(x => (x.Quantity));
returnData.ListOfData.Add(lastRow);
return(returnData);
}
public void DataSetがカレンダーになっているか()
{
int userID = this.getUserID(testLoginNo);
MonthlyReport _mr = new MonthlyReport(2013, userID);
_mr.setMonth(12);
DataSet _ds = _mr.getMonthlyWorkReport();
Assert.AreEqual(1, _ds.Tables[this.listTableName].Rows[0]["day"]);
Assert.AreEqual("日", _ds.Tables[this.listTableName].Rows[0]["week"]);
Assert.AreEqual(31, _ds.Tables[this.listTableName].Rows[30]["day"]);
Assert.AreEqual(31, _ds.Tables[this.listTableName].Rows.Count);
_mr.setMonth(2);
_ds = _mr.getMonthlyWorkReport();
Assert.AreEqual(1, _ds.Tables[this.listTableName].Rows[0]["day"]);
Assert.AreEqual("土", _ds.Tables[this.listTableName].Rows[0]["week"]);
Assert.AreEqual(28, _ds.Tables[this.listTableName].Rows[27]["day"]);
Assert.AreEqual(28, _ds.Tables[this.listTableName].Rows.Count);
}
public static A_MonthlyReport ToAModel(this MonthlyReport value)
{
A_MonthlyReport result = new A_MonthlyReport
{
ID = value.ID,
SystemID = value.SystemID,
Description = value.Description,
IsDeleted = value.IsDeleted,
FinMonth = value.FinMonth,
FinYear = value.FinYear,
CreateTime = value.CreateTime,
CreatorName = value.CreatorName,
ModifierName = value.ModifierName,
ModifyTime = value.ModifyTime,
Status = value.Status,
SystemBatchID = value.SystemBatchID
};
return(result);
}
public void RegisterInformationTest()
{
MonthlyReport monthlyReport = new MonthlyReport
{
IdMonthlyReport = 1,
DeliveryDate = DateTime.Now,
PerformedActivities = "Acordar con la organización vinculada las tareas que se realizarán",
ResultsObtained = "Documento de calendario de actividades",
HoursReported = 20,
HoursCumulative = 20,
Enrollment = "zS18012124",
IdProject = 1
};
_unitOfWork.MonthlyReports.Add(monthlyReport);
int expected = 2;
int actual = _monthlyReports.Count;
Assert.AreEqual(expected, actual);
}
public MonthlyReport DeepCopy()
{
MonthlyReport newReport = new MonthlyReport();
newReport.currentMonth = this.currentMonth;
newReport.restaurantTake = this.restaurantTake;
newReport.revenueRoomLvl1 = this.revenueRoomLvl1;
newReport.revenueRoomLvl2 = this.revenueRoomLvl2;
newReport.revenueRoomLvl3 = this.revenueRoomLvl3;
newReport.revenueRoomLvl4 = this.revenueRoomLvl4;
newReport.revenueRoomLvl5 = this.revenueRoomLvl5;
newReport.revenueConferences = this.revenueConferences;
newReport.revenueEvents = this.revenueEvents;
newReport.revenueGroups = this.revenueGroups;
newReport.restaurantCost = this.restaurantCost;
newReport.expenseDepartmentHeadStaff = this.expenseDepartmentHeadStaff;
newReport.expenseHotelServicesStaff = this.expenseHotelServicesStaff;
newReport.expenseFoodAndBeverageStaff = this.expenseFoodAndBeverageStaff;
newReport.expenseFrontDeskStaff = this.expenseFrontDeskStaff;
newReport.expenseConferenceStaff = this.expenseConferenceStaff;
newReport.expenseOtherStaff = this.expenseOtherStaff;
newReport.expenseRepairCost = this.expenseRepairCost;
newReport.expenseUpgradeCost = this.expenseUpgradeCost;
newReport.outOfOrderRepair = this.outOfOrderRepair;
newReport.outOfOrderUpgrade = this.outOfOrderUpgrade;
newReport.outOfOrderUnusable = this.outOfOrderUnusable;
newReport.numbDepartmentHead = this.numbDepartmentHead;
newReport.numbHotelServicesStaff = this.numbHotelServicesStaff;
newReport.numbFoodAndBeverageStaff = this.numbFoodAndBeverageStaff;
newReport.numbFrontDeskStaff = this.numbFrontDeskStaff;
newReport.numbConferenceStaff = this.numbConferenceStaff;
newReport.numbOtherStaff = this.numbOtherStaff;
newReport.numbRoomLvl1 = this.numbRoomLvl1;
newReport.numbRoomLvl2 = this.numbRoomLvl2;
newReport.numbRoomLvl3 = this.numbRoomLvl3;
newReport.numbRoomLvl4 = this.numbRoomLvl4;
newReport.numbRoomLvl5 = this.numbRoomLvl5;
newReport.numbRoomLvl1Booked = this.numbRoomLvl1Booked;
newReport.numbRoomLvl2Booked = this.numbRoomLvl2Booked;
newReport.numbRoomLvl3Booked = this.numbRoomLvl3Booked;
newReport.numbRoomLvl4Booked = this.numbRoomLvl4Booked;
newReport.numbRoomLvl5Booked = this.numbRoomLvl5Booked;
return newReport;
}
public void Add(MonthlyReport report)
{
monthlyReportList.Add(report);
}
//create monthly reports
public void GenerateNewMonthReports()
{
newMonthlyReport = new MonthlyReport(Calendar.GetDate());
monthlyReports.Add(newMonthlyReport);
//-----------------------------------------reception log
currentLog = new ReceptionLog();
currentLog = GameObject.FindGameObjectWithTag("RatesInput").GetComponent<RatesSetup>().newReceptionLog.DeepCopy();
//Adds a new ReceptionLog to the list and Reference to the log we're currently editing.
receptionLogs.Add (currentLog);
currentLog.month = receptionLogs.Count;
}
