public Int32 UpdateAgentGroup(IAgentGroup iagentgroup)
{
Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS");
string sqlCommand = "proAgentGroupUpdate";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@UserAction", DbType.Byte, iagentgroup.UserAction);
db.AddInParameter(dbCommand, "@ID_AgentGroup", DbType.String, iagentgroup.MasterID);
db.AddInParameter(dbCommand, "@AgentGroupCode", DbType.String, iagentgroup.AgentGroupCode);
db.AddInParameter(dbCommand, "@AgentGroupName", DbType.String, iagentgroup.AgentGroupName);
db.AddInParameter(dbCommand, "@AgentGroupOverdueHours", DbType.Int32, iagentgroup.AgentGroupOverdueHours);
db.AddInParameter(dbCommand, "@AggAdministrator", DbType.Byte, iagentgroup.AggAdministrator);
db.AddInParameter(dbCommand, "@AggAdd", DbType.Byte, iagentgroup.AggAdd);
db.AddInParameter(dbCommand, "@AggModify", DbType.Byte, iagentgroup.AggModify);
db.AddInParameter(dbCommand, "@AggDelete", DbType.Byte, iagentgroup.AggDelete);
db.AddInParameter(dbCommand, "@AggView", DbType.Byte, iagentgroup.AggView);
db.AddInParameter(dbCommand, "@SortOrder", DbType.Int64, iagentgroup.SortOrder);
db.AddInParameter(dbCommand, "@UserCode", DbType.Int64, iagentgroup.UserCode);
db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, iagentgroup.FK_Company);
try
{
return(Convert.ToInt32(db.ExecuteScalar(dbCommand)));
}
catch (SqlException e)
{
return(0);
}
}
protected override void Dispose(bool disposing)
{
base.Dispose(disposing);
if (!disposing)
{
return;
}
m_agents = null;
m_lockedAgents.Clear();
m_lockedAgents = null;
m_outputAgents.Dispose();
}
public int DeleteAgentGroup(IAgentGroup iagentgroup)
{
Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS");
string sqlCommand = "proAgentGroupDelete";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ID_AgentGroup", DbType.Int64, iagentgroup.MasterID);
db.AddInParameter(dbCommand, "@CancelledUser", DbType.Int64, iagentgroup.UserCode);
db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, iagentgroup.FK_Company);
try
{
return(Convert.ToInt32(db.ExecuteScalar(dbCommand)));
}
catch (SqlException e)
{
//UpdateErrorLog(iTopic, e);
throw e;
}
}
public DataTable SelectAllAgentGroup(IAgentGroup iagentgroup)
{
DataTable dtblAgentGroup = new DataTable();
Database db = DatabaseFactory.CreateDatabase("SUPPORTTICKETS");
string sqlCommand = "proAgentGroupSelect";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "@ID_AgentGroup", DbType.String, iagentgroup.MasterID);
db.AddInParameter(dbCommand, "@AgentGroupCode", DbType.String, iagentgroup.AgentGroupCode);
db.AddInParameter(dbCommand, "@AgentGroupName", DbType.String, iagentgroup.AgentGroupName);
db.AddInParameter(dbCommand, "@PageIndex", DbType.Int32, iagentgroup.PageIndex);
db.AddInParameter(dbCommand, "@PageSize", DbType.Int32, iagentgroup.PageSize);
db.AddInParameter(dbCommand, "@FK_Company", DbType.Int64, iagentgroup.FK_Company);
try
{
dtblAgentGroup = db.ExecuteDataSet(dbCommand).Tables[0];
return(dtblAgentGroup);
}
catch (SqlException e)
{
throw e;
}
}
