/// <summary> /// Bind data to the fields /// </summary> protected void BindData() { ShippingAdmin shipAdmin = new ShippingAdmin(); StoreSettingsAdmin settingsAdmin = new StoreSettingsAdmin(); if (ItemId > 0) { Shipping shippingOption = shipAdmin.GetShippingOptionById(ItemId); lblShippingType.Text = shipAdmin.GetShippingTypeName(shippingOption.ShippingTypeID); if (shippingOption.ProfileID.HasValue) lblProfileName.Text = shipAdmin.GetProfileNamee((int)shippingOption.ProfileID); else lblProfileName.Text = "All Profiles"; lblDescription.Text = shippingOption.Description; lblShippingCode.Text = shippingOption.ShippingCode; if (shippingOption.HandlingCharge > 0) { lblHandlingCharge.Text = shippingOption.HandlingCharge.ToString("N2"); } else { lblHandlingCharge.Text = "0.00"; } if (shippingOption.DestinationCountryCode != null) { if (shippingOption.DestinationCountryCode.Length > 0) { lblDestinationCountry.Text = shippingOption.DestinationCountryCode; } } else { lblDestinationCountry.Text = "All Countries"; } imgActive.Src = ZNodeHelper.GetCheckMark((bool)shippingOption.ActiveInd); lblDisplayOrder.Text = shippingOption.DisplayOrder.ToString(); if (shippingOption.ShippingTypeID == 1) { pnlShippingRuletypes.Visible = true; } } else { //nothing to do here } }
/// <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; }