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(); }
}
}
public void TransformTextFact()
{
var connection = default(DbConnection);
var reader = default(DbDataReader);
try
{
connection = this._factory.CreateConnection();
connection.Open();
var schema = connection.GetTablesSchema();
reader = new DataTableReader(schema);
while (reader.Read())
{
var name = TextTemplateFact.GetTableName(reader);
var type = TextTemplateFact.GetTableType(reader);
var context = new InsertTableContext(name, type)
{
ProcedureNamePrefix = @"usp_",
ProcedureNameSuffix = @"",
};
var template = new InsertTableTemplate(context);
template.Initialize();
var text = template.TransformText();
// TODO :
}
}
finally
{
if (reader != null) { reader.Close(); }
if (connection != null) { connection.Close(); }
}
}
public void CtorTest ()
{
dt.Rows [1].Delete ();
DataTableReader reader = new DataTableReader (dt);
try {
int i = 0;
while (reader.Read ())
i++;
reader.Close ();
Assert.AreEqual (2, i, "no. of rows iterated is wrong");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'MyDataBaseDataSet1.mainbilll' table. You can move, or remove it, as needed.
this.mainbilllTableAdapter.Fill(this.MyDataBaseDataSet1.mainbilll);
DataTable table = this.MyDataBaseDataSet1.Tables[1];
DataTableReader read = new DataTableReader(table);
while (read.Read())
{
comboBox1.Items.Add(read.GetInt32(0));
}
read.Close();
this.reportViewer1.RefreshReport();
//Microsoft.Reporting.WinForms.ReportPageSettings settings = this.reportViewer1.LocalReport.GetDefaultPageSettings();
//settings.Margins.Bottom = 25;
//settings.Margins.Top = 25;
//settings.Margins.Left = 25;
//settings.Margins.Right = 25;
//Microsoft.Reporting.WinForms.
}
public void InvalidIndexTest ()
{
DataTableReader reader = new DataTableReader (dt);
try {
reader.Read ();
int i = (int) reader [90]; // kidding, ;-)
i++; // to supress warning
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void AccessBeforeReadTest ()
{
DataTableReader reader = new DataTableReader (dt);
try {
int i = (int) reader [0];
i++; // to supress warning
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void ClearTest ()
{
DataTableReader reader = null;
try {
reader = new DataTableReader (dt);
reader.Read (); // first row
reader.Read (); // second row
dt.Clear ();
try {
int i = (int) reader [0];
i++; // supress warning
Assert.Fail("#1 should have thrown RowNotInTableException");
} catch (RowNotInTableException) {}
// clear and add test
reader.Close ();
reader = new DataTableReader (dt);
reader.Read (); // first row
reader.Read (); // second row
dt.Clear ();
dt.Rows.Add (new object [] {8, "mono 8"});
dt.AcceptChanges ();
bool success = reader.Read ();
Assert.IsFalse (success, "#2 is always invalid");
// clear when reader is not read yet
reader.Close ();
reader = new DataTableReader (dt);
dt.Clear ();
dt.Rows.Add (new object [] {8, "mono 8"});
dt.AcceptChanges ();
success = reader.Read ();
Assert.IsTrue (success, "#3 should add");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void DeletePreviousAndAcceptChangesTest ()
{
DataTableReader reader = new DataTableReader (dt);
try {
reader.Read (); // first row
reader.Read (); // second row
dt.Rows [0].Delete ();
dt.AcceptChanges ();
Assert.AreEqual (2, (int) reader [0], "#1 should not affect the current position");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void GetTest ()
{
dt.Columns.Add ("nullint", typeof (int));
dt.Rows [0] ["nullint"] = 333;
DataTableReader reader = new DataTableReader (dt);
try {
reader.Read ();
int ordinal = reader.GetOrdinal ("nullint");
// Get by name
Assert.AreEqual (1, (int) reader ["id"], "#1 should be able to get by name");
Assert.AreEqual (333, reader.GetInt32 (ordinal), "#2 should get int32");
Assert.AreEqual ("System.Int32", reader.GetDataTypeName (ordinal), "#3 data type should match");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void MultipleResultSetsTest ()
{
DataTable dt1 = new DataTable ("test2");
dt1.Columns.Add ("x", typeof (string));
dt1.Rows.Add (new object [] {"test"} );
dt1.Rows.Add (new object [] {"test1"} );
dt1.AcceptChanges ();
DataTable [] collection = new DataTable [] { dt, dt1 } ;
DataTableReader reader = new DataTableReader (collection);
try {
int i = 0;
do {
while (reader.Read ())
i++;
} while (reader.NextResult ());
Assert.AreEqual (5, i, "#1 rows should be of both the tables");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void SchemaTest ()
{
DataTable another = new DataTable ("another");
another.Columns.Add ("x", typeof (string));
another.Rows.Add (new object [] {"test 1" });
another.Rows.Add (new object [] {"test 2" });
another.Rows.Add (new object [] {"test 3" });
DataTableReader reader = new DataTableReader (new DataTable [] { dt, another });
try {
DataTable schema = reader.GetSchemaTable ();
Assert.AreEqual (dt.Columns.Count, schema.Rows.Count, "#1 should be same");
Assert.AreEqual (dt.Columns [1].DataType.ToString (), schema.Rows [1] ["DataType"].ToString (), "#2 data type should match");
reader.NextResult (); //schema should change here
schema = reader.GetSchemaTable ();
Assert.AreEqual (another.Columns.Count, schema.Rows.Count, "#3 should be same");
Assert.AreEqual (another.Columns [0].DataType.ToString (), schema.Rows [0] ["DataType"].ToString (), "#4 data type should match");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void SeeTheModifiedTest ()
{
DataTableReader reader = new DataTableReader (dt);
try {
reader.Read (); // first row
dt.Rows [1] ["name"] = "mono changed";
reader.Read ();
string value = reader [1].ToString ();
Assert.AreEqual ("mono changed", value, "#2 reader should have moved to 3rd row");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void IgnoreDeletedRowsDynamicTest ()
{
DataTableReader reader = new DataTableReader (dt);
try {
reader.Read (); // first row
dt.Rows [1].Delete ();
reader.Read (); // it should be 3rd row
string value = reader [0].ToString ();
Assert.AreEqual ("3", value, "#1 reader should have moved to 3rd row");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
private void backbone(Akt akten)
{
label1.Text = tk.vuxna.ToString();
label2.Text = tk.ungdom.ToString();
label3.Text = tk.barn.ToString();
label5.Text = tk.biljetter[tk.fuskIgen].forestallning.namn;
label6.Text = tk.biljetter[tk.fuskIgen].akter.namn;
rk2();
// label8.Text = tk.totalpris.ToString() + " Kr";
// radiokoll(); den var här förut, funkade, beehövs den`?
//Akt temp = new Akt();
//temp = tk.akter[tk.antal];
// int id = tk.biljetter[tk.fuskIgen].akter.id;
int id = akten.id;
string query = "select * from biljett where akt_id = ";
query += id.ToString();
NpgsqlDataAdapter da = new NpgsqlDataAdapter(query, conn);
da.Fill(dt);
int x = 0;
x = tk.vuxna + tk.barn + tk.ungdom;
/* if (x >= 8)
{
MessageBox.Show("Tyvärr finns inte tillräkligt med plats, utanför");
this.Hide();
Huvudsidan hu = new Huvudsidan();
hu.ShowDialog();
Close();
}*/
//Här ska tk metoden ligga, kanske :p
foreach (DataRow row in dt.Rows)
{
if ((bool)row["fri_placering"] == true)
{
}
else
{
/* if (x >= 8)
{
MessageBox.Show("Tyvärr finns inte tillräkligt med plats, innanför");
this.Hide();
Huvudsidan hu = new Huvudsidan();
hu.ShowDialog();
Close();
}
else
{ */
string platsid = row["plats_id"].ToString();
bool vecka = false;
DateTime dt = new DateTime();
// dt = (DateTime)row["tidsstampel"];
if ((bool)row["reserverad"] == true)
{
DateTime dat = (DateTime)row["tidsstampel"];
DateTime nu = DateTime.Now;
TimeSpan ts = new TimeSpan(7, 0, 0, 0);
//TimeSpan elapsed = nu.Subtract(dat);
DateTime test = tk.biljetter[0].forestallning.forsaljningsslut.Subtract(ts);
if (test < DateTime.Now)
{
vecka = true;
}
}
string query2 = "select nummer from platser where id =" + platsid;
NpgsqlDataAdapter da2 = new NpgsqlDataAdapter(query2, conn);
DataTable dt2 = new DataTable();
da2.Fill(dt2);
DataTableReader dr = new DataTableReader(dt2);
string platsnamn = "";
while (dr.Read())
{
string fusk = "button_";
platsnamn = dr[0].ToString();
fusk += platsnamn;
gk(button_A1, fusk, vecka, platsid, id);
gk(button_A2, fusk, vecka, platsid, id);
gk(button_A3, fusk, vecka, platsid, id);
gk(button_A4, fusk, vecka, platsid, id);
gk(button_A5, fusk, vecka, platsid, id);
gk(button_A6, fusk, vecka, platsid, id);
gk(button_A7, fusk, vecka, platsid, id);
gk(button_A8, fusk, vecka, platsid, id);
gk(button_B1, fusk, vecka, platsid, id);
gk(button_B2, fusk, vecka, platsid, id);
gk(button_B3, fusk, vecka, platsid, id);
gk(button_B4, fusk, vecka, platsid, id);
gk(button_B5, fusk, vecka, platsid, id);
gk(button_B6, fusk, vecka, platsid, id);
gk(button_B7, fusk, vecka, platsid, id);
gk(button_B8, fusk, vecka, platsid, id);
gk(button_D1, fusk, vecka, platsid, id);
gk(button_D2, fusk, vecka, platsid, id);
gk(button_D3, fusk, vecka, platsid, id);
gk(button_D4, fusk, vecka, platsid, id);
gk(button_D5, fusk, vecka, platsid, id);
gk(button_D6, fusk, vecka, platsid, id);
gk(button_D7, fusk, vecka, platsid, id);
gk(button_D8, fusk, vecka, platsid, id);
gk(button_F1, fusk, vecka, platsid, id);
gk(button_F2, fusk, vecka, platsid, id);
gk(button_F3, fusk, vecka, platsid, id);
gk(button_F4, fusk, vecka, platsid, id);
gk(button_F5, fusk, vecka, platsid, id);
gk(button_F6, fusk, vecka, platsid, id);
gk(button_F7, fusk, vecka, platsid, id);
gk(button_F8, fusk, vecka, platsid, id);
gk(button_H1, fusk, vecka, platsid, id);
gk(button_H2, fusk, vecka, platsid, id);
gk(button_H3, fusk, vecka, platsid, id);
gk(button_H4, fusk, vecka, platsid, id);
gk(button_H5, fusk, vecka, platsid, id);
gk(button_H6, fusk, vecka, platsid, id);
gk(button_H7, fusk, vecka, platsid, id);
gk(button_H8, fusk, vecka, platsid, id);
gk(button_G1, fusk, vecka, platsid, id);
gk(button_G2, fusk, vecka, platsid, id);
gk(button_G3, fusk, vecka, platsid, id);
gk(button_G4, fusk, vecka, platsid, id);
gk(button_G5, fusk, vecka, platsid, id);
gk(button_G6, fusk, vecka, platsid, id);
gk(button_G7, fusk, vecka, platsid, id);
gk(button_G8, fusk, vecka, platsid, id);
gk(button_E1, fusk, vecka, platsid, id);
gk(button_E2, fusk, vecka, platsid, id);
gk(button_E3, fusk, vecka, platsid, id);
gk(button_E4, fusk, vecka, platsid, id);
gk(button_E5, fusk, vecka, platsid, id);
gk(button_E6, fusk, vecka, platsid, id);
gk(button_E7, fusk, vecka, platsid, id);
gk(button_E8, fusk, vecka, platsid, id);
gk(button_C1, fusk, vecka, platsid, id);
gk(button_C2, fusk, vecka, platsid, id);
gk(button_C3, fusk, vecka, platsid, id);
gk(button_C4, fusk, vecka, platsid, id);
gk(button_C5, fusk, vecka, platsid, id);
gk(button_C6, fusk, vecka, platsid, id);
gk(button_C7, fusk, vecka, platsid, id);
gk(button_C8, fusk, vecka, platsid, id);
// }
}
dr.Close();
x++;
}
}
}
public void DontSeeTheEarlierRowsTest ()
{
DataTableReader reader = new DataTableReader (dt);
try {
reader.Read (); // first row
reader.Read (); // second row
// insert a row at position 0
DataRow r = dt.NewRow ();
r [0] = 0;
r [1] = "adhi bagavan";
dt.Rows.InsertAt (r, 0);
Assert.AreEqual (2, (int) reader.GetInt32 (0), "#1 should not alter the position");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void CloseTest ()
{
DataTableReader reader = new DataTableReader (dt);
try {
int i = 0;
while (reader.Read () && i < 1)
i++;
reader.Close ();
reader.Read ();
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void AddAtPointTest ()
{
DataTableReader reader = new DataTableReader (dt);
try {
reader.Read (); // first row
reader.Read (); // second row
DataRow r = dt.NewRow ();
r [0] = 0;
r [1] = "same point";
dt.Rows.InsertAt (r, 1);
dt.Rows.Add (new object [] { 4, "mono 4"}); // should not affect the counter
Assert.AreEqual (2, (int) reader [0], "#1 should not affect the current position");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void GetOrdinalTest ()
{
DataTableReader reader = new DataTableReader (dt);
try {
Assert.AreEqual (1, reader.GetOrdinal ("name"), "#1 get ordinal should work even" +
" without calling Read");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void DeleteLastAndAcceptChangesTest2 ()
{
DataTableReader reader = new DataTableReader (dt);
try {
reader.Read (); // first row
reader.Read (); // second row
reader.Read (); // third row
dt.Rows [2].Delete (); // delete row, where reader points to
dt.AcceptChanges (); // accept the action
Assert.AreEqual (2, (int) reader [0], "#1 should point to the first row");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void NoRowsTest ()
{
dt.Rows.Clear ();
dt.AcceptChanges ();
DataTableReader reader = new DataTableReader (dt);
try {
Assert.IsFalse (reader.Read (), "#1 there are no rows");
Assert.IsFalse (reader.NextResult (), "#2 there are no further resultsets");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void MultipleDeleteTest ()
{
dt.Rows.Add (new object [] {4, "mono 4"});
dt.Rows.Add (new object [] {5, "mono 5"});
dt.Rows.Add (new object [] {6, "mono 6"});
dt.Rows.Add (new object [] {7, "mono 7"});
dt.Rows.Add (new object [] {8, "mono 8"});
dt.AcceptChanges ();
DataTableReader reader = new DataTableReader (dt);
try {
reader.Read (); // first row
reader.Read ();
reader.Read ();
reader.Read ();
reader.Read ();
dt.Rows [3].Delete ();
dt.Rows [1].Delete ();
dt.Rows [2].Delete ();
dt.Rows [0].Delete ();
dt.Rows [6].Delete ();
dt.AcceptChanges ();
Assert.AreEqual (5, (int) reader [0], "#1 should keep pointing to 5");
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void NoTablesTest ()
{
DataTableReader reader = new DataTableReader (new DataTable [] {});
try {
reader.Read ();
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void RowInAccessibleTest ()
{
DataTableReader reader = new DataTableReader (dt);
try {
reader.Read ();
reader.Read (); // 2nd row
dt.Rows [1].Delete ();
string value = reader [1].ToString ();
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void ReadAfterClosedTest ()
{
DataTableReader reader = new DataTableReader (dt);
try {
reader.Read ();
reader.Close ();
reader.Read ();
} finally {
if (reader != null && !reader.IsClosed)
reader.Close ();
}
}
public void loadTableName(ComboBox cb)
{
System.Data.DataTable dt = ocon.GetSchema("Tables");
DataTableReader dtr = new DataTableReader(dt);
cb.Items.Clear();
cb.Text = "";
while (dtr.Read())
{
cb.Items.Add(dtr["Table_Name"]);
}
dtr.Close();
}
public void ExecuteReader(string command, Action<System.Data.Common.DbDataReader> action)
{
if (command == "SELECT GETDATE()")
{
var dataTable = new DataTable("mocktable");
dataTable.Columns.Add("column0", typeof(DateTime));
dataTable.Rows.Add(new DateTime(2001, 2, 3, 4, 5, 6, 7));
var dataReader = new DataTableReader(dataTable);
while (dataReader.Read())
action(dataReader);
dataReader.Close();
}
else
throw new NotImplementedException();
}
