private static void GetDataSetSpsSchema(TbConnection con, string command)
{
DbCommand com = con.CreateCommand();
com.CommandText = command;
DataTable table = new DataTable("sps_schema");
DataColumn workCol = table.Columns.Add("schemaid", typeof(Int32));
workCol.AllowDBNull = false;
workCol.Unique = true;
table.Columns.Add("wmi", typeof(String));
table.Columns.Add("salesmakecode", typeof(Int32));
table.Columns.Add("protocol", typeof(Int32));
table.Columns.Add("systemtype", typeof(Int32));
table.Columns.Add("modelyearcode", typeof(Int32));
table.Columns.Add("vinpattern", typeof(String));
table.Columns.Add("snfrom", typeof(String));
table.Columns.Add("snto", typeof(String));
table.Columns.Add("hwid", typeof(Int32));
table.Columns.Add("identtype", typeof(Int32));
table.Load(com.ExecuteReader());
set.Tables.Add(table);
workCol.Dispose();
com.Dispose();
}
private void MakeTPTable()
{
DataColumn myColumn = new DataColumn();
DataTable dtbl = new DataTable("history");
dtbl.Locale = CultureInfo.CurrentCulture;
myColumn.DataType = System.Type.GetType("System.String");
myColumn.ColumnName = "time";
dtbl.Columns.Add(myColumn);
myColumn = new DataColumn();
myColumn.DataType = System.Type.GetType("System.String");
myColumn.ColumnName = "name";
dtbl.Columns.Add(myColumn);
myColumn = new DataColumn();
myColumn.DataType = System.Type.GetType("System.String");
myColumn.ColumnName = "slurl";
dtbl.Columns.Add(myColumn);
dtbl.PrimaryKey = new DataColumn[] { dtbl.Columns["time"] };
tp = dtbl;
myColumn.Dispose();
dtbl.Dispose();
}
private static void GetDataSetSpsHwdescription(TbConnection con, string command)
{
DbCommand com = con.CreateCommand();
com.CommandText = command;
DataTable table = new DataTable("sps_hwdescription");
DataColumn workCol = table.Columns.Add("hwid", typeof(Int32));
workCol.AllowDBNull = false;
workCol.Unique = true;
table.Columns.Add("hwlocid", typeof(Int32));
table.Columns.Add("hwname", typeof(String));
table.Load(com.ExecuteReader());
set.Tables.Add(table);
workCol.Dispose();
com.Dispose();
/*
* TbDataAdapter adapter = new TbDataAdapter();
*
* DataTable sampleTable = new DataTable("sps_hwdescription");
* TbCommand com = (TbCommand)con.CreateCommand();
* com.CommandText = command;
* adapter.SelectCommand = com;
* adapter.Fill(sampleTable);
* //adapter.Fill(sampleTable,"sps_schema");
*
* adapter.Dispose();
* com.Dispose();
*/
}
private void makeHeader(DataTable lsTable, string[] lsColumns)
{
try
{
DataColumn lsCol;
if (lsTable.Columns.Count == 0)
{
lsTable.Columns.Clear();
}
foreach (string s in lsColumns)
{
lsCol = new DataColumn();
lsCol.DataType = System.Type.GetType("System.String");
lsCol.ColumnName = s;
lsTable.Columns.Add(lsCol);
lsCol.Dispose();
}
return;
}
catch (Exception ex)
{
showErrorMessage(ex);
}
}
//Convert DataTbale All column in String Column
public DataTable ConverDataTableToString(DataTable dataTable)
{
DataTable tempDataTable = new DataTable();
foreach (DataColumn columnName in dataTable.Columns)
{
DataColumn tempColumn = new DataColumn();
tempColumn.ColumnName = columnName.ColumnName;
tempColumn.DataType = System.Type.GetType("System.String");
tempColumn.AutoIncrement = false;
tempColumn.Caption = columnName.Caption;
tempColumn.ReadOnly = false;
tempColumn.Unique = false;
tempDataTable.Columns.Add(tempColumn);
tempColumn.Dispose();
}
foreach (DataRow readRow in dataTable.Rows)
{
DataRow tempdataRow = tempDataTable.NewRow();
foreach (DataColumn readColumn in dataTable.Columns)
{
tempdataRow[readColumn.ColumnName] = readRow[readColumn.ColumnName].ToString();
}
tempDataTable.Rows.Add(tempdataRow);
}
return(tempDataTable);
}
private void replaceObjectDataColumn(DataTable dt, DataColumn dcOld)
{
int index = dcOld.Ordinal;
dt.Columns.Remove(dcOld);
DataColumn dcNew = new DataColumn(dcOld.ColumnName, typeof(System.Byte[]), dcOld.Expression, dcOld.ColumnMapping);
dcNew.AutoIncrement = dcOld.AutoIncrement;
dcNew.AutoIncrementSeed = dcOld.AutoIncrementSeed;
dcNew.AutoIncrementStep = dcOld.AutoIncrementStep;
dcNew.Caption = dcOld.Caption;
dcNew.DefaultValue = dcOld.DefaultValue;
foreach (object prop in dcOld.ExtendedProperties)
{
dcNew.ExtendedProperties.Add(prop.GetHashCode(), prop);
}
dcNew.MaxLength = dcOld.MaxLength;
dcNew.Prefix = dcOld.Prefix;
dcNew.ReadOnly = dcOld.ReadOnly;
dcNew.Unique = dcOld.Unique;
dt.Columns.Add(dcNew);
dcNew.SetOrdinal(index);
dcOld.Dispose();
dcOld = null;
}
private void LimpaColunas()
{
col_ID.Dispose();
col_Time.Dispose();
col_Msg.Dispose();
col_ID = null;
col_Time = null;
col_Msg = null;
}
public void Dispose()
{
sentence?.Dispose();
resultSentence?.Dispose();
dc1?.Dispose();
dc2?.Dispose();
dc3?.Dispose();
sentence = null;
resultSentence = null;
dc1 = null;
dc2 = null;
dc3 = null;
}
//private DataTable MakeDataTable()
//{
// DataColumn myColumn = new DataColumn();
// DataTable dtbl = new DataTable("list");
// myColumn.DataType = System.Type.GetType("System.String");
// myColumn.ColumnName = "mute_name";
// dtbl.Columns.Add(myColumn);
// myColumn = new DataColumn();
// myColumn.DataType = System.Type.GetType("System.String");
// myColumn.ColumnName = "uuid";
// dtbl.Columns.Add(myColumn);
// //mutelist.Columns.Add(myColumn);
// //dtbl.PrimaryKey = new DataColumn[] { dtbl.Columns["uuid"] };
// myColumn.Dispose();
// return dtbl;
//}
private static DataTable MakeGiverDataTable()
{
DataTable dtbl = new DataTable("list");
dtbl.Locale = CultureInfo.CurrentCulture;
DataColumn myColumn = new DataColumn();
myColumn.DataType = System.Type.GetType("System.String");
myColumn.ColumnName = "Command";
dtbl.Columns.Add(myColumn);
//client.Inventory.GiveItem(iitem.UUID, iitem.Name, iitem.AssetType, avid, false);
DataColumn myColumn1 = new DataColumn();
myColumn1.DataType = System.Type.GetType("System.String");
myColumn1.ColumnName = "UUID";
dtbl.Columns.Add(myColumn1);
DataColumn myColumn2 = new DataColumn();
myColumn2 = new DataColumn();
myColumn2.DataType = System.Type.GetType("System.String");
myColumn2.ColumnName = "Name";
dtbl.Columns.Add(myColumn2);
DataColumn myColumn3 = new DataColumn();
myColumn3.DataType = System.Type.GetType("System.String");
myColumn3.ColumnName = "AssetType";
dtbl.Columns.Add(myColumn3);
DataColumn[] keys = new DataColumn[1];
keys[0] = myColumn;
dtbl.PrimaryKey = keys;
myColumn.Dispose();
myColumn1.Dispose();
myColumn2.Dispose();
myColumn3.Dispose();
return(dtbl);
}
private static void GetDataSetSpsConfiguration(TbConnection con, string command)
{
DbCommand com = con.CreateCommand();
com.CommandText = command;
DataTable table = new DataTable("sps_configuration");
DataColumn workCol = table.Columns.Add("vehicleid", typeof(Int32));
//workCol.AllowDBNull = false;
//workCol.Unique = true;
table.Columns.Add("ecuid", typeof(Int32));
table.Load(com.ExecuteReader());
set.Tables.Add(table);
workCol.Dispose();
com.Dispose();
}
/// <summary>
/// To create data column
/// </summary>
/// <param name="caption">Caption</param>
/// <param name="columnName">Column Name</param>
/// <param name="dataType">Data Type</param>
/// <returns></returns>
public static DataColumn CreateDataColumn(string caption, string columnName, string dataType)
{
DataColumn column = null;
try
{
column = new DataColumn();
column.Caption = caption;
column.ColumnName = columnName;
column.DataType = System.Type.GetType(dataType);
return(column);
}
finally
{
if (column != null)
{
column.Dispose();
column = null;
}
}
}
public static DataTable CreateNewTable(string TableName, string[] Fields)
{
DataTable dataTable = new DataTable(TableName);
DataColumn[] dataColumnArray = new DataColumn[1]
{
new DataColumn()
};
dataColumnArray[0].DataType = System.Type.GetType("System.Int32");
dataColumnArray[0].ColumnName = "Count";
dataColumnArray[0].AutoIncrement = true;
dataColumnArray[0].ReadOnly = true;
dataTable.Columns.Add(dataColumnArray[0]);
dataTable.PrimaryKey = dataColumnArray;
for (int index = 0; index < Fields.Length; ++index)
{
DataColumn column = !Fields[index].StartsWith("dbl") ? (!Fields[index].StartsWith("int") ? new DataColumn(Fields[index], System.Type.GetType("System.String")) : new DataColumn(Fields[index], System.Type.GetType("System.Int32"))) : new DataColumn(Fields[index], System.Type.GetType("System.double"));
dataTable.Columns.Add(column);
column.Dispose();
}
return(dataTable);
}
/// <summary>
/// Gets the data table from data reader.
/// </summary>
/// <returns>The data table from data reader.</returns>
/// <param name="dataReader">Data reader.</param>
private DataTable GetDataTableFromDataReader(IDataReader dataReader)
{
DataTable schemaTable = dataReader.GetSchemaTable();
schemaTable.Locale = CultureInfo.CurrentCulture;
DataTable resultTable = new DataTable();
resultTable.Locale = CultureInfo.CurrentCulture;
foreach (DataRow dataRow in schemaTable.Rows)
{
DataColumn dataColumn = new DataColumn();
dataColumn.ColumnName = dataRow["ColumnName"].ToString();
dataColumn.DataType = Type.GetType(dataRow["DataType"].ToString());
dataColumn.ReadOnly = (bool)dataRow["IsReadOnly"];
dataColumn.AutoIncrement = (bool)dataRow["IsAutoIncrement"];
dataColumn.Unique = (bool)dataRow["IsUnique"];
resultTable.Columns.Add(dataColumn);
dataColumn.Dispose();
}
schemaTable.Dispose();
while (dataReader.Read())
{
DataRow dataRow = resultTable.NewRow();
for (int i = 0; i < resultTable.Columns.Count; i++)
{
dataRow[i] = dataReader[i];
}
resultTable.Rows.Add(dataRow);
}
return(resultTable);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (String.IsNullOrWhiteSpace(txtName1.Text) || String.IsNullOrWhiteSpace(txtName2.Text) ||
String.IsNullOrWhiteSpace(txtName3.Text) || String.IsNullOrWhiteSpace(txtScore1.Text) ||
String.IsNullOrWhiteSpace(txtScore2.Text) || String.IsNullOrWhiteSpace(txtScore3.Text))
{
MessageBox.Show("All text boxes need a value to be saved.");
}
else
{
DataSet ds = new DataSet("BombSquad");
DataTable table = new DataTable("CurrentLevel");
DataColumn column = new DataColumn("Level");
column.DataType = Type.GetType("System.String");
table.Columns.Add(column);
DataRow row = table.NewRow();
row["Level"] = "Easy";
table.Rows.Add(row);
ds.Tables.Add(table);
table = new DataTable("Scores");
column = new DataColumn("Level");
column.DataType = Type.GetType("System.String");
table.Columns.Add(column);
column = new DataColumn("Name");
column.DataType = Type.GetType("System.String");
table.Columns.Add(column);
column = new DataColumn("Score");
column.DataType = Type.GetType("System.String");
table.Columns.Add(column);
row = table.NewRow();
row["Level"] = "Easy";
row["Name"] = txtName1.Text;
row["Score"] = txtScore1.Text;
table.Rows.Add(row);
row = table.NewRow();
row["Level"] = "Medium";
row["Name"] = txtName2.Text;
row["Score"] = txtScore2.Text;
table.Rows.Add(row);
row = table.NewRow();
row["Level"] = "Hard";
row["Name"] = txtName3.Text;
row["Score"] = txtScore3.Text;
table.Rows.Add(row);
ds.Tables.Add(table);
// write to file
ds.WriteXml("BombSquad.xml");
ds.Dispose();
table.Dispose();
column.Dispose();
}
}
/// <versions>08-10-2017(v0.0.4.8)</versions>
private Boolean Set_Results_DataSource(GridControl objGridControl, AMFCMembers objListResults)
{
StackFrame objStackFrame = new StackFrame();
String sErrorMsg = String.Empty;
try
{
#region Results Datasource
if (objListResults == null || objListResults.Members == null || objListResults.Members.Count == 0)
{
sErrorMsg = "Não foi possível obter Sócios para esta procura!";
Program.HandleError(objStackFrame.GetMethod().Name, sErrorMsg, Program.ErroType.ERROR, true, false);
return(false);
}
#endregion Results Datasource
#region TreeDataSet
DataTable objDataTableResults = new DataTable("Table_Find_Members_Resuls");
#region Data Columns Creation
DataColumn objDataColumn_Member_NUMERO = new DataColumn(new AMFCMember().Get_DBFMemberField_Name_ByType(GesAMFC.AMFCMember.DBFMemberFields.NUMERO), typeof(Int64)); //Int64
DataColumn objDataColumn_Member_NOME = new DataColumn(new AMFCMember().Get_DBFMemberField_Name_ByType(GesAMFC.AMFCMember.DBFMemberFields.NOME), typeof(String));
DataColumn objDataColumn_Member_DATAADMI = new DataColumn(new AMFCMember().Get_DBFMemberField_Name_ByType(GesAMFC.AMFCMember.DBFMemberFields.DATAADMI), typeof(String));
#endregion Data Columns Creation
#region Data Table Add Columns
objDataTableResults.Columns.AddRange(
new DataColumn[] {
objDataColumn_Member_NUMERO,
objDataColumn_Member_NOME,
objDataColumn_Member_DATAADMI
}
);
#endregion Data Table Add Columns
#region Data Columns Dispose
objDataColumn_Member_NUMERO.Dispose();
objDataColumn_Member_NOME.Dispose();
objDataColumn_Member_DATAADMI.Dispose();
#endregion Data Columns Dispose
#endregion TreeDataSet
#region Binding Data
foreach (AMFCMember objMember in objListResults.Members)
{
if (objMember == null || objMember.NUMERO < 1 || String.IsNullOrEmpty(objMember.NOME))
{
continue;
}
#region Set Member Row Data
DataRow objDataRow = objDataTableResults.NewRow();
objDataRow[objMember.Get_DBFMemberField_Name_ByType(GesAMFC.AMFCMember.DBFMemberFields.NUMERO)] = objMember.NUMERO.ToString();
objDataRow[objMember.Get_DBFMemberField_Name_ByType(GesAMFC.AMFCMember.DBFMemberFields.NOME)] = objMember.NOME;
objDataRow[objMember.Get_DBFMemberField_Name_ByType(GesAMFC.AMFCMember.DBFMemberFields.DATAADMI)] = objMember.DATAADMI;
#endregion Set Member Row Data
objDataTableResults.Rows.Add(objDataRow);
}
objGridControl.DataSource = objDataTableResults;
return(true);
#endregion Binding Data
}
catch (Exception ex)
{
Program.HandleError(ex.TargetSite.Name, ex.Message, Program.ErroType.EXCEPTION, true, false);
return(false);
}
finally { objStackFrame = null; }
}
