/// <summary>
/// Get the values of Planning table to set configs vars...
/// </summary>
/// <param name="unique_id"></param>
/// <returns></returns>
public static Configs ReadPlanning(string unique_id)
{
Configs cfg = new Configs();
//
String sql = @"SELECT ColSiteNum
, OperatorName
, UniqueId
, DUName
, InstanceId
, DataExpCtrChk
, WaiverChk
, VolumeGB
, DurationWorkDays
, PlanAOReceiveDate
, ActAOReceiveDate
, PlanAOStartDate
, ActAOStartDate
, PlanAOEndDate
, ActAOEndDate
, Status
, Comment
FROM Shell_AutoArchDB.dbo.shell_Planning
WHERE UniqueId LIKE '%{0}%'";
SqlCommand comm = new SqlCommand();
comm.CommandText = string.Format(sql, unique_id);
comm.CommandType = CommandType.Text;
using (SqlDataReader dataReader = SQLServer.DataAccess.ExecuteReader(comm))
{
if (dataReader.Read())
{
cfg.COLSITENUM = dataReader.GetInt32(0).ToString().Trim();
//
if (!dataReader.IsDBNull(1))
cfg.OPERATORNAME = dataReader.GetString(1).Trim();
//
cfg.UNIQUEID = dataReader.GetString(2).Trim();
cfg.DUNAME = dataReader.GetString(3).Trim();
cfg.INSTANCEID = dataReader.GetString(4).Trim();
//
if (!dataReader.IsDBNull(5))
cfg.DATAEXPCTRCHK = dataReader.GetInt32(5).ToString().Trim();
if (!dataReader.IsDBNull(6))
cfg.WAIVERCHK = dataReader.GetInt32(6).ToString().Trim();
cfg.VOLUMEGB = dataReader.GetDecimal(7).ToString().Trim();
//
if (!dataReader.IsDBNull(8))
cfg.DURATIONWORKDAYS = dataReader.GetInt32(8).ToString().Trim();
//
if (!dataReader.IsDBNull(9)) { cfg.PLANAORECEIVEDATE = dataReader.GetDateTime(9).ToString().Trim(); }
if (!dataReader.IsDBNull(10)) { cfg.ACTAORECEIVEDATE = dataReader.GetDateTime(10).ToString().Trim(); }
if (!dataReader.IsDBNull(11)) { cfg.PLANAOSTARTDATE = dataReader.GetDateTime(11).ToString().Trim(); }
if (!dataReader.IsDBNull(12)) { cfg.ACTAOSTARTDATE = dataReader.GetDateTime(12).ToString().Trim(); }
if (!dataReader.IsDBNull(13)) { cfg.PLANAOENDDATE = dataReader.GetDateTime(13).ToString().Trim(); }
if (!dataReader.IsDBNull(14)) { cfg.ACTAOENDDATE = dataReader.GetDateTime(14).ToString().Trim(); }
//
cfg.STATUS = dataReader.GetString(15).Trim();
//
if (!dataReader.IsDBNull(16))
cfg.COMMENT = dataReader.GetString(16).Trim();
}
}
return cfg;
}
/// <summary>
/// Get the values of LAPI table to set configs vars...
/// </summary>
/// <param name="id_instance"></param>
/// <returns></returns>
public static Configs ReadLAPI(string id_instance)
{
Configs cfg = new Configs();
//
String sql = @"SELECT ID_INSTANCE
,LL_IP
,LL_PORT
,LL_BASE_URI
,TSI_Managed
,ArchTool_Max_Thread_Ini
,ArchTool_Max_Thread_fim
FROM Shell_AutoArchDB.dbo.shell_LAPIconf
WHERE ID_INSTANCE LIKE '%{0}%'";
SqlCommand comm = new SqlCommand();
comm.CommandText = string.Format(sql, id_instance);
comm.CommandType = CommandType.Text;
using (SqlDataReader dataReader = SQLServer.DataAccess.ExecuteReader(comm))
{
if (dataReader.Read())
{
cfg.ID_INSTANCE = dataReader.GetString(0).Trim();
cfg.LL_IP = dataReader.GetString(1).Trim();
cfg.LL_PORT = dataReader.GetString(2).Trim();
cfg.LL_BASE_URI = dataReader.GetString(3).Trim();
cfg.TSI_MANAGED = dataReader.GetInt32(4);
cfg.ARCHTOOL_MAX_THREAD_INI = dataReader.GetInt32(5).ToString().Trim();
cfg.ARCHTOOL_MAX_THREAD_FIM = dataReader.GetInt32(6).ToString().Trim();
}
}
return cfg;
}
