public vendorFields get_sample_vendor()
{
vendorFields vendor_tester = new vendorFields( );
vendor_tester.id = 0;
vendor_tester.v_code = "QUCAST";
vendor_tester.business_name = "QUALITY CASTINGS";
vendor_tester.address_1 = "1908 MACARTHUR RD";
vendor_tester.address_2 = "";
vendor_tester.city_state_zip = "WAUKESHA WI 53188";
vendor_tester.fax_number = "414-475-6539";
vendor_tester.terms = "";
vendor_tester.order_contact = "RANDY HARRINGTON";
vendor_tester.order_email = "*****@*****.**";
vendor_tester.order_email_cc = "262-442-7565";
vendor_tester.order_phone = "";
vendor_tester.account_contact = "";
vendor_tester.account_email = "";
vendor_tester.account_phone = "";
vendor_tester.quality_contact = "test quality contact";
vendor_tester.quality_email = "";
vendor_tester.quality_phone = "";
vendor_tester.shipping_contact = "";
vendor_tester.shipping_email = "";
vendor_tester.shipping_phone = "test shipping phone";
return(vendor_tester);
}
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 List <vendorFields> vendor_parser(List <string> raw)
{
List <vendorFields> vendors = new List <vendorFields>( );
vendorFields vendor;
foreach (string s in raw)
{
vendor = new vendorFields( );
string temp_s = s.Replace("\0", "");
string[] cracked = temp_s.Split('|');
for (int i = 0; i < (cracked.Count()); i++)
{
vendor = _switch.vendorSwitch(i, cracked[i], vendor);
}
if (!String.IsNullOrEmpty(vendor.v_code.Trim()))
{
vendors.Add(vendor);
}
}
return(vendors);
}
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 void query_string_along(vendorFields vendor)
{
}
public void update_string_along(sqlParameters ssp, vendorFields vendor)
{
}
public void create_string_along(vendorFields vendor)
{
}