public void LoadSingleVersion(BLL.Version oVersion)
{
StringBuilder sSQL = new StringBuilder();
sSQL.AppendLine("select")
.AppendLine(" *")
.AppendLine(" from")
.AppendLine(" [version] a")
.AppendLine(" where")
.AppendFormat(" a.[VersionID]='{0}'", oVersion.VersionID);
DataTable oDT = base.ExecuteSQLToDatatable(sSQL.ToString());
if (oDT.Rows.Count > 0)
{
oVersion.DBID = (Guid)oDT.Rows[0]["DBID"];
oVersion.ScanStart = oDT.Rows[0]["ScanStart"].ToString();
oVersion.ScanComplete = DBHelper.NullToString(oDT.Rows[0]["ScanComplete"]);
oVersion.ChangesFound = (bool)oDT.Rows[0]["ChangesFound"];
oVersion.ChangeDateTime = oDT.Rows[0]["change_date_time"].ToString();
oVersion.ChangeUID = oDT.Rows[0]["change_uid"].ToString();
}
else
{
oVersion = null;
}
}
private List <distroTrend.Model.Version> GetVersions(int distroId)
{
BLL.Version objVersion = new BLL.Version();
List <distroTrend.Model.Version> versions = objVersion.GetVersions(_connString, distroId).ToList();
return(versions);
}
public List <SQLAutoDocLib.BLL.Version> ListAllVersionsInDatabase(Guid DBID)
{
List <SQLAutoDocLib.BLL.Version> oList = new List <SQLAutoDocLib.BLL.Version>();
DataTable oIDs = m_DBFactory.AllVersions(DBID: DBID);
foreach (DataRow oID in oIDs.Rows)
{
BLL.Version oVersion = new BLL.Version(DBID: DBID, VersionID: oID[0].ToString());
oVersion.Load();
oList.Add(oVersion);
}
return(oList);
}
