/// <summary>
/// Method to save ticket details
/// </summary>
/// <param name="ticket">Ticket object</param>
/// <returns>True- If Saving is successful.Else false</returns>
public bool SaveTicketAndStepDetails()
{
try
{
StringBuilder query = new StringBuilder();
query.AppendFormat(" BEGIN ");
query.AppendFormat(@"UPDATE GIS_ONC.NJUNS_TICKET SET
TICKET_TYPE = '{0}',
TICKET_STATUS ='{1}' ,
POLE_FID = {2},
POLE_NUMBER = '{3}',
MISCELLANEOUS_ID = '{4}',
NJUNS_MEMBER_CODE = '{5}',
POLE_OWNER = '{6}',
CONTACT_NAME = '{7}',
CONTACT_PHONE = '{8}',
STATE = '{9}',
COUNTY ='{10}',
PLACE = '{11}',
LATITUDE = '{12}',
LONGITUDE = '{13}',
HOUSE_NUMBER = '{14}',
STREET_NAME = '{15}',
PRIORITY_CODE = '{16}',
JOB_TYPE = '{17}',
REMARKS = '{18}',
NUMBER_OF_POLES = '{19}',
DAYS_INTERVAL = {20},
START_DATE = {21},
WORK_REQUESTED_DATE = {22}
WHERE GIS_NJUNS_TICKET_ID = '{23}' ;",
TICKET_TYPE,
TICKET_STATUS,
POLE_FID,
POLE_NUMBER,
MISCELLANEOUS_ID,
NJUNS_MEMBER_CODE,
POLE_OWNER,
CONTACT_NAME,
CONTACT_PHONE,
STATE,
COUNTY,
PLACE,
LATITUDE,
LONGITUDE,
HOUSE_NUMBER,
STREET_NAME,
PRIORITY_CODE,
JOB_TYPE,
REMARKS,
NUMBER_OF_POLES,
DAYS_INTERVAL,
"'" + START_DATE.ToString("dd-MMM-yy") + "'",
"'" + WORK_REQUESTED_DATE.ToString("dd-MMM-yy") + "'",
GIS_NJUNS_TICKET_ID);
Recordset tmpRs = GetRecordSet(string.Format("DELETE FROM GIS_ONC.NJUNS_STEP WHERE GIS_NJUNS_TICKET_ID = '{0}'", GIS_NJUNS_TICKET_ID));
foreach (TicketStepType step in TicketStepTypeList)
{
if (step == null)
{
continue;
}
query.AppendFormat(@"INSERT INTO GIS_ONC.NJUNS_STEP(
GIS_NJUNS_TICKET_ID,
NJUNS_TICKET_ID,
JOB_TYPE,
NUMBER_POLES,
DAYS_INTERVAL,
REMARKS,
NJUNS_MEMBER,
NJUNS_STEP_ID
)
VALUES({0},{1},'{2}','{3}','{4}','{5}','{6}',{7});",
GIS_NJUNS_TICKET_ID,
NJUNS_TICKET_ID,
step.JobType,
step.NumberOfPoles,
step.DaysInterval,
step.Remarks,
step.CustomNjunsMemberValue,
step.ReferenceId
);
}
query.AppendFormat(" COMMIT ; ");
query.AppendFormat(" END ; ");
DataContext.Execute(query.ToString(), out int iRecordsAffected, (int)CommandTypeEnum.adCmdText);
return(true);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// Method inserts new record into NJUNS Ticket table
/// </summary>
/// <returns>True, if insertion is successful</returns>
public bool InsertNewTicketRecord()
{
int iRecordsAffected = 0;
try
{
GIS_NJUNS_TICKET_ID = GetNextSequenceValue("GIS_ONC.GIS_NJUNS_TICKET_ID_SEQ");
StringBuilder insertQuery = new StringBuilder();
insertQuery.AppendFormat(" BEGIN ");
insertQuery.AppendFormat(@"INSERT INTO GIS_ONC.NJUNS_TICKET(
NJUNS_TICKET_ID,
TICKET_NUMBER,
TICKET_TYPE,
TICKET_STATUS,
POLE_FID,
POLE_NUMBER,
MISCELLANEOUS_ID,
NJUNS_MEMBER_CODE,
POLE_OWNER,
CONTACT_NAME,
CONTACT_PHONE,
STATE,
COUNTY,
PLACE,
LATITUDE,
LONGITUDE,
HOUSE_NUMBER,
STREET_NAME,
PRIORITY_CODE,
JOB_TYPE,
REMARKS,
NUMBER_OF_POLES,
DAYS_INTERVAL,
WORK_REQUESTED_DATE,
GIS_NJUNS_TICKET_ID
)
VALUES('{0}',{1},'{2}','{3}',{4},'{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}',{24});",
NJUNS_TICKET_ID,
TICKET_NUMBER,
TICKET_TYPE,
TICKET_STATUS,
POLE_FID,
POLE_NUMBER,
MISCELLANEOUS_ID,
NJUNS_MEMBER_CODE,
POLE_OWNER,
CONTACT_NAME,
CONTACT_PHONE,
STATE,
COUNTY,
PLACE,
LATITUDE,
LONGITUDE,
HOUSE_NUMBER,
STREET_NAME,
PRIORITY_CODE,
JOB_TYPE,
REMARKS,
NUMBER_OF_POLES,
DAYS_INTERVAL,
WORK_REQUESTED_DATE.ToString("dd-MMM-yy"),
GIS_NJUNS_TICKET_ID
);
insertQuery.AppendFormat(" END ; ");
string insertSql = insertQuery.ToString();
DataContext.Execute(insertSql, out iRecordsAffected, (int)CommandTypeEnum.adCmdText);
return(true);
}
catch (Exception)
{
MessageBox.Show("Failed to insert ticket record", "Custom Create Ticket Error", MessageBoxButtons.OK);
return(false);
}
}
