private void bbatonishe_Click(object sender, EventArgs e)
{
dabse.OleDbCommand newCom = new dabse.OleDbCommand();
var comand = new dabse.OleDbCommand("SELECT Код, Название FROM Дисциплины WHERE Шифр_специальности=?", Date_baseone);
comand.Parameters.Add("Шфр_спц", dabse.OleDbType.Integer, 255).Value = int.Parse(shifrSpecialnosti.Text);
comand.Connection = Date_baseone;
dabse.OleDbDataReader Result = comand.ExecuteReader();
int x = Result.FieldCount;
String Name_disc, index_disk;
while (Result.Read() == true)
{
index_disk = Result.GetValue(0).ToString();
Name_disc = Result.GetValue(1).ToString();
dabse.OleDbCommand spisok = new dabse.OleDbCommand("insert into Дисциплины_обучение (Шифр_студента, Код_дисциплины) values (?, ?)", Date_baseone);
spisok.Parameters.Add("Шифр_студента", dabse.OleDbType.Integer, 255).Value = int.Parse(shifrStudenta.Text);
spisok.Parameters.Add("Код_дисциплины", dabse.OleDbType.Integer, 255).Value = int.Parse(index_disk);
spisok.Connection = Date_baseone;
//MessageBox.Show(spisok.CommandText);
spisok.ExecuteReader();
//spisok.Close();
}
MessageBox.Show("Всё хорошо!!!");
}
public Form1()
{
InitializeComponent();
var connection = new oleDB.OleDbConnection("Data Source=\"e:\\vic.mdb\";User ID=Admin;Provider=\"Microsoft.Jet.OLEDB.4.0\";");
connection.Open();
oleDB.OleDbCommand command = new oleDB.OleDbCommand("Select * From [Phones]", connection);
oleDB.OleDbDataReader reader = command.ExecuteReader();
DataTable table = new DataTable();
table.Columns.Add(reader.GetName(0));
table.Columns.Add(reader.GetName(1));
table.Columns.Add(reader.GetName(2));
while (reader.Read() == true)
{
table.Rows.Add(new object[] { reader.GetValue(0), reader.GetValue(1), reader.GetValue(2) });
}
reader.Close();
connection.Close();
dataGridView1.DataSource = table;
}
// Constructor for searched login
public Login(uint gloid)
{
// Declarations
uint gvoid = 0, modifiedby = 0;
string username = null, password = null, note = null, status = null;
bool active = false;
DateTime datemodified = new DateTime(1901, 1, 1);
// Command
string query = string.Format("SELECT glo_username, glo_password, glo_note, glo_active, glo_status, gvo_id, date_modified, modified_by FROM gfrc_login" +
" WHERE glo_id = {0}", gloid);
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
username = rdr.GetString(0);
password = rdr.GetString(1);
note = rdr.GetString(2);
active = rdr.GetBoolean(3);
status = rdr.GetString(4);
if (!UInt32.TryParse(rdr.GetValue(5).ToString(), out gvoid))
gvoid = 0;
if (!DateTime.TryParse(rdr.GetValue(6).ToString(), out datemodified))
datemodified = new DateTime(1901, 1, 1);
if (!UInt32.TryParse(rdr.GetValue(7).ToString(), out modifiedby))
modifiedby = 0;
}
}
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
_gloID = gloid;
_Username = username;
_Password = password;
_Note = note;
_Active = active;
_Status = status;
_gvoID = gvoid;
_DateModified = datemodified;
_ModifiedBy = modifiedby;
}
// Constructor for searched volunteer holiday
public Holiday(uint gvhid)
{
// Declarations
uint gvoid = 0, modifiedby = 0;
DateTime datemodified = new DateTime(1901, 1, 1), start = new DateTime(1901, 1, 1), end = new DateTime(1901, 1, 1);
// Command
string query = string.Format("SELECT gvo_id, gvh_start, gvh_end, date_modified, modified_by " +
"FROM gfrc_volunteer_holiday WHERE gvh_id = {0}", gvhid);
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
gvoid = Convert.ToUInt32(rdr.GetInt32(0));
start = rdr.GetDateTime(1);
if (!DateTime.TryParse(rdr.GetValue(2).ToString(), out end))
end = new DateTime(1901, 1, 1);
if (!DateTime.TryParse(rdr.GetValue(14).ToString(), out datemodified))
datemodified = new DateTime(1901, 1, 1);
if (!UInt32.TryParse(rdr.GetValue(15).ToString(), out modifiedby))
modifiedby = 0;
}
}
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
_gvhID = gvhid;
_gvoID = gvoid;
_Start = start;
_End = end;
_DateModified = datemodified;
_ModifiedBy = modifiedby;
}
public static DataTable FunctionOfAdding(String stringsione)
{
var Database = new dabse.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb");
Database.Open();
dabse.OleDbCommand loadingOfTable = new dabse.OleDbCommand("Select * From " + stringsione, Database);
dabse.OleDbDataReader result = loadingOfTable.ExecuteReader();
DataTable table = new DataTable();
for (int i = 0; i < result.FieldCount; i++)
{
table.Columns.Add(result.GetName(i));
}
while (result.Read() == true)
{
object[] yacheiki = new object[result.FieldCount];
for (int i = 0; i < result.FieldCount; i++)
{
yacheiki[i] = result.GetValue(i);
}
table.Rows.Add(yacheiki);
}
result.Close();
Database.Close();
return(table);
}
private void button1_Click(object sender, EventArgs e)
{
var Database = new OleDiBi.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Медведев.mdb");
Database.Open();
OleDiBi.OleDbCommand loadingOfTable = new OleDiBi.OleDbCommand(richTextBox1.Text, Database);
OleDiBi.OleDbDataReader result = loadingOfTable.ExecuteReader();
DataTable table = new DataTable();
for (int i = 0; i < result.FieldCount; i++)
{
table.Columns.Add(result.GetName(i));
}
while (result.Read() == true)
{
object[] yacheiki = new object[result.FieldCount];
for (int i = 0; i < result.FieldCount; i++)
{
yacheiki[i] = result.GetValue(i);
}
table.Rows.Add(yacheiki);
}
result.Close();
Database.Close();
dataGridView1.DataSource = table;
}
//Get all pictures from Database and save in a list
public List<byte[]> photos()
{
byte[] aBytes = null;
List<byte[]> pictures = new List<byte[]> {};
for (int i = 1; i <= 5000; i++)
{
try
{
int cont = 0;
string query = "SELECT image FROM Data WHERE counter = " + i + " AND image <> NULL;";
command = new OleDbCommand(query, connection);
reader = command.ExecuteReader();
while (reader.Read())
{
aBytes = (byte[])reader.GetValue(cont);
pictures.Add(aBytes);
cont++;
}
reader.Close();
}
catch (Exception e)
{
////The error message is not displayed to continue with the process.
//MessageBox.Show("I'm so sorry, we cannot get the images.\n" + e);
}
}
return pictures;
}
private void btnSave_Click(object sender, EventArgs e)
{
saveFileDialog1.ShowDialog(); //Se muestra el cuadro de diálogo para guardar
string nombreArchivo = saveFileDialog1.FileName; //Contiene la ruta completa del archivo a guardar
FileStream Holi = new FileStream(nombreArchivo,FileMode.Create);
StreamWriter writer = new StreamWriter(Holi);
consulta = "SELECT * FROM Paquetes WHERE Numero = " + cmbPaquetes.SelectedItem;
cmd = new OleDbCommand(consulta, Con);
Con.Open();
DR = cmd.ExecuteReader();
while (DR.Read())
{
writer.Write("Nº: " + DR.GetValue(0) + "\t"); //Escribe el número de paquete
writer.Write("Costo: $" + DR.GetValue(2) + "\t"); //Escribe el costo
writer.Write("Origen: " + DR.GetValue(3) + "\t"); //Escribe el origen
writer.WriteLine("Destino: " + DR.GetValue(4)); //Escribe el destino
}
Con.Close();
consulta = "SELECT * FROM Movimientos WHERE Paquete = " + cmbPaquetes.SelectedItem;
cmd = new OleDbCommand(consulta, Con);
Con.Open();
DR = cmd.ExecuteReader();
int mov;
while (DR.Read())
{
writer.Write("Fecha: " + DR.GetValue(2) + "\t"); //Añade la fecha
mov = (int)DR.GetValue(3);
writer.WriteLine(QueMov[mov-1]); //Añade el movimiento
}
Con.Close(); //Cierra conexión
writer.Close(); //Cierra Streamwriter
Holi.Close(); //Ciera filestream
//PINCHE IMBÉCIL!!!! .l. (-_-) .l.
}
//vykresli obrazok
private void loadPictureOfCrossSection(byte num)
{
string command = "Select h,b,tw,tf,r,d from SECTIONS where csprof_name like '" + combo_text + "'";
string h = "h", b = "b", tw = "tw", tf = "tf", r = "r", d = "d";
dat_reader = dat_conn.getDBReader(command);
dat_reader.Read();
try
{
h = dat_reader.GetValue(0).ToString();
b = dat_reader.GetValue(1).ToString();
tw = dat_reader.GetValue(2).ToString();
tf = dat_reader.GetValue(3).ToString();
r = dat_reader.GetValue(4).ToString();
d = dat_reader.GetValue(5).ToString();
}
catch (FormatException) { MessageBox.Show("Probably wrong selected cross-section."); }
catch (InvalidOperationException) { MessageBox.Show("Probably wrong selected cross-section."); }
switch (num)
{
case 1:
Image image = Image.FromFile(@"prierezy\prier1.jpg");
Bitmap myBitmap = new Bitmap(image, pictureBox1.Width, pictureBox1.Height);
Graphics g = Graphics.FromImage(myBitmap);
Font f_text = new Font("Arial", 14, FontStyle.Bold);
g.DrawString(h, f_text, Brushes.Black, new PointF(2, pictureBox1.Height / 2 + 30));
g.DrawString(d, f_text, Brushes.Black, new PointF(pictureBox1.Width / 8, pictureBox1.Height / 2 + 30));
f_text = new Font("Arial", 16, FontStyle.Bold);
g.DrawString(tw, f_text, Brushes.Black, new PointF(pictureBox1.Width / 2 +50, pictureBox1.Height / 2-30));
g.DrawString(tf, f_text, Brushes.Black, new PointF(pictureBox1.Width/1.15f, pictureBox1.Height/1.25f));
g.DrawString(r, f_text, Brushes.Black, new PointF(pictureBox1.Width / 2 + 80, pictureBox1.Height / 2 + 47));
f_text = new Font("Arial", 19, FontStyle.Bold);
g.DrawString(b, f_text, Brushes.Black, new PointF(pictureBox1.Width / 2 + 12, 10));
//g.DrawImage(myBitmap, AutoScrollPosition.X, AutoScrollPosition.Y);
pictureBox1.Image = myBitmap;
break;
case 2:
image = Image.FromFile(@"prierezy\prier2.jpg");
myBitmap = new Bitmap(image, pictureBox1.Width, pictureBox1.Height);
g = Graphics.FromImage(myBitmap);
f_text = new Font("Arial", 14, FontStyle.Bold);
g.DrawString(h, f_text, Brushes.Black, new PointF(2, pictureBox1.Height / 2 + 30));
f_text = new Font("Arial", 16, FontStyle.Bold);
g.DrawString(b, f_text, Brushes.Black, new PointF(pictureBox1.Width / 2 + 10, 12));
//g.DrawString(tw, f_text, Brushes.Black, new PointF(10, 0));
//g.DrawString(tf, f_text, Brushes.Black, new PointF(10, 0));
//g.DrawString(r, f_text, Brushes.Black, new PointF(10, 0));
//g.DrawString(d, f_text, Brushes.Black, new PointF(10, 0));
//g.DrawImage(myBitmap, AutoScrollPosition.X, AutoScrollPosition.Y);
pictureBox1.Image = myBitmap;
break;
case 3: break;
default: MessageBox.Show("Neimplementovane..."); break;
}
}
public static string GetDataFieldValues(OleDbDataReader reader)
{
string dt = "";
for (int i = 0; i < reader.FieldCount; i++)
{
dt = dt + "'" + ReplaceMarks(reader.GetValue(i).ToString()) + "'";
if (i < reader.FieldCount - 1)
{
dt = dt + ", ";
}
}
return dt;
}
static void Main(string[] args)
{
var connection = new oleDB.OleDbConnection("Data Source=\"e:\\vic.mdb\";User ID=Admin;Provider=\"Microsoft.Jet.OLEDB.4.0\";");
connection.Open();
var command = new oleDB.OleDbCommand("SELECT * From [Phones]", connection);
oleDB.OleDbDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
Console.WriteLine("Таблица БД:\n");
while (reader.Read() == true)
{
Console.WriteLine("{0,-3} {1, -15} {2, -15}", reader.GetValue(0), reader.GetValue(1), reader.GetValue(2));
}
reader.Close();
connection.Close();
Console.ReadKey();
}
public void LoadRow(OleDbDataReader reader)
{
var schema = reader.GetSchemaTable();
foreach (var pi in this.GetType().GetProperties())
{
if (schema.Select("ColumnName='" + pi.Name + "'").Length > 0)
{
var value = reader.GetValue(reader.GetOrdinal(pi.Name));
if (value != null)
pi.SetValue(this, value, null);
}
}
}
public static void Load(this DataObject dataObj, OleDbDataReader reader)
{
try
{
foreach (ColumnDefinition columnDef in dataObj.ColumnDefs())
{
if (reader.GetValue(columnDef.ColumnIndex) != DBNull.Value)
{
switch (columnDef.ColumnFieldType)
{
case ColumnDefinition.FieldType.String:
dataObj.GetColumnValues()[columnDef.ColumnIndex] = reader.GetString(columnDef.ColumnIndex);
break;
case ColumnDefinition.FieldType.Int32:
dataObj.GetColumnValues()[columnDef.ColumnIndex] = reader.GetInt32(columnDef.ColumnIndex);
break;
case ColumnDefinition.FieldType.Boolean:
dataObj.GetColumnValues()[columnDef.ColumnIndex] = reader.GetBoolean(columnDef.ColumnIndex);
break;
}
}
else //default values for nulls
{
switch (columnDef.ColumnFieldType)
{
case ColumnDefinition.FieldType.String:
dataObj.GetColumnValues()[columnDef.ColumnIndex] = string.Empty;
break;
case ColumnDefinition.FieldType.Int32:
dataObj.GetColumnValues()[columnDef.ColumnIndex] = 0;
break;
case ColumnDefinition.FieldType.Boolean:
dataObj.GetColumnValues()[columnDef.ColumnIndex] = false;
break;
}
}
}
}
catch (Exception e)
{
//TODO: what to do here?
}
}
//Get the last request in the data base
public int LastRequest()
{
int last = 1;
string query = "SELECT MAX(counter) FROM Data";
try
{
command = new OleDbCommand(query, connection);
reader = command.ExecuteReader();
if(reader.Read())
{
last = int.Parse(reader.GetValue(0).ToString());
}
reader.Close();
}
catch(Exception e)
{
MessageBox.Show("We're so sorry, couldn't get the last record." + e);
}
return last;
}
//loading of data
//data from mat_name from table CONCRETE in database
//loading all elements from column mat_num except 0,1,List_name,Unit
private void loadList()
{
string item;
listView1.Items.Clear();
dat_reader = dat_conn.getDBReader("Select mat_name from concrete where id_concrete not in (1,2,3) order by id_concrete"); // if cell type is text - string '2'
while (dat_reader.Read())
{
item = dat_reader.GetValue(0).ToString();
listView1.Items.Add(item);
}
/*
ListViewItem();
listView1.Items.Add();
ListViewItem.ListViewSubItem
ListViewGroupCollection
ListViewItem.ListViewSubItemCollection ();
*/
}
// Constructor for searched volunteer qualification
public vQualification(uint gvqid)
{
// Declarations
uint gvoid = 0;
string qualification = null;
// Command
string query = string.Format("SELECT gvo_id, gvq_qual " +
"FROM gfrc_volunteer_qualification WHERE gvq_id = {0}", gvqid);
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
UInt32.TryParse(rdr.GetValue(0).ToString(), out gvoid);
qualification = rdr.GetString(1);
}
}
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
_gvqID = gvqid;
_gvoID = gvoid;
_Qualification = qualification;
}
public bool createQualification(vQualification create)
{
bool result = false;
// Command
string query = String.Format(@"INSERT INTO gfrc_volunteer_qualification (gvo_id, gvq_qual) " +
"VALUES({0}, '{1}')",
create.gvoID, create.Qualification);
int affected = 0;
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
affected = cmd.ExecuteNonQuery();
// checks if rows were affected by the insert query
if (affected > 0)
{
result = true;
query = String.Format(@"SELECT gvq_id FROM gfrc_volunteer_qualification WHERE gvq_id = (SELECT MAX(gvq_id) FROM gfrc_volunteer_qualification)");
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
// Set gloID
UInt32.TryParse(rdr.GetValue(0).ToString(), out _gvqID);
}
}
}
}
catch (Exception e)
{
result = false;
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return result;
}
private PivotItem ReadItem(OleDbDataReader dataReader, int rowId)
{
PivotItem item = new PivotItem(rowId.ToString(), this);
for (int column = 0; column < dataReader.FieldCount; column++)
{
if (dataReader.IsDBNull(column)) continue;
String columnName = dataReader.GetName(column).ToLowerInvariant();
String value = dataReader.GetValue(column).ToString();
if (String.IsNullOrEmpty(value)) continue;
if (columnName == OleDbSchemaConstants.Item.Name)
{
item.Name = value;
}
else if (columnName == OleDbSchemaConstants.Item.Image)
{
String imagePath = UriUtility.ExpandRelativeUri(this.BasePath, value);
item.Image = new PivotImage(imagePath);
}
else if (columnName == OleDbSchemaConstants.Item.Description)
{
item.Description = value;
}
else if (columnName == OleDbSchemaConstants.Item.Href)
{
item.Href = value;
}
else if (columnName == OleDbSchemaConstants.Item.RelatedLinks)
{
StringReader valueReader = new StringReader(value);
String singleValue = null;
while ((singleValue = valueReader.ReadLine()) != null)
{
String[] parts = singleValue.Split(
new String[] { OleDbSchemaConstants.LinkPartDelimiter }, StringSplitOptions.None);
if (parts.Length > 0)
{
String name = null, url = null;
if (parts.Length == 1)
{
url = parts[0];
}
else if (parts.Length >= 2)
{
name = parts[0];
url = parts[1];
}
item.AddRelatedLink(new PivotLink(name, url));
}
}
}
else
{
PivotFacetCategory facetCategory = null;
foreach (PivotFacetCategory currentFacetCategory in m_facetCategoryMap.Values)
{
if (columnName == currentFacetCategory.Name.Replace('.', '#').ToLowerInvariant())
{
facetCategory = currentFacetCategory;
break;
}
}
if (facetCategory != null)
{
item.AddFacetValues(facetCategory.Name, this.SplitJoinedStrings(value).ToArray());
}
}
}
return item;
}
private PivotFacetCategory CreateFacetCategory(OleDbDataReader dataReader)
{
String name = null;
PivotFacetType type = null;
for (int column = 0; column < dataReader.FieldCount; column++)
{
if (dataReader.IsDBNull(column)) continue;
String columnName = dataReader.GetName(column).ToLowerInvariant();
String value = dataReader.GetValue(column).ToString();
if (columnName == OleDbSchemaConstants.FacetCategory.Name)
{
name = value;
}
else if (columnName == OleDbSchemaConstants.FacetCategory.Type)
{
type = PivotFacetType.Parse(value);
}
}
if (name == null) throw new InvalidDataException("Facet Categories data set is missing a Name column");
if (type == null) throw new InvalidDataException("Facet Categories data set is missing a Type column");
return new PivotFacetCategory(name, type);
}
/// <summary>
/// Поиск Записи в таблице
/// </summary>
/// <param name="parDataReader">Ридер - для пробега по таблице</param>
/// <param name="parFromLesson">Параметр который ищем</param>
/// <param name="parColNumberCompare">Номер столбца для сравнения</param>
/// <param name="parColNumberReturn">Номер столбца откуда возращаем результат</param>
/// <returns></returns>
public Object SearchRecordInTable(OleDbDataReader parDataReader, Object parFromLesson, int parColNumberCompare, int parColNumberReturn)
{
Object param = null;
while (parDataReader.Read())
{
if (parFromLesson.Equals(parDataReader.GetValue(parColNumberCompare)))
{
//задаем значение параметра
param = parDataReader.GetValue(parColNumberReturn);
break;
}
}
parDataReader.Dispose();
return param;
}
private void naplnZoznamy()
{
string combo1 = comboBox1.Text; //actual text in combobox1
string combo2 = comboBox2.Text; //actual text in combobox2
string unit = "nedef";
CheckedListInfo chLInfo;
this.deleteLists();
#region choosing typ_prierezu from database
// checking type of cross-section from database for further processing
string sql = "Select csprofshape from sections where csprof_name like '" + combo2 + "'";
dat_reader = dat_conn.getDBReader(sql);
dat_reader.Read();
try
{
typ_prierezu = Convert.ToByte(dat_reader.GetValue(0).ToString());
}
catch (InvalidOperationException) { /*MessageBox.Show("Set up cross-section in ComboBox Cross-section, please!");*/
//This type of exception appears mainly because text in combo2 is empty
}
catch (FormatException) { }
#endregion
dtform = new DataTableForm(typ_prierezu);
try
{
#region filling lists with actual variables,their names in table and units
chLInfo = dtform.ZozChLInfos[0, 0]; //for checkListbox 4. (STEEL)
for (int i = 0; i < chLInfo.ZoznamPremennych.Count; i++)
{
//if the variable is checked in checkedlistbox4 then add this variable to list of variables
if (chLInfo.ZoznamZasktPrem[i])
{
zoznamNazvyPremeSTEEL.Add(chLInfo.ZoznamPremennych[i]); //variables for database
zoznamMenuNazvySTEEL.Add(chLInfo.ZoznamZobrazPremennych[i]); //variables names for table
zoznamMenuJednotkySTEEL.Add(chLInfo.ZoznamJednotiek[i]); //units of these variables
}
}
chLInfo = dtform.ZozChLInfos[typ_prierezu, 0]; //pre checkListbox 1.
for (int i = 0; i < chLInfo.ZoznamPremennych.Count; i++)
{
if (chLInfo.ZoznamZasktPrem[i])
{
zoznamNazvyPremennych.Add(chLInfo.ZoznamPremennych[i]); //premenne do databazy
zoznamMenuNazvy.Add(chLInfo.ZoznamZobrazPremennych[i]); //premenne zobrazene v tabulke
zoznamMenuJednotky.Add(chLInfo.ZoznamJednotiek[i]);
//MessageBox.Show(chLInfo.ZoznamPremennych[i] + "\n" + chLInfo.ZoznamZobrazPremennych[i] + "\n"
// + chLInfo.ZoznamJednotiek[i]);
}
}
chLInfo = dtform.ZozChLInfos[typ_prierezu, 1]; //pre checkListbox 2.
for (int i = 0; i < chLInfo.ZoznamPremennych.Count; i++)
{
if (chLInfo.ZoznamZasktPrem[i])
{
zoznamMenuNazvy.Add(chLInfo.ZoznamPremennych[i]); //premenne zadavane pouzivatelom
zoznamNazvyPremennych.Add(chLInfo.ZoznamPremennych[i]);
//MessageBox.Show(chLInfo.ZoznamPremennych[i]);
}
}
#endregion
#region loading values for variables from database
//getting values of actual choosen variables of STEEL
for (int i = 0; i < zoznamNazvyPremeSTEEL.Count; i++)
{
if (combo1 != "" && comboBox1.SelectedIndex != 0 && combo2 != "")
{
sql = "Select " + zoznamNazvyPremeSTEEL[i] + " from Steel where mat_name like '"+combo1+"'";
dat_reader = dat_conn.getDBReader(sql);
dat_reader.Read();
try
{
zoznamMenuHodnotySTEEL.Add(dat_reader.GetValue(0).ToString());
}
catch (InvalidOperationException) { }
}
}
//getting values of actual choosen variables of cross sections
//if variable is from user input - getting character from database that determines
//that it is user input,adding unit for this variable ,other visual style for this
//variable in datagrid is defined in method updateDataGridView()
for (int i = 0; i < zoznamNazvyPremennych.Count; i++)
{
if (combo2 != "" && combo1 != "")
{
sql = "Select ";
switch (zoznamNazvyPremennych[i])
{
#region Table - user-data cells basic loading - database "user" column
// Internal forces in section
case "N": sql += "user"; unit = "kN"; zoznamMenuJednotky.Add(unit); break;
case "Vy": sql += "user"; unit = "kN"; zoznamMenuJednotky.Add(unit); break;
case "Vz": sql += "user"; unit = "kN"; zoznamMenuJednotky.Add(unit); break;
case "Mx": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
case "My": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
case "Mz": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
// End bending moments
case "My.a": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
case "My.b": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
case "Mz.a": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
case "Mz.b": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
// Midspan bending moments
case "My.s": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
case "Mz.s": sql += "user"; unit = "kNm"; zoznamMenuJednotky.Add(unit); break;
// Annex A - Table A.2 input data
case "My.Ed.x": sql += "user"; unit = "[kNm]"; zoznamMenuJednotky.Add(unit); break;
case "Mz.Ed.x": sql += "user"; unit = "[kNm]"; zoznamMenuJednotky.Add(unit); break;
case "Deflection.y.x": sql += "user"; unit = "[mm]"; zoznamMenuJednotky.Add(unit); break;
case "Deflection.z.x": sql += "user"; unit = "[mm]"; zoznamMenuJednotky.Add(unit); break;
// Lateral buckling Mcr variables
case "C1y": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break;
case "C2y": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break;
case "C3y": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break;
case "kz_LT": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break;
case "kw_LT": sql += "user"; unit = "[-]"; zoznamMenuJednotky.Add(unit); break;
// Beam properties - lenght
case "L_teor": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break;
case "L_y_buck": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break;
case "L_z_buck": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break;
case "L_y_LT": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break;
case "L_z_LT": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break;
case "L_T": sql += "user"; unit = "mm"; zoznamMenuJednotky.Add(unit); break;
// Cross-section data
case "Anet": sql += "user"; unit = "mm2"; zoznamMenuJednotky.Add(unit); break;
// Variables - Torsion NAD CZE
case "MEd.T": sql += "user"; unit = "[kNm]"; zoznamMenuJednotky.Add(unit); break;
case "VEd.T": sql += "user"; unit = "[kN]"; zoznamMenuJednotky.Add(unit); break;
case "e.T": sql += "user"; unit = "[mm]"; zoznamMenuJednotky.Add(unit); break;
#endregion
default: sql += zoznamNazvyPremennych[i]; break;
}
sql += " from SECTIONS where csprof_name like '" + combo2 + "'";
dat_reader = dat_conn.getDBReader(sql);
dat_reader.Read();
try
{
zoznamMenuHodnoty.Add(dat_reader.GetValue(0).ToString());//zapise sa hodnota do zoznamu
}
catch (InvalidOperationException) { }
}
}
#endregion
}
catch (NullReferenceException) { MessageBox.Show("There is nothing to display! Please choose some variables in Options -> Data table list."); }
}
//Image mainBackGroundImage;
public frmMainForm()
{
byte i = 0;
PrivateDataEncode pde = new PrivateDataEncode();
myConn = new OleDbConnection();
myCom = new OleDbCommand();
myCom.CommandText = "Select M_ID, M_Name, M_Type, M_Description From tblMasterInfor ORDER BY M_Type";
myCom.Connection = myConn;
myConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Data.mdb;Jet OLEDB:Database Password=whatthehellisgoingon";
try{
myConn.Open();
}catch (Exception e)
{
MessageBox.Show(ERROR_WHILE_LOADING_DATABASE + e.Message.ToString(), "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.Dispose();
Application.Exit();
}
myReader = myCom.ExecuteReader();
System.ComponentModel.ComponentResourceManager resources1 = new System.ComponentModel.ComponentResourceManager(typeof(frmMainForm));
InitializeComponent();
if (myReader.HasRows)
{
while (myReader.Read())
{
this.tbTmp4LoadDynamic = new System.Windows.Forms.ToolStripButton();
this.tbTmp4LoadDynamic.Overflow = ToolStripItemOverflow.Never;
if (myReader.GetByte(2) == frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_DIAGNOSIS)
{
try{
this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\diagnosis.bmp");
}catch (System.IO.FileNotFoundException) {}
}
else if (myReader.GetByte(2) == frmAddNewMasterItem.ENUM_INTEGER_CATOGERY_TREATMENT)
{ //treatment
try{
this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\treatment.bmp"); //career.bmp
}catch (System.IO.FileNotFoundException) {}
}
else
{
try{
this.tbTmp4LoadDynamic.Image = Image.FromFile(Application.StartupPath + @"\image\career.bmp");
}catch (System.IO.FileNotFoundException) {}
}
//this.tbTmp4LoadDynamic.Image = ((System.Drawing.Image)(resources.GetObject("mnuBtnPatientRecord.Image")));
this.tbTmp4LoadDynamic.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.tbTmp4LoadDynamic.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
this.tbTmp4LoadDynamic.ImageTransparentColor = System.Drawing.Color.Magenta;
this.tbTmp4LoadDynamic.Name = "tb" + myReader.GetValue(0).ToString();
this.tbTmp4LoadDynamic.Size = new System.Drawing.Size(90, 40);
this.tbTmp4LoadDynamic.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
this.tbTmp4LoadDynamic.Click += new System.EventHandler(this.DynamicToolBarClick);
this.tbTmp4LoadDynamic.ImageTransparentColor = System.Drawing.Color.Magenta;
this.tbTmp4LoadDynamic.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.ImageAndText;
this.tbTmp4LoadDynamic.Text = myReader.GetString(1);
this.tbTmp4LoadDynamic.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageBeforeText;
this.tbTmp4LoadDynamic.DoubleClick += new EventHandler(DynamicToolBarClick);
sepTmp = new ToolStripSeparator();
sepTmp.Name = "auto" + i++.ToString();
sepTmp.Size = new System.Drawing.Size(6, 1);
this.tbMainToolBar.Items.AddRange(new System.Windows.Forms.ToolStripItem[] { sepTmp, tbTmp4LoadDynamic });
} // myReader.Read()
} //myReader.HasRows
myReader.Close();
this.frmMainForm_SizeChanged(null, null);
}
public EN1993_1_1(string combo1, string combo2,bool item3,bool item4, bool item5, bool item6)
{
string sql1;
string sql2;
sql1 = "Select mat_num, mat_name, mat_prod_code_num, mat_prod_code_name1, mat_prod_code_name2, steel_grade_num, fy1, fu1, fy2, fu2, gamaM0, gamaM1, gamaM2, betaw, eta_shear, E, G, nu_pois, alpha_temp from Steel where mat_name like '" + combo1 + "'";
#region Database DATA-STEEL variables reader
dat_conn = DatabaseConnection.getInstance();
dat_reader = dat_conn.getDBReader(sql1);
try
{
while (dat_reader.Read())
{
// STEEL DATABASE DATA
#region Data list
try
{
mat_num = Convert.ToInt16(dat_reader.GetValue(0).ToString());
}
catch (FormatException) { }
try
{
mat_name = dat_reader.GetValue(1).ToString();
}
catch (FormatException) { }
try
{
mat_prod_code_num = Convert.ToInt16(dat_reader.GetValue(2).ToString());
}
catch (FormatException) { }
try
{
mat_prod_code_name1 = dat_reader.GetValue(3).ToString();
}
catch (FormatException) { }
try
{
mat_prod_code_name2 = dat_reader.GetValue(4).ToString();
}
catch (FormatException) { }
try
{
steel_grade_num = Convert.ToInt32(dat_reader.GetValue(5).ToString());
}
catch (FormatException) { }
try
{
fy1 = Convert.ToDouble(dat_reader.GetValue(6).ToString());
}
catch (FormatException) { }
try
{
fu1 = Convert.ToDouble(dat_reader.GetValue(7).ToString());
}
catch (FormatException) { }
try
{
fy2 = Convert.ToDouble(dat_reader.GetValue(8).ToString());
}
catch (FormatException) { }
try
{
fu2 = Convert.ToDouble(dat_reader.GetValue(9).ToString());
}
catch (FormatException) { }
try
{
gamaM0 = Convert.ToDouble(dat_reader.GetValue(10).ToString());
}
catch (FormatException) { }
try
{
gamaM1 = Convert.ToDouble(dat_reader.GetValue(11).ToString());
}
catch (FormatException) { }
try
{
gamaM2 = Convert.ToDouble(dat_reader.GetValue(12).ToString());
}
catch (FormatException) { }
try
{
betaw = Convert.ToDouble(dat_reader.GetValue(13).ToString());
}
catch (FormatException) { }
try
{
eta_shear = Convert.ToDouble(dat_reader.GetValue(14).ToString());
}
catch (FormatException) { }
try
{
_E = Convert.ToDouble(dat_reader.GetValue(15).ToString());
}
catch (FormatException) { }
try
{
_G = Convert.ToDouble(dat_reader.GetValue(16).ToString());
}
catch (FormatException) { }
try
{
nu_pois = Convert.ToDouble(dat_reader.GetValue(17).ToString());
}
catch (FormatException) { }
try
{
alpha_temp = Convert.ToDouble(dat_reader.GetValue(18).ToString());
}
catch (FormatException) { }
#endregion
}
}
catch (FormatException) { }
#endregion
sql2 = "Select csprof_namenum, csprof_name, csprofshape, csprof_production, csprodcode1_name1, csprodcode1_name2, csprodcode2_name1, csprodcode2_name2, csproducer1, csproducer2, csprof_weight,h, b, bh, bd, tw, tf, r, r1, r2, r3, hi, d, d1, e, e_apostrof, ez, ey, w, w1, v, v1, v2, eel, epl, D_tube, t_tube, A, A_su, Af, Aw, Ay_v, Az_v, Av, Iy, Wy_el, Wy1, Wy2, Wy_pl, iy_r, Sy, Iz, Wz_el, Wz1, Wz2, Wz_pl, iz_r, Sz, IT, Wt, Iw, ss, ys, ym, Id, Ieta, Weta, ieta_r, Ixi, Wxi2, Wxi13,ixi_r, Iyz, omega_w, izf, iz1, ipc, ay, aeta, ip, ia, Ww1, Ww2, Sw3, iw1, k, a1, tg_fi, cy1, ty1, cz1, tz1, cy2, ty2, cz2, tz2 from sections where csprof_name like '" + combo2 + "'";
#region Database DATA-SECTIONS variables reader
dat_conn = DatabaseConnection.getInstance();
dat_reader = dat_conn.getDBReader(sql2);
try
{
while (dat_reader.Read())
{
// CROSS-SECTION DATABASE DATA
#region Data list
// 0 - 9
try
{
csprof_namenum = Convert.ToInt16(dat_reader.GetValue(0).ToString());
}
catch (FormatException) { }
try
{
csprof_name = dat_reader.GetValue(1).ToString();
}
catch (FormatException) { }
try
{
csprofshape = Convert.ToInt16(dat_reader.GetValue(2).ToString());
}
catch (FormatException) { }
try
{
csprof_production = Convert.ToInt16(dat_reader.GetValue(3).ToString());
}
catch (FormatException) { }
try
{
csprodcode1_name1 = dat_reader.GetValue(4).ToString();
}
catch (FormatException) { }
try
{
csprodcode1_name2 = dat_reader.GetValue(5).ToString();
}
catch (FormatException) { }
try
{
csprodcode2_name1 = dat_reader.GetValue(6).ToString();
}
catch (FormatException) { }
try
{
csprodcode2_name2 = dat_reader.GetValue(7).ToString();
}
catch (FormatException) { }
try
{
csproducer1 = dat_reader.GetValue(8).ToString();
}
catch (FormatException) { }
try
{
csproducer2 = dat_reader.GetValue(9).ToString();
}
catch (FormatException) { }
// 10-19
csprof_weight = Convert.ToDouble(dat_reader.GetValue(10).ToString());
try
{
h = Convert.ToDouble(dat_reader.GetValue(11).ToString());
}
catch (FormatException) { }
try
{
b = Convert.ToDouble(dat_reader.GetValue(12).ToString());
}
catch (FormatException) { }
try
{
bh = Convert.ToDouble(dat_reader.GetValue(13).ToString());
}
catch (FormatException) { }
try
{
bd = Convert.ToDouble(dat_reader.GetValue(14).ToString());
}
catch (FormatException) { }
try
{
tw = Convert.ToDouble(dat_reader.GetValue(15).ToString());
}
catch (FormatException) { }
try
{
tf = Convert.ToDouble(dat_reader.GetValue(16).ToString());
}
catch (FormatException) { }
try
{
r = Convert.ToDouble(dat_reader.GetValue(17).ToString());
}
catch (FormatException) { }
try
{
r1 = Convert.ToDouble(dat_reader.GetValue(18).ToString());
}
catch (FormatException) { }
try
{
r2 = Convert.ToDouble(dat_reader.GetValue(19).ToString());
}
catch (FormatException) { }
// 20-29
try
{
r3 = Convert.ToDouble(dat_reader.GetValue(20).ToString());
}
catch (FormatException) { }
try
{
hi = Convert.ToDouble(dat_reader.GetValue(21).ToString());
}
catch (FormatException) { }
try
{
d = Convert.ToDouble(dat_reader.GetValue(22).ToString());
}
catch (FormatException) { }
try
{
d1 = Convert.ToDouble(dat_reader.GetValue(23).ToString());
}
catch (FormatException) { }
try
{
e = Convert.ToDouble(dat_reader.GetValue(24).ToString());
}
catch (FormatException) { }
try
{
e_apostrof = Convert.ToDouble(dat_reader.GetValue(25).ToString());
}
catch (FormatException) { }
try
{
ez = Convert.ToDouble(dat_reader.GetValue(26).ToString());
}
catch (FormatException) { }
try
{
ey = Convert.ToDouble(dat_reader.GetValue(27).ToString());
}
catch (FormatException) { }
try
{
w = Convert.ToDouble(dat_reader.GetValue(28).ToString());
}
catch (FormatException) { }
try
{
w1 = Convert.ToDouble(dat_reader.GetValue(29).ToString());
}
catch (FormatException) { }
// 30-39
try
{
v = Convert.ToDouble(dat_reader.GetValue(30).ToString());
}
catch (FormatException) { }
try
{
v1 = Convert.ToDouble(dat_reader.GetValue(31).ToString());
}
catch (FormatException) { }
try
{
v2 = Convert.ToDouble(dat_reader.GetValue(32).ToString());
}
catch (FormatException) { }
try
{
eel = Convert.ToDouble(dat_reader.GetValue(33).ToString());
}
catch (FormatException) { }
try
{
epl = Convert.ToDouble(dat_reader.GetValue(34).ToString());
}
catch (FormatException) { }
try
{
_D_tube = Convert.ToDouble(dat_reader.GetValue(35).ToString());
}
catch (FormatException) { }
try
{
t_tube = Convert.ToDouble(dat_reader.GetValue(36).ToString());
}
catch (FormatException) { }
try
{
_A = Convert.ToDouble(dat_reader.GetValue(37).ToString());
}
catch (FormatException) { }
try
{
_A_su = Convert.ToDouble(dat_reader.GetValue(38).ToString());
}
catch (FormatException) { }
try
{
_Af = Convert.ToDouble(dat_reader.GetValue(39).ToString());
}
catch (FormatException) { }
// 40-49
try
{
_Aw = Convert.ToDouble(dat_reader.GetValue(40).ToString());
}
catch (FormatException) { }
try
{
_Ay_v = Convert.ToDouble(dat_reader.GetValue(41).ToString());
}
catch (FormatException) { }
try
{
_Az_v = Convert.ToDouble(dat_reader.GetValue(42).ToString());
}
catch (FormatException) { }
try
{
_Av = Convert.ToDouble(dat_reader.GetValue(43).ToString());
}
catch (FormatException) { }
try
{
_Iy = Convert.ToDouble(dat_reader.GetValue(44).ToString());
}
catch (FormatException) { }
try
{
_Wy_el = Convert.ToDouble(dat_reader.GetValue(45).ToString());
}
catch (FormatException) { }
try
{
_Wy1 = Convert.ToDouble(dat_reader.GetValue(46).ToString());
}
catch (FormatException) { }
try
{
_Wy2 = Convert.ToDouble(dat_reader.GetValue(47).ToString());
}
catch (FormatException) { }
try
{
_Wy_pl = Convert.ToDouble(dat_reader.GetValue(48).ToString());
}
catch (FormatException) { }
try
{
iy_r = Convert.ToDouble(dat_reader.GetValue(49).ToString());
}
catch (FormatException) { }
// 50-59
try
{
_Sy = Convert.ToDouble(dat_reader.GetValue(50).ToString());
}
catch (FormatException) { }
try
{
_Iz = Convert.ToDouble(dat_reader.GetValue(51).ToString());
}
catch (FormatException) { }
try
{
_Wz_el = Convert.ToDouble(dat_reader.GetValue(52).ToString());
}
catch (FormatException) { }
try
{
_Wz1 = Convert.ToDouble(dat_reader.GetValue(53).ToString());
}
catch (FormatException) { }
try
{
_Wz2 = Convert.ToDouble(dat_reader.GetValue(54).ToString());
}
catch (FormatException) { }
try
{
_Wz_pl = Convert.ToDouble(dat_reader.GetValue(55).ToString());
}
catch (FormatException) { }
try
{
iz_r = Convert.ToDouble(dat_reader.GetValue(56).ToString());
}
catch (FormatException) { }
try
{
_Sz = Convert.ToDouble(dat_reader.GetValue(57).ToString());
}
catch (FormatException) { }
try
{
_IT = Convert.ToDouble(dat_reader.GetValue(58).ToString());
}
catch (FormatException) { }
try
{
_Wt = Convert.ToDouble(dat_reader.GetValue(59).ToString());
}
catch (FormatException) { }
// 60-69
try
{
_Iw = Convert.ToDouble(dat_reader.GetValue(60).ToString());
}
catch (FormatException) { }
try
{
ss = Convert.ToDouble(dat_reader.GetValue(61).ToString());
}
catch (FormatException) { }
try
{
ys = Convert.ToDouble(dat_reader.GetValue(62).ToString());
}
catch (FormatException) { }
try
{
ym = Convert.ToDouble(dat_reader.GetValue(63).ToString());
}
catch (FormatException) { }
try
{
_Id = Convert.ToDouble(dat_reader.GetValue(64).ToString());
}
catch (FormatException) { }
try
{
_Ieta = Convert.ToDouble(dat_reader.GetValue(65).ToString());
}
catch (FormatException) { }
try
{
_Weta = Convert.ToDouble(dat_reader.GetValue(66).ToString());
}
catch (FormatException) { }
try
{
ieta_r = Convert.ToDouble(dat_reader.GetValue(67).ToString());
}
catch (FormatException) { }
try
{
_Ixi = Convert.ToDouble(dat_reader.GetValue(68).ToString());
}
catch (FormatException) { }
try
{
_Wxi2 = Convert.ToDouble(dat_reader.GetValue(69).ToString());
}
catch (FormatException) { }
// 70-79
try
{
_Wxi13 = Convert.ToDouble(dat_reader.GetValue(70).ToString());
}
catch (FormatException) { }
try
{
ixi_r = Convert.ToDouble(dat_reader.GetValue(71).ToString());
}
catch (FormatException) { }
try
{
_Iyz = Convert.ToDouble(dat_reader.GetValue(72).ToString());
}
catch (FormatException) { }
try
{
omega_w = Convert.ToDouble(dat_reader.GetValue(73).ToString());
}
catch (FormatException) { }
try
{
izf = Convert.ToDouble(dat_reader.GetValue(74).ToString());
}
catch (FormatException) { }
try
{
iz1 = Convert.ToDouble(dat_reader.GetValue(75).ToString());
}
catch (FormatException) { }
try
{
ipc = Convert.ToDouble(dat_reader.GetValue(76).ToString());
}
catch (FormatException) { }
try
{
ay = Convert.ToDouble(dat_reader.GetValue(77).ToString());
}
catch (FormatException) { }
try
{
aeta = Convert.ToDouble(dat_reader.GetValue(78).ToString());
}
catch (FormatException) { }
try
{
ip = Convert.ToDouble(dat_reader.GetValue(79).ToString());
}
catch (FormatException) { }
// 80-89
try
{
ia = Convert.ToDouble(dat_reader.GetValue(80).ToString());
}
catch (FormatException) { }
try
{
_Ww1 = Convert.ToDouble(dat_reader.GetValue(81).ToString());
}
catch (FormatException) { }
try
{
_Ww2 = Convert.ToDouble(dat_reader.GetValue(82).ToString());
}
catch (FormatException) { }
try
{
_Sw3 = Convert.ToDouble(dat_reader.GetValue(83).ToString());
}
catch (FormatException) { }
try
{
iw1 = Convert.ToDouble(dat_reader.GetValue(84).ToString());
}
catch (FormatException) { }
try
{
k = Convert.ToDouble(dat_reader.GetValue(85).ToString());
}
catch (FormatException) { }
try
{
a1 = Convert.ToDouble(dat_reader.GetValue(86).ToString());
}
catch (FormatException) { }
try
{
tg_fi = Convert.ToDouble(dat_reader.GetValue(87).ToString());
}
catch (FormatException) { }
try
{
cy1 = Convert.ToDouble(dat_reader.GetValue(88).ToString());
}
catch (FormatException) { }
try
{
ty1 = Convert.ToDouble(dat_reader.GetValue(89).ToString());
}
catch (FormatException) { }
// 90-99
try
{
cz1 = Convert.ToDouble(dat_reader.GetValue(90).ToString());
}
catch (FormatException) { }
try
{
tz1 = Convert.ToDouble(dat_reader.GetValue(91).ToString());
}
catch (FormatException) { }
try
{
cy2 = Convert.ToDouble(dat_reader.GetValue(92).ToString());
}
catch (FormatException) { }
try
{
ty2 = Convert.ToDouble(dat_reader.GetValue(93).ToString());
}
catch (FormatException) { }
try
{
cz2 = Convert.ToDouble(dat_reader.GetValue(94).ToString());
}
catch (FormatException) { }
try
{
tz2 = Convert.ToDouble(dat_reader.GetValue(95).ToString());
}
catch (FormatException) { }
#endregion
}
}
catch (FormatException) { }
#endregion
// Data from Form: EN1993-1-1MessageBoxes.cs
this.item3_check = item3;
this.item4_check = item4;
this.item5_check = item5;
this.item6_check = item6;
}
// Display the result set recursively expanding chapterDepth deep
public void DisplayReader(OleDbDataReader myDataReader, ref uint count, uint alignment, int chapterDepth)
{
try
{
// compute alignment
StringBuilder indent = new StringBuilder((int) alignment);
indent.Append(' ', (int) alignment);
while (myDataReader.Read())
{
// add alignment
StringBuilder row = new StringBuilder(indent.ToString());
// for all columns
for (int i = 0; i < myDataReader.FieldCount; i++)
{
// null columns
if (myDataReader.IsDBNull(i))
{
row.Append("NULL;");
}
else
{
//vector columns
object[] myArray = myDataReader.GetValue(i) as object[];
if (myArray != null)
{
DisplayValue(myArray, row);
}
else
{
//check for chapter columns from "group on" queries
if (myDataReader.GetFieldType(i).ToString() != "System.Data.IDataReader")
{
//regular columns are displayed here
row.Append(myDataReader.GetValue(i));
}
else
{
//for a chapter column type just display the colum name
row.Append(myDataReader.GetName(i));
}
}
row.Append(';');
}
}
if (chapterDepth >= 0)
{
this.ScrubberGUIInst.DebugPrint(row.ToString());
count++;
}
// for each chapter column
for (int i = 0; i < myDataReader.FieldCount; i++)
{
if (myDataReader.GetFieldType(i).ToString() == "System.Data.IDataReader")
{
OleDbDataReader Reader = myDataReader.GetValue(i) as OleDbDataReader;
DisplayReader(Reader, ref count, alignment + 8, chapterDepth - 1);
}
}
}
}
finally
{
myDataReader.Close();
myDataReader.Dispose();
}
}
// Constructor for searched volunteer position
public Position(uint gvid, char gvo_gvp)
{
// Declarations
uint gvoid = 0, gvpid = 0;
string position = null, drivercat = null, drivercatdoc = null, drivertrans = null;
string query = "";
// Command
if (gvo_gvp == 'o')
query = string.Format("SELECT gvo_id, gvp_id, gvp_position, gvp_driver_cat, gvp_driver_cat_doc, gvp_driver_trans " +
"FROM gfrc_volunteer_position WHERE gvo_id = {0}", gvid);
else if (gvo_gvp == 'p')
query = string.Format("SELECT gvo_id, gvp_id, gvp_position, gvp_driver_cat, gvp_driver_cat_doc, gvp_driver_trans " +
"FROM gfrc_volunteer_position WHERE gvp_id = {0}", gvid);
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
UInt32.TryParse(rdr.GetValue(0).ToString(), out gvoid);
UInt32.TryParse(rdr.GetValue(1).ToString(), out gvpid);
position = rdr.GetString(2);
drivercat = rdr.GetString(3);
drivercatdoc = rdr.GetString(4);
drivertrans = rdr.GetString(5);
}
}
}
catch (Exception e)
{
string exception = e.ToString();
gvoid = 0;
gvpid = 0;
position = "";
drivercat = "";
drivercatdoc = "";
drivertrans = "";
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
_gvpID = gvpid;
_gvoID = gvoid;
_Position = position;
_DriverCat = drivercat;
_DriverCatDoc = drivercatdoc;
_DriverTrans = drivertrans;
}
private void cmbClientes_SelectedIndexChanged(object sender, EventArgs e)
{
cmbPaquetes.Items.Clear(); //Limpia el combobox de paquetes
//Consulta sql
consulta = "SELECT Numero FROM Paquetes WHERE Cliente = " + (cmbClientes.SelectedIndex +1);
//Se crea el comando
cmd = new OleDbCommand(consulta, Con);
Con.Open(); //Abre conexión
DR = cmd.ExecuteReader(); //Ejectura datareader
while (DR.Read()) //Mientras siga leyendo
cmbPaquetes.Items.Add(DR.GetValue(0)); //Añado al combobox los datos de la columna que saque de la base de datos
Con.Close(); //Cierra conexión
}
private void loadCombo1()
{
string item;
comboBox1.Items.Clear();
dat_reader = dat_conn.getDBReader("Select mat_name from ALUMINIUM_32a where id_Aluminium_T32a not in (1,2,3) order by id_Aluminium_T32a");
while (dat_reader.Read())
{
item = dat_reader.GetValue(0).ToString();
comboBox1.Items.Add(item);
}
}
private void Form1_Load(object sender, EventArgs e)
{
string consulta= "SELECT Nombre from Clientes";
//Crea comando.
cmd = new OleDbCommand(consulta, Con);
Con.Open(); //Abre conexión
DR = cmd.ExecuteReader(); //Ejecuta datareader
while (DR.Read()) //Mientras tenga datos por leer
{
cmbClientes.Items.Add(DR.GetValue(0)); //Añado los nombres al combobox
}
Con.Close(); //Cierra conexión
//Nueva consulta
consulta = "SELECT descripcion FROM CatalogoMovimientos";
//Crea comando
cmd = new OleDbCommand(consulta, Con);
Con.Open(); //Abre conexión
DR = cmd.ExecuteReader(); //Ejecutar datareader
while (DR.Read()) //Mientras sigan datos por leer
QueMov.Add(DR.GetValue(0)); //Se añaden las descripciones de los movimientos
Con.Close(); //Cierra conexión
}
//loading of combobox1
//data from mat_name from table STEEL in database
//loading all elements from column mat_num except 0,1,List_name,Unit
private void loadCombo1()
{
string item;
comboBox1.Items.Clear();
dat_reader = dat_conn.getDBReader("Select mat_name from Steel where id_steel not in (1,2,3) order by id_steel"); // if cell type is text - string '2'
while (dat_reader.Read())
{
item = dat_reader.GetValue(0).ToString();
comboBox1.Items.Add(item);
}
}
public Vector<vQualification> listQualifications(uint gvoid)
{
// Declarations
Vector<vQualification> quals = new Vector<vQualification>();
uint gvqid = 0;
string qualification = null;
vQualification input = new vQualification();
// Command
string query = string.Format("SELECT gvq_id, gvq_qual " +
"FROM gfrc_volunteer_qualification WHERE gvo_id = {0}", gvoid);
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
if (!UInt32.TryParse(rdr.GetValue(0).ToString(), out gvqid))
gvqid = 0;
qualification = rdr.GetString(1);
if (gvqid != 0)
{
input = new vQualification(gvqid, gvoid, qualification);
quals.Add(input);
}
}
}
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return quals;
}
public string loginProperty(string x)
{
openConnection();
string value = "";
rder = new OleDbCommand("SELECT IDENTITY FROM UserIds WHERE USERID='" + x + "'", con);
dr = rder.ExecuteReader();
while (dr.Read())
{
value = dr.GetValue(0).ToString();
}
con.Close();
Console.WriteLine("Value :" + value);
return value;
}
private DataSet ConvertDataReaderToDataSet(OleDbDataReader reader)
{
DataSet dataSet = new DataSet();
DataTable schemaTable = reader.GetSchemaTable();
DataTable dataTable = new DataTable();
for (int cntr = 0; cntr < schemaTable.Rows.Count; ++cntr)
{
DataRow dataRow = schemaTable.Rows[cntr];
string columnName = dataRow["ColumnName"].ToString();
DataColumn column = new DataColumn(columnName, dataRow["ColumnName"].GetType());
dataTable.Columns.Add(column);
}
while (reader.Read())
{
DataRow dataRow = dataTable.NewRow();
for (int cntr = 0; cntr < reader.FieldCount; ++cntr)
{
dataRow[cntr] = reader.GetValue(cntr);
}
dataTable.Rows.Add(dataRow);
}
dataSet.Tables.Add(dataTable);
return dataSet;
}
public Vector<Holiday> listHolidays(uint gvoid)
{
// Declarations
Vector<Holiday> quals = new Vector<Holiday>();
uint gvhid = 0, modifiedby = 0;
DateTime datemodified = new DateTime(1901, 1, 1), start = new DateTime(1901, 1, 1), end = new DateTime(1901, 1, 1);
Holiday input = new Holiday();
// Declarations
// Command
string query = string.Format("SELECT gvh_id, gvh_start, gvh_end, date_modified, modified_by " +
"FROM gfrc_volunteer_holiday WHERE gvo_id = {0}", gvoid);
try
{
using (conn)
{
conn.Open();
cmd = new OleDbCommand(query, conn);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
if (UInt32.TryParse(rdr.GetValue(0).ToString(), out gvhid))
{
start = rdr.GetDateTime(1);
if (!DateTime.TryParse(rdr.GetValue(2).ToString(), out end))
end = new DateTime(1901, 1, 1);
if (!DateTime.TryParse(rdr.GetValue(14).ToString(), out datemodified))
datemodified = new DateTime(1901, 1, 1);
if (!UInt32.TryParse(rdr.GetValue(15).ToString(), out modifiedby))
modifiedby = 0;
input = new Holiday(gvhid, gvoid, start, end, datemodified, modifiedby);
quals.Add(input);
}
}
}
}
finally
{
if (rdr != null)
rdr.Close();
}
if (conn != null)
{
conn.Close();
}
return quals;
}
private bool IsEmptyRow(OleDbDataReader dataReader)
{
bool empty = true;
for (int i = 0; i < dataReader.FieldCount; i++)
{
if (dataReader.GetValue(i).ToString() != "")
{
empty = false;
break;
}
}
return empty;
}
public CMat_02_00(string combo1)
{
m_sMatType = 2;
string sql1;
sql1 = "Select mat_num, mat_name, mat_prod_code_num, mat_prod_code_name1, mat_prod_code_name2, concrete_grade_num, fck, fck_cube, fctm, fcm, fctk0_05, fctk0_95, epsilon_c1, epsilon_cu1, epsilon_c2, epsilon_cu2, epsilon_c3, epsilon_cu3, n, gamaMc, Ecm, Ec, G, nu_pois, alpha_temp from Concrete where mat_name like '" + combo1 + "'";
// Database DATA-CONCRETE variables reader
dat_conn = DatabaseConnection.getInstance();
dat_reader = dat_conn.getDBReader(sql1);
try
{
while (dat_reader.Read())
{
// CONCRETE DATABASE DATA
#region Data list
try
{
mat_num = Convert.ToInt16(dat_reader.GetValue(0).ToString());
}
catch (FormatException) { }
try
{
mat_name = dat_reader.GetValue(1).ToString();
}
catch (FormatException) { }
try
{
mat_prod_code_num = Convert.ToInt16(dat_reader.GetValue(2).ToString());
}
catch (FormatException) { }
try
{
mat_prod_code_name1 = dat_reader.GetValue(3).ToString();
}
catch (FormatException) { }
try
{
mat_prod_code_name2 = dat_reader.GetValue(4).ToString();
}
catch (FormatException) { }
try
{
concrete_grade_num = Convert.ToInt32(dat_reader.GetValue(5).ToString());
}
catch (FormatException) { }
try
{
fck = Convert.ToDouble(dat_reader.GetValue(6).ToString());
}
catch (FormatException) { }
try
{
fck_cube = Convert.ToDouble(dat_reader.GetValue(7).ToString());
}
catch (FormatException) { }
try
{
fctm = Convert.ToDouble(dat_reader.GetValue(8).ToString());
}
catch (FormatException) { }
try
{
fcm = Convert.ToDouble(dat_reader.GetValue(9).ToString());
}
catch (FormatException) { }
try
{
fctk0_05 = Convert.ToDouble(dat_reader.GetValue(10).ToString());
}
catch (FormatException) { }
try
{
fctk0_95 = Convert.ToDouble(dat_reader.GetValue(11).ToString());
}
catch (FormatException) { }
try
{
epsilon_c1 = Convert.ToDouble(dat_reader.GetValue(12).ToString());
}
catch (FormatException) { }
try
{
epsilon_cu1 = Convert.ToDouble(dat_reader.GetValue(13).ToString());
}
catch (FormatException) { }
try
{
epsilon_c2 = Convert.ToDouble(dat_reader.GetValue(14).ToString());
}
catch (FormatException) { }
try
{
epsilon_cu2 = Convert.ToDouble(dat_reader.GetValue(15).ToString());
}
catch (FormatException) { }
try
{
epsilon_c3 = Convert.ToDouble(dat_reader.GetValue(16).ToString());
}
catch (FormatException) { }
try
{
epsilon_cu3 = Convert.ToDouble(dat_reader.GetValue(17).ToString());
}
catch (FormatException) { }
try
{
d_n = Convert.ToDouble(dat_reader.GetValue(18).ToString());
}
catch (FormatException) { }
try
{
d_gamaMc = Convert.ToDouble(dat_reader.GetValue(19).ToString());
}
catch (FormatException) { }
try
{
d_Ecm = Convert.ToDouble(dat_reader.GetValue(20).ToString());
}
catch (FormatException) { }
try
{
d_Ec = Convert.ToDouble(dat_reader.GetValue(21).ToString());
}
catch (FormatException) { }
try
{
d_G = Convert.ToDouble(dat_reader.GetValue(22).ToString());
}
catch (FormatException) { }
try
{
d_nu_pois = Convert.ToDouble(dat_reader.GetValue(23).ToString());
}
catch (FormatException) { }
try
{
d_alpha_temp = Convert.ToDouble(dat_reader.GetValue(24).ToString());
}
catch (FormatException) { }
#endregion
}
}
catch (FormatException) { }
}
//loading of combobox2
//data from column csprof_name from table Sections in database
private void loadCombo2()
{
string item;
comboBox2.Items.Clear();
dat_reader = dat_conn.getDBReader("Select csprof_name from Sections where id_sections not in (1,2,3) order by id_sections");//,3,24,43,62,80,105,130,155,180,222,278)");
while (dat_reader.Read())
{
item = dat_reader.GetValue(0).ToString();
comboBox2.Items.Add(item);
}
}
