public async Task <ActionResult> Report(string month)
{
RFQStatsListModel statsModel_Weekly;
try
{
RFQLogServices srv = new RFQLogServices();
DateTime current = DateTime.Now;
DateTime test = new DateTime(current.Year, 2, current.Day);
RFQ_StatsListDTO weeklyStats = await srv.GetStatsForGivenMonth_Weekly(test);
statsModel_Weekly = new RFQStatsListModel();
List <RFQStatsModel> rfqStatsModels = new List <RFQStatsModel>();
if (weeklyStats.stats.Count > 0)
{
for (int index = 0; index < weeklyStats.stats.Count; ++index)
{
rfqStatsModels.Add(new RFQStatsModel()
{
DateName = "Week " + (object)weeklyStats.stats[index].DatedIndex,
OpenRFQs = weeklyStats.stats[index].OpenRFQs,
LateRFQs = weeklyStats.stats[index].LateRFQs,
PercentageRFQsCompleted = "nil",
AvgDaysToComplete = string.Format("{0:0.0}", (object)weeklyStats.stats[index].AvgDaysToComplete)
});
}
}
statsModel_Weekly.StatsList = rfqStatsModels;
}
catch
{
return((ActionResult)this.PartialView());
}
return((ActionResult)this.PartialView((object)statsModel_Weekly));
}
public async Task <ActionResult> CompletedLastWeek()
{
try
{
RFQLogServices srv = new RFQLogServices();
List <RFQ_LogDTO> rfqDTOs = await srv.GetCompletedLastWeek();
RFQLogListModel completedLW_List = new RFQLogListModel();
if (rfqDTOs.Count > 0)
{
for (int index = 0; index < rfqDTOs.Count; ++index)
{
completedLW_List.RFQs.Add(new RFQLogModel()
{
RFQLogNumber = rfqDTOs[index].RFQLogNumber,
CustomerName = rfqDTOs[index].CustomerName,
Division = rfqDTOs[index].Division,
Reason = rfqDTOs[index].Reason,
Program = rfqDTOs[index].Program,
SOPDate = rfqDTOs[index].SOPDate,
PPAPDate = rfqDTOs[index].PPAPDate,
PartNumber = rfqDTOs[index].PartNumber,
DrawingNumber = rfqDTOs[index].DrawingNumber,
DrawingDate = rfqDTOs[index].DrawingDate,
EngineeringLevel = rfqDTOs[index].EngineeringLevel,
EstAnnualVolume = rfqDTOs[index].EstAnnualVolume,
QuoteDueDate = rfqDTOs[index].QuoteDueDate,
QuoteRequestDate = rfqDTOs[index].QuoteRequestDate,
RequesterName = rfqDTOs[index].RequesterName,
RequestType = rfqDTOs[index].RequestType,
ClosedDate = rfqDTOs[index].ClosedDate,
Status = rfqDTOs[index].Status
});
}
}
this.Session["recordsReturned"] = (object)completedLW_List.RFQs.Count;
return((ActionResult)this.View((object)completedLW_List));
}
catch
{
return((ActionResult)this.View());
}
}
public async Task <ActionResult> PassedDueLastWeek()
{
try
{
RFQLogServices srv = new RFQLogServices();
List <RFQ_LogDTO> rfqDTOs = await srv.GetPassedDueLastWeek();
RFQLogListModel completedLW_List = new RFQLogListModel();
if (rfqDTOs.Count > 0)
{
for (int index = 0; index < rfqDTOs.Count; ++index)
{
RFQLogModel rfqLogModel = new RFQLogModel();
rfqLogModel.RFQLogNumber = rfqDTOs[index].RFQLogNumber;
rfqLogModel.CustomerName = rfqDTOs[index].CustomerName;
rfqLogModel.Division = rfqDTOs[index].Division;
rfqLogModel.Reason = rfqDTOs[index].Reason;
rfqLogModel.Program = rfqDTOs[index].Program;
rfqLogModel.SOPDate = rfqDTOs[index].SOPDate;
rfqLogModel.PPAPDate = rfqDTOs[index].PPAPDate;
rfqLogModel.PartNumber = rfqDTOs[index].PartNumber;
rfqLogModel.DrawingNumber = rfqDTOs[index].DrawingNumber;
rfqLogModel.DrawingDate = rfqDTOs[index].DrawingDate;
rfqLogModel.EngineeringLevel = rfqDTOs[index].EngineeringLevel;
rfqLogModel.EstAnnualVolume = rfqDTOs[index].EstAnnualVolume;
rfqLogModel.QuoteDueDate = rfqDTOs[index].QuoteDueDate;
rfqLogModel.QuoteRequestDate = rfqDTOs[index].QuoteRequestDate;
rfqLogModel.RequesterName = rfqDTOs[index].RequesterName;
rfqLogModel.RequestType = rfqDTOs[index].RequestType;
DateTime?closedDate = rfqDTOs[index].ClosedDate;
rfqLogModel.ClosedDate = closedDate.HasValue ? rfqDTOs[index].ClosedDate : new DateTime?(new DateTime(1L));
rfqLogModel.Status = rfqDTOs[index].Status;
completedLW_List.RFQs.Add(rfqLogModel);
}
}
this.Session["recordsReturned"] = (object)completedLW_List.RFQs.Count;
return((ActionResult)this.View((object)completedLW_List));
}
catch
{
return((ActionResult)this.View());
}
}
public async Task <ActionResult> Index()
{
try
{
RFQLogServices srv = new RFQLogServices();
List <RFQ_LogDTO> rfqDTOs = await srv.GetAll();
RFQLogListModel allRFQs = new RFQLogListModel();
if (rfqDTOs.Count > 0)
{
for (int index = 0; index < rfqDTOs.Count; ++index)
{
RFQLogModel rfqLogModel = new RFQLogModel();
rfqLogModel.RFQLogNumber = rfqDTOs[index].RFQLogNumber;
rfqLogModel.CustomerName = rfqDTOs[index].CustomerName;
rfqLogModel.Division = rfqDTOs[index].Division;
rfqLogModel.Reason = rfqDTOs[index].Reason;
rfqLogModel.Program = rfqDTOs[index].Program;
rfqLogModel.SOPDate = rfqDTOs[index].SOPDate;
rfqLogModel.PPAPDate = rfqDTOs[index].PPAPDate;
rfqLogModel.PartNumber = rfqDTOs[index].PartNumber;
rfqLogModel.DrawingNumber = rfqDTOs[index].DrawingNumber;
rfqLogModel.DrawingDate = rfqDTOs[index].DrawingDate;
rfqLogModel.EngineeringLevel = rfqDTOs[index].EngineeringLevel;
rfqLogModel.EstAnnualVolume = rfqDTOs[index].EstAnnualVolume;
rfqLogModel.QuoteDueDate = rfqDTOs[index].QuoteDueDate;
rfqLogModel.QuoteRequestDate = rfqDTOs[index].QuoteRequestDate;
rfqLogModel.RequesterName = rfqDTOs[index].RequesterName;
rfqLogModel.RequestType = rfqDTOs[index].RequestType;
DateTime?closedDate = rfqDTOs[index].ClosedDate;
rfqLogModel.ClosedDate = closedDate.HasValue ? rfqDTOs[index].ClosedDate : new DateTime?(new DateTime(1L));
rfqLogModel.Status = rfqDTOs[index].Status;
allRFQs.RFQs.Add(rfqLogModel);
}
}
List <string> requesters = await srv.GetDropDownFieldValues_CustomQuery("HRDB", "FullName", "SELECT RTRIM(LTRIM(firstname)) + ' ' + RTRIM(LTRIM(lastname)) AS FullName FROM tbl_employees WHERE paystatus = 'A' ORDER BY FullName");
requesters.Insert(0, "PLEASE SELECT");
// ISSUE: reference to a compiler-generated field
if (SearchController.\u003CIndex\u003Eo__SiteContainer0.\u003C\u003Ep__Site1 == null)
{
// ISSUE: reference to a compiler-generated field
SearchController.\u003CIndex\u003Eo__SiteContainer0.\u003C\u003Ep__Site1 = CallSite <Func <CallSite, object, List <string>, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "Requesters", typeof(SearchController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj1 = SearchController.\u003CIndex\u003Eo__SiteContainer0.\u003C\u003Ep__Site1.Target((CallSite)SearchController.\u003CIndex\u003Eo__SiteContainer0.\u003C\u003Ep__Site1, this.ViewBag, requesters);
List <string> customers = await srv.GetDropDownFieldValues("COMP", "vCustomers", "shortname", "ORDER BY [shortname]");
customers.Insert(0, "PLEASE SELECT");
// ISSUE: reference to a compiler-generated field
if (SearchController.\u003CIndex\u003Eo__SiteContainer0.\u003C\u003Ep__Site2 == null)
{
// ISSUE: reference to a compiler-generated field
SearchController.\u003CIndex\u003Eo__SiteContainer0.\u003C\u003Ep__Site2 = CallSite <Func <CallSite, object, List <string>, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "CustomerNames", typeof(SearchController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj2 = SearchController.\u003CIndex\u003Eo__SiteContainer0.\u003C\u003Ep__Site2.Target((CallSite)SearchController.\u003CIndex\u003Eo__SiteContainer0.\u003C\u003Ep__Site2, this.ViewBag, customers);
List <string> divisions = await srv.GetDropDownFieldValues("HRDB", "tbl_division", "division", "WHERE active = 1");
divisions.Insert(0, "PLEASE SELECT");
// ISSUE: reference to a compiler-generated field
if (SearchController.\u003CIndex\u003Eo__SiteContainer0.\u003C\u003Ep__Site3 == null)
{
// ISSUE: reference to a compiler-generated field
SearchController.\u003CIndex\u003Eo__SiteContainer0.\u003C\u003Ep__Site3 = CallSite <Func <CallSite, object, List <string>, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "Divisions", typeof(SearchController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj3 = SearchController.\u003CIndex\u003Eo__SiteContainer0.\u003C\u003Ep__Site3.Target((CallSite)SearchController.\u003CIndex\u003Eo__SiteContainer0.\u003C\u003Ep__Site3, this.ViewBag, divisions);
this.ViewData["SearchResults"] = (object)allRFQs;
return((ActionResult)this.View());
}
catch
{
return((ActionResult)this.View());
}
}
public async Task <ActionResult> Index(RFQLogModel searchCriteria)
{
RFQLogServices srv = new RFQLogServices();
List <string> requesters = await srv.GetDropDownFieldValues_CustomQuery("HRDB", "FullName", "SELECT RTRIM(LTRIM(firstname)) + ' ' + RTRIM(LTRIM(lastname)) AS FullName FROM tbl_employees WHERE paystatus = 'A' ORDER BY FullName");
requesters.Insert(0, "PLEASE SELECT");
// ISSUE: reference to a compiler-generated field
if (SearchController.\u003CIndex\u003Eo__SiteContainere.\u003C\u003Ep__Sitef == null)
{
// ISSUE: reference to a compiler-generated field
SearchController.\u003CIndex\u003Eo__SiteContainere.\u003C\u003Ep__Sitef = CallSite <Func <CallSite, object, List <string>, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "Requesters", typeof(SearchController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj1 = SearchController.\u003CIndex\u003Eo__SiteContainere.\u003C\u003Ep__Sitef.Target((CallSite)SearchController.\u003CIndex\u003Eo__SiteContainere.\u003C\u003Ep__Sitef, this.ViewBag, requesters);
List <string> customers = await srv.GetDropDownFieldValues("COMP", "vCustomers", "shortname", "ORDER BY [shortname]");
customers.Insert(0, "PLEASE SELECT");
// ISSUE: reference to a compiler-generated field
if (SearchController.\u003CIndex\u003Eo__SiteContainere.\u003C\u003Ep__Site10 == null)
{
// ISSUE: reference to a compiler-generated field
SearchController.\u003CIndex\u003Eo__SiteContainere.\u003C\u003Ep__Site10 = CallSite <Func <CallSite, object, List <string>, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "CustomerNames", typeof(SearchController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj2 = SearchController.\u003CIndex\u003Eo__SiteContainere.\u003C\u003Ep__Site10.Target((CallSite)SearchController.\u003CIndex\u003Eo__SiteContainere.\u003C\u003Ep__Site10, this.ViewBag, customers);
List <string> divisions = await srv.GetDropDownFieldValues("HRDB", "tbl_division", "division", "WHERE active = 1");
divisions.Insert(0, "PLEASE SELECT");
// ISSUE: reference to a compiler-generated field
if (SearchController.\u003CIndex\u003Eo__SiteContainere.\u003C\u003Ep__Site11 == null)
{
// ISSUE: reference to a compiler-generated field
SearchController.\u003CIndex\u003Eo__SiteContainere.\u003C\u003Ep__Site11 = CallSite <Func <CallSite, object, List <string>, object> > .Create(Binder.SetMember(CSharpBinderFlags.None, "Divisions", typeof(SearchController), (IEnumerable <CSharpArgumentInfo>) new CSharpArgumentInfo[2]
{
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.None, (string)null),
CSharpArgumentInfo.Create(CSharpArgumentInfoFlags.UseCompileTimeType, (string)null)
}));
}
// ISSUE: reference to a compiler-generated field
// ISSUE: reference to a compiler-generated field
object obj3 = SearchController.\u003CIndex\u003Eo__SiteContainere.\u003C\u003Ep__Site11.Target((CallSite)SearchController.\u003CIndex\u003Eo__SiteContainere.\u003C\u003Ep__Site11, this.ViewBag, divisions);
RFQ_LogDTO searchDTO = new RFQ_LogDTO();
searchDTO.CustomerName = !(searchCriteria.CustomerName != "PLEASE SELECT") ? (string)null : searchCriteria.CustomerName;
searchDTO.Division = !(searchCriteria.Division != "PLEASE SELECT") ? (string)null : searchCriteria.Division;
searchDTO.Program = !(searchCriteria.Program != "PLEASE SELECT") ? (string)null : searchCriteria.Program;
searchDTO.Reason = !(searchCriteria.Reason != "PLEASE SELECT") ? (string)null : searchCriteria.Reason;
searchDTO.PartNumber = !(searchCriteria.PartNumber != "PLEASE SELECT") ? (string)null : searchCriteria.PartNumber;
searchDTO.DrawingNumber = !(searchCriteria.DrawingNumber != "PLEASE SELECT") ? (string)null : searchCriteria.DrawingNumber;
searchDTO.EngineeringLevel = !(searchCriteria.EngineeringLevel != "PLEASE SELECT") ? (string)null : searchCriteria.EngineeringLevel;
searchDTO.RequesterName = !(searchCriteria.RequesterName != "PLEASE SELECT") ? (string)null : searchCriteria.RequesterName;
searchDTO.Status = !(searchCriteria.Status != "ALL") ? "ALL" : searchCriteria.Status;
searchDTO.RequestType = !(searchCriteria.RequestType != "ALL") ? "ALL" : searchCriteria.RequestType;
try
{
if (searchDTO.RequesterName != null || searchDTO.CustomerName != null || (searchDTO.Division != null || searchDTO.RequestType != null) || searchDTO.Status != null)
{
List <RFQ_LogDTO> resultsReturned = await srv.CustomSearch(searchDTO);
RFQLogListModel results = new RFQLogListModel();
if (resultsReturned.Count > 0)
{
for (int index = 0; index < resultsReturned.Count; ++index)
{
RFQLogModel rfqLogModel = new RFQLogModel();
rfqLogModel.RFQLogNumber = resultsReturned[index].RFQLogNumber;
rfqLogModel.CustomerName = resultsReturned[index].CustomerName;
rfqLogModel.Division = resultsReturned[index].Division;
rfqLogModel.Reason = resultsReturned[index].Reason;
rfqLogModel.Program = resultsReturned[index].Program;
rfqLogModel.SOPDate = resultsReturned[index].SOPDate;
rfqLogModel.PPAPDate = resultsReturned[index].PPAPDate;
rfqLogModel.PartNumber = resultsReturned[index].PartNumber;
rfqLogModel.DrawingNumber = resultsReturned[index].DrawingNumber;
rfqLogModel.DrawingDate = resultsReturned[index].DrawingDate;
rfqLogModel.EngineeringLevel = resultsReturned[index].EngineeringLevel;
rfqLogModel.EstAnnualVolume = resultsReturned[index].EstAnnualVolume;
rfqLogModel.QuoteDueDate = resultsReturned[index].QuoteDueDate;
rfqLogModel.QuoteRequestDate = resultsReturned[index].QuoteRequestDate;
rfqLogModel.RequesterName = resultsReturned[index].RequesterName;
rfqLogModel.RequestType = resultsReturned[index].RequestType;
DateTime?closedDate = resultsReturned[index].ClosedDate;
rfqLogModel.ClosedDate = closedDate.HasValue ? resultsReturned[index].ClosedDate : new DateTime?(new DateTime(1L));
rfqLogModel.Status = resultsReturned[index].Status;
results.RFQs.Add(rfqLogModel);
}
}
this.Session["recordsReturned"] = (object)results.RFQs.Count;
this.ViewData["SearchResults"] = (object)results;
return((ActionResult)this.View());
}
this.ViewData["SearchResults"] = (object)new RFQLogListModel()
{
RFQs =
{
new RFQLogModel()
{
RequesterName = "No Results Found",
QuoteRequestDate = new DateTime?(new DateTime(1L)),
QuoteDueDate = new DateTime?(new DateTime(1L)),
ClosedDate = new DateTime?(new DateTime(1L))
}
}
};
return((ActionResult)this.View());
}
catch (Exception ex)
{
return((ActionResult)this.View((object)ex));
}
}
public async Task <ActionResult> Index(string month)
{
int selectedMonth = 0;
selectedMonth = month == null ? DateTime.Now.Month : int.Parse(month);
try
{
RFQLogServices srv = new RFQLogServices();
RFQ_StatsListDTO monthlyStats = await srv.GetRFQStats_Monthly(DateTime.Now);
RFQStatsListModel statsModel_Monthly = new RFQStatsListModel();
List <RFQStatsModel> rfqStatsModels = new List <RFQStatsModel>();
if (monthlyStats.stats.Count > 0)
{
for (int index = 0; index < monthlyStats.stats.Count; ++index)
{
rfqStatsModels.Add(new RFQStatsModel()
{
DateName = DateTimeExtensions.GetMonthNameFromNumber(monthlyStats.stats[index].DatedIndex),
OpenRFQs = monthlyStats.stats[index].OpenRFQs,
LateRFQs = monthlyStats.stats[index].LateRFQs,
PercentageRFQsCompleted = string.Format("{0:0.0}", (object)monthlyStats.stats[index].PercentRFQsCompletedOnTime),
AvgDaysToComplete = string.Format("{0:0.0}", (object)monthlyStats.stats[index].AvgDaysToComplete),
DaysLate = monthlyStats.stats[index].DaysLate
});
}
}
if (monthlyStats.stats.Count < 12)
{
int num = 12 - monthlyStats.stats.Count;
for (int index = 0; index < num; ++index)
{
rfqStatsModels.Add(new RFQStatsModel());
}
}
statsModel_Monthly.StatsList = rfqStatsModels;
if (month == null)
{
this.Session["monthSelected"] = (object)0;
}
else
{
this.Session["monthSelected"] = (object)(int.Parse(month) - 1);
}
if (statsModel_Monthly.StatsList.Count > 0)
{
this.ViewData["Monthly"] = (object)statsModel_Monthly;
}
}
catch (Exception ex)
{
string message = ex.Message;
return((ActionResult)this.View());
}
try
{
DateTime current = DateTime.Now;
DateTime date = new DateTime(current.Year, selectedMonth, 1);
RFQLogServices srv = new RFQLogServices();
RFQ_StatsListDTO weeklyStats = await srv.GetStatsForGivenMonth_Weekly(date);
RFQStatsListModel statsModel_Weekly = new RFQStatsListModel();
List <RFQStatsModel> rfqStatsModels = new List <RFQStatsModel>();
if (weeklyStats.stats.Count > 0)
{
for (int index = 0; index < weeklyStats.stats.Count; ++index)
{
rfqStatsModels.Add(new RFQStatsModel()
{
DateName = "Week " + (object)weeklyStats.stats[index].DatedIndex,
OpenRFQs = weeklyStats.stats[index].OpenRFQs,
LateRFQs = weeklyStats.stats[index].LateRFQs,
PercentageRFQsCompleted = string.Format("{0:0.00}", (object)weeklyStats.stats[index].PercentRFQsCompletedOnTime),
AvgDaysToComplete = string.Format("{0:0.0}", (object)weeklyStats.stats[index].AvgDaysToComplete),
DaysLate = weeklyStats.stats[index].DaysLate
});
}
}
statsModel_Weekly.StatsList = rfqStatsModels;
this.Session["monthName"] = (object)date.ToString("MMMM", (IFormatProvider)CultureInfo.CurrentCulture);
this.ViewData["Weekly"] = (object)statsModel_Weekly;
}
catch
{
return((ActionResult)this.View());
}
return((ActionResult)this.View());
}
public RFQLogModel()
{
this._dal = new RFQLogServices();
this.Filenames = new List <string>();
this.PostedFiles = new List <HttpPostedFileBase>();
}