/// <summary> /// Display the Order State name for a Order state /// </summary> /// <param name="FieldValue"></param> /// <returns></returns> protected string DisplayOrderStatus(object FieldValue) { ZNode.Libraries.Admin.OrderAdmin _OrderStateAdmin = new OrderAdmin(); OrderState _OrderState = _OrderStateAdmin.GetByOrderStateID(int.Parse(FieldValue.ToString())); return _OrderState.OrderStateName.ToString(); }
/// <summary> /// /// </summary> /// <param name="ds"></param> /// <returns></returns> private DataSet FormatReportDataSet(DataSet ds) { //This will copied the structure and data from the Original dataset DataSet tempDataSet = ds.Copy(); # region Local Variables OrderAdmin orderAdmin = new OrderAdmin(); ShippingAdmin shippingAdmin = new ShippingAdmin(); StoreSettingsAdmin storeAdmin = new StoreSettingsAdmin(); #endregion //Initialize new columns for OrderStatus,ShippingType,Payment Type //Add column to this temporary dataset DataColumn columnOrderStatus = new DataColumn("OrderStatus"); tempDataSet.Tables[0].Columns.Add(columnOrderStatus); //Add ShippingType column DataColumn columnShippingType = new DataColumn("ShippingTypeName"); tempDataSet.Tables[0].Columns.Add(columnShippingType); //Add Paymenttype column DataColumn columnPaymentType = new DataColumn("PaymentTypeName"); tempDataSet.Tables[0].Columns.Add(columnPaymentType); //Loop through the Orders in the dataset foreach (DataRow dr in tempDataSet.Tables[0].Rows) { //Get Order Status int OrderStateId = int.Parse(dr["OrderStateId"].ToString()); OrderState entity = orderAdmin.GetByOrderStateID(OrderStateId); int shippingId = int.Parse(dr["ShippingId"].ToString()); Shipping shippingEntity = shippingAdmin.GetShippingOptionById(shippingId); int paymentTypeId = 0; if(dr["PaymentTypeId"].ToString().Length > 0) //If PaymentTypeId value length is greater than Zero paymentTypeId = int.Parse(dr["PaymentTypeId"].ToString()); PaymentType paymentType = storeAdmin.GetPaymentTypeById(paymentTypeId); if (entity != null) dr["OrderStatus"] = entity.OrderStateName; if (shippingEntity != null) dr["ShippingTypeName"] = (shippingAdmin.GetShippingTypeName(shippingEntity.ShippingTypeID)); if (paymentType != null) dr["PaymentTypeName"] = paymentType.Name; } //Return dataset return tempDataSet; }