/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromVendorshipfromresults(ref DataRow row, Vendorshipfromresults entity) { row.SetField("co_num", entity.coNum); row.SetField("wh_num", entity.whNum); row.SetField("vendor_id", entity.vendorId); row.SetField("edi_code", entity.ediCode); row.SetField("contact_name", entity.contactName); row.SetField("addr1", entity.addr1); row.SetField("addr2", entity.addr2); row.SetField("addr3", entity.addr3); row.SetField("city", entity.city); row.SetField("state", entity.state); row.SetField("zip", entity.zip); row.SetField("country", entity.country); row.SetField("phone_number", entity.phoneNumber); row.SetField("fax_number", entity.faxNumber); row.SetField("duns_number", entity.dunsNumber); row.SetField("vendaddrrowid", entity.vendaddrrowid.ToByteArray()); row.SetField("vendorshipfromresultsuserfield", entity.vendorshipfromresultsuserfield); row.SetField("userfield", entity.userfield); }
public static Vendorshipfromresults BuildVendorshipfromresultsFromRow(DataRow row) { Vendorshipfromresults entity = new Vendorshipfromresults(); entity.coNum = row.IsNull("co_num") ? string.Empty : row.Field <string>("co_num"); entity.whNum = row.IsNull("wh_num") ? string.Empty : row.Field <string>("wh_num"); entity.vendorId = row.IsNull("vendor_id") ? string.Empty : row.Field <string>("vendor_id"); entity.ediCode = row.IsNull("edi_code") ? string.Empty : row.Field <string>("edi_code"); entity.contactName = row.IsNull("contact_name") ? string.Empty : row.Field <string>("contact_name"); entity.addr1 = row.IsNull("addr1") ? string.Empty : row.Field <string>("addr1"); entity.addr2 = row.IsNull("addr2") ? string.Empty : row.Field <string>("addr2"); entity.addr3 = row.IsNull("addr3") ? string.Empty : row.Field <string>("addr3"); entity.city = row.IsNull("city") ? string.Empty : row.Field <string>("city"); entity.state = row.IsNull("state") ? string.Empty : row.Field <string>("state"); entity.zip = row.IsNull("zip") ? string.Empty : row.Field <string>("zip"); entity.country = row.IsNull("country") ? string.Empty : row.Field <string>("country"); entity.phoneNumber = row.IsNull("phone_number") ? string.Empty : row.Field <string>("phone_number"); entity.faxNumber = row.IsNull("fax_number") ? string.Empty : row.Field <string>("fax_number"); entity.dunsNumber = row.IsNull("duns_number") ? string.Empty : row.Field <string>("duns_number"); entity.vendaddrrowid = row.Field <byte[]>("vendaddrrowid").ToStringEncoded(); entity.vendorshipfromresultsuserfield = row.IsNull("vendorshipfromresultsuserfield") ? string.Empty : row.Field <string>("vendorshipfromresultsuserfield"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }