/// <summary>
/// Returns all record from dupe data base.
/// </summary>
/// <param name="commandText">The command text.</param>
/// <returns><c>null</c> if record not found, else <see cref="DataBaseDupe"/></returns>
public static List<DataBaseDupe> SelectFromDupeAll(string commandText)
{
Log.Debug("SelectFromDupeAll: '{0}'", commandText);
DataTable dataTable = GetDataTable(commandText);
DataRowCollection dataRowCollection = dataTable.Rows;
if (dataRowCollection.Count > 0)
{
List<DataBaseDupe> list = new List<DataBaseDupe>();
foreach (DataRow dataRow in dataRowCollection)
{
object[] itemArray = dataRow.ItemArray;
DataBaseDupe dataBaseDupe = new DataBaseDupe
{
Id = Misc.String2Number(itemArray[0].ToString()),
UserName = itemArray[1].ToString(),
GroupName = itemArray[2].ToString(),
DateTime = itemArray[3].ToString(),
PathReal = itemArray[4].ToString(),
PathVirtual = itemArray[5].ToString(),
ReleaseName = itemArray[6].ToString(),
Nuked = Misc.String2Number(itemArray[7].ToString()) > 0 ? true : false,
NukedReason = itemArray[8].ToString(),
Wiped = Misc.String2Number(itemArray[9].ToString()) > 0 ? true : false,
WipedReason = itemArray[10].ToString(),
};
list.Add(dataBaseDupe);
}
return list;
}
return null;
}
public string FormatDupe(string line,
DataBaseDupe dataBaseDupe)
{
string formatDupe = MinimumLength(line) || dataBaseDupe == null
? line
: String.Format(new MyFormat(), line
, dataBaseDupe.Id // {0}
, dataBaseDupe.UserName // {1}
, dataBaseDupe.GroupName // {2}
, dataBaseDupe.DateTime // {3}
, dataBaseDupe.PathReal // {4}
, dataBaseDupe.PathVirtual // {5}
, dataBaseDupe.ReleaseName // {6}
, dataBaseDupe.Nuked // {7}
, dataBaseDupe.NukedReason // {8}
, dataBaseDupe.Wiped // {9}
, dataBaseDupe.WipedReason // {10}
, Constants.CodeNewLine //{11}
, Constants.CodeIrcColor // {12}
, Constants.CodeIrcBold // {13}
, Constants.CodeIrcUnderline); // {14}
Log.Debug("FormatDupe: " + formatDupe);
return formatDupe;
}
