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