//public App_CurrentWorkTicket RetrieveCurrentAppWorkTicket()
//{
// lock (_locker)
// {
// return new App_CurrentWorkTicket(); // puke... db stuff handled in class. Should we remove and put here?
// }
//}
#endregion
#region Work Ticket Text
// dch rkl 01/20/2017 This is done as part of work ticket load
//public void FillWorkTicketTextTable()
//{
// StringBuilder sb = new StringBuilder();
// List<JT_TechnicianScheduleDetail> scheduledTickets = GetTechnicianScheduleDetailFromDB();
// for (int i = 0; i < scheduledTickets.Count; i++)
// {
// if (i > 0)
// {
// sb.Append(" or ");
// }
// sb.Append("(SalesOrderNo eq '");
// sb.Append(scheduledTickets[i].SalesOrderNo);
// sb.Append("' and WTNumber eq '");
// sb.Append(scheduledTickets[i].WTNumber);
// sb.Append("' and WTStep eq '");
// sb.Append(scheduledTickets[i].WTStep);
// sb.Append("')");
// }
// FillLocalTable<JT_WorkTicketText>("where", sb.ToString());
//}
public App_WorkTicketText RetrieveTextFromWorkTicket(App_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();
}
}
if (note == null)
{
return(null);
}
else
{
return(new App_WorkTicketText(note));
}
}
public void SaveWorkTicketText(App_WorkTicketText workTicketText)
{
int rows = 0;
lock (_locker)
{
JT_WorkTicketText workTicketToSave = new JT_WorkTicketText()
{
WTNumber = workTicketText.WTNumber,
WTStep = workTicketText.WTStep,
Text = workTicketText.Text,
SequenceNo = workTicketText.SequenceNo,
SalesOrderNo = workTicketText.SalesOrderNo,
IsModified = true,
ID = workTicketText.ID
};
JT_TransactionImportDetail transactionDetail = new JT_TransactionImportDetail()
{
RecordType = "W",
SalesOrderNo = workTicketText.SalesOrderNo,
WTNumber = workTicketText.WTNumber,
WTStep = workTicketText.WTStep,
TransactionDate = DateTime.Now.ToString("yyyyMMdd"), // dch rkl 11/03/2016 include transaction date for notes
StepText = workTicketText.Text
};
_database.Insert(transactionDetail);
SaveWorkTicketText(workTicketToSave);
/*workTicketText.IsModified = true;
* // puke
* //JT_WorkTicketText itemToSave;
*
*
* if (workTicketText.WTNumber != null && workTicketText.WTStep != null)
* {
* rows = _database.Update(workTicketText);
* }
* else
* {
* rows = _database.Insert(workTicketText);
* }
*
* // puke... need call back?*/
}
}
public void SaveWorkTicketText(JT_WorkTicketText workTicketText)
{
int rows = 0;
lock (_locker)
{
workTicketText.IsModified = true;
if (workTicketText.ID != 0)
{
rows = _database.Update(workTicketText);
}
else
{
rows = _database.Insert(workTicketText);
}
// puke... need call back?
}
}
public JT_WorkTicketText RetrieveTextFromCurrentWorkTicket()
{
JT_WorkTicketText note = null;
lock (_locker)
{
JT_TechnicianScheduleDetail scheduleDetail = RetrieveCurrentScheduleDetail();
if (scheduleDetail != null)
{
note =
_database.Table <JT_WorkTicketText>().Where(
wtt => (wtt.SalesOrderNo == scheduleDetail.SalesOrderNo) &&
(wtt.WTNumber == scheduleDetail.WTNumber) &&
(wtt.WTStep == scheduleDetail.WTStep)
).FirstOrDefault();
}
}
return(note);
}
