private void SaveOrders(ValidationCollectedInfo info, String transactionId) { var username = User.Identity.Name; foreach (var order in info.Orders) { order.invoice_transaction_id = transactionId; if (String.Compare(order.type, FlyerTypes.Custom.ToString(), true) == 0) { order.status = Order.flyerstatus.Pending_Approval.ToString(); } else { order.status = Order.flyerstatus.Scheduled.ToString(); } order.Save(); } var processedOrderIds = String.Join(",", info.Orders.Select(o => o.order_id.ToString()).ToArray()); var orderTransaction = new FlyerMeDSTableAdapters.fly_TransactionTableAdapter(); orderTransaction.Insert(transactionId, username, processedOrderIds, info.PromoCode, info.SubTotal, info.Discount, info.TaxCost, info.TotalPrice); if (!String.IsNullOrEmpty(info.PromoCode)) { var objOrder = new OrdersBLL(); objOrder.UpdateDiscount(info.PromoCode); objOrder.UpdateOfferDiscount(username, info.PromoCode); } SendEmailReceipt(transactionId, username, info); }
private void SetRptOrdersDatasource() { var profile = Profile.GetProfile(Page.User.Identity.Name); var orderBLL = new OrdersBLL(); var dtOrders = orderBLL.Adapter.GetOrdersByCustomerIdPaged(Profile.UserName, pager.PageNumber, pager.PageSize, filter.Type); if (dtOrders.Count > 0) { pager.ItemsCount = (Int32)dtOrders.Rows[0]["TotalRecords"]; } rptOrders.DataSource = dtOrders; rptOrders.DataBind(); }
private static DataTable GetOrders() { var result = new DataTable(); var dcCol = new DataColumn("order_id", typeof(Int64)); result.Columns.Add(dcCol); dcCol = new DataColumn("title", typeof(String)); result.Columns.Add(dcCol); dcCol = new DataColumn("total_price", typeof(String)); result.Columns.Add(dcCol); var ordersBLL = new OrdersBLL(); var orderTable = ordersBLL.Adapter.GetOrdersByCustomerID(HttpContext.Current.User.Identity.Name, Order.flyerstatus.Incomplete.ToString()); Func <DataRow, Boolean> canIncludeOrder = (dr) => { return((dr["markup"] as String).HasText() && (dr["invoice_transaction_id"] as String).HasNoText() && ((Decimal)dr["tota_price"]) > 0M); }; DataRow dataRow; DataRow orderDataRow; for (var i = 0; i < orderTable.Rows.Count; i++) { orderDataRow = orderTable.Rows[i]; if (canIncludeOrder(orderDataRow)) { dataRow = result.NewRow(); dataRow["order_id"] = orderDataRow["order_id"]; dataRow["title"] = (orderDataRow["title"] as String).HasText() ? orderDataRow["title"] : orderDataRow["email_subject"]; dataRow["total_price"] = ((Decimal)orderDataRow["tota_price"]).FormatPrice(); result.Rows.Add(dataRow); } } return(result); }
/// -----------------------------------------------------------------------------/// /// <summary> ///<para>Initialize order object using orderid supplied</para> /// </summary> /// <remarks> /// </remarks> /// <history> /// </history> /// -----------------------------------------------------------------------------/// public Order(int orderid) { OrdersBLL ordersBLL = new OrdersBLL(); FlyerMeDS.fly_orderDataTable orderTable = ordersBLL.Adapter.GetOrderByOrderID(orderid); if (orderTable.Rows.Count > 0) { FlyerMeDS.fly_orderRow data = (FlyerMeDS.fly_orderRow)orderTable.Rows[0]; if (!Convert.IsDBNull(data["order_id"])) { _order_id = (long)data["order_id"]; } if (!Convert.IsDBNull(data["customer_id"])) { _customer_id = (string)data["customer_id"]; } if (!Convert.IsDBNull(data["type"])) { _type = (string)data["type"]; } if (!Convert.IsDBNull(data["photo_type"])) { _photo_type = (string)data["photo_type"]; } if (!Convert.IsDBNull(data["market_state"])) { _market_state = (string)data["market_state"]; } if (!Convert.IsDBNull(data["market_county"])) { _market_county = (string)data["market_county"]; } if (!Convert.IsDBNull(data["market_association"])) { _market_association = (string)data["market_association"]; } if (!Convert.IsDBNull(data["market_msa"])) { _market_msa = (string)data["market_msa"]; } if (!Convert.IsDBNull(data["tota_price"])) { _tota_price = (decimal)data["tota_price"]; } if (!Convert.IsDBNull(data["invoice_tax"])) { _invoice_tax = (decimal)data["invoice_tax"]; } if (!Convert.IsDBNull(data["invoice_promocode"])) { _invoice_promocode = (string)data["invoice_promocode"]; } if (!Convert.IsDBNull(data["invoice_transaction_id"])) { _invoice_transaction_id = (string)data["invoice_transaction_id"]; } if (!Convert.IsDBNull(data["status"])) { _status = (string)data["status"]; } if (!Convert.IsDBNull(data["headline"])) { _headline = (string)data["headline"]; } if (!Convert.IsDBNull(data["theme"])) { _theme = (string)data["theme"]; } if (!Convert.IsDBNull(data["layout"])) { _layout = (string)data["layout"]; } if (!Convert.IsDBNull(data["delivery_date"])) { _delivery_date = (DateTime)data["delivery_date"]; } if (!Convert.IsDBNull(data["mls_number"])) { _mls_number = (string)data["mls_number"]; } if (!Convert.IsDBNull(data["email_subject"])) { _email_subject = (string)data["email_subject"]; } if (!Convert.IsDBNull(data["title"])) { _title = (string)data["title"]; } if (!Convert.IsDBNull(data["sub_title"])) { _sub_title = (string)data["sub_title"]; } if (!Convert.IsDBNull(data["prop_address1"])) { _prop_address1 = (string)data["prop_address1"]; } if (!Convert.IsDBNull(data["prop_address2"])) { _prop_address2 = (string)data["prop_address2"]; } if (!Convert.IsDBNull(data["prop_city"])) { _prop_city = (string)data["prop_city"]; } if (!Convert.IsDBNull(data["prop_state"])) { _prop_state = (string)data["prop_state"]; } if (!Convert.IsDBNull(data["prop_zipcode"])) { _prop_zipcode = (string)data["prop_zipcode"]; } if (!Convert.IsDBNull(data["prop_desc"])) { _prop_desc = (string)data["prop_desc"]; } if (!Convert.IsDBNull(data["prop_price"])) { _prop_price = (string)data["prop_price"]; } if (!Convert.IsDBNull(data["bullet1"])) { _bullet1 = (string)data["bullet1"]; } if (!Convert.IsDBNull(data["bullet2"])) { _bullet2 = (string)data["bullet2"]; } if (!Convert.IsDBNull(data["bullet3"])) { _bullet3 = (string)data["bullet3"]; } if (!Convert.IsDBNull(data["bullet4"])) { _bullet4 = (string)data["bullet4"]; } if (!Convert.IsDBNull(data["bullet5"])) { _bullet5 = (string)data["bullet5"]; } if (!Convert.IsDBNull(data["bullet6"])) { _bullet6 = (string)data["bullet6"]; } if (!Convert.IsDBNull(data["bullet7"])) { _bullet7 = (string)data["bullet7"]; } if (!Convert.IsDBNull(data["bullet8"])) { _bullet8 = (string)data["bullet8"]; } if (!Convert.IsDBNull(data["custom_field1"])) { _custom_field1 = (string)data["custom_field1"]; } if (!Convert.IsDBNull(data["custom_field2"])) { _custom_field2 = (string)data["custom_field2"]; } if (!Convert.IsDBNull(data["custom_field3"])) { _custom_field3 = (string)data["custom_field3"]; } if (!Convert.IsDBNull(data["custom_field4"])) { _custom_field4 = (string)data["custom_field4"]; } if (!Convert.IsDBNull(data["custom_field5"])) { _custom_field5 = (string)data["custom_field5"]; } if (!Convert.IsDBNull(data["custom_field6"])) { _custom_field6 = (string)data["custom_field6"]; } if (!Convert.IsDBNull(data["custom_field7"])) { _custom_field7 = (string)data["custom_field7"]; } if (!Convert.IsDBNull(data["custom_field8"])) { _custom_field8 = (string)data["custom_field8"]; } if (!Convert.IsDBNull(data["custom_field9"])) { _custom_field9 = (string)data["custom_field9"]; } if (!Convert.IsDBNull(data["custom_field10"])) { _custom_field10 = (string)data["custom_field10"]; } if (!Convert.IsDBNull(data["custom_field_value1"])) { _custom_field_value1 = (string)data["custom_field_value1"]; } if (!Convert.IsDBNull(data["custom_field_value2"])) { _custom_field_value2 = (string)data["custom_field_value2"]; } if (!Convert.IsDBNull(data["custom_field_value3"])) { _custom_field_value3 = (string)data["custom_field_value3"]; } if (!Convert.IsDBNull(data["custom_field_value4"])) { _custom_field_value4 = (string)data["custom_field_value4"]; } if (!Convert.IsDBNull(data["custom_field_value5"])) { _custom_field_value5 = (string)data["custom_field_value5"]; } if (!Convert.IsDBNull(data["custom_field_value6"])) { _custom_field_value6 = (string)data["custom_field_value6"]; } if (!Convert.IsDBNull(data["custom_field_value7"])) { _custom_field_value7 = (string)data["custom_field_value7"]; } if (!Convert.IsDBNull(data["custom_field_value8"])) { _custom_field_value8 = (string)data["custom_field_value8"]; } if (!Convert.IsDBNull(data["custom_field_value9"])) { _custom_field_value9 = (string)data["custom_field_value9"]; } if (!Convert.IsDBNull(data["custom_field_value10"])) { _custom_field_value10 = (string)data["custom_field_value10"]; } if (!Convert.IsDBNull(data["mls_link"])) { _mls_link = (string)data["mls_link"]; } if (!Convert.IsDBNull(data["virtualtour_link"])) { _virtualtour_link = (string)data["virtualtour_link"]; } if (!Convert.IsDBNull(data["map_link"])) { _map_link = (string)data["map_link"]; } if (!Convert.IsDBNull(data["use_mls_logo"])) { _use_mls_logo = (bool)data["use_mls_logo"]; } if (!Convert.IsDBNull(data["use_housing_logo"])) { _use_housing_logo = (bool)data["use_housing_logo"]; } if (!Convert.IsDBNull(data["markup"])) { _markup = (string)data["markup"]; } if (!Convert.IsDBNull(data["flyer"])) { _flyer = (string)data["flyer"]; } if (!Convert.IsDBNull(data["price_range_min"])) { _price_range_min = (string)data["price_range_min"]; } if (!Convert.IsDBNull(data["price_range_max"])) { _price_range_max = (string)data["price_range_max"]; } if (!Convert.IsDBNull(data["property_type"])) { _property_type = (string)data["property_type"]; } if (!Convert.IsDBNull(data["sqft_range_min"])) { _sqft_range_min = (string)data["sqft_range_min"]; } if (!Convert.IsDBNull(data["sqft_range_max"])) { _sqft_range_max = (string)data["sqft_range_max"]; } if (!Convert.IsDBNull(data["location"])) { _location = (string)data["location"]; } if (!Convert.IsDBNull(data["more_info"])) { _more_info = (string)data["more_info"]; } if (!Convert.IsDBNull(data["buyer_message"])) { _buyer_message = (string)data["buyer_message"]; } if (!Convert.IsDBNull(data["photo1"])) { _photo1 = (string)data["photo1"]; } if (!Convert.IsDBNull(data["photo2"])) { _photo2 = (string)data["photo2"]; } if (!Convert.IsDBNull(data["photo3"])) { _photo3 = (string)data["photo3"]; } if (!Convert.IsDBNull(data["photo4"])) { _photo4 = (string)data["photo4"]; } if (!Convert.IsDBNull(data["photo5"])) { _photo5 = (string)data["photo5"]; } if (!Convert.IsDBNull(data["photo6"])) { _photo6 = (string)data["photo6"]; } if (!Convert.IsDBNull(data["photo7"])) { _photo7 = (string)data["photo7"]; } if (!Convert.IsDBNull(data["photo8"])) { _photo8 = (string)data["photo8"]; } if (!Convert.IsDBNull(data["photo9"])) { _photo9 = (string)data["photo9"]; } if (!Convert.IsDBNull(data["photo10"])) { _photo10 = (string)data["photo10"]; } if (!Convert.IsDBNull(data["field1"])) { _field1 = (string)data["field1"]; } if (!Convert.IsDBNull(data["field2"])) { _field2 = (string)data["field2"]; } if (!Convert.IsDBNull(data["field3"])) { _field3 = (string)data["field3"]; } if (!Convert.IsDBNull(data["field4"])) { _field4 = (string)data["field4"]; } if (!Convert.IsDBNull(data["field5"])) { _field5 = (string)data["field5"]; } if (!Convert.IsDBNull(data["created_on"])) { _created_on = (DateTime)data["created_on"]; } if (!Convert.IsDBNull(data["updated_on"])) { _updated_on = (DateTime)data["updated_on"]; } if (!Convert.IsDBNull(data["sent_on"])) { _sent_on = (DateTime)data["sent_on"]; } //============New Fields======================================================================== if (!Convert.IsDBNull(data["LastPageNo"])) { _LastPageNo = (int)data["LastPageNo"]; } if (!Convert.IsDBNull(data["Bedrooms"])) { _Bedrooms = (string)data["Bedrooms"]; } if (!Convert.IsDBNull(data["FullBaths"])) { _FullBaths = (string)data["FullBaths"]; } if (!Convert.IsDBNull(data["HalfBaths"])) { _HalfBaths = (string)data["HalfBaths"]; } if (!Convert.IsDBNull(data["Parking"])) { _Parking = (string)data["Parking"]; } if (!Convert.IsDBNull(data["SqFoots"])) { _SqFoots = (string)data["SqFoots"]; } if (!Convert.IsDBNull(data["YearBuilt"])) { _YearBuilt = (string)data["YearBuilt"]; } if (!Convert.IsDBNull(data["Floors"])) { _Floors = (string)data["Floors"]; } if (!Convert.IsDBNull(data["LotSize"])) { _LotSize = (string)data["LotSize"]; } if (!Convert.IsDBNull(data["Subdivision"])) { _Subdivision = (string)data["Subdivision"]; } if (!Convert.IsDBNull(data["HOA"])) { _HOA = (string)data["HOA"]; } if (!Convert.IsDBNull(data["PropertyFeatures"])) { _PropertyFeatures = (string)data["PropertyFeatures"]; } if (!Convert.IsDBNull(data["PropertyFeaturesValues"])) { _PropertyFeaturesValues = (string)data["PropertyFeaturesValues"]; } if (!Convert.IsDBNull(data["OtherPropertyFeatures"])) { _OtherPropertyFeatures = (string)data["OtherPropertyFeatures"]; } if (!Convert.IsDBNull(data["Discount"])) { _Discount = (decimal)data["Discount"]; } if (!Convert.IsDBNull(data["fk_PropertyCategory"])) { _PropertyCategory = (int)data["fk_PropertyCategory"]; } if (!Convert.IsDBNull(data["fk_PropertyType"])) { _PropertyType = (int)data["fk_PropertyType"]; } if (!Convert.IsDBNull(data["IsSyndicat"])) { _IsSyndicat = (bool)data["IsSyndicat"]; } if (!Convert.IsDBNull(data["AptSuiteBldg"])) { _AptSuiteBldg = (String)data["AptSuiteBldg"]; } if (!Convert.IsDBNull(data["OpenHouses"])) { _OpenHouses = (String)data["OpenHouses"]; } //=============================================================================================== } }
/// -----------------------------------------------------------------------------/// /// <summary> ///<para>Update current order informaiton</para> /// </summary> /// <remarks> /// </remarks> /// <history> /// </history> /// -----------------------------------------------------------------------------/// protected void Update() { OrdersBLL orderBll = new OrdersBLL(); bool success = orderBll.Update(this); }
/// -----------------------------------------------------------------------------/// /// <summary> ///<para>Inserts new order row</para> /// </summary> /// <remarks> /// </remarks> /// <history> /// </history> /// -----------------------------------------------------------------------------/// protected void Insert() { OrdersBLL orderBll = new OrdersBLL(); this.order_id = orderBll.Insert(this); }