public SetQCByAttribute1 GetAttribute(string attribute1, string status, string statusSite, string connectionName)
{
Database db = DatabaseFactory.CreateDatabase(connectionName);
DbCommand dbCommand = db.GetStoredProcCommand(Resources.SetQCByAttribute1Resources.SP_SetQCByAttribute1);
db.AddInParameter(dbCommand, Resources.SetQCByAttribute1Resources.PARAM_ATTRIBUTE1, DbType.String, attribute1);
db.AddInParameter(dbCommand, Resources.SetQCByAttribute1Resources.PARAM_STATUS, DbType.String, status);
db.AddInParameter(dbCommand, Resources.SetQCByAttribute1Resources.PARAM_STATUS_SITE, DbType.String, statusSite);
SetQCByAttribute1 Attribute = new SetQCByAttribute1();
using (IDataReader dr = db.ExecuteReader(dbCommand))
{
int _attribute1 = dr.GetOrdinal(Resources.SetQCByAttribute1Resources.FIELD_ATTRIBUTE1);
if (dr.Read())
{
SetQCByAttribute1 item = new SetQCByAttribute1();
item.Attribute1 = dr.GetString(_attribute1);
Attribute = item;
}
}
return(Attribute);
}
public static SetQCByAttribute1 GetAttribute(string attribute1, string status, string statusSite)
{
SetQCByAttribute1 Attribute = new SetQCByAttribute1();
SetQCByAttribute1DAL objAttribute = new SetQCByAttribute1DAL();
try
{
try
{
Attribute = objAttribute.GetAttribute(attribute1, status, statusSite, CommonENT.MYCTSDB_CONNECTION);
}
catch (Exception ex)
{
new EventsManager.EventsManager(ex, EventsManager.EventsManager.OrigenError.BaseDeDatos);
Attribute = objAttribute.GetAttribute(attribute1, status, statusSite, CommonENT.MYCTSDBBACKUP_CONNECTION);
}
}
catch
{ }
return(Attribute);
}
