public static RFQLogModel DTO_to_Model(RFQ_LogDTO dto)
{
return(new RFQLogModel()
{
RFQLogNumber = dto.RFQLogNumber,
RequestType = dto.RequestType,
RequesterName = dto.RequesterName,
ReqesterEmail = dto.ReqesterEmail,
PurchasingEmail = dto.PurchasingEmail,
CustomerName = dto.CustomerName,
Division = dto.Division,
Program = dto.Program,
Reason = dto.Reason,
SOPDate = dto.SOPDate,
PPAPDate = dto.PPAPDate,
PartNumber = dto.PartNumber,
DrawingNumber = dto.DrawingNumber,
DrawingDate = dto.DrawingDate,
EngineeringLevel = dto.EngineeringLevel,
EstAnnualVolume = dto.EstAnnualVolume,
QuoteRequestDate = dto.QuoteRequestDate,
QuoteDueDate = dto.QuoteDueDate,
Status = dto.Status,
ClosedDate = dto.ClosedDate,
ParentAssembly = dto.ParentAssembly
});
}
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));
}
}
