public void Fact()
{
var connection = default (DbConnection);
var reader = default(DbDataReader);
try
{
connection = KandaXunitProviderFactory.Instance.CreateConnection();
connection.Open();
var schema = connection.GetTablesSchema();
reader = new DataTableReader(schema);
while (reader.Read())
{
var name = reader.GetString(reader.GetOrdinal(@"TABLE_NAME"));
var type = reader.GetString(reader.GetOrdinal(@"TABLE_TYPE"));
//this.transformEntity(name, type);
this.transformInsertTable(name, type);
}
}
finally
{
if (reader != null) { reader.Close(); }
if (connection != null) { connection.Close(); }
}
}
private void FillPartyName()
{
DataTableReader read = new DataTableReader(this.maindataset.Pending);
while (read.Read())
{
txtPartyName.Items.Add(read.GetString(3));
}
}
//list the log-in sessions according to the selected criterion
private void BuildListBox(int userID, int groupID, DateTime time1, DateTime time2, bool cvs)
{
string pad = " ";
try
{
DataSet sessionData = InternalAdminDB.SelectSessionHistory(userID, groupID, time1, time2);
DataTable sessionHistory = sessionData.Tables[0];
if (sessionHistory.Rows.Count == 0)
{
lblResponse.Text = Utilities.FormatWarningMessage(" No sessions found for your criteria.");
lblResponse.Visible = true;
}
else
{
StringBuilder buf = new StringBuilder();
buf.AppendLine(String.Format("{0,-14}{1,-18}{2,-10}{3,-10}{4,-26}{5,-24}",
"User Name", "Create Time", "End Time","Modify","Group","Client"));
DataTableReader dtr = new DataTableReader(sessionHistory);
while(dtr.Read())
{
//buf.Append(dtr.GetInt64(0) + pad);
buf.Append(String.Format("{0,-12:12}", dtr.GetString(1)) + pad);
if(!dtr.IsDBNull(2))
buf.Append(DateUtil.ToUserTime(dtr.GetDateTime(2),
CultureInfo.InvariantCulture,userTZ,"g") +pad);
else
buf.Append(String.Format("{0,-9:9}", "Not Set") + pad);
if (!dtr.IsDBNull(3))
buf.Append(DateUtil.ToUserTime(dtr.GetDateTime(3), CultureInfo.InvariantCulture, userTZ, "T") + pad);
else
buf.Append(String.Format("{0,-8}", "Not Set") + pad);
if (!dtr.IsDBNull(4))
buf.Append(DateUtil.ToUserTime(dtr.GetDateTime(4), CultureInfo.InvariantCulture, userTZ, "T") + pad);
else
buf.Append(String.Format("{0,-8}", "Not Set") + pad);
string tmp = dtr.GetString(5);
if (tmp != null && tmp.Length > 24)
tmp = tmp.Substring(0, 24);
buf.Append(String.Format("{0,-24}",tmp) + pad);
tmp = dtr.GetString(6);
if (tmp != null && tmp.Length > 24)
tmp = tmp.Substring(0, 24);
buf.Append(String.Format("{0,-24}",tmp));
buf.AppendLine();
}
txtLoginDisplay.Text = buf.ToString();
}
}
catch (Exception ex)
{
lblResponse.Text = Utilities.FormatErrorMessage(" Cannot retrieve UserSessions. " + ex.GetBaseException());
lblResponse.Visible = true;
}
}
