//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); }