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( ); } }