Input string was not in a correct format.

Input string was not in a correct format.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Input string was not in a correct format.

Source Error:


Line 179:
Line 180:
Line 181:            res.Code = Int32.Parse(cmd.Parameters["@resultCode"].ToString());
Line 182:            res.Message = cmd.Parameters["@resultMessage"].ToString();
Line 183:
 

[DataObjectMethod(DataObjectMethodType.Update, true)]
        public static TransactionResult UpdateReOpenedTicket(Ticket ticket)
        {
            TransactionResult res = new TransactionResult();

            Database db = DatabaseFactory.CreateDatabase();
            string sql = "sprUpdateReOpenedTicket";
            DbCommand cmd = db.GetStoredProcCommand(sql);
            db.AddInParameter(cmd, "@ticketID", DbType.Int32, ticket.TicketID);
            db.AddInParameter(cmd, "@ticketNumber", DbType.String, ticket.TicketNumber);
            db.AddInParameter(cmd, "@ticketType", DbType.String, ticket.TicketType);
            db.AddInParameter(cmd, "@ticketStatus", DbType.String, ticket.TicketStatus);
            db.AddInParameter(cmd, "@ticketSeverity", DbType.String, ticket.TicketSeverity);
            db.AddInParameter(cmd, "@shortDescription", DbType.String, ticket.ShortDescription);
            db.AddInParameter(cmd, "@externalTicket", DbType.String, ticket.ExternalTicket);
            db.AddInParameter(cmd, "@reasonMenu", DbType.String, ticket.ReasonMenu);
            db.AddInParameter(cmd, "@problemNote", DbType.String, ticket.ProblemNote);
            db.AddInParameter(cmd, "@solutionNote", DbType.String, ticket.SolutionNote);
            db.AddInParameter(cmd, "@actionNote", DbType.String, ticket.ActionNote);
            db.AddInParameter(cmd, "@followupNote", DbType.String, ticket.FollowupNote);
            db.AddInParameter(cmd, "@companiesFlag", DbType.Boolean, ticket.CompaniesFlag);
            db.AddInParameter(cmd, "@agentCreated", DbType.String, ticket.AgentCreated);
            db.AddInParameter(cmd, "@dateCreated", DbType.DateTime, ticket.DateCreated);
            db.AddInParameter(cmd, "@dateLastModified", DbType.DateTime, ticket.DateLastModified);
            db.AddInParameter(cmd, "@agentClosed", DbType.String, ticket.AgentClosed);
            db.AddInParameter(cmd, "@dateClosed", DbType.DateTime, ticket.DateClosed);
            db.AddInParameter(cmd, "@agentFollowup", DbType.String, ticket.AgentFollowup);
            db.AddInParameter(cmd, "@followupBy", DbType.DateTime, ticket.FollowupBy);
            db.AddInParameter(cmd, "@deletedFlag", DbType.Boolean, ticket.DeletedFlag);
            db.AddInParameter(cmd, "@ticketTypeOld", DbType.String, ticket.TicketTypeOld);
            db.AddInParameter(cmd, "@assignedTo", DbType.String, ticket.AssignedTo);
            db.AddInParameter(cmd, "@requestType", DbType.String, ticket.RequestType);
            db.AddInParameter(cmd, "@serviceImpact", DbType.String, ticket.ServiceImpact);
            db.AddInParameter(cmd, "@dateTimeAssigned", DbType.DateTime, ticket.DateTimeAssigned);
            db.AddInParameter(cmd, "@priority", DbType.String, ticket.Priority);
            db.AddInParameter(cmd, "@dateAssigned", DbType.DateTime, ticket.DateTimeAssigned);
            db.AddInParameter(cmd, "@trackIt", DbType.String, ticket.TrackIt);
            db.AddInParameter(cmd, "@contactMethod", DbType.String, ticket.ContactMethod);
            db.AddInParameter(cmd, "@locationSIMs", DbType.String, ticket.LocationSIMs);
            db.AddInParameter(cmd, "@userID", DbType.String, ticket.UserID);
            db.AddInParameter(cmd, "@ticketApplicationType", DbType.String, ticket.TicketApplicationType);
            db.AddInParameter(cmd, "@accountID", DbType.Int32, ticket.AccountID);

            db.AddOutParameter(cmd, "@resultCode", DbType.Int32, 4);
            db.AddOutParameter(cmd, "@resultMessage", DbType.String, 200);

            db.ExecuteNonQuery(cmd);


            res.Code = Int32.Parse(cmd.Parameters["@resultCode"].ToString());
            res.Message = cmd.Parameters["@resultMessage"].ToString();


            return res;
        }

        [DataObjectMethod(DataObjectMethodType.Update, true)]
        public static TransactionResult UpdateClosedTicket(Ticket ticket)
        {
            TransactionResult res = new TransactionResult();

            Database db = DatabaseFactory.CreateDatabase();
            string sql = "sprUpdateClosedTicket";
            DbCommand cmd = db.GetStoredProcCommand(sql);
            db.AddInParameter(cmd, "@ticketID", DbType.Int32, ticket.TicketID);
            db.AddInParameter(cmd, "@ticketNumber", DbType.String, ticket.TicketNumber);
            db.AddInParameter(cmd, "@ticketType", DbType.String, ticket.TicketType);
            db.AddInParameter(cmd, "@ticketStatus", DbType.String, ticket.TicketStatus);
            db.AddInParameter(cmd, "@ticketSeverity", DbType.String, ticket.TicketSeverity);
            db.AddInParameter(cmd, "@shortDescription", DbType.String, ticket.ShortDescription);
            db.AddInParameter(cmd, "@externalTicket", DbType.String, ticket.ExternalTicket);
            db.AddInParameter(cmd, "@reasonMenu", DbType.String, ticket.ReasonMenu);
            db.AddInParameter(cmd, "@problemNote", DbType.String, ticket.ProblemNote);
            db.AddInParameter(cmd, "@solutionNote", DbType.String, ticket.SolutionNote);
            db.AddInParameter(cmd, "@actionNote", DbType.String, ticket.ActionNote);
            db.AddInParameter(cmd, "@followupNote", DbType.String, ticket.FollowupNote);
            db.AddInParameter(cmd, "@companiesFlag", DbType.Boolean, ticket.CompaniesFlag);
            db.AddInParameter(cmd, "@agentCreated", DbType.String, ticket.AgentCreated);
            db.AddInParameter(cmd, "@dateCreated", DbType.DateTime, ticket.DateCreated);
            db.AddInParameter(cmd, "@dateLastModified", DbType.DateTime, ticket.DateLastModified);
            db.AddInParameter(cmd, "@agentClosed", DbType.String, ticket.AgentClosed);
            db.AddInParameter(cmd, "@dateClosed", DbType.DateTime, ticket.DateClosed);
            db.AddInParameter(cmd, "@agentFollowup", DbType.String, ticket.AgentFollowup);
            db.AddInParameter(cmd, "@followupBy", DbType.DateTime, ticket.FollowupBy);
            db.AddInParameter(cmd, "@deletedFlag", DbType.Boolean, ticket.DeletedFlag);
            db.AddInParameter(cmd, "@ticketTypeOld", DbType.String, ticket.TicketTypeOld);
            db.AddInParameter(cmd, "@assignedTo", DbType.String, ticket.AssignedTo);
            db.AddInParameter(cmd, "@requestType", DbType.String, ticket.RequestType);
            db.AddInParameter(cmd, "@serviceImpact", DbType.String, ticket.ServiceImpact);
            db.AddInParameter(cmd, "@dateTimeAssigned", DbType.DateTime, ticket.DateTimeAssigned);
            db.AddInParameter(cmd, "@priority", DbType.String, ticket.Priority);
            db.AddInParameter(cmd, "@dateAssigned", DbType.DateTime, ticket.DateTimeAssigned);
            db.AddInParameter(cmd, "@trackIt", DbType.String, ticket.TrackIt);
            db.AddInParameter(cmd, "@contactMethod", DbType.String, ticket.ContactMethod);
            db.AddInParameter(cmd, "@locationSIMs", DbType.String, ticket.LocationSIMs);
            db.AddInParameter(cmd, "@userID", DbType.String, ticket.UserID);
            db.AddInParameter(cmd, "@ticketApplicationType", DbType.String, ticket.TicketApplicationType);
            db.AddInParameter(cmd, "@accountID", DbType.Int32, ticket.AccountID);

            db.AddOutParameter(cmd, "@resultCode", DbType.Int32, 4);
            db.AddOutParameter(cmd, "@resultMessage", DbType.String, 200);

            db.ExecuteNonQuery(cmd);


            res.Code = Int32.Parse(cmd.Parameters["@resultCode"].ToString());
            res.Message = cmd.Parameters["@resultMessage"].ToString();


            return res;

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].sprUpdateReOpenedTicket') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].sprUpdateReOpenedTicket
GO
 
