コード例 #1
0
ファイル: lnDoorxOrder.cs プロジェクト: sotillo257/VenusDoor
        public bool UpdateDoorsxOrder(Order Order)
        {
            try
            {
                lnDecimals        deci           = new lnDecimals();
                List <Decimals>   listDeci       = deci.GetAllDecimals();
                lnDoorsPrices     dp             = new lnDoorsPrices();
                List <DoorxOrder> listDoorOrders = null;
                if (Order.TEMP == true)
                {
                    listDoorOrders = GetAllTEMPdxoXdxu(Order.DoorxUser.Id);
                }
                else
                {
                    listDoorOrders = GetAllDoorxOrderByDoorxUser(Order.DoorxUser.Id);
                }
                lnDoorsxUser DU = new lnDoorsxUser();
                Order.SubTotal = 0;
                Order.Quantity = 0;
                lnOrder _LNOrder = new lnOrder();
                lnUser  _LNUser  = new lnUser();
                User    u        = new User();
                u = _LNUser.GetUserById(Order.User.Id);
                DoorsxUser Dxu = null;
                if (Order.TEMP == true)
                {
                    Dxu = DU.GetTEMPdxuById(Order.DoorxUser.Id);
                }
                else
                {
                    Dxu = DU.GetDoorsxUserById(Order.DoorxUser.Id);
                }

                foreach (DoorxOrder item in listDoorOrders)
                {
                    int Rail = 1;
                    if (Order.DoorxUser.TopRail.Id == 3 || Order.DoorxUser.BottomRail.Id == 3 || Order.DoorxUser.DoorStyle.Id == 1009 || Order.DoorxUser.DoorStyle.Id == 1008)
                    {
                        Rail = 2;
                    }
                    int panel = Order.DoorxUser.Panel.Id;
                    if (Order.DoorxUser.DoorStyle.Id == 1002)
                    {
                        panel = 5;
                    }
                    //else if (Order.DoorxUser.DoorStyle.Id == 1003)
                    //{
                    //    Order.DoorxUser.Panel.Id = 2;
                    //}
                    //if (Order.DoorxUser.Panel.Id == 2)
                    //{
                    //    panel = Order.DoorxUser.Panel.Id;
                    //}
                    if (Order.DoorxUser.DoorStyle.Id == 1010)
                    {
                        panel = 2;
                    }
                    //else
                    //{
                    //    if (Order.DoorxUser.Panel.Id == 3)
                    //    {
                    //        Order.DoorxUser.Panel.Id = 5;
                    //    }
                    //}
                    item.User = u;
                    DoorsPrices DoorPrice = dp.GetDoorsPricesById(0, panel, Order.DoorxUser.Material.Id, Rail);
                    decimal     deciW     = listDeci.Where(x => x.Id == item.DecimalsWidth.Id).FirstOrDefault().Value;
                    decimal     deciH     = listDeci.Where(x => x.Id == item.DecimalsHeight.Id).FirstOrDefault().Value;
                    decimal     Width     = item.Width + deciW;
                    decimal     Height    = item.Height + deciH;
                    decimal     result    = (((((Width * Height) / 12m) / 12m) - 1.5m) * DoorPrice.AdditionalSFPrice) + DoorPrice.BasePrice;
                    if ((Order.DoorxUser.DoorStyle.Id == 1010))
                    {
                        result = result / 100m * 80m;
                    }
                    if (result < DoorPrice.BasePrice)
                    {
                        result = (DoorPrice.BasePrice * 2);
                        if (item.User.Descuento > 0)
                        {
                            decimal des = decimal.Parse(item.User.Descuento.ToString()) / 100m;
                            item.TotalDescuento = result * des;
                            result = result - (des * result);
                        }
                        if (item.Descuento > 0)
                        {
                            decimal des = decimal.Parse(item.Descuento.ToString()) / 100m;
                            item.TotalDescuento = result * des;
                            result = result - (des * result);
                        }
                        else
                        {
                            if (Order.Descuento > 0)
                            {
                                decimal des = decimal.Parse(Order.Descuento.ToString()) / 100m;
                                item.Descuento      = Order.Descuento;
                                item.TotalDescuento = result * des;
                                result = result - (des * result);
                            }
                        }
                        item.ItemCost = result;
                        item.SubTotal = result * item.Quantity;
                    }
                    else
                    {
                        result = result * 2;
                        if (item.User.Descuento > 0)
                        {
                            decimal des = decimal.Parse(item.User.Descuento.ToString()) / 100m;
                            item.TotalDescuento = result * des;
                            result = result - (des * result);
                        }
                        if (item.Descuento > 0)
                        {
                            decimal des = decimal.Parse(item.Descuento.ToString()) / 100m;
                            item.TotalDescuento = result * des;
                            result = result - (des * result);
                        }
                        else
                        {
                            if (Order.Descuento > 0)
                            {
                                decimal des = decimal.Parse(Order.Descuento.ToString()) / 100m;
                                item.Descuento      = Order.Descuento;
                                item.TotalDescuento = result * des;
                                result = result - (des * result);
                            }
                        }

                        item.ItemCost = result;
                        item.SubTotal = result * item.Quantity;
                    }

                    if (Dxu.isDrill == true)
                    {
                        if (Order.DoorxUser.isDrill == false)
                        {
                            item.HingeDirection.Id = 1;
                        }
                    }
                    else
                    {
                        item.HingeDirection.Id = 1;
                    }
                    item.DoorxUser        = Order.DoorxUser;
                    item.ModificationDate = DateTime.Now;
                    item.ModificationUser = item.User.Id;
                    item.ProfilePicture   = DU.BuscarProfilePicture(Order.DoorxUser.OutsideEdgeProfile.Id, Order.DoorxUser.InsideEdgeProfile.Id, Order.DoorxUser.Panel.Id);
                    item.Picture          = DU.BuscarDoorPicture(item);
                    if (Order.TEMP == true)
                    {
                        item.TEMP = true;
                    }
                    int retorno = _AD.UpdateDoorsxOrder(item);
                    Order.SubTotal = Order.SubTotal + item.SubTotal;
                    Order.Tax      = 0.0825m * Order.SubTotal;
                    Order.Total    = Order.Tax + Order.SubTotal;
                    Order.Quantity = Order.Quantity + item.Quantity;
                    _LNOrder.UpdateOrder(Order);
                }

                return(true);
            }
            catch (Exception ex)
            {
                throw;
            }
        }
