public void update_products(sqlParameters ssp, string updateData)
{
List <string> parametersRAW = new List <string>( );
for (int i = 0; i < spec.productTxSpec.Count - 1; i++)
{
product = _switch.prodSwitch(i, updateData.Substring(position, spec.productTxSpec[i]), product);
position += spec.productTxSpec[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.productSqlSwitchUpdate(update, product, Id, ds.Tables[0].Rows[0].ItemArray);
}
ssp.db_connector.Open( );
update.ExecuteNonQuery( );
ssp.db_connector.Close( );
}
public List <productField> productParser(List <string> raw)
{
List <productField> products = new List <productField>();
productField product = new productField();
foreach (string line in raw)
{
product = new productField();
product.parts_reqd = new Dictionary <string, int>();
string[] cracked = line.Split(',');
for (int i = 0; i < cracked.Count() - 1; i++)
{
product = _switch.prodSwitch(i, cracked[i], product);
}
products.Add(product);
}
return(products);
}
public void insert_product(sqlParameters ssp, string insertData)
{
for (int i = 0; i < spec.partTxSpec.Count - 1; i++)
{
product = _switch.prodSwitch(i, insertData.Substring(position, spec.productTxSpec[i]), product);
position += spec.partTxSpec[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 (part.part_name.Trim( ) != null)
{
insert = _switch.productSqlSwitchInsert(insert, product);
ssp.db_connector.Open( );
insert.ExecuteNonQuery( );
ssp.db_connector.Close( );
}
}
