/// <summary>
/// Handle single quote in ticket step details
/// </summary>
/// <param name="step"></param>
/// <returns></returns>
private TicketStepType HandleSpecialCharacters(TicketStepType step)
{
if (step != null)
{
if (!string.IsNullOrEmpty(step.JobType))
{
step.JobType = step.JobType.Replace("'", "''").Replace("&", "'&");
}
if (!string.IsNullOrEmpty(step.DaysInterval))
{
step.DaysInterval = step.DaysInterval.Replace("'", "''").Replace("&", "'&");
}
if (!string.IsNullOrEmpty(step.NumberOfPoles))
{
step.NumberOfPoles = step.NumberOfPoles.Replace("'", "''").Replace("&", "'&");
}
if (step.NjunsMemberCode != null && !string.IsNullOrEmpty(step.NjunsMemberCode.Value))
{
step.NjunsMemberCode.Value = step.NjunsMemberCode.Value.Replace("'", "''").Replace("&", "'&");
}
if (!string.IsNullOrEmpty(step.Remarks))
{
step.Remarks = step.Remarks.Replace("'", "''").Replace("&", "'&");
}
}
return(step);
}
/// <summary>
/// Insert a row of type 'Ticket' at specified row index
/// </summary>
/// <param name="rowIindex"> row index</param>
/// <param name="t"> ticket step object</param>
private void InsertRow(int rowIindex, TicketStepType t)
{
try
{
BindingSource bs = (BindingSource)this.ticketStepTypeListBindingSource;
bs.Insert(rowIindex, t);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Method to read the Ticket attributes for the input GIS ticket Id
/// </summary>
/// <param name="gisTicketId">Njuns Ticket ID</param>
/// <param name="ticketNumber">ticketNumber</param>
/// <param name="ticketId">Njuns Ticket ID</param>
/// <returns>true, if ticket attributes exists in GIS. Else returns false.</returns>
internal bool GetTicketAttributes(int gisTicketId, int ticketNumber = 0, string nJunsTicketId = "")
{
List <string> memberCodeList;
List <string> poleOwnerList;
try
{
string sql = string.Empty;
if (ticketNumber > 0 && !string.IsNullOrEmpty(nJunsTicketId))
{
sql = string.Format("SELECT * FROM GIS_ONC.NJUNS_TICKET WHERE TICKET_NUMBER = {0} AND NJUNS_TICKET_ID = '{1}'", ticketNumber, nJunsTicketId);
}
else
{
sql = string.Format("SELECT * FROM GIS_ONC.NJUNS_TICKET WHERE GIS_NJUNS_TICKET_ID = {0}", gisTicketId);
}
Recordset ticketAttributesRs = GetRecordSet(sql);
if (ticketAttributesRs != null && ticketAttributesRs.RecordCount == 0)
{
MessageBox.Show(m_InterfacePoint + " : " + " Invalid ticket ID.", "Submit Ticket Error", MessageBoxButtons.OK);
return(false);
}
m_Type = Convert.ToString(ticketAttributesRs.Fields["TICKET_TYPE"].Value);
m_StructureId = Convert.ToString(ticketAttributesRs.Fields["POLE_NUMBER"].Value);
m_Wr = Convert.ToString(ticketAttributesRs.Fields["MISCELLANEOUS_ID"].Value);
m_NjunsMemberCode = Convert.ToString(ticketAttributesRs.Fields["NJUNS_MEMBER_CODE"].Value);
m_PoleOwner = Convert.ToString(ticketAttributesRs.Fields["POLE_OWNER"].Value);
m_PoleNumber = m_StructureId;
m_status = Convert.ToString(ticketAttributesRs.Fields["TICKET_STATUS"].Value);
m_StartDate = Convert.ToDateTime(ticketAttributesRs.Fields["START_DATE"].Value);
m_WorkRequestedDate = Convert.ToDateTime(ticketAttributesRs.Fields["WORK_REQUESTED_DATE"].Value);
m_State = Convert.ToString(ticketAttributesRs.Fields["STATE"].Value);
m_County = Convert.ToString(ticketAttributesRs.Fields["COUNTY"].Value);
m_Place = Convert.ToString(ticketAttributesRs.Fields["PLACE"].Value);
m_HouseNumber = Convert.ToString(ticketAttributesRs.Fields["HOUSE_NUMBER"].Value);
m_StreetName = Convert.ToString(ticketAttributesRs.Fields["STREET_NAME"].Value);
m_PriorityCode = Convert.ToString(ticketAttributesRs.Fields["PRIORITY_CODE"].Value);
m_PlotFilePath = Convert.ToString(ticketAttributesRs.Fields["PLOT"].Value);
m_InvoiceFilePath = Convert.ToString(ticketAttributesRs.Fields["INVOICE"].Value);
m_JobType = Convert.ToString(ticketAttributesRs.Fields["JOB_TYPE"].Value);
m_NumberOfPoles = Convert.ToString(ticketAttributesRs.Fields["NUMBER_OF_POLES"].Value);
m_DaysInterval = Convert.ToString(ticketAttributesRs.Fields["DAYS_INTERVAL"].Value);
m_Remarks = Convert.ToString(ticketAttributesRs.Fields["REMARKS"].Value);
ticketAttributesRs.Close();
ticketAttributesRs = null;
BuildLists(out memberCodeList, out poleOwnerList);
ticketAttributesRs = GetRecordSet(string.Format("SELECT * FROM GIS_ONC.NJUNS_STEP WHERE GIS_NJUNS_TICKET_ID = {0}", gisTicketId));
if (ticketAttributesRs != null && ticketAttributesRs.RecordCount == 0)
{
MessageBox.Show(m_InterfacePoint + " : " + " Invalid ticket ID.", "Submit Ticket Error", MessageBoxButtons.OK);
return(false);
}
ticketAttributesRs.MoveFirst();
TicketStepType[] ticketStepType = new TicketStepType[ticketAttributesRs.RecordCount];
int i = 0;
while (!ticketAttributesRs.EOF)
{
ticketStepType[i] = new TicketStepType();
ticketStepType[i].DaysInterval = Convert.ToString(ticketAttributesRs.Fields["DAYS_INTERVAL"].Value);
ticketStepType[i].JobType = Convert.ToString(ticketAttributesRs.Fields["JOB_TYPE"].Value);
MemberType mType = new MemberType();
mType.Value = Convert.ToString(ticketAttributesRs.Fields["NJUNS_MEMBER"].Value);
Recordset njunsGuidRs = GetRecordSet(string.Format("SELECT NJUNS_CODE_GUID FROM NJUNS_MEMBER_COUNTY MC, NJUNS_MEMBER M WHERE MC.NJUNS_MEMBER_ID = M.NJUNS_MEMBER_ID AND M.NJUNS_MEMBER = '{0}'", mType.Value));
if (njunsGuidRs != null && njunsGuidRs.RecordCount > 0)
{
njunsGuidRs.MoveFirst();
mType.Id = Convert.ToString(njunsGuidRs.Fields["NJUNS_CODE_GUID"].Value);
}
ticketStepType[i].NjunsMemberCode = mType;
ticketStepType[i].CustomNjunsMemberValue = mType.Value;
ticketStepType[i].NumberOfPoles = Convert.ToString(ticketAttributesRs.Fields["NUMBER_POLES"].Value);
ticketStepType[i].Remarks = Convert.ToString(ticketAttributesRs.Fields["REMARKS"].Value);
ticketStepType[i].ReferenceId = Convert.ToString(i + 1);
i = i + 1;
ticketAttributesRs.MoveNext();
}
m_ticketStepTypeList = ticketStepType.ToList();
return(true);
}
catch (Exception)
{
throw;
}
}
