public HttpResponseMessage WeekDataChart()
{
//string key;
//var ur = new AppUserRepository();
//var AbsenceId = 0;
//var userId = ur.ValidateUser(uDto.Key, out key, ref AbsenceId);
//AppUserRoleRepository aur = new AppUserRoleRepository();
//if (userId > 0)
//{
var wer = new AD_WeekDataRepository();
//var WeekEndDate = DateTime.Parse(uDto.AD_WeekEnd);
var data = wer.GetYTDGroup();
//var data2 = wer.GetYTDProduct();
//if (data.Count == 0)
//{
// var prodData = wer.GetAllProducts();
// foreach (var prod in prodData)
// {
// var wkData = new AD_WeekData();
// wkData.AD_ProductID = prod;
// wkData.AD_WeekEnd = WeekEndDate;
// wer.Save(wkData);
// }
// data = wer.GetByDate(WeekEndDate);
//}
//var col = new Collection<Dictionary<string, string>>();
//data = data.OrderBy(x => x.AD_Products.AD_GroupID).ToList();
//foreach (var wd in data)
//{
// var dic = new Dictionary<string, string>();
// dic.Add("AD_ProductID", wd.AD_ProductID.ToString());
// dic.Add("ProductName", wd.AD_Products.AD_ProductName);
// dic.Add("BudgetLbs", wd.AD_BudgetLbs != null ? wd.AD_BudgetLbs.ToString() : "0");
// dic.Add("BudgetDollars", wd.AD_BudgetDollars != null ? wd.AD_BudgetDollars.ToString() : "0");
// dic.Add("ActualLbs", wd.AD_ActualLbs != null ? wd.AD_ActualLbs.ToString() : "0");
// dic.Add("ActualDollars", wd.AD_ActualDollars != null ? wd.AD_ActualDollars.ToString() : "0");
// dic.Add("AD_WeekDataID", wd.AD_WeekDataID.ToString());
// col.Add(dic);
//}
//var retVal = new GenericDTO
//{
// //Key = key,
// ReturnData = col
//};
return(Request.CreateResponse(HttpStatusCode.OK, data));
//}
//var message = "validation failed";
//return Request.CreateResponse(HttpStatusCode.NotFound, message);
}
public HttpResponseMessage YTDSales()
{
var wer = new AD_WeekDataRepository();
var data = wer.GetYTDSales();
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
public HttpResponseMessage AvgSellingPrice()
{
var wer = new AD_WeekDataRepository();
var data = wer.GetAvgSellingPrice();
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
public HttpResponseMessage WeekDataAddOrEdit([FromBody] WeekDataDTO uDto)
{
string key;
var ur = new AppUserRepository();
var AbsenceId = 0;
var userId = ur.ValidateUser(uDto.Key, out key, ref AbsenceId);
AppUserRoleRepository aur = new AppUserRoleRepository();
if (userId > 0)
{
var wer = new AD_WeekDataRepository();
var WeekEndDate = DateTime.Parse(uDto.AD_WeekEnd);
var data = wer.GetByDate(WeekEndDate);
if (data.Count == 0)
{
var prodData = wer.GetAllProducts();
foreach (var prod in prodData)
{
var wkData = new AD_WeekData();
wkData.AD_ProductID = prod;
wkData.AD_WeekEnd = WeekEndDate;
wer.Save(wkData);
}
data = wer.GetByDate(WeekEndDate);
}
var col = new Collection <Dictionary <string, string> >();
data = data.OrderBy(x => x.AD_Products.AD_GroupID).ToList();
foreach (var wd in data)
{
var dic = new Dictionary <string, string>();
dic.Add("AD_ProductID", wd.AD_ProductID.ToString());
dic.Add("ProductName", wd.AD_Products.AD_ProductName);
dic.Add("BudgetLbs", wd.AD_BudgetLbs != null ? wd.AD_BudgetLbs.ToString() : "0");
dic.Add("BudgetDollars", wd.AD_BudgetDollars != null ? wd.AD_BudgetDollars.ToString() : "0");
dic.Add("ActualLbs", wd.AD_ActualLbs != null ? wd.AD_ActualLbs.ToString() : "0");
dic.Add("ActualDollars", wd.AD_ActualDollars != null ? wd.AD_ActualDollars.ToString() : "0");
dic.Add("AD_WeekDataID", wd.AD_WeekDataID.ToString());
col.Add(dic);
}
var retVal = new GenericDTO
{
Key = key,
ReturnData = col
};
return(Request.CreateResponse(HttpStatusCode.OK, retVal));
}
var message = "validation failed";
return(Request.CreateResponse(HttpStatusCode.NotFound, message));
}
public HttpResponseMessage SalesStats()
{
var wer = new AD_WeekDataRepository();
var data = wer.GetSalesStats();
data.TopCustomer = "Harper";
data.TopCustomerDollars = 345.67M;
data.TopProduct = "1/2 lb Fillet";
data.TopProductDollars = 987.90M;
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
public HttpResponseMessage ChangeWeekDataProperty(HttpRequestMessage request, WeekDataDTO cqDTO)
{
string key;
var ur = new AppUserRepository();
var CompanyId = 0;
var userId = ur.ValidateUser(cqDTO.Key, out key, ref CompanyId);
AppUserRoleRepository aur = new AppUserRoleRepository();
if (userId > 0)
{
var sor = new AD_WeekDataRepository();
var data = sor.GetById(int.Parse(cqDTO.AD_WeekDataID));
if (cqDTO.AD_BudgetLbs != null)
{
data.AD_BudgetLbs = int.Parse(cqDTO.AD_BudgetLbs);
}
if (cqDTO.AD_BudgetDollars != null)
{
data.AD_BudgetDollars = decimal.Parse(cqDTO.AD_BudgetDollars);
}
if (cqDTO.AD_ActualLbs != null)
{
data.AD_ActualLbs = int.Parse(cqDTO.AD_ActualLbs);
}
if (cqDTO.AD_ActualDollars != null)
{
data.AD_ActualDollars = decimal.Parse(cqDTO.AD_ActualDollars);
}
sor.Save(data);
return(Request.CreateResponse(HttpStatusCode.OK, "Success"));
}//}
var message = "validation failed";
return(request.CreateResponse(HttpStatusCode.NotFound, message));
}
internal HttpResponseMessage WeekDataDates(HttpRequestMessage request, WeekDataDTO cqDTO)
{
string key;
var aur = new AppUserRepository();
var companyId = 0;
var userId = aur.ValidateUser(cqDTO.Key, out key, ref companyId);
if (userId > 0)
{
var ur = new AD_WeekDataRepository();
if (cqDTO.AD_WeekEnd != null)
{
cqDTO.Start_WeekDataDate = DateTime.Parse(cqDTO.AD_WeekEnd).ToString();
cqDTO.End_WeekDataDate = DateTime.Parse(cqDTO.AD_WeekEnd).AddDays(1).ToString();
}
else
{
int sm = int.Parse(cqDTO.StartDateMonth);
if (sm == 1)
{
cqDTO.Start_WeekDataDate = DateTime.Parse("12/23/" + (int.Parse(cqDTO.StartDateYear) - 1).ToString()).ToString();
cqDTO.End_WeekDataDate = DateTime.Parse("2/14/" + cqDTO.StartDateYear).ToString();
}
else if (sm == 12)
{
cqDTO.Start_WeekDataDate = DateTime.Parse("11/23/" + cqDTO.StartDateYear).ToString();
cqDTO.End_WeekDataDate = DateTime.Parse("1/14/" + (int.Parse(cqDTO.StartDateYear) + 1).ToString()).ToString();
}
else
{
cqDTO.Start_WeekDataDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) - 1).ToString() + "/23/" + cqDTO.StartDateYear).ToString();
cqDTO.End_WeekDataDate = DateTime.Parse((int.Parse(cqDTO.StartDateMonth) + 1).ToString() + "/14/" + cqDTO.StartDateYear).ToString();
}
cqDTO.StartDateMonth = null;
cqDTO.StartDateYear = null;
}
var data = ur.GetByDateRange(DateTime.Parse(cqDTO.Start_WeekDataDate), DateTime.Parse(cqDTO.End_WeekDataDate));
var col = new Collection <Dictionary <string, string> >();
//data = data.GroupBy(x => x.AbsenceDate).Select(x => x.First()).OrderBy(x => x.AbsenceDate).ToList();
foreach (var item in data)
{
var dic = new Dictionary <string, string>();
dic.Add("WeekDataDate", item.AD_WeekEnd.Value.ToShortDateString());
col.Add(dic);
var ufdic = new Dictionary <string, string>();
}
var retVal = new GenericDTO
{
Key = key,
ReturnData = col
};
return(Request.CreateResponse(HttpStatusCode.OK, retVal));
}
var message = "validation failed";
return(request.CreateResponse(HttpStatusCode.NotFound, message));
}