CREATE PROCEDURE [dbo].sprUpdateReOpenedTicket
(
@ticketID int = null,
@ticketNumber nvarchar(50) = null,
@ticketType nvarchar(50) = null,
@ticketStatus nvarchar(50) = null,
@ticketSeverity nvarchar(50) = null,
@shortDescription nvarchar(1000) = null,
@externalTicket nvarchar(1000) = null,
@reasonMenu nvarchar(50) = null,
@problemNote ntext = null,
@solutionNote ntext = null,
@actionNote ntext = null,
@followupNote ntext = null,
@companiesFlag bit = null,
@agentCreated nvarchar(50) = null,
@dateCreated datetime = null,
@dateLastModified datetime = null,
@agentClosed nvarchar(50) = null,
@dateClosed datetime = null,
@agentFollowup nvarchar(50) = null,
@followupBy datetime = null,
@deletedFlag bit = null,
@ticketTypeOld nvarchar(50) = null,
@assignedTo varchar(50) = null,
@requestType varchar(50) = null,
@serviceImpact varchar(50) = null,
@dateTimeAssigned datetime = null,
@priority varchar(50) = null,
@dateAssigned datetime = null,
@trackIt varchar(50) = null,
@contactMethod varchar(50) = null,
@locationSIMs varchar(50) = null,
@userID nvarchar(50) = null,
@ticketApplicationType nvarchar(50) = null,
@accountID int = null,
@resultCode INT OUTPUT,
@resultMessage NVARCHAR(200) OUTPUT
)
AS
 
