public void update_part(sqlParameters ssp, string updateData)
{
List <string> parametersRAW = new List <string>( );
for (int i = 0; i < spec.partTxSpec.Count - 1; i++)
{
part = _switch.partSwitchFromQB(i, updateData.Substring(position, spec.partTxSpec[i]), part);
position += spec.partTxSpec[i];
}
SqlCommandBuilder scb;
DataSet ds = new DataSet( );
ssp.SQLcmd = "SELECT * FROM " + ssp.tableName + " WHERE " + ssp.searchKey + " = " + ssp.searchVal;
SqlDataAdapter sda = new SqlDataAdapter(ssp.SQLcmd, ssp.db_connector);
sda.Fill(ds, ssp.tableName);
scb = new SqlCommandBuilder(sda);
SqlCommand update = scb.GetUpdateCommand(true);
update.Connection = ssp.db_connector;
if (int.TryParse(ds.Tables[0].Rows[0].ItemArray[0].ToString( ), out int Id))
{
update = _switch.partSwitchToSQLUpdate(update, part, Id, ds.Tables[0].Rows[0].ItemArray);
}
ssp.db_connector.Open( );
update.ExecuteNonQuery( );
ssp.db_connector.Close( );
}
public void update_vendor(sqlParameters ssp, string updateData)
{
int lent = updateData.Length;
for (int i = 0; i < spec.vendorTxSpec.Count; i++)
{
vendor = _switch.vendorSwitch(i, updateData.Substring(position, spec.vendorTxSpec[i]), vendor);
position += spec.vendorTxSpec[i];
}
SqlCommandBuilder scb;
DataSet ds = new DataSet( );
ssp.SQLcmd = "SELECT * FROM " + ssp.tableName + " WHERE " + ssp.searchKey + " = " + ssp.searchVal;
SqlDataAdapter sda = new SqlDataAdapter(ssp.SQLcmd, ssp.db_connector);
sda.Fill(ds, ssp.tableName);
scb = new SqlCommandBuilder(sda);
SqlCommand update = scb.GetUpdateCommand(true);
update.Connection = ssp.db_connector;
if (int.TryParse(ds.Tables[0].Rows[0].ItemArray[0].ToString( ), out int Id))
{
update = _switch.vendorSwitchToSQLUpdate(update, vendor, ds.Tables[0].Rows[0].ItemArray);
}
ssp.db_connector.Open( );
update.ExecuteNonQuery( );
ssp.db_connector.Close( );
}
public int delete_row(sqlParameters ssp)
{
SqlCommand sqlCommand = new SqlCommand(ssp.SQLcmd, ssp.db_connector);
ssp.db_connector.Open( );
rowsChanged = sqlCommand.ExecuteNonQuery( );
ssp.db_connector.Close( );
return(rowsChanged);
}
public sqlParameters getSSP(string searchKey, string searchVal, string SQLcmd, string tableName, SqlConnection db_connector)
{
dbConfig db = new dbConfig( );
sqlParameters ssp = new sqlParameters( );
ssp.db_connector = new SqlConnection(db.inven_SQL_admin);
ssp.tableName = tableName;
ssp.SQLcmd = SQLcmd;
ssp.searchKey = searchKey;
ssp.searchVal = searchVal;
return(ssp);
}
public void load_Into_SQL(List <vendorFields> vendors, sqlParameters ssp)
{
int added = 0;
List <SqlCommand> sqlCommands = new List <SqlCommand>( );
SqlCommandBuilder scb = createCommandBuilder(dbconfig.vendorTable);
SqlCommand insert = scb.GetInsertCommand( );
SqlCommand holder = new SqlCommand( );
foreach (vendorFields _v in vendors)
{
holder = insert.Clone( );
foreach (SqlParameter param in holder.Parameters)
{
if (param.SourceColumn == "id")
{
param.Value = _v.id;
}
else
{
param.Value = _switch.vendorSqlSwitch(param.SourceColumn, _v);
}
}
holder.Connection = sql_conn;
holder.CommandType = System.Data.CommandType.Text;
sqlCommands.Add(holder);
}
openDBcnxtn( );
foreach (SqlCommand s in sqlCommands)
{
DataSet ds = new DataSet( );
SqlDataAdapter sda1 = new SqlDataAdapter(ssp.SQLcmd + " * FROM " + ssp.tableName + " WHERE " + ssp.searchKey + " = " + s.Parameters[0].Value.ToString( ), sql_conn);
sda1.Fill(ds, "vendor");
if (ds.Tables["vendor"].Rows.Count == 0)
{
added += s.ExecuteNonQuery( );
}
}
sql_conn.Close( );
Console.WriteLine(added + " vendors added to database.");
Console.ReadKey( );
}
public List <string> query_vendor(sqlParameters ssp)
{
List <string> response = new List <string>( );
string fullString = "";
fileSpec spec = new fileSpec( );
DataSet dataSet = new DataSet( );
SqlDataAdapter sda1 = new SqlDataAdapter(ssp.SQLcmd, ssp.db_connector);
ssp.db_connector.Open( );
sda1.Fill(dataSet, ssp.tableName);
if (dataSet.Tables.Count == 1)
{
if (dataSet.Tables[0].Rows.Count == 1)
{
int fieldCount = dataSet.Tables[0].Rows[0].ItemArray.Count( );
for (int i = 0; i < fieldCount - 1; i++)
{
fullString += (dataSet.Tables[0].Rows[0].ItemArray[i].ToString( ) + space).Remove(spec.vendorTxSpec[i]);
}
response.Add(fullString);
}
if (dataSet.Tables[0].Rows.Count > 1)
{
foreach (DataRow row in dataSet.Tables[0].Rows)
{
fullString = "";
for (int i = 0; i < row.ItemArray.Count( ); i++)
{
fullString += (row.ItemArray[i].ToString( ) + space).Remove(spec.vendorTxSpec[i]);
}
response.Add(fullString);
}
}
}
sql_conn.Close( );
return(response);
}
public void insert_vendor(sqlParameters ssp, string insertData)
{
for (int i = 0; i < spec.vendorTxSpec.Count - 1; i++)
{
vendor = _switch.vendorSwitch(i, insertData.Substring(position, spec.vendorTxSpec[i]), vendor);
position += spec.vendorTxSpec[i];
}
DataSet ds = new DataSet( );
SqlCommandBuilder scb;
SqlDataAdapter sda = new SqlDataAdapter(ssp.SQLcmd, ssp.db_connector);
sda.Fill(ds, ssp.tableName);
scb = new SqlCommandBuilder(sda);
SqlCommand insert = scb.GetInsertCommand(true);
insert.Connection = ssp.db_connector;
if (vendor.v_code.Trim( ) != null)
{
insert = _switch.vendorSwitchToSQLInsert(insert, vendor);
ssp.db_connector.Open( );
insert.ExecuteNonQuery( );
ssp.db_connector.Close( );
}
}
public string selectQuery(sqlParameters ssp)
{
string partTable = db.db_name + db.partTable;
string vendorTable = db.db_name + db.vendorTable;
string productTable = db.db_name + db.productTable;
SqlDataAdapter sda1 = new SqlDataAdapter(ssp.SQLcmd, ssp.db_connector);
List <int> sendSpec = new List <int>( );
if (ssp.tableName == productTable)
{
sendSpec = spec.productTxSpec;
ssp.db_connector.Open( );
sda1.Fill(ds, ssp.tableName);
if (ds.Tables.Count == 1)
{
if (ds.Tables[0].Rows.Count == 1)
{
int fieldCount = sendSpec.Count( );
for (int i = 0; i < fieldCount; i++)
{
fullString += (ds.Tables[0].Rows[0].ItemArray[i + 1].ToString( ) + space).Remove(sendSpec[i]);
}
}
}
}
else if (ssp.tableName == partTable)
{
sendSpec = spec.partTxSpec;
ssp.db_connector.Open( );
sda1.Fill(ds, ssp.tableName);
if (ds.Tables.Count == 1)
{
if (ds.Tables[0].Rows.Count == 1)
{
int fieldCount = sendSpec.Count();
for (int i = 0; i < fieldCount; i++)
{
fullString += (ds.Tables[0].Rows[0].ItemArray[i + 2].ToString( ) + space).Remove(sendSpec[i]);
}
}
}
}
else if (ssp.tableName == vendorTable)
{
sendSpec = spec.vendorTxSpec;
ssp.db_connector.Open( );
sda1.Fill(ds, ssp.tableName);
if (ds.Tables.Count == 1)
{
if (ds.Tables[0].Rows.Count == 1)
{
int fieldCount = ds.Tables[0].Rows[0].ItemArray.Count( );
for (int i = 0; i < fieldCount; i++)
{
fullString += (ds.Tables[0].Rows[0].ItemArray[i].ToString( ) + space).Remove(sendSpec[i]);
}
}
}
}
sql_conn.Close( );
return(fullString);
}
public stringAlongField delete_string_along(stringAlongField stringAlong, sqlParameters ssp)
{
return(stringAlong);
}
public void update_string_along(sqlParameters ssp, vendorFields vendor)
{
}
