public static System.Web.WebPages.HelperResult RequestTypeName(RequestListModel model, RequestListRowModel r)
{
return(new System.Web.WebPages.HelperResult(__razor_helper_writer => {
#line 33 "..\..\App_Code\RequestHelpers.cshtml"
Lpp.Dns.Portal.PluginRequestType rt = model.AllRequestTypes[r.Request.RequestTypeID];
string name = rt.RequestType.Name;
#line default
#line hidden
WriteLiteralTo(@__razor_helper_writer, " <span title=\"");
#line 36 "..\..\App_Code\RequestHelpers.cshtml"
WriteTo(@__razor_helper_writer, name ?? "");
#line default
#line hidden
WriteLiteralTo(@__razor_helper_writer, "\">");
#line 36 "..\..\App_Code\RequestHelpers.cshtml"
WriteTo(@__razor_helper_writer, string.IsNullOrEmpty(name) ? "(unknown)" : name);
#line default
#line hidden
WriteLiteralTo(@__razor_helper_writer, "</span>\r\n");
#line 37 "..\..\App_Code\RequestHelpers.cshtml"
#line default
#line hidden
}));
}
public static System.Web.WebPages.HelperResult RequestTypeFilter(System.Web.Mvc.HtmlHelper html, RequestListModel model, Func <RequestListGetModel, string> reloadUrl)
{
return(new System.Web.WebPages.HelperResult(__razor_helper_writer => {
#line 17 "..\..\App_Code\RequestHelpers.cshtml"
var current = model.RequestTypeFilter;
#line default
#line hidden
WriteLiteralTo(@__razor_helper_writer, " <div class=\"ui-dropdown-button ui-has-hint FilterButton");
#line 20 "..\..\App_Code\RequestHelpers.cshtml"
WriteTo(@__razor_helper_writer, model.RequestTypeFilter == null ? "" : " Active");
#line default
#line hidden
WriteLiteralTo(@__razor_helper_writer, "\"\r\n hint-text=\"");
#line 21 "..\..\App_Code\RequestHelpers.cshtml"
WriteTo(@__razor_helper_writer, current == null ? "Filter by type" : "Showing " + current.RequestType.Name);
#line default
#line hidden
WriteLiteralTo(@__razor_helper_writer, "\"> </div>\r\n");
WriteLiteralTo(@__razor_helper_writer, " <div class=\"ui-dropdown ui-scrolling FilterOptions\" style=\"display: none\">\r\n");
#line 23 "..\..\App_Code\RequestHelpers.cshtml"
foreach (var rt in model.UsedRequestTypes.Select(rt => new RequestTypeFilterItem((PluginRequestType)rt)).OrderBy(rt => rt.Name).StartWith(new RequestTypeFilterItem()))
{
var m = model.List.OriginalRequest;
m.RequestTypeFilter = rt.ID;
#line default
#line hidden
WriteLiteralTo(@__razor_helper_writer, " <a href=\"");
#line 27 "..\..\App_Code\RequestHelpers.cshtml"
WriteTo(@__razor_helper_writer, html.Raw(reloadUrl(m)));
#line default
#line hidden
WriteLiteralTo(@__razor_helper_writer, "\" class=\"GridReloadLink");
#line 27 "..\..\App_Code\RequestHelpers.cshtml"
WriteTo(@__razor_helper_writer, rt.ID == model.List.OriginalRequest.RequestTypeFilter ? " Selected" : "");
#line default
#line hidden
WriteLiteralTo(@__razor_helper_writer, "\">");
#line 27 "..\..\App_Code\RequestHelpers.cshtml"
WriteTo(@__razor_helper_writer, rt.Name);
#line default
#line hidden
WriteLiteralTo(@__razor_helper_writer, "</a>\r\n");
#line 28 "..\..\App_Code\RequestHelpers.cshtml"
}
#line default
#line hidden
WriteLiteralTo(@__razor_helper_writer, " </div>\r\n");
#line 30 "..\..\App_Code\RequestHelpers.cshtml"
#line default
#line hidden
}));
}
public static System.Web.WebPages.HelperResult PageSizeSelector(System.Web.Mvc.HtmlHelper html, RequestListModel model, Func <RequestListGetModel, string> reloadUrl)
{
return(new System.Web.WebPages.HelperResult(__razor_helper_writer => {
#line 12 "..\..\App_Code\RequestHelpers.cshtml"
#line default
#line hidden
#line 13 "..\..\App_Code\RequestHelpers.cshtml"
WriteTo(@__razor_helper_writer, html.PageSizeSelector("requests", model.List, reloadUrl));
#line default
#line hidden
#line 13 "..\..\App_Code\RequestHelpers.cshtml"
#line default
#line hidden
}));
}
public string GenerateRequestListReport(Guid diaryId, DateTime date, int testingPeriod)
{
var diaryW = Db.Diaries.Where(x => x.Id == diaryId).Select(DiaryMappings.ToDiaryW).FirstOrDefault();
var acreditedItems = new List <RequestListModel>();
var notAcreditedItems = new List <RequestListModel>();
foreach (var product in diaryW.Products.OrderBy(dp => dp.Number))
{
if (product.ProductTests.Any(pt => pt.Test.AcredetationLevel.Level == AcreditationLevels.Acredited))
{
var item = new RequestListModel();
item.ProductNumber = product.Number;
item.ProductName = product.Name;
item.ProductTests = product.ProductTests
.Where(pt => pt.Test.AcredetationLevel.Level == AcreditationLevels.Acredited)
.Select(pt => new SubListModel()
{
TestType = pt.Test.TestType.ShortName,
TestName = pt.Test.Name,
Method = pt.TestMethod.Method,
MethodValue = pt.Test.MethodValue,
Remark = pt.Remark
})
.ToList();
acreditedItems.Add(item);
}
if (product.ProductTests.Any(pt => pt.Test.AcredetationLevel.Level == AcreditationLevels.NotAcredited))
{
var item = new RequestListModel();
item.ProductNumber = product.Number;
item.ProductName = product.Name;
item.ProductTests = product.ProductTests
.Where(pt => pt.Test.AcredetationLevel.Level == AcreditationLevels.NotAcredited)
.Select(pt => new SubListModel()
{
TestType = pt.Test.TestType.ShortName,
TestName = pt.Test.Name,
Method = pt.TestMethod.Method,
MethodValue = pt.Test.MethodValue,
Remark = pt.Remark
})
.ToList();
notAcreditedItems.Add(item);
}
}
string requestsGeneratedCount = string.Empty;
if (acreditedItems.Count > 0)
{
//GENERATE REQUEST A
var model = new ReportModel();
model.ReportParameters.Add("RequestNumber", AcreditationLevels.Acredited + diaryW.Number);
model.ReportParameters.Add("TestingPeriod", testingPeriod);
model.ReportParameters.Add("Date", date);
model.ReportItems = acreditedItems;
var report = new RequestListReport(model);
var data = report.GenerateReport();
//this is supposed to create all the necessary directories for the file.
CheckAndGenerateDirectories(diaryW.Number);
var fileProps = GetFileProperties(diaryW.Number, FileNames.RequestListReport, AcreditationLevels.Acredited);
if (File.Exists(fileProps.FullPath))
{
string newDestination = fileProps.FullPath.Substring(0, fileProps.FullPath.Length - 5) + "_" + DateTime.Now.ToString("dd_MM_yyyy_HH_mm_ss") + ".xlsx";
File.Move(fileProps.FullPath, newDestination);
}
var file = File.Create(fileProps.FullPath);
file.Write(data, 0, data.Length);
file.Close();
requestsGeneratedCount += "A";
}
if (notAcreditedItems.Count > 0)
{
//Generate Request B
var model = new ReportModel();
model.ReportParameters.Add("RequestNumber", AcreditationLevels.NotAcredited + diaryW.Number);
model.ReportParameters.Add("TestingPeriod", testingPeriod);
model.ReportParameters.Add("Date", date);
model.ReportItems = notAcreditedItems;
var report = new RequestListReport(model);
var data = report.GenerateReport();
//this is supposed to create all the necessary directories for the file.
CheckAndGenerateDirectories(diaryW.Number);
var fileProps = GetFileProperties(diaryW.Number, FileNames.RequestListReport, AcreditationLevels.NotAcredited);
if (File.Exists(fileProps.FullPath))
{
string newDestination = fileProps.FullPath.Substring(0, fileProps.FullPath.Length - 5) + "_" + DateTime.Now.ToString("dd_MM_yyyy_HH_mm_ss") + ".xlsx";
File.Move(fileProps.FullPath, newDestination);
}
var file = File.Create(fileProps.FullPath);
file.Write(data, 0, data.Length);
file.Close();
requestsGeneratedCount += "B";
}
return(requestsGeneratedCount);
}
public ActionResult List(int pageSize, int pageNumber, string orderField, string orderType)
{
var data = new CommonListData();
var direction = SortDirection.Desc;
if (orderType != null && orderType == "Asc")
{
direction = SortDirection.Asc;
}
var field = Field.Name;
if (orderField != null)
{
switch (orderField)
{
case "Name":
field = Field.Name;
break;
case "Description":
field = Field.Description;
break;
case "Status":
field = Field.Status;
break;
case "Date":
field = Field.Date;
break;
case "Rating":
field = Field.Rating;
break;
case "Views":
field = Field.Views;
break;
default:
field = Field.Name;
break;
}
}
data.OrderBy = new OrderByInfo {
Direction = direction, Field = field
};
if (pageSize != 0)
{
data.PageSize = pageSize;
}
if (pageNumber != 0)
{
data.PageNumber = pageNumber;
}
Session["RequestListData"] = data;
var model = new RequestListModel(data);
return(View(model));
}
public ActionResult Index()
{
var model = new RequestListModel();
return(View(model));
}
// GET: Options/ReportingOptions
public ActionResult Index()
{
int siteCoID = base.siteusercompanyid;
ViewBag.CoReports = db.GetReportsBySiteCoID(siteCoID);
var projects = db.GetProjectsBySiteCoID(siteCoID);
var workorders = new List <WorkOrderListModel>();
var pors = new List <PorListModel>();
var deliveries = new List <DeliveryListModel>();
var requests = new List <RequestListModel>();
foreach (var item in projects)
{
var workorder_list = db.GetProjectWorkByProjectID(item.ViewID);
var por_list = db.GetProjectPorListByProjectID(item.ViewID);
var delivery_list = db.GetProjectDeliveryListByProjectID(item.ViewID);
var request_list = db.GetProjectCorByProjectID(item.ViewID);
foreach (var value in workorder_list)
{
var record = new WorkOrderListModel()
{
Name = value.WO_,
ViewID = value.ViewID
};
workorders.Add(record);
}
foreach (var value in por_list)
{
var record = new PorListModel()
{
Name = value.Por_,
ViewID = value.ViewID
};
pors.Add(record);
}
foreach (var value in delivery_list)
{
var record = new DeliveryListModel()
{
Name = value.Delivery_,
ViewID = value.ViewID
};
deliveries.Add(record);
}
foreach (var value in request_list)
{
var record = new RequestListModel()
{
Name = value.Name,
ViewID = value.View
};
requests.Add(record);
}
}
ViewBag.WorkOrderList = workorders;
ViewBag.PorList = pors;
ViewBag.DeliveryList = deliveries;
ViewBag.RequestList = requests;
return(View());
}