BEGIN
      BEGIN TRANSACTION
      BEGIN TRY
UPDATE
  [dbo].[tbl_tickets]
SET
  [TicketNumber] = @ticketNumber,
  [TicketType] = @ticketType,
  [TicketStatus] = @ticketStatus,
  [TicketSeverity] = @ticketSeverity,
  [ShortDescription] = @shortDescription,
  [ExternalTicket] = @externalTicket,
  [ReasonMenu] = @reasonMenu,
  [ProblemNote] = @problemNote,
  [SolutionNote] = @solutionNote,
  [ActionNote] = @actionNote,
  [FollowupNote] = @followupNote,
  [CompaniesFlag] = @companiesFlag,
  [AgentCreated] = @agentCreated,
  [DateCreated] = @dateCreated,
  [DateLastModified] = @dateLastModified,
  [AgentClosed] = @agentClosed,
  [DateClosed] = @dateClosed,
  [AgentFollowup] = @agentFollowup,
  [FollowupBy] = @followupBy,
  [DeletedFlag] = @deletedFlag,
  [TicketTypeOld] = @ticketTypeOld,
  [AssignedTo] = @assignedTo,
  [RequestType] = @requestType,
  [ServiceImpact] = @serviceImpact,
  [DateTimeAssigned] = @dateTimeAssigned,
  [Priority] = @priority,
  [DateAssigned] = @dateAssigned,
  [TrackIt] = @trackIt,
  [ContactMethod] = @contactMethod,
  [LocationSIMs] = @locationSIMs,
  [UserID] = @userID,
  [TicketApplicationType] = @ticketApplicationType,
  [AccountID] = @accountID
WHERE
  [TicketID] = @ticketID
              
              
              SET @resultCode = 0
              SET @resultMessage = 'ticketID ' + CAST(@ticketID  AS NVARCHAR(200)) + ': ' + @ticketNumber  + ' was updated.'
              
   
        END TRY
   
        BEGIN CATCH
  	IF @@TRANCOUNT > 1 ROLLBACK
              
              SET @ticketID = 0
              SET @resultCode = 1
              SET @resultMessage = 'ticketID ' + CAST(@ticketID AS NVARCHAR(200)) + ': ' + @ticketNumber + ' update error.  ' + char(13) + char(10)
                          + ERROR_NUMBER() + '. '  + char(13) + char(10)
                          + ERROR_MESSAGE() + '. ' + char(13) + char(10)
                          + ERROR_LINE() + '. ' + char(13) + char(10)
                          + ERROR_PROCEDURE() + '. ' + char(13) + char(10)
                          + ERROR_STATE() + '. ' + char(13) + char(10)
   
        END CATCH
  
  COMMIT TRAN
  END
GO

Select allOpen in new window