public DataTable SelectAllUserTickets(IUserTickets iUserTickets) { DataTable dtblUserTickets = new DataTable(); Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS"); string sqlCommand = "proUserTicketsSelect"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@UserCode", DbType.Int64, iUserTickets.UserCode); db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, iUserTickets.FK_Company); db.AddInParameter(dbCommand, "@ProdName", DbType.String, iUserTickets.ProdName); db.AddInParameter(dbCommand, "@TicketNo", DbType.String, iUserTickets.TickNo); db.AddInParameter(dbCommand, "@TicketSubject", DbType.String, iUserTickets.TickSubject); db.AddInParameter(dbCommand, "@PageIndex", DbType.Int32, iUserTickets.PageIndex); db.AddInParameter(dbCommand, "@PageSize", DbType.Int32, iUserTickets.PageSize); db.AddInParameter(dbCommand, "@Status", DbType.Int16, iUserTickets.TickStatus); try { dtblUserTickets = db.ExecuteDataSet(dbCommand).Tables[0]; return(dtblUserTickets); } catch (SqlException e) { throw e; } }
public Int32 UpdateUserTickets(IUserTickets iUserTickets) { Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS"); string sqlCommand = "proUserTicketsUpdate"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@UserAction", DbType.Byte, iUserTickets.UserAction); db.AddInParameter(dbCommand, "@ID_Tickets", DbType.String, iUserTickets.MasterID); db.AddInParameter(dbCommand, "@TickNo", DbType.String, iUserTickets.TickNo); db.AddInParameter(dbCommand, "@TickDate", DbType.DateTime, iUserTickets.TickDate); db.AddInParameter(dbCommand, "@TickSubject", DbType.String, iUserTickets.TickSubject); db.AddInParameter(dbCommand, "@TickPriority", DbType.Int16, iUserTickets.TickPriority); db.AddInParameter(dbCommand, "@Description", DbType.String, iUserTickets.TickDescription); db.AddInParameter(dbCommand, "@XmlAttachment", DbType.String, iUserTickets.XmlAttachment); db.AddInParameter(dbCommand, "@TickStatus", DbType.Int16, iUserTickets.TickStatus); db.AddInParameter(dbCommand, "@FK_Product", DbType.Int64, iUserTickets.FK_Product); db.AddInParameter(dbCommand, "@FK_Topic", DbType.Int64, iUserTickets.FK_Topic); db.AddInParameter(dbCommand, "@AgentCode", DbType.Int64, iUserTickets.AgentCode); db.AddInParameter(dbCommand, "@UserCode", DbType.Int64, iUserTickets.UserCode); db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, iUserTickets.FK_Company); db.AddInParameter(dbCommand, "@UserIPAddress", DbType.String, iUserTickets.UserIPAddress); try { return(Convert.ToInt32(db.ExecuteScalar(dbCommand))); } catch (SqlException e) { return(0); } }
public DataTable AutoGenTktNo(IUserTickets iUserTickets) { DataTable dtbl = new DataTable(); Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS"); string sqlCommand = "proTicketAutoGenerate"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, iUserTickets.FK_Company); try { dtbl = db.ExecuteDataSet(dbCommand).Tables[0]; return(dtbl); } catch (SqlException e) { throw e; } }
public int DeleteUserTickets(IUserTickets iUserTickets) { Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS"); string sqlCommand = "proUserTicketsDelete"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@ID_UserTickets", DbType.Int64, iUserTickets.MasterID); db.AddInParameter(dbCommand, "@CancelledUser", DbType.Int64, iUserTickets.UserCode); db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, iUserTickets.FK_Company); try { return(Convert.ToInt32(db.ExecuteScalar(dbCommand))); } catch (SqlException e) { //UpdateErrorLog(iUserTickets, e); throw e; } }
public DataTable SelectGetTicketDetails(IUserTickets iUserTickets) { DataTable dtblUserTickets = new DataTable(); Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS"); string sqlCommand = "proUserTicketDetailsSelect"; DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand); db.AddInParameter(dbCommand, "@UserCode", DbType.Int64, iUserTickets.UserCode); db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, iUserTickets.FK_Company); db.AddInParameter(dbCommand, "@ID_Tickets", DbType.Int64, iUserTickets.MasterID); try { dtblUserTickets = db.ExecuteDataSet(dbCommand).Tables[0]; return(dtblUserTickets); } catch (SqlException e) { throw e; } }