Total Posts: 73 Karma: 531 Joined: 4/17/2010 Location: Egypt Using SSMS, insert Nop_LocaleStringResource (LanguageID,ResourceName,ResourceValue) values (7,'Keem.OrderProgress.Cart','Select') Open OrderProgress in Source View <%@ Control Language="C#" AutoEventWireup="true" Inherits="NopSolutions.NopCommerce.Web.Modules.OrderProgressControl" CodeBehind="OrderProgress.ascx.cs" %> <div class="order-progress"> <ul> <li> <asp:HyperLink runat="server" ID="hlCart" Text="<% $NopResources:OrderProgress.Cart %>"> </asp:HyperLink></li> <li> <asp:HyperLink runat="server" ID="hlAddress" Text="<% $NopResources:OrderProgress.Address %>"> </asp:HyperLink></li> <%if(!SettingManager.GetSettingValueBoolean("Keem.ShoppingCart.Hide")){%> <li> <asp:HyperLink runat="server" ID="hlShipping" Text="<% $NopResources:OrderProgress.Shipping %>"> </asp:HyperLink></li> <%} %> <li> <asp:HyperLink runat="server" ID="hlPayment" Text="<% $NopResources:OrderProgress.Payment %>"> </asp:HyperLink></li> <li> <asp:HyperLink runat="server" ID="hlConfirm" Text="<% $NopResources:OrderProgress.Confirm %>"> </asp:HyperLink></li> <li> <asp:HyperLink runat="server" ID="hlComplete" Text="<% $NopResources:OrderProgress.Complete %>"> </asp:HyperLink></li> </ul> </div> Open OrderProgress in Code view //------------------------------------------------------------------------------ // The contents of this file are subject to the nopCommerce Public License Version 1.0 ("License"); you may not use this file except in compliance with the License. // You may obtain a copy of the License at https://www.nopcommerce.com/License.aspx. // // Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. // See the License for the specific language governing rights and limitations under the License. // // The Original Code is nopCommerce. // The Initial Developer of the Original Code is NopSolutions. // All Rights Reserved. // // Contributor(s): _______. //------------------------------------------------------------------------------ using System; using System.Collections; using System.ComponentModel; using System.Configuration; using System.Data; using System.Text; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using NopSolutions.NopCommerce.BusinessLogic; using NopSolutions.NopCommerce.BusinessLogic.SEO; using NopSolutions.NopCommerce.Common.Utils; using NopSolutions.NopCommerce.BusinessLogic.Configuration.Settings;//KEEM using NopSolutions.NopCommerce.BusinessLogic.Localization; namespace NopSolutions.NopCommerce.Web.Modules { public partial class OrderProgressControl : BaseNopUserControl { protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { //KEEM if (SettingManager.GetSettingValueBoolean("Keem.ShoppingCart.Hide")) { //intializing hlCart.Text = GetLocaleResourceString("Keem.OrderProgress.Cart"); } //END KEEM SetStatus(); SetLinks(); } } private void SetStatus() { hlCart.CssClass = GetStatusCss("Cart"); hlAddress.CssClass = GetStatusCss("Address"); hlShipping.CssClass = GetStatusCss("Shipping"); hlPayment.CssClass = GetStatusCss("Payment"); hlConfirm.CssClass = GetStatusCss("Confirm"); hlComplete.CssClass = GetStatusCss("Complete"); } private void SetLinks() { switch (this.OrderProgressStep.ToLowerInvariant()) { case "cart": { hlCart.NavigateUrl = SEOHelper.GetShoppingCartUrl(); hlAddress.NavigateUrl = string.Empty; hlShipping.NavigateUrl = string.Empty; hlPayment.NavigateUrl = string.Empty; hlConfirm.NavigateUrl = string.Empty; hlComplete.NavigateUrl = string.Empty; //KEEM if (SettingManager.GetSettingValueBoolean("Keem.ShoppingCart.Hide")) { hlCart.NavigateUrl = CommonHelper.GetStoreLocation() + "select.aspx"; } //END KEEM } break; case "address": { hlCart.NavigateUrl = SEOHelper.GetShoppingCartUrl(); hlAddress.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutshippingaddress.aspx"; hlShipping.NavigateUrl = string.Empty; hlPayment.NavigateUrl = string.Empty; hlConfirm.NavigateUrl = string.Empty; hlComplete.NavigateUrl = string.Empty; //KEEM if (SettingManager.GetSettingValueBoolean("Keem.ShoppingCart.Hide")) { hlCart.NavigateUrl = CommonHelper.GetStoreLocation() + "select.aspx"; hlAddress.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutbillingaddress.aspx"; } //END KEEM } break; case "shipping": { hlCart.NavigateUrl = SEOHelper.GetShoppingCartUrl(); hlAddress.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutshippingaddress.aspx"; hlShipping.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutshippingmethod.aspx"; hlPayment.NavigateUrl = string.Empty; hlConfirm.NavigateUrl = string.Empty; hlComplete.NavigateUrl = string.Empty; } break; case "payment": { hlCart.NavigateUrl = SEOHelper.GetShoppingCartUrl(); hlAddress.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutshippingaddress.aspx"; hlShipping.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutshippingmethod.aspx"; hlPayment.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutpaymentmethod.aspx"; hlConfirm.NavigateUrl = string.Empty; hlComplete.NavigateUrl = string.Empty; //KEEM if (SettingManager.GetSettingValueBoolean("Keem.ShoppingCart.Hide")) { hlCart.NavigateUrl = CommonHelper.GetStoreLocation() + "select.aspx"; hlAddress.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutbillingaddress.aspx"; } //END KEEM } break; case "confirm": { hlCart.NavigateUrl = SEOHelper.GetShoppingCartUrl(); hlAddress.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutshippingaddress.aspx"; hlShipping.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutshippingmethod.aspx"; hlPayment.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutpaymentmethod.aspx"; hlConfirm.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutconfirm.aspx"; hlComplete.NavigateUrl = string.Empty; //KEEM if (SettingManager.GetSettingValueBoolean("Keem.ShoppingCart.Hide")) { hlCart.NavigateUrl = CommonHelper.GetStoreLocation() + "select.aspx"; hlAddress.NavigateUrl = CommonHelper.GetStoreLocation() + "checkoutbillingaddress.aspx"; } //END KEEM } break; case "complete": { hlCart.NavigateUrl = string.Empty; hlAddress.NavigateUrl = string.Empty; hlShipping.NavigateUrl = string.Empty; hlPayment.NavigateUrl = string.Empty; hlConfirm.NavigateUrl = string.Empty; hlComplete.NavigateUrl = string.Empty; } break; default: { hlCart.NavigateUrl = string.Empty; hlAddress.NavigateUrl = string.Empty; hlShipping.NavigateUrl = string.Empty; hlPayment.NavigateUrl = string.Empty; hlConfirm.NavigateUrl = string.Empty; hlComplete.NavigateUrl = string.Empty; } break; } } public string GetStatusCss(string step) { if (this.OrderProgressStep.ToLowerInvariant() == step.ToLowerInvariant()) return "active-step"; else return "inactive-step"; } public string OrderProgressStep { get { object obj2 = this.ViewState["OrderProgressStep"]; if (obj2 != null) return (string)obj2; else return string.Empty; } set { this.ViewState["OrderProgressStep"] = value; } } } }
Total Posts: 73 Karma: 531 Joined: 4/17/2010 Location: Egypt Open OrderSummary in source view <%@ Control Language="C#" AutoEventWireup="true" Inherits="NopSolutions.NopCommerce.Web.Modules.OrderSummaryControl" CodeBehind="OrderSummary.ascx.cs" %> <%@ Register TagPrefix="nopCommerce" TagName="GoogleCheckoutButton" Src="~/Modules/GoogleCheckoutButton.ascx" %> <%@ Register TagPrefix="nopCommerce" TagName="OrderTotals" Src="~/Modules/OrderTotals.ascx" %> <%@ Register TagPrefix="nopCommerce" TagName="CheckoutAttributes" Src="~/Modules/CheckoutAttributes.ascx" %> <%@ Register TagPrefix="nopCommerce" TagName="EstimateShipping" Src="~/Modules/EstimateShipping.ascx" %> <%@ Register TagPrefix="nopCommerce" TagName="ProductBox1" Src="~/Modules/ProductBox1.ascx" %> <asp:Panel class="order-summary-content" runat="server" ID="pnlEmptyCart"> <%if(!SettingManager.GetSettingValueBoolean("Keem.ShoppingCart.Hide")) { %> <%=GetLocaleResourceString("ShoppingCart.CartIsEmpty")%> <%} %> </asp:Panel> <asp:Panel class="order-summary-content" runat="server" ID="pnlCart"> <%if (this.IsShoppingCart) { %> <%if (SettingManager.GetSettingValueBoolean("Display.Checkout.DiscountCouponBox")) { %> <asp:Panel runat="server" ID="phCoupon" CssClass="coupon-box"> <b> <%=GetLocaleResourceString("ShoppingCart.DiscountCouponCode")%></b> <br /> <%=GetLocaleResourceString("ShoppingCart.DiscountCouponCode.Tooltip")%> <br /> <asp:TextBox ID="txtDiscountCouponCode" runat="server" Width="125px" /> <asp:Button runat="server" ID="btnApplyDiscountCouponCode" OnClick="btnApplyDiscountCouponCode_Click" Text="<% $NopResources:ShoppingCart.ApplyDiscountCouponCodeButton %>" CssClass="applycouponcodebutton" CausesValidation="false" /> <asp:Panel runat="server" ID="pnlDiscountWarnings" CssClass="warning-box" EnableViewState="false" Visible="false"> <br /> <asp:Label runat="server" ID="lblDiscountWarning" CssClass="warning-text" EnableViewState="false" Visible="false"></asp:Label> </asp:Panel> </asp:Panel> <%} %> <div class="clear"> </div> <%if (SettingManager.GetSettingValueBoolean("Display.Checkout.GiftCardBox")) { %> <asp:Panel runat="server" ID="phGiftCards" CssClass="coupon-box"> <b> <%=GetLocaleResourceString("ShoppingCart.GiftCards")%></b> <br /> <%=GetLocaleResourceString("ShoppingCart.GiftCards.Tooltip")%> <br /> <asp:TextBox ID="txtGiftCardCouponCode" runat="server" Width="125px" /> <asp:Button runat="server" ID="btnApplyGiftCardsCouponCode" OnClick="btnApplyGiftCardCouponCode_Click" Text="<% $NopResources:ShoppingCart.ApplyGiftCardCouponCodeButton %>" CssClass="applycouponcodebutton" CausesValidation="false" /> <asp:Panel runat="server" ID="pnlGiftCardWarnings" CssClass="warning-box" EnableViewState="false" Visible="false"> <br /> <asp:Label runat="server" ID="lblGiftCardWarning" CssClass="warning-text" EnableViewState="false" Visible="false"></asp:Label> </asp:Panel> </asp:Panel> <%} %> <div class="clear"> </div> <%} %> <asp:Panel runat="server" ID="pnlCommonWarnings" CssClass="warning-box" EnableViewState="false" Visible="false"> <asp:Label runat="server" ID="lblCommonWarning" CssClass="warning-text" EnableViewState="false" Visible="false"></asp:Label> </asp:Panel> <table class="cart"> <tbody> <tr class="cart-header-row"> <%if (IsShoppingCart) { %> <%if(!SettingManager.GetSettingValueBoolean("Keem.ShoppingCart.Hide")){%> <td width="10%"> <asp:CheckBox runat="server" ID="cbRemoveFromCart" /> </td><%} %> <%} %> <%if (SettingManager.GetSettingValueBoolean("Display.Products.ShowSKU")) {%> <td width="10%"> <%=GetLocaleResourceString("ShoppingCart.SKU")%> </td> <%} %> <%if (SettingManager.GetSettingValueBoolean("Display.ShowProductImagesOnShoppingCart")) {%> <td class="picture"> </td> <%} %> <td width="40%"> <%=GetLocaleResourceString("ShoppingCart.Product(s)")%> </td> <td width="20%"> <%=GetLocaleResourceString("ShoppingCart.UnitPrice")%> </td> <td width="10%"> <%=GetLocaleResourceString("ShoppingCart.Quantity")%> </td> <td width="20%" class="end"> <%=GetLocaleResourceString("ShoppingCart.ItemTotal")%> </td> </tr> <asp:Repeater ID="rptShoppingCart" runat="server"> <ItemTemplate> <tr class="cart-item-row"> <%if (IsShoppingCart) { %> <%if(!SettingManager.GetSettingValueBoolean("Keem.ShoppingCart.Hide")){%> <td width="10%"> <asp:CheckBox runat="server" ID="cbRemoveFromCart" /> </td><%} %> <%} %> <%if (SettingManager.GetSettingValueBoolean("Display.Products.ShowSKU")) {%> <td width="10%"> <%#Server.HtmlEncode(((ShoppingCartItem)Container.DataItem).ProductVariant.SKU)%> </td> <%} %> <%if (SettingManager.GetSettingValueBoolean("Display.ShowProductImagesOnShoppingCart")) {%> <td class="productpicture"> <asp:Image ID="iProductVariantPicture" runat="server" ImageUrl='<%#GetProductVariantImageUrl((ShoppingCartItem)Container.DataItem)%>' AlternateText="Product picture" /> </td> <%} %> <td width="40%" class="product"> <a href='<%#GetProductUrl((ShoppingCartItem)Container.DataItem)%>' title="View details"> <%#Server.HtmlEncode(GetProductVariantName((ShoppingCartItem)Container.DataItem))%></a> <%#GetAttributeDescription((ShoppingCartItem)Container.DataItem)%> <%#GetRecurringDescription((ShoppingCartItem)Container.DataItem)%> <asp:Panel runat="server" ID="pnlWarnings" CssClass="warning-box" EnableViewState="false" Visible="false"> <asp:Label runat="server" ID="lblWarning" CssClass="warning-text" EnableViewState="false" Visible="false"></asp:Label> </asp:Panel> </td> <td width="20%"> <%#GetShoppingCartItemUnitPriceString((ShoppingCartItem)Container.DataItem)%> </td> <td width="10%"> <%if (IsShoppingCart) { %> <%if (!SettingManager.GetSettingValueBoolean("Keem.ShoppingCart.Hide")) {%> <asp:TextBox ID="txtQuantity" size="4" runat="server" Text='<%# Eval("Quantity") %>' SkinID="ShoppingCartQuantityText"/> <%}%> <%else { %> <asp:Label ID="lblQuantityKeem" size="4" runat="server" Text='<%# Eval("Quantity") %>' SkinID="ShoppingCartQuantityText"/> <%} %> <%} %> </td> <td width="20%" class="end"> <%#GetShoppingCartItemSubTotalString((ShoppingCartItem)Container.DataItem)%> <asp:Label ID="lblShoppingCartItemId" runat="server" Visible="false" Text='<%# Eval("ShoppingCartItemId") %>' /> </td> </tr> </ItemTemplate> </asp:Repeater> </tbody> </table> <div class="clear"> </div> <div class="selected-checkout-attributes"> <%=GetCheckoutAttributeDescription()%> </div> <div class="clear"> </div> <div class="cart-footer"> <%if (this.IsShoppingCart) { %> <div class="clear"> </div> <nopCommerce:CheckoutAttributes ID="ctrlCheckoutAttributes" runat="server"></nopCommerce:CheckoutAttributes> <div class="clear"> </div> <nopCommerce:EstimateShipping ID="ctrlEstimateShipping" runat="server"></nopCommerce:EstimateShipping> <div class="clear"> </div> <div class="buttons"> <%if (SettingManager.GetSettingValueBoolean("Checkout.TermsOfServiceEnabled")) { %> <script language="javascript" type="text/javascript"> function accepttermsofservice(msg) { if (!document.getElementById('<%=cbTermsOfService.ClientID%>').checked) { alert(msg); return false; } else return true; } </script> <div class="terms-of-service"> <asp:CheckBox runat="server" ID="cbTermsOfService" /> <asp:Literal runat="server" ID="lTermsOfService" /> </div> <%} %> <div class="common-buttons"> <%if (!SettingManager.GetSettingValueBoolean("Keem.ShoppingCart.Hide")) {%> <asp:Button ID="btnUpdate" OnClick="btnUpdate_Click" runat="server" Text="<% $NopResources:ShoppingCart.UpdateCart %>" CssClass="updatecartbutton" /> <asp:Button ID="btnContinueShopping" OnClick="btnContinueShopping_Click" runat="server" Text="<% $NopResources:ShoppingCart.ContinueShopping %>" CssClass="continueshoppingbutton" /> <%}%> <asp:Button ID="btnCheckout" OnClick="btnCheckout_Click" runat="server" Text="<% $NopResources:ShoppingCart.Checkout %>" CssClass="checkoutbutton" /> </div> <div class="addon-buttons"> <nopCommerce:GoogleCheckoutButton runat="server" ID="btnGoogleCheckoutButton"></nopCommerce:GoogleCheckoutButton> </div> </div> <div class="clear"> </div> <%} %> <nopCommerce:OrderTotals runat="server" ID="ctrlOrderTotals" /> <%if (this.IsShoppingCart) { %> <div class="clear"> </div> <div class="product-grid"> <asp:DataList ID="dlCrossSells" runat="server" RepeatColumns="2" RepeatDirection="Horizontal" RepeatLayout="Table" ItemStyle-CssClass="item-box"> <HeaderTemplate> <span class="crosssells-title"><%=GetLocaleResourceString("ShoppingCart.CrossSells")%></span> </HeaderTemplate> <ItemTemplate> <nopCommerce:ProductBox1 ID="ctrlProductBox" Product='<%# Container.DataItem %>' runat="server" RedirectCartAfterAddingProduct="True" /> </ItemTemplate> </asp:DataList> </div> <div class="clear"> </div> <%} %> </div> </asp:Panel> for now ignore select.aspx, Now, testing your code , run , shipping is not visible including (shipping:not required)!
Total Posts: 73 Karma: 531 Joined: 4/17/2010 Location: Egypt open Header.ascx in source view <%@ Control Language="C#" AutoEventWireup="true" Inherits="NopSolutions.NopCommerce.Web.Modules.HeaderControl" CodeBehind="Header.ascx.cs" %> <%@ Register TagPrefix="nopCommerce" TagName="CurrencySelector" Src="~/Modules/CurrencySelector.ascx" %> <%@ Register TagPrefix="nopCommerce" TagName="LanguageSelector" Src="~/Modules/LanguageSelector.ascx" %> <%@ Register TagPrefix="nopCommerce" TagName="TaxDisplayTypeSelector" Src="~/Modules/TaxDisplayTypeSelector.ascx" %> <div class="header"> <div class="header-logo"> <a href="<%=CommonHelper.GetStoreLocation()%>" class="logo"> </a> </div> <div class="header-links-wrapper"> <div class="header-links"> <ul> <asp:LoginView ID="topLoginView" runat="server"> <AnonymousTemplate> <li><a href="<%=Page.ResolveUrl("~/register.aspx")%>" class="ico-register"> <%=GetLocaleResourceString("Account.Register")%></a></li> <li><a href="<%=Page.ResolveUrl("~/login.aspx")%>" class="ico-login"> <%=GetLocaleResourceString("Account.Login")%></a></li> </AnonymousTemplate> <LoggedInTemplate> <li> <a href="<%= SEOHelper.GetMyAccountUrl()%>" class="account"><%=Page.User.Identity.Name %></a> <% if (NopContext.Current.IsCurrentCustomerImpersonated) { %> <span class="impersonate">(<%=string.Format(GetLocaleResourceString("Account.ImpersonatedAs"), CustomerManager.UsernamesEnabled ? Server.HtmlEncode(NopContext.Current.User.Username) : Server.HtmlEncode(NopContext.Current.User.Email))%> - <asp:LinkButton runat="server" ID="lFinishImpersonate" Text="<% $NopResources:Account.ImpersonatedAs.Finish %>" ToolTip="<% $NopResources:Account.ImpersonatedAs.Finish.Tooltip %>" OnClick="lFinishImpersonate_Click" CssClass="finish-impersonation"></asp:LinkButton>)</span> <%} %> </li> <li><a href="<%=Page.ResolveUrl("~/logout.aspx")%>" class="ico-logout"> <%=GetLocaleResourceString("Account.Logout")%></a> </li> <% if (ForumManager.AllowPrivateMessages) { %> <li><a href="<%=Page.ResolveUrl("~/privatemessages.aspx")%>" class="ico-inbox"> <%=GetLocaleResourceString("PrivateMessages.Inbox")%></a> <asp:Literal runat="server" ID="lUnreadPrivateMessages" /> </li> <%} %> </LoggedInTemplate> </asp:LoginView> <%if (!SettingManager.GetSettingValueBoolean("Keem.ShoppingCart.Hide")) {%> <li><a href="<%= SEOHelper.GetShoppingCartUrl()%>" class="ico-cart"> <%=GetLocaleResourceString("Account.ShoppingCart")%> </a><a href="<%= SEOHelper.GetShoppingCartUrl()%>">(<%=ShoppingCartManager.GetCurrentShoppingCart(ShoppingCartTypeEnum.ShoppingCart).Count%>)</a> </li> <% if (SettingManager.GetSettingValueBoolean("Common.EnableWishlist")) { %> <li><a href="<%= SEOHelper.GetWishlistUrl()%>" class="ico-wishlist"> <%=GetLocaleResourceString("Wishlist.Wishlist")%></a> <a href="<%= SEOHelper.GetWishlistUrl()%>"> (<%=ShoppingCartManager.GetCurrentShoppingCart(ShoppingCartTypeEnum.Wishlist).Count%>)</a> </li> <%} %> <%}%> <% if (NopContext.Current.User != null && NopContext.Current.User.IsAdmin) { %> <li><a href="<%=Page.ResolveUrl("~/administration/")%>" class="ico-admin"> <%=GetLocaleResourceString("Account.Administration")%></a> </li> <%} %> </ul> </div> </div> <div class="header-selectors-wrapper"> <div class="header-taxDisplayTypeSelector"> <nopCommerce:TaxDisplayTypeSelector runat="server" ID="ctrlTaxDisplayTypeSelector"> </nopCommerce:TaxDisplayTypeSelector> </div> <div class="header-currencyselector"> <nopCommerce:CurrencySelector runat="server" ID="ctrlCurrencySelector"></nopCommerce:CurrencySelector> </div> <div class="header-languageselector"> <nopCommerce:LanguageSelector runat="server" ID="ctrlLanguageSelector"></nopCommerce:LanguageSelector> </div> </div> </div>
Total Posts: 73 Karma: 531 Joined: 4/17/2010 Location: Egypt What is Select.aspx ?!!!!!!!!!! Now as I told you before,in the Travel Insustry,nothing is called shopping cart! so Will be using a copy of Shoppingcart.aspx as select.aspx ! just copy & past shoppingcart.aspx & renam it to Select.aspx!! (We'll be cheating!) Open source view & modify the header to be: <h1><%=GetLocaleResourceString("Keem.Account.ShoppingCart")%></h1> In code view modify the PAge_Load to be: protected void Page_Load(object sender, EventArgs e) { CommonHelper.SetResponseNoCache(Response); string title = GetLocaleResourceString("Keem.PageTitle.ShoppingCart"); SEOHelper.RenderTitle(this, title, true); } now,using SSMS , insert Nop_LocaleStringResource (LanguageID,ResourceName,ResourceValue) values (7,'Keem.Account.ShoppingCart','Select') Now,AS Keem.ShoppingCart.Hide=True,customer will be directed to Select.aspx (no shipping) else , original NC! Now,I think we handeled items 1- Hiding SC & 2-Hiding Shipping! I hope you like this code ,I hope anyone may find it helpful!! Soon I shall post 3rd item i.e. Considering Arival & Departure times! see you..
Total Posts: 73 Karma: 531 Joined: 4/17/2010 Location: Egypt Hi Andria, Please tell me what do you think about this design ? good ,not good .. Appreciating your comments!
Total Posts: 73 Karma: 531 Joined: 4/17/2010 Location: Egypt Hellow everybody,waiting for your comments!
Total Posts: 73 Karma: 531 Joined: 4/17/2010 Location: Egypt Hi, Dealing with the hotel as Nop_product entity & dealing with the room as Nop_productvariant lead me to add two coulm to the Nop_productvariant Arrival & Departure (type of DateTime). Latter aftyer my develpoing is done,I realized a big mistake in my core DB design (of adding such 2 colms) as I was able to book a room in the range of my Arrival & departure(concerning all my effort for the SearchBox,Admin area ..etc) but I wrongly forgot about my room balance to be booked as Units in Pv table! So,I invite you all to concern this link to a Hoteel booking DB digram http://www.databaseanswers.org/data_models/hotels/hotel_reservations_popkin.htm Andria,I think that I will re-consider own tables first to perfectly adjust the DB core desgin ,then re-conceder the user interface latter. Thanks!
Total Posts: 380 Karma: 5106 Joined: 12/11/2008 Location: Singapore Interesting, I will look into this feature too