/// <summary>
/// Returns a Data Set containing multiple Data Tables reresenting sub-reports table structures.
/// </summary>
/// <param name="parameters"></param>
/// <returns></returns>
public static DataSet ACGReport(ReportParameters parameters)
{
OApplicationSetting appconfig = OApplicationSetting.Current;
DataSet ACGDataSet = new DataSet("ACG Report");
DateTime? filterYTD = parameters.GetDateTime("FILTER_YTD");
DateTime YTD = (filterYTD != null) ? filterYTD.Value : DateTime.Now;
Guid filterLocation = new Guid(parameters.GetString("FILTER_Location"));
OLocation location = TablesLogic.tLocation.Load(filterLocation);
DataTable LocationName = new DataTable();
LocationName.Columns.Add("Location", typeof(string));
LocationName.Rows.Add(location.ObjectName.ToUpper());
LocationName.TableName = "Location";
DataTable BudgetDetailSummaryRRAccounts = BudgetDetailSummaryReport(location, YTD, "Repairs & Replacements", true, 0);
DataTable BudgetDetailSummaryMiscAccounts = BudgetDetailSummaryReport(location, YTD, "Miscellaneous", false, 0);
DataTable BudgetDetailSummaryStatutoryAccounts = BudgetDetailSummaryReport(location, YTD, "Statutory Fee", true, 0);
DataTable BudgetDetailSummary = BudgetDetailSummaryRRAccounts.Clone();
BudgetDetailSummary.Merge(BudgetDetailSummaryRRAccounts);
BudgetDetailSummary.Merge(BudgetDetailSummaryMiscAccounts);
BudgetDetailSummary.Merge(BudgetDetailSummaryStatutoryAccounts);
DataTable BudgetDetailSummaryTenancyAccount = BudgetDetailSummaryReport(location, YTD, "Tenancy Works", false, 0);
BudgetDetailSummaryTenancyAccount.TableName = "BudgetDetailSummaryTenancyAccount";
DataTable BudgetDetailSummaryTermContractAccount = BudgetDetailSummaryReport(location, YTD, "Term Contract", true, 0);
BudgetDetailSummaryTermContractAccount.TableName = "BudgetDetailSummaryTermContractAccount";
DataTable Capex = CapexReport(location, YTD);
//DataTable PreventiveMaintenanceProgramme = PreventiveMaintenanceReport(YTD);
DataTable PreventiveMaintenanceProgramme = new DataTable("PreventiveMaintenanceProgramme");
DataTable ServiceContracts = ServiceContractsReport(location, YTD);
DataTable ServiceToTenants = ServiceToTenantsReport(location, YTD);
ACGDataSet.Tables.Add(BudgetDetailSummary);
ACGDataSet.Tables.Add(Capex);
ACGDataSet.Tables.Add(PreventiveMaintenanceProgramme);
ACGDataSet.Tables.Add(ServiceContracts);
ACGDataSet.Tables.Add(ServiceToTenants);
ACGDataSet.Tables.Add(new DataTable("Dummy"));
ACGDataSet.Tables.Add(LocationName);
ACGDataSet.Tables.Add(BudgetDetailSummaryTenancyAccount);
ACGDataSet.Tables.Add(BudgetDetailSummaryTermContractAccount);
return ACGDataSet;
}
public static DataTable GetVendorReport(ReportParameters parameters)
{
DataTable dtReturn = new DataTable();
dtReturn.Columns.Add("Vendor Name", typeof(string));
dtReturn.Columns.Add("Vendor Type", typeof(string));
dtReturn.Columns.Add("Vendor Classification", typeof(string));
dtReturn.Columns.Add("Operation Address", typeof(string));
dtReturn.Columns.Add("Operation Cellphone", typeof(string));
dtReturn.Columns.Add("Operation Email", typeof(string));
dtReturn.Columns.Add("Operation Phone", typeof(string));
dtReturn.Columns.Add("Operation Contact Person", typeof(string));
dtReturn.Columns.Add("Debarred", typeof(string));
dtReturn.Columns.Add("Debarment Start", typeof(DateTime));
dtReturn.Columns["Debarment Start"].ExtendedProperties["DataFormatString"] = "{0:dd-MMM-yyyy}";
dtReturn.Columns.Add("Debarment End", typeof(DateTime));
dtReturn.Columns["Debarment End"].ExtendedProperties["DataFormatString"] = "{0:dd-MMM-yyyy}";
dtReturn.Columns.Add("Billing Location Contact Person", typeof(string));
dtReturn.Columns.Add("Billing Location Address", typeof(string));
dtReturn.Columns.Add("Billing Location Phone", typeof(string));
dtReturn.Columns.Add("Billing Location Country", typeof(string));
dtReturn.Columns.Add("Billing Location State", typeof(string));
dtReturn.Columns.Add("Billing Location City", typeof(string));
dtReturn.Columns.Add("Billing Location Cellphone", typeof(string));
dtReturn.Columns.Add("Billing Location Email", typeof(string));
dtReturn.Columns.Add("Billing Location Fax", typeof(string));
dtReturn.Columns.Add("Operation Location Country", typeof(string));
dtReturn.Columns.Add("Operation Location State", typeof(string));
dtReturn.Columns.Add("Operating Location City", typeof(string));
dtReturn.Columns.Add("Operation Location Fax", typeof(string));
DataTable dt = TablesLogic.tVendor.SelectDistinct(
TablesLogic.tVendor.ObjectID,
TablesLogic.tVendor.ObjectName,
TablesLogic.tVendor.VendorClassification.ObjectName.As("VendorClassification"),
TablesLogic.tVendor.OperatingAddress,
TablesLogic.tVendor.OperatingCellPhone,
TablesLogic.tVendor.OperatingEmail,
TablesLogic.tVendor.OperatingPhone,
TablesLogic.tVendor.OperatingContactPerson,
TablesLogic.tVendor.IsDebarred,
TablesLogic.tVendor.DebarmentStartDate,
TablesLogic.tVendor.DebarmentEndDate,
TablesLogic.tVendor.BillingContactPerson,
TablesLogic.tVendor.BillingAddress,
TablesLogic.tVendor.BillingPhone,
TablesLogic.tVendor.BillingAddressCountry,
TablesLogic.tVendor.BillingAddressState,
TablesLogic.tVendor.BillingAddressCity,
TablesLogic.tVendor.BillingCellPhone,
TablesLogic.tVendor.BillingEmail,
TablesLogic.tVendor.BillingFax,
TablesLogic.tVendor.OperatingAddressCountry,
TablesLogic.tVendor.OperatingAddressState,
TablesLogic.tVendor.OperatingAddressCity,
TablesLogic.tVendor.OperatingFax)
.Where(
TablesLogic.tVendor.IsDeleted == 0
& (parameters.GetString("FILTER_DEBARRED") == "" ? Query.True : TablesLogic.tVendor.IsDebarred == parameters.GetString("FILTER_DEBARRED"))
& (parameters.GetString("FILTER_DEBARMENTSTARTFROM") == "" ? Query.True : TablesLogic.tVendor.DebarmentStartDate >= parameters.GetDateTime("FILTER_DEBARMENTSTARTFROM"))
& (parameters.GetString("FILTER_DEBARMENTSTARTTO") == "" ? Query.True : TablesLogic.tVendor.DebarmentStartDate <= parameters.GetDateTime("FILTER_DEBARMENTSTARTTO"))
& (parameters.GetString("FILTER_DEBARMENTENDFROM") == "" ? Query.True : TablesLogic.tVendor.DebarmentEndDate >= parameters.GetDateTime("FILTER_DEBARMENTENDFROM"))
& (parameters.GetString("FILTER_DEBARMENTENDTO") == "" ? Query.True : TablesLogic.tVendor.DebarmentEndDate <= parameters.GetDateTime("FILTER_DEBARMENTENDTO"))
& TablesLogic.tVendor.OperatingAddress.Like("%" + parameters.GetString("FILTER_OPERATIONADDRESS") + "%")
& TablesLogic.tVendor.BillingAddress.Like("%" + parameters.GetString("FILTER_BILLINGADDRESS") + "%")
& TablesLogic.tVendor.ObjectName.Like("%" + parameters.GetString("FILTER_VENDORNAME") + "%")
& (parameters.GetString("FILTER_VENDORTYPE") == "" ? Query.True : TablesLogic.tVendor.VendorTypes.ObjectID == parameters.GetString("FILTER_VENDORTYPE"))
& (parameters.GetString("FILTER_VENDORCLASSIFICATION") == "" ? Query.True : TablesLogic.tVendor.VendorClassificationID == parameters.GetString("FILTER_VENDORCLASSIFICATION"))
);
foreach (DataRow row in dt.Rows)
{
DataRow returnRow = dtReturn.NewRow();
returnRow["Vendor Name"] = row["ObjectName"];
returnRow["Vendor Classification"] = row["VendorClassification"];
returnRow["Operation Address"] = row["OperatingAddress"];
returnRow["Operation Cellphone"] = row["OperatingCellPhone"];
returnRow["Operation Email"] = row["OperatingEmail"];
returnRow["Operation Phone"] = row["OperatingPhone"];
returnRow["Operation Contact Person"] = row["OperatingContactPerson"];
if (row["IsDebarred"].ToString() == "1")
returnRow["Debarred"] = "Yes";
if (row["IsDebarred"].ToString() == "0")
returnRow["Debarred"] = "No";
returnRow["Debarment Start"] = row["DebarmentStartDate"];
returnRow["Debarment End"] = row["DebarmentEndDate"];
returnRow["Billing Location Contact Person"] = row["BillingContactPerson"];
returnRow["Billing Location Address"] = row["BillingAddress"];
returnRow["Billing Location Phone"] = row["BillingPhone"];
returnRow["Billing Location Country"] = row["BillingAddressCountry"];
returnRow["Billing Location State"] = row["BillingAddressState"];
returnRow["Billing Location City"] = row["BillingAddressCity"];
returnRow["Billing Location Cellphone"] = row["BillingCellPhone"];
returnRow["Billing Location Email"] = row["BillingEmail"];
returnRow["Billing Location Fax"] = row["BillingFax"];
returnRow["Operation Location Country"] = row["OperatingAddressCountry"];
returnRow["Operation Location State"] = row["OperatingAddressState"];
returnRow["Operating Location City"] = row["OperatingAddressCity"];
returnRow["Operation Location Fax"] = row["OperatingFax"];
OVendor vendortype = TablesLogic.tVendor[new Guid(row["ObjectID"].ToString())];
string vendortypestring = "";
foreach (OCode codename in vendortype.VendorTypes)
{
vendortypestring = vendortypestring + codename.ObjectName + ", ";
}
if(vendortypestring != "")
returnRow["Vendor Type"] = vendortypestring.Remove(vendortypestring.Length - 2);
dtReturn.Rows.Add(returnRow);
}
return dtReturn;
}
public static DataTable GetContractReport(ReportParameters parameters)
{
DataTable dtReturn = new DataTable();
dtReturn.Columns.Add("Contract Name", typeof(string));
dtReturn.Columns["Contract Name"].ExtendedProperties["Width"] = "500px";
dtReturn.Columns.Add("Contract Description", typeof(string));
dtReturn.Columns["Contract Description"].ExtendedProperties["Width"] = "500px";
dtReturn.Columns.Add("Contract Start Date", typeof(DateTime));
dtReturn.Columns["Contract Start Date"].ExtendedProperties["DataFormatString"] = "{0:dd-MMM-yyyy}";
dtReturn.Columns.Add("Contract End Date", typeof(DateTime));
dtReturn.Columns["Contract End Date"].ExtendedProperties["DataFormatString"] = "{0:dd-MMM-yyyy}";
dtReturn.Columns.Add("Contract Terms", typeof(string));
dtReturn.Columns.Add("Contract Warranty", typeof(string));
dtReturn.Columns.Add("Contract Sum($)", typeof(decimal));
dtReturn.Columns.Add("Contract Manager", typeof(string));
dtReturn.Columns.Add("Contact Person Name", typeof(string));
dtReturn.Columns.Add("Contact Person Cellphone", typeof(string));
dtReturn.Columns.Add("Contact Person Email", typeof(string));
dtReturn.Columns.Add("Provide Adhoc Maintenance", typeof(string));
dtReturn.Columns.Add("Locations", typeof(string));
dtReturn.Columns["Locations"].ExtendedProperties["Width"] = "500px";
dtReturn.Columns.Add("Type of Services", typeof(string));
dtReturn.Columns["Type of Services"].ExtendedProperties["Width"] = "500px";
dtReturn.Columns.Add("Provide Purchasing Agreement", typeof(string));
dtReturn.Columns.Add("Materials Agreement", typeof(string));
dtReturn.Columns["Materials Agreement"].ExtendedProperties["Width"] = "500px";
dtReturn.Columns.Add("Service Agreement", typeof(string));
dtReturn.Columns["Service Agreement"].ExtendedProperties["Width"] = "800px";
dtReturn.Columns.Add("Vendor Name", typeof(string));
dtReturn.Columns.Add("Vendor Type", typeof(string));
dtReturn.Columns.Add("Vendor Classification", typeof(string));
dtReturn.Columns.Add("Contact Person Fax", typeof(string));
dtReturn.Columns.Add("Contact Person Phone", typeof(string));
dtReturn.Columns.Add("Person 1 To Remind", typeof(string));
dtReturn.Columns.Add("Person 2 To Remind", typeof(string));
dtReturn.Columns.Add("Person 3 To Remind", typeof(string));
dtReturn.Columns.Add("Person 4 To Remind", typeof(string));
dtReturn.Columns.Add("Reminder Days 1", typeof(int));
dtReturn.Columns.Add("Reminder Days 2", typeof(int));
dtReturn.Columns.Add("Reminder Days 3", typeof(int));
dtReturn.Columns.Add("Reminder Days 4", typeof(int));
ExpressionCondition cond = GetAccessibleCondition(parameters.GetString("UserID"),true, TablesLogic.tContract.Locations.HierarchyPath, "");
if (cond == null)
cond = Query.False;
DataTable dt = TablesLogic.tContract.SelectDistinct(TablesLogic.tContract.ObjectID,
TablesLogic.tContract.ObjectName,
TablesLogic.tContract.Description,
TablesLogic.tContract.ContractStartDate,
TablesLogic.tContract.ContractEndDate,
TablesLogic.tContract.Terms,
TablesLogic.tContract.Warranty,
TablesLogic.tContract.ContractSum,
TablesLogic.tContract.ContractManager.ObjectName.As("Manager"),
TablesLogic.tContract.ContactPerson,
TablesLogic.tContract.ContactCellphone,
TablesLogic.tContract.ContactPhone,
TablesLogic.tContract.ContactEmail,
TablesLogic.tContract.ContactFax,
TablesLogic.tContract.Reminder1User.ObjectName.As("User1"),
TablesLogic.tContract.Reminder2User.ObjectName.As("User2"),
TablesLogic.tContract.Reminder3User.ObjectName.As("User3"),
TablesLogic.tContract.Reminder4User.ObjectName.As("User4"),
TablesLogic.tContract.EndReminderDays1,
TablesLogic.tContract.EndReminderDays2,
TablesLogic.tContract.EndReminderDays3,
TablesLogic.tContract.EndReminderDays4,
TablesLogic.tContract.Vendor.ObjectName.As("Vendor"),
TablesLogic.tContract.Vendor.VendorClassification.ObjectName.As("VendorClassification"),
TablesLogic.tContract.ProvideMaintenance,
TablesLogic.tContract.ProvidePricingAgreement)
.Where(TablesLogic.tContract.IsDeleted == 0
& TablesLogic.tContract.ObjectName.Like("%" + parameters.GetString("FILTER_CONTRACTNAME") + "%")
& TablesLogic.tContract.Description.Like("%" + parameters.GetString("FILTER_DESCRIPTION") + "%")
& TablesLogic.tContract.Terms.Like("%" + parameters.GetString("FILTER_TERMS") + "%")
& TablesLogic.tContract.Insurance.Like("%" + parameters.GetString("FILTER_INSURANTCE") + "%")
& TablesLogic.tContract.Warranty.Like("%" + parameters.GetString("FILTER_WARRANTY") + "%")
& TablesLogic.tContract.Vendor.ObjectName.Like("%" + parameters.GetString("FILTER_VENDORNAME") + "%")
& (parameters.GetString("FILTER_CONTRACTSTARTFROM") == "" ? Query.True :
TablesLogic.tContract.ContractStartDate >= parameters.GetDateTime("FILTER_CONTRACTSTARTFROM"))
& (parameters.GetString("FILTER_CONTRACTSTARTTO") == "" ? Query.True :
TablesLogic.tContract.ContractStartDate < parameters.GetDateTime("FILTER_CONTRACTSTARTTO").Value.AddDays(1))
& (parameters.GetString("FILTER_CONTRACTENDFROM") == "" ? Query.True :
TablesLogic.tContract.ContractEndDate >= parameters.GetDateTime("FILTER_CONTRACTENDFROM"))
& (parameters.GetString("FILTER_CONTRACTENDTO") == "" ? Query.True :
TablesLogic.tContract.ContractEndDate < parameters.GetDateTime("FILTER_CONTRACTENDTO").Value.AddDays(1))
& (parameters.GetString("FILTER_CONTRACTSUMFROM") == "" ? Query.True :
TablesLogic.tContract.ContractSum >= parameters.GetDecimal("FILTER_CONTRACTSUMFROM"))
& (parameters.GetString("FILTER_CONTRACTSUMTO") == "" ? Query.True :
TablesLogic.tContract.ContractSum <= parameters.GetDecimal("FILTER_CONTRACTSUMTO"))
& (parameters.GetString("TreeviewID") == "" ? cond :
TablesLogic.tContract.Locations.HierarchyPath.Like(TablesLogic.tLocation.Load(new Guid(parameters.GetString("TreeviewID"))).HierarchyPath + "%"))
& (parameters.GetString("FILTER_CONTRACTEXPIRED") == "" ? Query.True :
TablesLogic.tContract.ContractEndDate <= DateTime.Now.AddMonths(parameters.GetInteger("FILTER_CONTRACTEXPIRED").Value))
& (parameters.GetString("FILTER_SHOWCLOSEDCONTRACT") == "" ? TablesLogic.tContract.CurrentActivity.ObjectName != "CONTRACT_CLOSED" :
Query.True)
& (parameters.GetString("FILTER_VENDORTYPE") == "" ? Query.True : TablesLogic.tContract.Vendor.VendorTypes.ObjectID == parameters.GetString("FILTER_VENDORTYPE"))
& (parameters.GetString("FILTER_VENDORCLASSIFICATION") == "" ? Query.True : TablesLogic.tContract.Vendor.VendorClassificationID == parameters.GetString("FILTER_VENDORCLASSIFICATION")));
foreach (DataRow row in dt.Rows)
{
DataRow returnRow = dtReturn.NewRow();
returnRow["Contract Name"] = row["ObjectName"];
returnRow["Contract Description"] = row["Description"];
returnRow["Contract Start Date"] = row["ContractStartDate"];
returnRow["Contract End Date"] = row["ContractEndDate"];
returnRow["Contract Terms"] = row["Terms"];
returnRow["Contract Warranty"] = row["Warranty"];
returnRow["Contract Sum($)"] = row["ContractSum"];
returnRow["Contract Manager"] = row["Manager"];
returnRow["Contact Person Name"] = row["ContactPerson"];
returnRow["Contact Person Cellphone"] = row["ContactCellphone"];
returnRow["Contact Person Email"] = row["ContactEmail"];
returnRow["Contact Person Fax"] = row["ContactFax"];
returnRow["Contact Person Phone"] = row["ContactPhone"];
returnRow["Person 1 To Remind"] = row["User1"];
returnRow["Person 2 To Remind"] = row["User2"];
returnRow["Person 3 To Remind"] = row["User3"];
returnRow["Person 4 To Remind"] = row["User4"];
returnRow["Reminder Days 1"] = row["EndReminderDays1"];
returnRow["Reminder Days 2"] = row["EndReminderDays2"];
returnRow["Reminder Days 3"] = row["EndReminderDays3"];
returnRow["Reminder Days 4"] = row["EndReminderDays4"];
returnRow["Vendor Name"] = row["Vendor"];
returnRow["Vendor Classification"] = row["VendorClassification"];
OContract contract = TablesLogic.tContract[new Guid(row["ObjectID"].ToString())];
string vendortypestring = "";
foreach (OCode codename in contract.Vendor.VendorTypes)
{
vendortypestring = vendortypestring + codename.ObjectName + ", ";
}
if (vendortypestring != "")
returnRow["Vendor Type"] = vendortypestring.Remove(vendortypestring.Length - 2);
//Retrieve all locations, type of services,. of the contract
if (row["ProvideMaintenance"] != DBNull.Value && row["ProvideMaintenance"].ToString() == "1")
{
returnRow["Provide Adhoc Maintenance"] = Resources.Strings.General_Yes;
string locations = "";
foreach (OLocation loc in contract.Locations)
{
if (locations == "")
locations = loc.Path;
else
locations += ", " + loc.Path;
}
returnRow["Locations"] = locations;
string services = "";
foreach (OCode code in contract.TypeOfServices)
{
if (services == "")
services = code.Path;
else
services += ", " + code.Path;
}
returnRow["Type of Services"] = services;
}
else
returnRow["Provide Adhoc Maintenance"] = Resources.Strings.General_No;
if (row["ProvidePricingAgreement"] != DBNull.Value && row["ProvidePricingAgreement"].ToString() == "1")
{
returnRow["Provide Purchasing Agreement"] = Resources.Strings.General_Yes;
string materials = "";
foreach (OContractPriceMaterial contractMat in contract.ContractPriceMaterials)
{
if (materials == "")
materials = contractMat.Catalogue.Path;
else
materials += ", " + contractMat.Catalogue.Path;
}
returnRow["Materials Agreement"] = materials;
string services = "";
foreach (OContractPriceService contractSev in contract.ContractPriceServices)
{
if (services == "")
services = contractSev.FixedRate.Path;
else
services += ", " + contractSev.FixedRate.Path;
}
returnRow["Service Agreement"] = services;
}
else
returnRow["Provide Purchasing Agreement"] = Resources.Strings.General_No;
dtReturn.Rows.Add(returnRow);
}
return dtReturn;
}
/// <summary>
/// caller history report
/// </summary>
/// <param name="parameters"></param>
/// <returns></returns>
public static DataTable CallerHistoryReport(ReportParameters parameters)
{
DataTable table = new DataTable();
table.Columns.Add("Location");
table.Columns.Add("Equipment");
table.Columns.Add("Created Date", typeof(DateTime));
table.Columns.Add("Name");
table.Columns.Add("CellPhone");
table.Columns.Add("Email");
table.Columns.Add("Fax");
table.Columns.Add("Phone");
table.Columns.Add("Priority");
table.Columns.Add("Work Description");
table.Columns.Add("Work Type");
table.Columns.Add("Type of service");
table.Columns.Add("Fault Type");
table.Columns.Add("Cost");
table.Columns.Add("Chargeable Amount");
table.Columns.Add("Status");
table.Columns.Add("Rejection Reason");
//string strLocationHirachyPath = LocationHirachyPath(parameters.GetString("TreeviewID"));
DateTime? FILTER_STARTDATEFROM = parameters.GetDateTime("FILTER_STARTDATEFROM");
DateTime? FILTER_STARTDATETO = parameters.GetDateTime("FILTER_STARTDATETO");
DateTime? FILTER_ENDDATEFROM = parameters.GetDateTime("FILTER_ENDDATEFROM");
DateTime? FILTER_ENDDATETO = parameters.GetDateTime("FILTER_ENDDATETO");
DataTable tempTable = TablesLogic.tWork.Select(
TablesLogic.tWork.ObjectID,
TablesLogic.tWork.LocationID,
TablesLogic.tWork.CreatedDateTime,
TablesLogic.tWork.CallerName,
TablesLogic.tWork.CallerCellPhone,
TablesLogic.tWork.CallerEmail,
TablesLogic.tWork.CallerFax,
TablesLogic.tWork.CallerPhone,
TablesLogic.tWork.Priority,
TablesLogic.tWork.WorkDescription,
TablesLogic.tWork.TypeOfWork.ObjectName,
TablesLogic.tWork.TypeOfService.ObjectName,
TablesLogic.tWork.TypeOfProblem.ObjectName,
TablesLogic.tWork.CurrentActivity.ObjectName)
.Where(TablesLogic.tWork.IsDeleted == 0 &
// & TablesLogic.tWork.Location.HierarchyPath.Like(strLocationHirachyPath + "%")
(parameters.GetString("TreeviewID") == "" ? GetAccessibleCondition(parameters.GetString("UserID"),true, TablesLogic.tWork.Location.HierarchyPath, "") :
TablesLogic.tWork.Location.HierarchyPath.Like(TablesLogic.tLocation.Load(new Guid(parameters.GetString("TreeviewID"))).HierarchyPath + "%"))
& (FILTER_STARTDATEFROM <= DateTime.Parse("1/1/1855") ? Query.True :
TablesLogic.tWork.CreatedDateTime >= parameters.GetDateTime("FILTER_STARTDATEFROM"))
& (FILTER_STARTDATETO <= DateTime.Parse("1/1/1855") ? Query.True :
TablesLogic.tWork.CreatedDateTime < parameters.GetDateTime("FILTER_STARTDATETO").Value.AddDays(1))
& TablesLogic.tWork.CallerName.Like("%" + parameters.GetString("FILTER_CALLERNAME") + "%")
);
foreach (DataRow row in tempTable.Rows)
{
OWork work = TablesLogic.tWork[new Guid(row["ObjectID"].ToString())];
switch (parameters.GetInteger("FILTER_CHARGEABLEAMOUNT"))
{
case 1: if ((parameters.GetDecimal("FILTER_COST") == null ? true : work.TotalActualCost == parameters.GetDecimal("FILTER_COST")) && work.TotalChargeOut < 2000)
table.Rows.Add(new object[] { row[1].ToString()==null?"":LocationPath(new Guid(row[1].ToString())),
row[2].ToString()==""?"":EquipmentPath(new Guid(row[2].ToString())),
row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10], row[11], row[12], row[13],
work.TotalActualCost, work.TotalChargeOut, TranslateWorkStatusToString(row[14].ToString()), row[14].ToString()=="WORK_REJECTED" ? row[15].ToString() : ""});
break;
case 2: if ((parameters.GetDecimal("FILTER_COST") == null ? true : work.TotalActualCost == parameters.GetDecimal("FILTER_COST")) && work.TotalChargeOut <= 5000 && work.TotalChargeOut >= 2000)
table.Rows.Add(new object[] { row[1].ToString()==null?"":LocationPath(new Guid(row[1].ToString())),
row[2].ToString()==""?"":EquipmentPath(new Guid(row[2].ToString())),
row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10], row[11], row[12], row[13],
work.TotalActualCost, work.TotalChargeOut, TranslateWorkStatusToString(row[14].ToString()), row[14].ToString()=="WORK_REJECTED" ? row[15].ToString() : ""});
break;
case 3: if ((parameters.GetDecimal("FILTER_COST") == null ? true : work.TotalActualCost == parameters.GetDecimal("FILTER_COST")) && work.TotalChargeOut > 5000)
table.Rows.Add(new object[] { row[1].ToString()==null?"":LocationPath(new Guid(row[1].ToString())),
row[2].ToString()==""?"":EquipmentPath(new Guid(row[2].ToString())),
row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10], row[11], row[12], row[13],
work.TotalActualCost, work.TotalChargeOut, TranslateWorkStatusToString(row[14].ToString()), row[14].ToString()=="WORK_REJECTED" ? row[15].ToString() : ""});
break;
default: if (parameters.GetDecimal("FILTER_COST") == null ? true : work.TotalActualCost == parameters.GetDecimal("FILTER_COST"))
table.Rows.Add(new object[] { row[1].ToString()==null?"":LocationPath(new Guid(row[1].ToString())),
row[2].ToString()==""?"":EquipmentPath(new Guid(row[2].ToString())),
row[3], row[4], row[5], row[6], row[7], row[8], row[9], row[10], row[11], row[12], row[13],
work.TotalActualCost, work.TotalChargeOut, TranslateWorkStatusToString(row[14].ToString()), row[14].ToString()=="WORK_REJECTED" ? row[15].ToString() : ""});
break;
}
}
return table;
}