コード例 #2
0
ファイル: lnDoorxOrder.cs プロジェクト: sotillo257/VenusDoor
        public bool UpdateDoorxOrder(int pIdOrder, DoorxOrder pDoorsOrder, int pIdUser)
        {
            try
            {
                lnDecimals      deci     = new lnDecimals();
                List <Decimals> listDeci = deci.GetAllDecimals();
                lnDoorsPrices   dp       = new lnDoorsPrices();
                lnDoorsxUser    DU       = new lnDoorsxUser();
                lnOrder         _LNOrder = new lnOrder();
                Order           Order    = null;
                if (pDoorsOrder.TEMP == true)
                {
                    Order = _LNOrder.GetTEMPorderById(pIdOrder);
                }
                else
                {
                    Order = _LNOrder.GetOrderById(pIdOrder);
                }

                lnUser _LNUser = new lnUser();
                Order.User = _LNUser.GetUserById(Order.User.Id);
                if (pDoorsOrder.TEMP == true)
                {
                    Order.DoorxUser = DU.GetAllTEMPdxu().Where(x => x.Order.Id == Order.Id).FirstOrDefault();
                }
                else
                {
                    Order.DoorxUser = DU.GetAllDoorsxUser().Where(x => x.Order.Id == Order.Id).FirstOrDefault();
                }
                Order.SubTotal = 0;
                Order.Quantity = 0;
                int Rail = 1;
                if (Order.DoorxUser.TopRail.Id == 3 || Order.DoorxUser.BottomRail.Id == 3 || Order.DoorxUser.DoorStyle.Id == 1009 || Order.DoorxUser.DoorStyle.Id == 1008)
                {
                    Rail = 2;
                }
                int panel = Order.DoorxUser.Panel.Id;
                if (Order.DoorxUser.DoorStyle.Id == 1002)
                {
                    Order.DoorxUser.Panel.Id = 5;
                }
                //else if (Order.DoorxUser.DoorStyle.Id == 1003)
                //{
                //    Order.DoorxUser.Panel.Id = 2;
                //}
                //if (Order.DoorxUser.Panel.Id == 2)
                //{
                //    panel = Order.DoorxUser.Panel.Id;
                //}
                if (Order.DoorxUser.DoorStyle.Id == 1010)
                {
                    panel = 2;
                }
                //else
                //{
                //    if (Order.DoorxUser.Panel.Id == 3)
                //    {
                //    Order.DoorxUser.Panel.Id = 5;
                //    }
                //}
                DoorsPrices DoorPrice = dp.GetDoorsPricesById(0, panel, Order.DoorxUser.Material.Id, Rail);
                decimal     deciW     = listDeci.Where(x => x.Id == pDoorsOrder.DecimalsWidth.Id).FirstOrDefault().Value;
                decimal     deciH     = listDeci.Where(x => x.Id == pDoorsOrder.DecimalsHeight.Id).FirstOrDefault().Value;
                decimal     Width     = pDoorsOrder.Width + deciW;
                decimal     Height    = pDoorsOrder.Height + deciH;
                decimal     result    = (((((Width * Height) / 12m) / 12m) - 1.5m) * DoorPrice.AdditionalSFPrice) + DoorPrice.BasePrice;
                if ((Order.DoorxUser.DoorStyle.Id == 1010))
                {
                    result = result / 100m * 80m;
                }

                if (result < DoorPrice.BasePrice)
                {
                    result = DoorPrice.BasePrice * 2;
                    if (Order.User.Descuento > 0)
                    {
                        decimal des = decimal.Parse(Order.User.Descuento.ToString()) / 100m;
                        pDoorsOrder.TotalDescuento = result * des;
                        result = result - (des * result);
                    }
                    if (pDoorsOrder.Descuento > 0)
                    {
                        decimal des = decimal.Parse(pDoorsOrder.Descuento.ToString()) / 100m;
                        pDoorsOrder.TotalDescuento = result * des;
                        result = result - (des * result);
                    }
                    else
                    {
                        if (Order.Descuento > 0)
                        {
                            decimal des = decimal.Parse(Order.Descuento.ToString()) / 100m;
                            pDoorsOrder.Descuento      = Order.Descuento;
                            pDoorsOrder.TotalDescuento = result * des;
                            result = result - (des * result);
                        }
                    }
                    pDoorsOrder.ItemCost = result;
                    pDoorsOrder.SubTotal = result * pDoorsOrder.Quantity;
                }
                else
                {
                    result = result * 2;
                    if (Order.User.Descuento > 0)
                    {
                        decimal des = decimal.Parse(Order.User.Descuento.ToString()) / 100m;
                        pDoorsOrder.TotalDescuento = result * des;
                        result = result - (des * result);
                    }
                    if (pDoorsOrder.Descuento > 0)
                    {
                        decimal des = decimal.Parse(pDoorsOrder.Descuento.ToString()) / 100m;
                        pDoorsOrder.TotalDescuento = result * des;
                        result = result - (des * result);
                    }
                    else
                    {
                        if (Order.Descuento > 0)
                        {
                            decimal des = decimal.Parse(Order.Descuento.ToString()) / 100m;
                            pDoorsOrder.Descuento      = Order.Descuento;
                            pDoorsOrder.TotalDescuento = result * des;
                            result = result - (des * result);
                        }
                    }
                    pDoorsOrder.ItemCost = result;
                    pDoorsOrder.SubTotal = result * pDoorsOrder.Quantity;
                }

                pDoorsOrder.DoorxUser        = Order.DoorxUser;
                pDoorsOrder.ModificationDate = DateTime.Now;
                pDoorsOrder.ModificationUser = pIdUser;
                pDoorsOrder.ProfilePicture   = DU.BuscarProfilePicture(Order.DoorxUser.OutsideEdgeProfile.Id, Order.DoorxUser.InsideEdgeProfile.Id, Order.DoorxUser.Panel.Id);
                pDoorsOrder.Picture          = DU.BuscarDoorPicture(pDoorsOrder);
                int retorno = _AD.UpdateDoorsxOrder(pDoorsOrder);

                decimal subTotal = _AD.GetTotalDoorxOrderByDoorxUser(Order.DoorxUser.Id);
                int     cantidad = _AD.GetAllDoorxOrderByDoorxUser(Order.DoorxUser.Id).Sum(x => x.Quantity);
                if (subTotal > 0)
                {
                    Order.SubTotal         = subTotal;
                    Order.Tax              = 0.0825m * Order.SubTotal;
                    Order.Total            = Order.Tax + Order.SubTotal;
                    Order.Quantity         = cantidad;
                    Order.ModificationDate = DateTime.Now;
                    Order.ModificationUser = pIdUser;
                    _LNOrder.UpdateOrder(Order);
                }


                return(true);
            }
            catch (Exception ex)
            {
                throw;
            }
        }
