public static AgentPCC GetAgentPCC(string Agent)
{
AgentPCC item = new AgentPCC();
AgentPCCDAL objAgents = new AgentPCCDAL();
try
{
try
{
item = objAgents.GetAgentPCC(Agent, CommonENT.MYCTSDBPRODUCTIVITY_CONNECTION);
}
catch (Exception ex)
{
new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos);
item = objAgents.GetAgentPCC(Agent, CommonENT.MYCTSDBPRODUCTIVITYBACKUP_CONNECTION);
}
}
catch
{ }
return(item);
}
public AgentPCC GetAgentPCC(string Agent, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbCommand = db.GetStoredProcCommand(Resources.AgentPCCResources.SP_GetAgentPCC);
db.AddInParameter(dbCommand, Resources.AgentPCCResources.PARAM_QUERY, DbType.String, Agent);
AgentPCC item = new AgentPCC();
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
int _pcc = dr.GetOrdinal(Resources.AgentPCCResources.PARAM_PCC);
while (dr.Read())
{
item.PCC = (dr[_pcc] == DBNull.Value) ? Types.StringNullValue : dr.GetString(_pcc);
}
}
return(item);
}
