public bool Update(Order order)
{
FlyerMeDS.fly_orderDataTable orders = Adapter.GetOrderByOrderID(Convert.ToInt32(order.order_id));
if (orders.Count == 0)
{
// no matching record found, return false
return(false);
}
FlyerMeDS.fly_orderRow orderrow = orders[0];
orderrow.customer_id = order.customer_id;
if (order.type == null)
{
orderrow.SettypeNull();
}
else
{
orderrow.type = order.type;
}
if (order.photo_type == null)
{
orderrow.Setphoto_typeNull();
}
else
{
orderrow.photo_type = order.photo_type;
}
if (order.market_state == null)
{
orderrow.Setmarket_stateNull();
}
else
{
orderrow.market_state = order.market_state;
}
if (order.market_county == null)
{
orderrow.Setmarket_countyNull();
}
else
{
orderrow.market_county = order.market_county;
}
if (order.market_association == null)
{
orderrow.Setmarket_associationNull();
}
else
{
orderrow.market_association = order.market_association;
}
if (order.market_msa == null)
{
orderrow.Setmarket_msaNull();
}
else
{
orderrow.market_msa = order.market_msa;
}
orderrow.tota_price = order.tota_price;
orderrow.invoice_tax = order.invoice_tax;
if (order.invoice_promocode == null)
{
orderrow.Setinvoice_promocodeNull();
}
else
{
orderrow.invoice_promocode = order.invoice_promocode;
}
if (order.invoice_transaction_id == null)
{
orderrow.Setinvoice_transaction_idNull();
}
else
{
orderrow.invoice_transaction_id = order.invoice_transaction_id;
}
if (order.status == null)
{
orderrow.SetstatusNull();
}
else
{
orderrow.status = order.status;
}
if (order.headline == null)
{
orderrow.SetheadlineNull();
}
else
{
orderrow.headline = order.headline;
}
if (order.theme == null)
{
orderrow.SetthemeNull();
}
else
{
orderrow.theme = order.theme;
}
if (order.layout == null)
{
orderrow.SetlayoutNull();
}
else
{
orderrow.layout = order.layout;
}
if (order.delivery_date == null)
{
orderrow.Setdelivery_dateNull();
}
else
{
orderrow.delivery_date = order.delivery_date;
}
if (order.mls_number == null)
{
orderrow.Setmls_numberNull();
}
else
{
orderrow.mls_number = order.mls_number;
}
if (order.email_subject == null)
{
orderrow.Setemail_subjectNull();
}
else
{
orderrow.email_subject = order.email_subject;
}
if (order.title == null)
{
orderrow.SettitleNull();
}
else
{
orderrow.title = order.title;
}
if (order.sub_title == null)
{
orderrow.Setsub_titleNull();
}
else
{
orderrow.sub_title = order.sub_title;
}
if (order.prop_address1 == null)
{
orderrow.Setprop_address1Null();
}
else
{
orderrow.prop_address1 = order.prop_address1;
}
if (order.prop_address2 == null)
{
orderrow.Setprop_address2Null();
}
else
{
orderrow.prop_address2 = order.prop_address2;
}
if (order.prop_city == null)
{
orderrow.Setprop_cityNull();
}
else
{
orderrow.prop_city = order.prop_city;
}
if (order.prop_state == null)
{
orderrow.Setprop_stateNull();
}
else
{
orderrow.prop_state = order.prop_state;
}
if (order.prop_zipcode == null)
{
orderrow.Setprop_zipcodeNull();
}
else
{
orderrow.prop_zipcode = order.prop_zipcode;
}
if (order.prop_desc == null)
{
orderrow.Setprop_descNull();
}
else
{
orderrow.prop_desc = order.prop_desc;
}
if (order.prop_price == null)
{
orderrow.Setprop_priceNull();
}
else
{
orderrow.prop_price = order.prop_price;
}
if (order.bullet1 == null)
{
orderrow.Setbullet1Null();
}
else
{
orderrow.bullet1 = order.bullet1;
}
if (order.bullet2 == null)
{
orderrow.Setbullet2Null();
}
else
{
orderrow.bullet2 = order.bullet2;
}
if (order.bullet3 == null)
{
orderrow.Setbullet3Null();
}
else
{
orderrow.bullet3 = order.bullet3;
}
if (order.bullet4 == null)
{
orderrow.Setbullet4Null();
}
else
{
orderrow.bullet4 = order.bullet4;
}
if (order.bullet5 == null)
{
orderrow.Setbullet5Null();
}
else
{
orderrow.bullet5 = order.bullet5;
}
if (order.bullet6 == null)
{
orderrow.Setbullet6Null();
}
else
{
orderrow.bullet6 = order.bullet6;
}
if (order.bullet7 == null)
{
orderrow.Setbullet7Null();
}
else
{
orderrow.bullet7 = order.bullet7;
}
if (order.bullet8 == null)
{
orderrow.Setbullet8Null();
}
else
{
orderrow.bullet8 = order.bullet8;
}
if (order.custom_field1 == null)
{
orderrow.Setcustom_field1Null();
}
else
{
orderrow.custom_field1 = order.custom_field1;
}
if (order.custom_field2 == null)
{
orderrow.Setcustom_field2Null();
}
else
{
orderrow.custom_field2 = order.custom_field2;
}
if (order.custom_field3 == null)
{
orderrow.Setcustom_field3Null();
}
else
{
orderrow.custom_field3 = order.custom_field3;
}
if (order.custom_field4 == null)
{
orderrow.Setcustom_field4Null();
}
else
{
orderrow.custom_field4 = order.custom_field4;
}
if (order.custom_field5 == null)
{
orderrow.Setcustom_field5Null();
}
else
{
orderrow.custom_field5 = order.custom_field5;
}
if (order.custom_field6 == null)
{
orderrow.Setcustom_field6Null();
}
else
{
orderrow.custom_field6 = order.custom_field6;
}
if (order.custom_field7 == null)
{
orderrow.Setcustom_field7Null();
}
else
{
orderrow.custom_field7 = order.custom_field7;
}
if (order.custom_field8 == null)
{
orderrow.Setcustom_field8Null();
}
else
{
orderrow.custom_field8 = order.custom_field8;
}
if (order.custom_field9 == null)
{
orderrow.Setcustom_field9Null();
}
else
{
orderrow.custom_field9 = order.custom_field9;
}
if (order.custom_field10 == null)
{
orderrow.Setcustom_field10Null();
}
else
{
orderrow.custom_field10 = order.custom_field10;
}
if (order.custom_field_value1 == null)
{
orderrow.Setcustom_field_value1Null();
}
else
{
orderrow.custom_field_value1 = order.custom_field_value1;
}
if (order.custom_field_value2 == null)
{
orderrow.Setcustom_field_value2Null();
}
else
{
orderrow.custom_field_value2 = order.custom_field_value2;
}
if (order.custom_field_value3 == null)
{
orderrow.Setcustom_field_value3Null();
}
else
{
orderrow.custom_field_value3 = order.custom_field_value3;
}
if (order.custom_field_value4 == null)
{
orderrow.Setcustom_field_value4Null();
}
else
{
orderrow.custom_field_value4 = order.custom_field_value4;
}
if (order.custom_field_value5 == null)
{
orderrow.Setcustom_field_value5Null();
}
else
{
orderrow.custom_field_value5 = order.custom_field_value5;
}
if (order.custom_field_value6 == null)
{
orderrow.Setcustom_field_value6Null();
}
else
{
orderrow.custom_field_value6 = order.custom_field_value6;
}
if (order.custom_field_value7 == null)
{
orderrow.Setcustom_field_value7Null();
}
else
{
orderrow.custom_field_value7 = order.custom_field_value7;
}
if (order.custom_field_value8 == null)
{
orderrow.Setcustom_field_value8Null();
}
else
{
orderrow.custom_field_value8 = order.custom_field_value8;
}
if (order.custom_field_value9 == null)
{
orderrow.Setcustom_field_value9Null();
}
else
{
orderrow.custom_field_value9 = order.custom_field_value9;
}
if (order.custom_field_value10 == null)
{
orderrow.Setcustom_field_value10Null();
}
else
{
orderrow.custom_field_value10 = order.custom_field_value10;
}
if (order.mls_link == null)
{
orderrow.Setmls_linkNull();
}
else
{
orderrow.mls_link = order.mls_link;
}
if (order.virtualtour_link == null)
{
orderrow.Setvirtualtour_linkNull();
}
else
{
orderrow.virtualtour_link = order.virtualtour_link;
}
if (order.map_link == null)
{
orderrow.Setmap_linkNull();
}
else
{
orderrow.map_link = order.map_link;
}
//if (order.use_mls_logo == null) orderrow.Setuse_mls_logoNull();
//else
orderrow.use_mls_logo = order.use_mls_logo;
//if (order.use_housing_logo == null) orderrow.Setuse_housing_logoNull();
//else
orderrow.use_housing_logo = order.use_housing_logo;
if (order.markup == null)
{
orderrow.SetmarkupNull();
}
else
{
orderrow.markup = order.markup;
}
if (order.flyer == null)
{
orderrow.SetflyerNull();
}
else
{
orderrow.flyer = order.flyer;
}
if (order.price_range_min == null)
{
orderrow.Setprice_range_minNull();
}
else
{
orderrow.price_range_min = order.price_range_min;
}
if (order.price_range_max == null)
{
orderrow.Setprice_range_maxNull();
}
else
{
orderrow.price_range_max = order.price_range_max;
}
if (order.property_type == null)
{
orderrow.Setproperty_typeNull();
}
else
{
orderrow.property_type = order.property_type;
}
if (order.sqft_range_min == null)
{
orderrow.Setsqft_range_minNull();
}
else
{
orderrow.sqft_range_min = order.sqft_range_min;
}
if (order.sqft_range_max == null)
{
orderrow.Setsqft_range_maxNull();
}
else
{
orderrow.sqft_range_max = order.sqft_range_max;
}
if (order.location == null)
{
orderrow.SetlocationNull();
}
else
{
orderrow.location = order.location;
}
if (order.more_info == null)
{
orderrow.Setmore_infoNull();
}
else
{
orderrow.more_info = order.more_info;
}
if (order.buyer_message == null)
{
orderrow.Setbuyer_messageNull();
}
else
{
orderrow.buyer_message = order.buyer_message;
}
if (order.photo1 == null)
{
orderrow.Setphoto1Null();
}
else
{
orderrow.photo1 = order.photo1;
}
if (order.photo2 == null)
{
orderrow.Setphoto2Null();
}
else
{
orderrow.photo2 = order.photo2;
}
if (order.photo3 == null)
{
orderrow.Setphoto3Null();
}
else
{
orderrow.photo3 = order.photo3;
}
if (order.photo4 == null)
{
orderrow.Setphoto4Null();
}
else
{
orderrow.photo4 = order.photo4;
}
if (order.photo5 == null)
{
orderrow.Setphoto5Null();
}
else
{
orderrow.photo5 = order.photo5;
}
if (order.photo6 == null)
{
orderrow.Setphoto6Null();
}
else
{
orderrow.photo6 = order.photo6;
}
if (order.photo7 == null)
{
orderrow.Setphoto7Null();
}
else
{
orderrow.photo7 = order.photo7;
}
if (order.photo8 == null)
{
orderrow.Setphoto8Null();
}
else
{
orderrow.photo8 = order.photo8;
}
if (order.photo9 == null)
{
orderrow.Setphoto9Null();
}
else
{
orderrow.photo9 = order.photo9;
}
if (order.photo10 == null)
{
orderrow.Setphoto10Null();
}
else
{
orderrow.photo10 = order.photo10;
}
if (order.field1 == null)
{
orderrow.Setfield1Null();
}
else
{
orderrow.field1 = order.field1;
}
if (order.field2 == null)
{
orderrow.Setfield2Null();
}
else
{
orderrow.field2 = order.field2;
}
if (order.field3 == null)
{
orderrow.Setfield3Null();
}
else
{
orderrow.field3 = order.field3;
}
if (order.field4 == null)
{
orderrow.Setfield4Null();
}
else
{
orderrow.field4 = order.field4;
}
if (order.field5 == null)
{
orderrow.Setfield5Null();
}
else
{
orderrow.field5 = order.field5;
}
if (order.created_on == null)
{
orderrow.Setcreated_onNull();
}
else
{
orderrow.created_on = order.created_on;
}
if (order.updated_on == null)
{
orderrow.Setupdated_onNull();
}
else
{
orderrow.updated_on = order.updated_on;
}
if (order.sent_on == null)
{
orderrow.Setsent_onNull();
}
else
{
orderrow.sent_on = order.sent_on;
}
orderrow.LastPageNo = order.LastPageNo;
//========New Fields==================================
if (order.Bedrooms == null)
{
orderrow.SetBedroomsNull();
}
else
{
orderrow.Bedrooms = order.Bedrooms;
}
if (order.FullBaths == null)
{
orderrow.SetFullBathsNull();
}
else
{
orderrow.FullBaths = order.FullBaths;
}
if (order.HalfBaths == null)
{
orderrow.SetHalfBathsNull();
}
else
{
orderrow.HalfBaths = order.HalfBaths;
}
if (order.Parking == null)
{
orderrow.SetParkingNull();
}
else
{
orderrow.Parking = order.Parking;
}
if (order.SqFoots == null)
{
orderrow.SetSqFootsNull();
}
else
{
orderrow.SqFoots = order.SqFoots;
}
if (order.YearBuilt == null)
{
orderrow.SetYearBuiltNull();
}
else
{
orderrow.YearBuilt = order.YearBuilt;
}
if (order.Floors == null)
{
orderrow.SetFloorsNull();
}
else
{
orderrow.Floors = order.Floors;
}
if (order.LotSize == null)
{
orderrow.SetLotSizeNull();
}
else
{
orderrow.LotSize = order.LotSize;
}
if (order.Subdivision == null)
{
orderrow.SetSubdivisionNull();
}
else
{
orderrow.Subdivision = order.Subdivision;
}
if (order.HOA == null)
{
orderrow.SetHOANull();
}
else
{
orderrow.HOA = order.HOA;
}
if (order.PropertyFeatures == null)
{
orderrow.SetPropertyFeaturesNull();
}
else
{
orderrow.PropertyFeatures = order.PropertyFeatures;
}
if (order.PropertyFeaturesValues == null)
{
orderrow.SetPropertyFeaturesValuesNull();
}
else
{
orderrow.PropertyFeaturesValues = order.PropertyFeaturesValues;
}
if (order.OtherPropertyFeatures == null)
{
orderrow.SetOtherPropertyFeaturesNull();
}
else
{
orderrow.OtherPropertyFeatures = order.OtherPropertyFeatures;
}
orderrow.Discount = order.Discount;
orderrow.fk_PropertyCategory = order.PropertyCategory;
orderrow.fk_PropertyType = order.PropertyType;
if (order.AptSuiteBldg == null)
{
orderrow.SetAptSuiteBldgNull();
}
else
{
orderrow.AptSuiteBldg = order.AptSuiteBldg;
}
if (order.OpenHouses == null)
{
orderrow.SetOpenHousesNull();
}
else
{
orderrow.OpenHouses = order.OpenHouses;
}
//====================================================
// Update the order record
int rowsAffected = Adapter.Update(orderrow);
// Return true if precisely one row was updated,
// otherwise false
return(rowsAffected == 1);
}
