//public GoalsDTO GetLast(DateTime date)
//{
//}
public void AddCurrentYearYTD(DateTime date, ArrayList storeList)
{
try
{
ArrayList ytdList = new ArrayList();
ArrayList list = new ArrayList();
ReportModel reportModel = new ReportModel();
GoalYTDDTO ytdDTO = new GoalYTDDTO();
bool isWeekExsist = false;
StoreDTO storeDTO = (StoreDTO)storeList[0];
WeeklyPaperworkModel model = new WeeklyPaperworkModel();
DateTime yearFirstWeekStartDate = ValidationUtility.YearWeekStartDate(date);
bool flag = model.IsWeeklyPaperExistIntoLocalDb(storeDTO.Id, yearFirstWeekStartDate);
ytdDTO.StoreId = storeDTO.Id;
ytdDTO.Year = date.Year;
ytdDTO.WeekStartDate = yearFirstWeekStartDate;
ytdDTO.WeekEndDate = yearFirstWeekStartDate.AddDays(6);
if (!flag)
{
model.AddWeeklyPaperWork(yearFirstWeekStartDate, storeList, true);
WeeklyPaperworkDTO dto = model.GetWeeklyPaperWorkOfWeek(storeDTO.Id, yearFirstWeekStartDate);
ytdDTO.FoodCost = dto.CostPercent;
ytdDTO.LaborCost = dto.LaborCostPercent;
ytdDTO.FoodLaborCost = dto.CostPercent + dto.LaborCostPercent;
}
else
{
WeeklyPaperworkDTO dto = model.GetWeeklyPaperWorkOfWeek(storeDTO.Id, yearFirstWeekStartDate);
ytdDTO.FoodCost = dto.CostPercent;
ytdDTO.LaborCost = dto.LaborCostPercent;
ytdDTO.FoodLaborCost = dto.CostPercent + dto.LaborCostPercent;
}
double totalsubWaySale = reportModel.TotalSabWaySaleOfYear(yearFirstWeekStartDate, yearFirstWeekStartDate.AddDays(6), storeDTO.ConnectionString);
ytdDTO.Auv = totalsubWaySale;
double totalDrinkSale = reportModel.TotalDrinkSale(yearFirstWeekStartDate, yearFirstWeekStartDate.AddDays(6), storeDTO.ConnectionString);
ytdDTO.DrinkCount = ValidationUtility.IsNan(totalDrinkSale / totalsubWaySale);
list = reportModel.GetSalesItemizationFoodLong(yearFirstWeekStartDate, storeDTO.ConnectionString);
ytdDTO.UnitFootlongSales = (double)list[0];
ytdDTO.FsPercent = ValidationUtility.IsNan(ytdDTO.UnitFootlongSales/ytdDTO.Auv);
ytdDTO.Unit = (double)list[1];
ytdDTO.Factor = (double)list[2];
ytdDTO.CustomerCount = (double)list[3];
ytdDTO.CheckItem = (double)list[4];
ytdDTO.Productivity = (double)list[5];
ytdDTO.HoursWorked = (double)list[6];
DateTime everyWeekStarDate = yearFirstWeekStartDate;
DateTime currenWeekStartDate = ValidationUtility.GetActualWeekStartDate(DateTime.Now);
ytdList.Add(ytdDTO);
while (!isWeekExsist)
{
ytdDTO = new GoalYTDDTO();
ytdDTO.StoreId = storeDTO.Id;
ytdDTO.Year = date.Year;
everyWeekStarDate = everyWeekStarDate.AddDays(7);
DateTime weekStartDate = ValidationUtility.GetActualWeekStartDate(everyWeekStarDate);
ytdDTO.WeekStartDate = weekStartDate;
ytdDTO.WeekEndDate = weekStartDate.AddDays(6);
flag = model.IsWeeklyPaperExistIntoLocalDb(storeDTO.Id, weekStartDate);
if (currenWeekStartDate.Date.Equals(weekStartDate.Date))
{
isWeekExsist = true;
if (!flag)
{
model.AddWeeklyPaperWork(weekStartDate, storeList, true);
WeeklyPaperworkDTO dto = model.GetWeeklyPaperWorkOfWeek(storeDTO.Id, weekStartDate);
ytdDTO.FoodCost = dto.CostPercent;
ytdDTO.LaborCost = dto.LaborCostPercent;
ytdDTO.FoodLaborCost = dto.CostPercent + dto.LaborCostPercent;
}
totalsubWaySale = reportModel.TotalSabWaySaleOfYear(weekStartDate, weekStartDate.AddDays(6), storeDTO.ConnectionString);
ytdDTO.Auv = totalsubWaySale;
totalDrinkSale = reportModel.TotalDrinkSale(weekStartDate, weekStartDate.AddDays(6), storeDTO.ConnectionString);
ytdDTO.DrinkCount = ValidationUtility.IsNan(totalDrinkSale / totalsubWaySale);
list = reportModel.GetSalesItemizationFoodLong(weekStartDate, storeDTO.ConnectionString);
ytdDTO.UnitFootlongSales = (double)list[0];
ytdDTO.FsPercent = ValidationUtility.IsNan(ytdDTO.UnitFootlongSales / ytdDTO.Auv);
ytdDTO.Unit = (double)list[1];
ytdDTO.Factor = (double)list[2];
ytdDTO.CustomerCount = (double)list[3];
ytdDTO.CheckItem = (double)list[4];
ytdDTO.Productivity = (double)list[5];
ytdDTO.HoursWorked = (double)list[6];
}
else
{
if (!flag)
{
model.AddWeeklyPaperWork(weekStartDate, storeList, true);
WeeklyPaperworkDTO dto = model.GetWeeklyPaperWorkOfWeek(storeDTO.Id, weekStartDate);
ytdDTO.FoodCost = dto.CostPercent;
ytdDTO.LaborCost = dto.LaborCostPercent;
ytdDTO.FoodLaborCost = dto.CostPercent + dto.LaborCostPercent;
}
totalsubWaySale= reportModel.TotalSabWaySaleOfYear(weekStartDate, weekStartDate.AddDays(6), storeDTO.ConnectionString);
ytdDTO.Auv = totalsubWaySale;
totalDrinkSale = reportModel.TotalDrinkSale(weekStartDate, weekStartDate.AddDays(6), storeDTO.ConnectionString);
ytdDTO.DrinkCount = ValidationUtility.IsNan(totalDrinkSale / totalsubWaySale);
list = reportModel.GetSalesItemizationFoodLong(weekStartDate, storeDTO.ConnectionString);
ytdDTO.UnitFootlongSales = (double)list[0];
ytdDTO.FsPercent = ValidationUtility.IsNan(ytdDTO.UnitFootlongSales / ytdDTO.Auv);
ytdDTO.Unit = (double)list[1];
ytdDTO.Factor = (double)list[2];
ytdDTO.CustomerCount = (double)list[3];
ytdDTO.CheckItem = (double)list[4];
ytdDTO.Productivity = (double)list[5];
ytdDTO.HoursWorked = (double)list[6];
}
ytdList.Add(ytdDTO);
}
AddGoalYTD(ytdList);
}
catch (Exception ex)
{
log.Error("Exception in AddCurrentYearYTD Method", ex);
}
}
public ArrayList GetControlSheetDataOfYear(DateTime date, ArrayList storeList)
{
ArrayList listItem = new ArrayList();
try
{
double totalFoodLong = 0;
double totalUnitSold = 0;
double totalFactor = 0;
double totalCustomerCount = 0;
double totalAverageTicket = 0;
double totalProductivity = 0;
bool isWeekExsist = false;
ArrayList list = null;
StoreDTO storeDTO = (StoreDTO)storeList[0];
ReportModel reportModel = new ReportModel();
DateTime yearFirstWeekDate = ValidationUtility.YearWeekStartDate(date);
DateTime yearLastWeekDate = ValidationUtility.GetActualWeekStartDate(new DateTime(date.Year, 12, 31));
ArrayList foodLaborCostList = GetYearlyFoodAndLaborCostPercent(yearFirstWeekDate, yearLastWeekDate.AddDays(6),storeDTO.Id);
double foodCost = (double)foodLaborCostList[0];
double laborCost = (double)foodLaborCostList[1];
double totalsubWaySale = reportModel.TotalSabWaySaleOfYear(yearFirstWeekDate, yearLastWeekDate.AddDays(6), storeDTO.ConnectionString);
double totalDrinkSale = reportModel.TotalDrinkSale(yearFirstWeekDate, yearLastWeekDate.AddDays(6), storeDTO.ConnectionString);
list = reportModel.GetSalesItemizationFoodLong(yearFirstWeekDate, storeDTO.ConnectionString);
totalFoodLong = (double)list[0];
totalUnitSold = (double)list[1];
totalFactor = (double)list[2];
totalCustomerCount = (double)list[3];
totalAverageTicket = (double)list[4];
totalProductivity = (double)list[5];
DateTime everyWeekStarDate = yearFirstWeekDate;
while (!isWeekExsist)
{
double total = 0;
double unitSold = 0;
double factor = 0;
double customerCount = 0;
double averageTicket = 0;
double productivity = 0;
everyWeekStarDate = everyWeekStarDate.AddDays(7);
DateTime weekStartDate = ValidationUtility.GetActualWeekStartDate(everyWeekStarDate);
if (yearLastWeekDate.Date.Equals(weekStartDate.Date))
{
isWeekExsist = true;
list = reportModel.GetSalesItemizationFoodLong(weekStartDate, storeDTO.ConnectionString);
total = (double)list[0];
unitSold = (double)list[1];
factor = (double)list[2];
customerCount = (double)list[3];
averageTicket = (double)list[4];
productivity = (double)list[5];
}
else
{
list = reportModel.GetSalesItemizationFoodLong(weekStartDate, storeDTO.ConnectionString);
total = (double)list[0];
unitSold = (double)list[1];
factor = (double)list[2];
customerCount = (double)list[3];
averageTicket = (double)list[4];
productivity = (double)list[5];
}
totalFoodLong = totalFoodLong + total;
totalUnitSold = totalUnitSold + unitSold;
totalFactor = totalFactor + factor;
totalCustomerCount = totalCustomerCount + customerCount;
totalAverageTicket = totalAverageTicket + averageTicket;
totalProductivity = totalProductivity + productivity;
}
listItem.Add(foodCost);
listItem.Add(laborCost);
listItem.Add(totalsubWaySale);
listItem.Add(totalFoodLong);
listItem.Add(totalDrinkSale);
listItem.Add(totalUnitSold);
listItem.Add(totalFactor);
listItem.Add(totalCustomerCount);
listItem.Add(totalAverageTicket);
listItem.Add(totalProductivity);
}
catch (Exception ex)
{
log.Error("Exception in GetControlSheetDataOfYear Method",ex);
}
return listItem;
}
public ArrayList GetCurrentWeekGoalsYTD(DateTime currentWeekStartDate, ArrayList storeList)
{
ArrayList currentYTDList = new ArrayList();
try
{
GoalYTDDTO ytdDTO = new GoalYTDDTO();
ReportModel reportModel = new ReportModel();
StoreDTO storeDTO = (StoreDTO)storeList[0];
WeeklyPaperworkModel model = new WeeklyPaperworkModel();
ytdDTO.StoreId = storeDTO.Id;
ytdDTO.Year = currentWeekStartDate.Year;
DateTime weekStartDate = ValidationUtility.GetActualWeekStartDate(currentWeekStartDate);
ytdDTO.WeekStartDate = weekStartDate;
ytdDTO.WeekEndDate = weekStartDate.AddDays(6);
bool flag = model.IsWeeklyPaperExistIntoLocalDb(storeDTO.Id, weekStartDate);
if (!flag)
{
model.AddWeeklyPaperWork(weekStartDate, storeList, true);
WeeklyPaperworkDTO dto = model.GetWeeklyPaperWorkOfWeek(storeDTO.Id, weekStartDate);
ytdDTO.FoodCost = dto.CostPercent;
ytdDTO.LaborCost = dto.LaborCostPercent;
ytdDTO.FoodLaborCost = dto.CostPercent + dto.LaborCostPercent;
}
else
{
WeeklyPaperworkDTO dto = model.GetWeeklyPaperWorkOfWeek(storeDTO.Id, weekStartDate);
ytdDTO.FoodCost = dto.CostPercent;
ytdDTO.LaborCost = dto.LaborCostPercent;
ytdDTO.FoodLaborCost = dto.CostPercent + dto.LaborCostPercent;
}
double totalsubWaySale = reportModel.TotalSabWaySaleOfYear(weekStartDate, weekStartDate.AddDays(6), storeDTO.ConnectionString);
ytdDTO.Auv = totalsubWaySale;
double totalDrinkSale = reportModel.TotalDrinkSale(weekStartDate, weekStartDate.AddDays(6), storeDTO.ConnectionString);
ytdDTO.DrinkCount = ValidationUtility.IsNan(totalDrinkSale / totalsubWaySale);
ArrayList list = reportModel.GetSalesItemizationFoodLong(weekStartDate, storeDTO.ConnectionString);
ytdDTO.UnitFootlongSales = (double)list[0];
ytdDTO.FsPercent = ValidationUtility.IsNan(ytdDTO.UnitFootlongSales/ytdDTO.Auv);
ytdDTO.Unit = (double)list[1];
ytdDTO.Factor = (double)list[2];
ytdDTO.CustomerCount = (double)list[3];
ytdDTO.CheckItem = (double)list[4];
ytdDTO.Productivity = (double)list[5];
ytdDTO.HoursWorked = (double)list[6];
currentYTDList.Add(ytdDTO);
}
catch (Exception ex)
{
log.Error("Exception in GetCurrentWeekGoalsYTD Method", ex);
}
return currentYTDList;
}