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