//Get Data From server For Actual Value
public WeeklyPaperworkDTO GetWeeklyPaperWork(DateTime currentWeekStartDate, ArrayList storeList)
{
WeeklyPaperworkDTO dto = null;
try
{
ReportModel reportModel = new ReportModel();
StoreDTO storeDTO = (StoreDTO)storeList[0];
WeeklyPaperworkModel model = new WeeklyPaperworkModel();
DateTime weekStartDate = ValidationUtility.GetActualWeekStartDate(currentWeekStartDate);
bool flag = model.IsWeeklyPaperExistIntoLocalDb(storeDTO.Id, weekStartDate);
if (!flag)
{
model.AddWeeklyPaperWork(weekStartDate, storeList, true);
dto = model.GetWeeklyPaperWorkOfWeek(storeDTO.Id, weekStartDate);
}
else
{
dto = model.GetWeeklyPaperWorkOfWeek(storeDTO.Id, weekStartDate);
}
}
catch (Exception ex)
{
log.Error("Exception in GetCurrentWeekGoalsYTD Method", ex);
}
return dto;
}
//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 JsonResult UpdatePaperworkList(string id, string ar, string paidOuts, string pettyExpense, string storeTransfer, string pfg1, string pfg2, string coke, string laborCost, string taxPercent, string nonTaxableSale)
{
WeeklyPaperworkModel weeklyPaperworkModel = new WeeklyPaperworkModel();
GoalsModel goalsModel = new GoalsModel();
string error = "";
string msg = "";
try
{
WeeklyPaperworkDTO weeklyPaperworkDTO = new WeeklyPaperworkDTO();
weeklyPaperworkDTO.Id = ValidationUtility.ToInteger(id);
weeklyPaperworkDTO.Ar = ValidationUtility.ToDouble(ar);
weeklyPaperworkDTO.PaidOuts = ValidationUtility.ToDouble(paidOuts);
weeklyPaperworkDTO.PettyExpense = ValidationUtility.ToDouble(pettyExpense);
weeklyPaperworkDTO.StoreTransfer = ValidationUtility.ToDouble(storeTransfer);
weeklyPaperworkDTO.Pfg1 = ValidationUtility.ToDouble(pfg1);
weeklyPaperworkDTO.Pfg2 = ValidationUtility.ToDouble(pfg2);
weeklyPaperworkDTO.Coke = ValidationUtility.ToDouble(coke);
weeklyPaperworkDTO.LaborCost = ValidationUtility.ToDouble(laborCost);
weeklyPaperworkDTO.TaxPercent = ValidationUtility.ToDouble(taxPercent);
weeklyPaperworkDTO.NonTaxableSale = ValidationUtility.ToDouble(nonTaxableSale);
weeklyPaperworkModel.UpdateWeeklyPaperSales(weeklyPaperworkDTO);
weeklyPaperworkDTO = weeklyPaperworkModel.GetWeeklyPaperWorkOfWeek(ValidationUtility.ToInteger(id));
ArrayList goalStoreList = new ArrayList();
// ArrayList storeList = ValidationUtility.GetStoreList(true);
ArrayList storeList = ValidationUtility.GetActiveStoreList(true);
foreach (StoreDTO storDTO in storeList)
{
if (storDTO.Id == weeklyPaperworkDTO.StoreId)
{
goalStoreList.Add(storDTO);
break;
}
}
if (!goalsModel.IsGoalsYTDCurrentYearRecordExist(weeklyPaperworkDTO.WeekStartDate, goalStoreList))
{
ArrayList currentYTDList = goalsModel.GetCurrentWeekGoalsYTD(weeklyPaperworkDTO.WeekStartDate, goalStoreList);
goalsModel.AddGoalYTD(currentYTDList);
}
else
{
goalsModel.UpdateCurrentYTD(weeklyPaperworkDTO);
}
error = "Success";
msg = "Update Successfully";
}
catch (Exception ex)
{
error = "Error";
msg = " Not Update ";
log.Error("Exception in UpdatePaperworkList ", ex);
}
ResponseDTO resDTO = new ResponseDTO { Error = error, Message = msg };
return Json(resDTO, JsonRequestBehavior.AllowGet);
}
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;
}