コード例 #3
0
ファイル: lnDoorxOrder.cs プロジェクト: sotillo257/VenusDoor
        public int InsertDoorsxOrder(DoorxOrder pDoorsxOrder)
        {
            try
            {
                lnDecimals      deci     = new lnDecimals();
                List <Decimals> listDeci = deci.GetAllDecimals();
                lnDoorsPrices   dp       = new lnDoorsPrices();
                lnDoorsxUser    DU       = new lnDoorsxUser();
                lnOrder         _LNOrder = new lnOrder();
                Order           item     = null;
                DoorsxUser      DoorUser = null;
                if (pDoorsxOrder.TEMP == true)
                {
                    DoorUser      = DU.GetTEMPdxuById(pDoorsxOrder.DoorxUser.Id);
                    DoorUser.TEMP = true;
                    item          = _LNOrder.GetTEMPorderById(DoorUser.Order.Id);
                    item.TEMP     = true;
                }
                else
                {
                    item     = _LNOrder.GetOrderByUser(pDoorsxOrder.User.Id).Where(x => x.Status.Id == 4).FirstOrDefault();
                    DoorUser = DU.GetAllDoorsxUser().Where(x => x.Order.Id == item.Id).FirstOrDefault();
                }
                pDoorsxOrder.DoorxUser = DoorUser;
                int Rail = 1;
                if (DoorUser.TopRail.Id == 3 || DoorUser.BottomRail.Id == 3 || DoorUser.DoorStyle.Id == 1009 || DoorUser.DoorStyle.Id == 1008)
                {
                    Rail = 2;
                }
                int panel = 5;
                if (DoorUser.Panel.Id == 2)
                {
                    panel = DoorUser.Panel.Id;
                }
                if (DoorUser.DoorStyle.Id == 1010)
                {
                    panel = 2;
                }
                lnUser _LNUser = new lnUser();
                User   u       = new User();
                u = _LNUser.GetUserById(pDoorsxOrder.User.Id);
                DoorsPrices DoorPrice = dp.GetDoorsPricesById(0, panel, DoorUser.Material.Id, Rail);
                decimal     deciW     = listDeci.Where(x => x.Id == pDoorsxOrder.DecimalsWidth.Id).FirstOrDefault().Value;
                decimal     deciH     = listDeci.Where(x => x.Id == pDoorsxOrder.DecimalsHeight.Id).FirstOrDefault().Value;
                decimal     Width     = pDoorsxOrder.Width + deciW;
                decimal     Height    = pDoorsxOrder.Height + deciH;
                decimal     a         = 1;
                decimal     b         = 1;
                decimal     aux       = 1;
                while (!(aux == deciW))
                {
                    aux = a / b;
                    if (aux < deciW)
                    {
                        a++;
                    }
                    else if (aux > deciW)
                    {
                        a--;
                        b++;
                    }
                }
                string fracc = a.ToString() + "/" + b.ToString();
                pDoorsxOrder.User = u;
                decimal result = (((((Width * Height) / 12m) / 12m) - 1.5m) * DoorPrice.AdditionalSFPrice) + DoorPrice.BasePrice;
                if ((DoorUser.DoorStyle.Id == 1010))
                {
                    result = result / 100m * 80m;
                }
                if (result < DoorPrice.BasePrice)
                {
                    result = DoorPrice.BasePrice * 2;
                    if (pDoorsxOrder.User.Descuento > 0)
                    {
                        decimal des = decimal.Parse(pDoorsxOrder.User.Descuento.ToString()) / 100m;
                        result = result - (des * result);
                    }
                    if (pDoorsxOrder.Descuento > 0)
                    {
                        decimal des = decimal.Parse(pDoorsxOrder.Descuento.ToString()) / 100m;
                        pDoorsxOrder.TotalDescuento = result * des;
                        result = result - (des * result);
                    }
                    pDoorsxOrder.ItemCost = result;
                    pDoorsxOrder.SubTotal = result * pDoorsxOrder.Quantity;
                }
                else
                {
                    result = result * 2;
                    if (pDoorsxOrder.User.Descuento > 0)
                    {
                        decimal des = decimal.Parse(pDoorsxOrder.User.Descuento.ToString()) / 100m;
                        pDoorsxOrder.TotalDescuento = result * des;
                        result = result - (des * result);
                    }
                    if (pDoorsxOrder.Descuento > 0)
                    {
                        decimal des = decimal.Parse(pDoorsxOrder.Descuento.ToString()) / 100m;
                        pDoorsxOrder.TotalDescuento = result * des;
                        result = result - (des * result);
                    }
                    pDoorsxOrder.ItemCost = result;
                    pDoorsxOrder.SubTotal = result * pDoorsxOrder.Quantity;
                }

                if (DoorUser.isDrill == false)
                {
                    pDoorsxOrder.HingeDirection.Id = 3;
                    pDoorsxOrder.HingePositions.Id = 2;
                }
                else
                {
                    pDoorsxOrder.HingeDirection.Id = pDoorsxOrder.HingeDirection.Id;
                    pDoorsxOrder.HingePositions.Id = 2;
                }
                pDoorsxOrder.CreationDate     = DateTime.Now;
                pDoorsxOrder.ModificationDate = DateTime.Now;
                pDoorsxOrder.CreatorUser      = pDoorsxOrder.User.Id;
                pDoorsxOrder.ModificationUser = pDoorsxOrder.User.Id;
                pDoorsxOrder.ProfilePicture   = DU.BuscarProfilePicture(DoorUser.OutsideEdgeProfile.Id, DoorUser.InsideEdgeProfile.Id, DoorUser.Panel.Id);
                pDoorsxOrder.Picture          = DU.BuscarDoorPicture(pDoorsxOrder);
                int retorno = _AD.InsertDoorsxOrder(pDoorsxOrder);
                item.SubTotal = item.SubTotal + pDoorsxOrder.SubTotal;
                item.Tax      = 0.0825m * item.SubTotal;
                item.Total    = item.Tax + item.SubTotal;
                item.Quantity = item.Quantity + pDoorsxOrder.Quantity;
                _LNOrder.UpdateOrder(item);
                return(retorno);
            }
            catch (Exception ex)
            {
                throw;
            }
        }