//public void SaveWorkTicketAsCurrent(JT_WorkTicket workTicket)
//{
// //int rows = 0;
// JT_TechnicianScheduleDetail scheduleDetail =
// _database.Table<JT_TechnicianScheduleDetail>().Where(
// sd => (sd.WTNumber == workTicket.WTNumber) &&
// (sd.WTStep == workTicket.WTStep) &&
// (sd.SalesOrderNo == workTicket.SalesOrderNo)
// ).FirstOrDefault();
// //App_CurrentSelectionData currentData = _database.Table<App_CurrentSelectionData>().FirstOrDefault();
// //currentData.SalesOrderNo = workTicket.SalesOrderNo;
// //currentData.WTNumber = workTicket.WTNumber;
// //currentData.WTStep = workTicket.WTStep;
// SaveScheduleDetailAsCurrent(scheduleDetail);
//}
public JT_WorkTicket RetrieveCurrentWorkTicket()
{
JT_WorkTicket currentTicket = null;
lock (_locker)
{
//App_CurrentSelectionData currentData = _database.Table<App_CurrentSelectionData>().FirstOrDefault();
//return _database.Table<JT_WorkTicket>().Where(
// wt => (wt.SalesOrderNo == currentData.SalesOrderNo) &&
// (wt.WTNumber == currentData.WTNumber) &&
// (wt.WTStep == currentData.WTStep)
// ).FirstOrDefault();
JT_TechnicianScheduleDetail scheduleDetail = RetrieveCurrentScheduleDetail();
if (scheduleDetail != null)
{
currentTicket =
_database.Table <JT_WorkTicket>().Where(
wt => (wt.SalesOrderNo == scheduleDetail.SalesOrderNo) &&
(wt.WTNumber == scheduleDetail.WTNumber) &&
(wt.WTStep == scheduleDetail.WTStep)
).FirstOrDefault();
}
}
return(currentTicket);
}
public App_ServiceAgreement GetServiceAgreement(JT_WorkTicket workTicket)
{
JT_ServiceAgreementHeader serviceAgreementHeader = new JT_ServiceAgreementHeader();
JT_ServiceAgreementDetail serviceAgreementDetail = new JT_ServiceAgreementDetail();
JT_ServiceAgreementPMDetail serviceAgreementPmDetail = new JT_ServiceAgreementPMDetail();
lock (_locker)
{
serviceAgreementHeader =
_database.Table <JT_ServiceAgreementHeader>().Where(
sah => (sah.ContractCode == workTicket.HdrServiceContractCode && sah.ARDivisionNo != null)
).FirstOrDefault();
if (serviceAgreementHeader != null)
{
serviceAgreementDetail =
_database.Table <JT_ServiceAgreementDetail>().Where(
sad => (sad.ARDivisionNo == serviceAgreementHeader.ARDivisionNo) &&
(sad.CustomerNo == serviceAgreementHeader.CustomerNo) &&
(sad.ContractCode == serviceAgreementHeader.ContractCode)
).FirstOrDefault();
serviceAgreementPmDetail =
_database.Table <JT_ServiceAgreementPMDetail>().Where(
sapmd => (sapmd.ARDivisionNo == serviceAgreementHeader.ARDivisionNo) &&
(sapmd.CustomerNo == serviceAgreementHeader.CustomerNo) &&
(sapmd.ContractCode == serviceAgreementHeader.ContractCode)
).FirstOrDefault();
}
}
return(new App_ServiceAgreement(serviceAgreementHeader, serviceAgreementDetail, serviceAgreementPmDetail));
}
public JT_WorkTicket GetWorkTicket(string formattedWorkTicketNumber)
{
//JT_WorkTicket workTicket = null;
JT_TechnicianScheduleDetail scheduleDetail = new JT_TechnicianScheduleDetail();
string[] workTicketNumberParts = JT_WorkTicket.BreakFormattedTicketNumber(formattedWorkTicketNumber);
scheduleDetail.SalesOrderNo = workTicketNumberParts[0];
scheduleDetail.WTNumber = workTicketNumberParts[1];
scheduleDetail.WTStep = workTicketNumberParts[2];
return(GetWorkTicket(scheduleDetail));
//lock (_locker)
//{
// workTicket =
// _database.Table<JT_WorkTicket>().Where(
// wt =>
// (wt.SalesOrderNo == workTicketNumberParts[0]) &&
// (wt.WTNumber == workTicketNumberParts[1]) //&&
// //(wt.WTStep == workTicketNumberParts[2])
// ).FirstOrDefault();
//}
//return workTicket;
}
/// <summary>
/// Retrieves a list of all JT_TransactionImportDetail objects from the local database table
/// representing expense items.
/// </summary>
/// <returns>A List container of JT_TransactionImportDetail expense objects.</returns>
public List <JT_TransactionImportDetail> GetExpensesForWorkTicket(JT_WorkTicket workTicket)
{
lock (_locker)
{
return(_database.Table <JT_TransactionImportDetail>().Where(
tid =>
(tid.RecordType == "E") &&
(tid.SalesOrderNo == workTicket.SalesOrderNo) &&
(tid.WTNumber == workTicket.WTNumber) &&
(tid.WTStep == workTicket.WTStep)
).OrderBy(tid => tid.ItemCode).ToList());
}
}
public ExpensesListPageViewModel(JT_WorkTicket workTicket)
{
// dch rkl 12/07/2016 catch exception
try
{
_expensesList = new ObservableCollection <App_Expense>();
SetWorkTicket(workTicket);
}
catch (Exception ex)
{
// dch rkl 12/07/2016 Log Error
ErrorReporting errorReporting = new ErrorReporting();
errorReporting.sendException(ex, "TechDashboard.ExpensesListPageViewModel(JT_WorkTicket workTicket)");
}
}
public void SetWorkTicket(JT_WorkTicket workTicket)
{
// dch rkl 12/07/2016 catch exception
try
{
//_workTicket = workTicket; TODO
SetExpensesList();
}
catch (Exception ex)
{
// dch rkl 12/07/2016 Log Error
ErrorReporting errorReporting = new ErrorReporting();
errorReporting.sendException(ex, "TechDashboard.ExpensesListPageViewModel.SetWorkTicket(JT_WorkTicket workTicket)");
}
}
public List <JT_ServiceEquipmentParts> RetrievePartsListFromWorkTicket(JT_WorkTicket workTicket)
{
lock (_locker)
{
List <JT_ServiceEquipmentParts> partsList = null;
CI_Item repairItem = RetrieveRepairItemFromWorkTicket(workTicket);
if (repairItem != null)
{
partsList = _database.Table <JT_ServiceEquipmentParts>().Where(
part => repairItem.ItemCode.Contains(part.ItemCode)
).ToList();
}
return(partsList);
}
}
protected SO_SalesOrderHeader GetSalesOrderHeader(JT_WorkTicket workTicket)
{
SO_SalesOrderHeader salesOrderHeader = null;
lock (_locker)
{
if (workTicket != null)
{
salesOrderHeader =
_database.Table <SO_SalesOrderHeader>().Where(
so => (so.SalesOrderNo == workTicket.SalesOrderNo)
).FirstOrDefault();
}
}
return(salesOrderHeader);
}
public CI_Item RetrieveRepairItemFromWorkTicket(JT_WorkTicket workTicket)
{
CI_Item currentRepairItem = null;
lock (_locker)
{
if (workTicket != null)
{
currentRepairItem =
_database.Table<CI_Item>().Where(
ri => ri.ItemCode == workTicket.DtlRepairItemCode
).FirstOrDefault();
}
}
return currentRepairItem;
}
public List <JT_ServiceEquipmentParts> RetrievePartsListFromWorkTicket(JT_WorkTicket workTicket)
{
lock (_locker)
{
//App_CurrentSelectionData currentData = _database.Table<App_CurrentSelectionData>().FirstOrDefault();
List <JT_ServiceEquipmentParts> partsList = null;
CI_Item repairItem = RetrieveRepairItemFromWorkTicket(workTicket);
if (repairItem != null)
{
partsList = _database.Table <JT_ServiceEquipmentParts>().Where(
part => repairItem.ItemCode.Contains(part.ItemCode)
).ToList();
}
return(partsList);
}
}
public bool IsPartOnPartsList(JT_WorkTicket workTicket, CI_Item partToFind)
{
bool returnValue = false;
lock (_locker)
{
try
{
returnValue = (RetrievePartsListFromWorkTicket(workTicket).Find(part => part.PartItemCode == partToFind.ItemCode) != null);
}
catch
{
returnValue = false;
}
}
return(returnValue);
}
public JT_WorkTicketText RetrieveTextFromWorkTicket(JT_WorkTicket workTicket)
{
JT_WorkTicketText note = null;
lock (_locker)
{
if (workTicket != null)
{
note =
_database.Table <JT_WorkTicketText>().Where(
wtt => (wtt.SalesOrderNo == workTicket.SalesOrderNo) &&
(wtt.WTNumber == workTicket.WTNumber) &&
(wtt.WTStep == workTicket.WTStep)
).FirstOrDefault();
}
}
return(note);
}
public JT_WorkTicket GetWorkTicket(JT_TechnicianScheduleDetail scheduleDetail)
{
JT_WorkTicket workTicket = null;
lock (_locker)
{
if (scheduleDetail != null)
{
workTicket =
_database.Table <JT_WorkTicket>().Where(
wt => (wt.SalesOrderNo == scheduleDetail.SalesOrderNo) &&
(wt.WTNumber == scheduleDetail.WTNumber) &&
(wt.WTStep == scheduleDetail.WTStep)
).FirstOrDefault();
}
}
return(workTicket);
}
public void SetWorkTicket(JT_WorkTicket workTicket)
{
//_workTicket = workTicket; puke
SetExpensesList();
}
public ExpensesListPageViewModel(JT_WorkTicket workTicket)
{
// puke
_expensesList = new ObservableCollection <App_Expense>();
SetWorkTicket(workTicket);
}
public App_WorkTicket GetWorkTicket(App_ScheduledAppointment scheduledAppointment)
{
JT_WorkTicket workTicket = null;
JT_WorkTicket workTicketStepZero = null;
JT_WorkTicketClass workTicketClass = null;
CI_Item repairItem = null;
JT_EquipmentAsset equipmentAsset = null;
App_ServiceAgreement serviceAgreement = null;
JT_ClassificationCode problemCode = null;
JT_ClassificationCode exceptionCode = null;
lock (_locker)
{
if (scheduledAppointment != null)
{
workTicket =
_database.Table <JT_WorkTicket>().Where(
wt => (wt.SalesOrderNo == scheduledAppointment.SalesOrderNumber) &&
(wt.WTNumber == scheduledAppointment.WorkTicketNumber) &&
(wt.WTStep == scheduledAppointment.WorkTicketStep)
).FirstOrDefault();
// dch rkl 11/30/2016 If JT_WorkTicket.HdrWTClass is null, populate it from SO_SalesOrderHeader.JT158_WTClass
if (workTicket.HdrWtClass == null)
{
SO_SalesOrderHeader soHeader = _database.Table <SO_SalesOrderHeader>().Where(
soh => (soh.SalesOrderNo == workTicket.SalesOrderNo)).FirstOrDefault();
if (soHeader != null)
{
workTicket.HdrWtClass = soHeader.JT158_WTClass;
}
}
workTicketStepZero =
_database.Table <JT_WorkTicket>().Where(
wt => (wt.SalesOrderNo == scheduledAppointment.SalesOrderNumber) &&
(wt.WTNumber == scheduledAppointment.WorkTicketNumber) &&
(wt.WTStep == "000")
).FirstOrDefault();
workTicketClass =
_database.Table <JT_WorkTicketClass>().Where(
wtc => (workTicket.HdrWtClass == wtc.WorkTicketClass)
).FirstOrDefault();
repairItem = GetItemFromDB(workTicket.DtlRepairItemCode);
if (workTicket.DtlMfgSerialNo != null)
{
equipmentAsset =
_database.Table <JT_EquipmentAsset> ().Where(
ea => (ea.ItemCode == repairItem.ItemCode) &&
(ea.MfgSerialNo == workTicket.DtlMfgSerialNo)
).FirstOrDefault();
}
else
{
equipmentAsset = new JT_EquipmentAsset();
}
serviceAgreement = GetServiceAgreement(workTicketStepZero);
//serviceAgreement = GetServiceAgreement(workTicket);
problemCode = _database.Table <JT_ClassificationCode>().Where(
pc => (pc.ClassificationCode == workTicket.DtlProblemCode)
).FirstOrDefault();
exceptionCode = _database.Table <JT_ClassificationCode>().Where(
pc => (pc.ClassificationCode == workTicket.DtlCoverageExceptionCode)
).FirstOrDefault();
}
}
return(new App_WorkTicket(workTicket, workTicketStepZero, workTicketClass,
new App_RepairItem(repairItem, equipmentAsset),
serviceAgreement, problemCode, exceptionCode));
}
public void FillServiceAgreementHeaderTable()
{
// Fill Service Agreement Details based on Tickets
//FillLocalTable<JT_ServiceAgreementHeader>(); // TODO filter
// dch rkl 01/31/2017 prevent duplicate filters, which generates long query string
DataTable dtFilter = new DataTable("Filter");
dtFilter.Columns.Add("ContractCode", typeof(string));
dtFilter.Columns.Add("CustomerNo", typeof(string));
dtFilter.Columns.Add("ARDivisionNo", typeof(string));
StringBuilder sbH = new StringBuilder();
List <JT_TechnicianScheduleDetail> scheduledTickets = GetTechnicianScheduleDetailFromDB();
List <JT_WorkTicket> tickets = GetWorkTicketsFromDB();
List <SO_SalesOrderHeader> sohs = GetSalesOrderHeadersFromDB();
for (int i = 0; i < scheduledTickets.Count; i++)
{
JT_WorkTicket ticket = tickets.FirstOrDefault(s => s.SalesOrderNo == scheduledTickets[i].SalesOrderNo &&
s.WTNumber == scheduledTickets[i].WTNumber && s.WTStep == "000" && s.HdrServiceContractCode != null);
if (ticket != null)
{
SO_SalesOrderHeader soHdr = sohs.FirstOrDefault(s => s.SalesOrderNo == scheduledTickets[i].SalesOrderNo);
if (soHdr != null)
{
// dch rkl 01/31/2017 prevent duplicate filters, which generates long query string
DataView dvFilter = new DataView(dtFilter);
dvFilter.RowFilter = "ContractCode = '" + ticket.HdrServiceContractCode + "' and CustomerNo = '" + soHdr.CustomerNo + "' and ARDivisionNo = '" + soHdr.ARDivisionNo + "'";
if (dvFilter.Count == 0)
{
dtFilter.Rows.Add(ticket.HdrServiceContractCode, soHdr.CustomerNo, soHdr.ARDivisionNo);
}
//if (sbH.Length > 0)
//{
// sbH.Append(" or ");
//}
//sbH.Append("(ContractCode eq '");
//sbH.Append(ticket.HdrServiceContractCode);
//sbH.Append("' and CustomerNo eq '");
//sbH.Append(soHdr.CustomerNo);
//sbH.Append("' and ARDivisionNo eq '");
//sbH.Append(soHdr.ARDivisionNo);
//sbH.Append("')");
// dch rkl 01/31/2017 prevent duplicate filters, which generates long query string END
}
}
}
// dch rkl 01/31/2017 prevent duplicate filters, which generates long query string BEGIN
foreach (DataRow row in dtFilter.Rows)
{
if (sbH.Length > 0)
{
sbH.Append(" or ");
}
sbH.Append("(ContractCode eq '");
sbH.Append(row["ContractCode"].ToString());
sbH.Append("' and CustomerNo eq '");
sbH.Append(row["CustomerNo"].ToString());
sbH.Append("' and ARDivisionNo eq '");
sbH.Append(row["ARDivisionNo"].ToString());
sbH.Append("')");
}
// dch rkl 01/31/2017 prevent duplicate filters, which generates long query string END
FillLocalTable <JT_ServiceAgreementHeader>("where", sbH.ToString());
FillLocalTable <JT_ServiceAgreementDetail>("where", sbH.ToString());
FillLocalTable <JT_ServiceAgreementPMDetail>("where", sbH.ToString());
}
public void SetWorkTicketForApplication(JT_WorkTicket workTicket)
{
//App.Database.SaveWorkTicketAsCurrent(workTicket);
// App.SetWorkTicketAsCurrent(workTicket);
}
