예제 #1
0
 public UserOrderHistoryDetail(Entity.Order order)
 {
     this.OrderId       = order.OrderId;
     this.TimeSubmitted = order.TimeSubmitted;
     this.AmountPaid    = order.AmountPaid;
     this.StoreName     = order.Location.Name;
 }
        public int CreateOrder(Entity.Order order, string shoppingCartId)
        {
            decimal orderTotal = 0;

            var cartItems = GetCartItems(shoppingCartId);

            foreach (var item in cartItems)
            {
                var orderDetails = new OrderDetail
                {
                    Album     = item.Album,
                    Order     = order,
                    UnitPrice = item.Album.Price,
                    Quantity  = item.Count
                };

                new OrderDetailsManager().Save(orderDetails);

                orderTotal += (item.Count * item.Album.Price);
            }

            order.Total = orderTotal;

            new OrderManager().Save(order);

            EmptyCart(shoppingCartId);

            return(order.Id);
        }
예제 #3
0
        public int CreateOrder(Entity.Order order)
        {
            if (order.TaxRate == null)
            {
                order.TaxRate = order.DefaultTaxRate;
            }
            int idOrder = orderRepository.InsertWithIdReturn(order);

            return(idOrder);
        }
예제 #4
0
 public int Create(OrderView item)
 {
     Models.Entity.Order order = new Entity.Order()
     {
         id = item.id, email_order = item.email_order, address_order = item.address_order, phone_order = item.phone_order, id_customer = item.id_customer, order_date = item.order_date, total = item.total, status = item.status
     };
     database.Orders.Add(order);
     database.SaveChanges();
     return(order.id);
 }
예제 #5
0
        /// <summary>
        /// Adds a new item to the order list.
        /// </summary>
        /// <param name="order">The order to be added.</param>
        /// <param name="itemQuantity">The quantity of items in the order.</param>
        public void AddSummaryItem(Entity.Order order, int itemQuantity)
        {
            var summaryItem = new StoreOrderSummaryItem();

            summaryItem.ItemQuantity  = itemQuantity;
            summaryItem.Price         = order.AmountPaid;
            summaryItem.TimeSubmitted = order.TimeSubmitted;
            summaryItem.OrderId       = order.OrderId;

            this.Items.Add(summaryItem);
        }
예제 #6
0
        public void AddHistoryItem(Entity.Order order, int itemQuantity)
        {
            // TODO: handle cast error
            var historyItem = new UserOrderHistoryItem();

            historyItem.OrderId       = order.OrderId;
            historyItem.TimeSubmitted = order.TimeSubmitted;
            historyItem.AmountPaid    = order.AmountPaid;
            historyItem.ItemQuantity  = itemQuantity;

            this.orders.Add(historyItem);
        }
예제 #7
0
        public TOut MapTo <TOut>(Entity.Order value) where TOut : class, new()
        {
            // All of the mappings with `NotifyGenerator.Tests.Concept.Entity` as input,
            // which output should we choose?

            if (typeof(TOut) == typeof(NotifyGenerator.Tests.Concept.ViewModel.Order))
            {
                // Map this sucka!
                return(new TOut());
            }

            return(default);
예제 #8
0
        public bool CreateOrder(List <OrderDetail> details, Entity.Order order)
        {
            db.Orders.Add(order);
            db.SaveChanges();
            int orderId = order.OrderId;

            if (orderId > 0)
            {
                foreach (var item in details)
                {
                    item.OrderId = orderId;
                    db.OrderDetails.Add(item);
                }
                var isOk = db.SaveChanges();
                if (isOk > 0)
                {
                    return(true);
                }
            }
            return(false);
        }
예제 #9
0
        /// <summary>
        /// Retrieves the customer's currently open order for a location.
        /// <remarks>
        /// If the customer has no open order for the location, a new one will be
        /// created, so this method will always return an order object.
        /// </remarks>
        /// </summary>
        /// <param name="user">User to get order from.</param>
        /// <param name="location">Location to check.</param>
        /// <returns>Order for the location.</returns>
        public async Task <Order> GetOpenOrder(User user, Location location)
        {
            var currentOrder = await _context.Orders
                               .Include(o => o.Location)
                               .Where(o => o.User.UserId == user.UserId)
                               .Where(o => o.TimeSubmitted == null)
                               .Where(o => o.Location.LocationId == location.LocationId)
                               .Select(o => o)
                               .SingleOrDefaultAsync();

            if (currentOrder == null)
            {
                var newOrder = new Entity.Order(user, location);
                _context.Add(newOrder);
                await _context.SaveChangesAsync();

                return(newOrder);
            }
            else
            {
                return(currentOrder);
            }
        }
예제 #10
0
        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            context.Response.Charset     = "utf-8";

            string Action = context.Request["Action"].ToString();

            string result = "{\"result\":\"failed\"}";
            string openid = "";

            if (!string.IsNullOrEmpty(Action))
            {
                switch (Action)
                {
                case "order":
                    var    orderdata  = context.Request["orderdata"].ToString();
                    string _statusid  = "1";
                    string _statusStr = "NotPaid";
                    AllTrustUs.SquirrelPocket.Entity.Order _o = JsonUtility.Deserialize <AllTrustUs.SquirrelPocket.Entity.Order>(orderdata);
                    if (Convert.ToDecimal(_o.actualprice) == 0)
                    {
                        _statusid  = "2";
                        _statusStr = "PaidSuccessed";
                    }

                    string insjson = @"insert into t_order(openid,outtradeno,fruittype,unitprice,startdate,enddate,days,
                            count,deliveryaddr,user,mp,totalprice,status,createdate,statusid,deliverystatus,otheraddr,GiftCardCode,deduction,actualprice,agencylevel,discount) values({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19},{20},{21});select @@IDENTITY;";
                    insjson = string.Format(insjson,
                                            UtilityFn.formatstring(_o.openid),
                                            UtilityFn.formatstring(UtilityFn.GenerateOutTradeNo()),
                                            UtilityFn.formatstring(_o.fruittype),
                                            UtilityFn.formatstring(_o.unitprice),
                                            UtilityFn.formatstring(_o.startdate),
                                            UtilityFn.formatstring(_o.enddate),
                                            UtilityFn.formatstring(_o.days),
                                            UtilityFn.formatstring(_o.count),
                                            UtilityFn.formatstring(_o.deliveryaddr),
                                            UtilityFn.formatstring(_o.user),
                                            UtilityFn.formatstring(_o.mp),
                                            UtilityFn.formatstring(_o.totalprice),
                                            UtilityFn.formatstring(_statusStr),
                                            UtilityFn.formatstring(DateTime.Now.ToString("yyyy/MM/dd HH:mm")),
                                            UtilityFn.formatstring(_statusid),
                                            UtilityFn.formatstring("未配送"),
                                            UtilityFn.formatstring(_o.otheraddr),
                                            UtilityFn.formatstring(_o.GiftCardCode),
                                            UtilityFn.formatstring(_o.deduction),
                                            UtilityFn.formatstring(_o.actualprice),
                                            UtilityFn.formatstring(_o.agencylevel),
                                            UtilityFn.formatstring(_o.discount)
                                            );
                    DataTable order = MySqlHelp.ExecuteDataTable(insjson);

                    if (order.Rows.Count > 0 && int.Parse(order.Rows[0][0].ToString()) > 0)
                    {
                        var orderid = order.Rows[0][0].ToString();
                        if (!string.IsNullOrEmpty(_o.GiftCardCode))
                        {
                            var updatecard = "update giftcard set isused='1',usedorderid='" + orderid + "',useddate='" + DateTime.Now.ToString("yyyy-MM-dd") + "' where giftcardcode='" + _o.GiftCardCode.Replace("-", "") + "'";
                            MySqlHelp.ExecuteNonQuery(updatecard);
                        }

                        foreach (AllTrustUs.SquirrelPocket.Entity.OrderFruit of in _o.fruits)
                        {
                            string insof = @"insert into t_orderfruts(orderid,fruitid,name,unit,unitprice,count,price,fruitNum,cost) 
                                    values({0},{1},{2},{3},{4},{5},{6},{7},{8});";
                            insof = string.Format(insof,
                                                  UtilityFn.formatstring(orderid),
                                                  UtilityFn.formatstring(of.FruitID),
                                                  UtilityFn.formatstring(of.Name),
                                                  UtilityFn.formatstring(string.IsNullOrEmpty(of.unit) ? "个" : of.unit),
                                                  UtilityFn.formatstring(of.unitprice),
                                                  UtilityFn.formatstring(string.IsNullOrEmpty(of.count) ? "1" : of.count),
                                                  UtilityFn.formatstring(of.price),
                                                  UtilityFn.formatstring(of.fruitNum),
                                                  UtilityFn.formatstring(of.cost)
                                                  );

                            MySqlHelp.ExecuteNonQuery(insof);
                        }

                        foreach (Entity.Delivery de in _o.deliverys)
                        {
                            string insdeli = @"insert into t_delivery(orderid,date,count,status) 
                                    values({0},{1},{2},{3});select @@IDENTITY;";
                            insdeli = string.Format(insdeli,
                                                    UtilityFn.formatstring(orderid),
                                                    UtilityFn.formatstring(de.Date),
                                                    UtilityFn.formatstring(de.Count),
                                                    UtilityFn.formatstring("未配送"));
                            DataTable deliDT = MySqlHelp.ExecuteDataTable(insdeli);
                            if (deliDT.Rows.Count > 0 && int.Parse(deliDT.Rows[0][0].ToString()) > 0)
                            {
                                var deliID = deliDT.Rows[0][0].ToString();
                                foreach (Entity.Deliveryfruits def in de.Deliveryfruits)
                                {
                                    string insdelif = @"insert into t_deliveryfruits(deliveryid,fruitid,name) 
                                    values({0},{1},{2});";
                                    insdelif = string.Format(insdelif,
                                                             UtilityFn.formatstring(deliID),
                                                             UtilityFn.formatstring(def.FruitID),
                                                             UtilityFn.formatstring(def.Name));
                                    MySqlHelp.ExecuteNonQuery(insdelif);
                                }
                            }
                        }
                        EmailHelper eh = new EmailHelper();
                        eh.SendMail("Squirel New Order Create", UtilityFn.JsonToHTMLTable(_o.ToJSONString()));

                        result = "{\"result\":\"successed\",\"orderid\":\"" + orderid + "\"}";
                    }
                    break;

                case "getorder":
                    openid = context.Request["openid"].ToString();
                    var status = context.Request["status"].ToString();
                    List <Entity.Order> _Orders = new List <Entity.Order>();
                    string    getsql            = "select * from t_order where openid=" + UtilityFn.formatstring(openid) + " and status=" + UtilityFn.formatstring(status) + " and status<>'deleted' order by statusid asc, createdate desc";
                    DataTable odDT = MySqlHelp.ExecuteDataTable(getsql);
                    for (int i = 0; i < odDT.Rows.Count; i++)
                    {
                        Entity.Order orderentity = new Entity.Order();

                        orderentity.openid       = odDT.Rows[i]["openid"].ToString();
                        orderentity.fruittype    = odDT.Rows[i]["fruittype"].ToString();
                        orderentity.startdate    = odDT.Rows[i]["startdate"].ToString();
                        orderentity.enddate      = odDT.Rows[i]["enddate"].ToString();
                        orderentity.days         = odDT.Rows[i]["days"].ToString();
                        orderentity.count        = odDT.Rows[i]["count"].ToString();
                        orderentity.deliveryaddr = odDT.Rows[i]["deliveryaddr"].ToString();
                        orderentity.user         = odDT.Rows[i]["user"].ToString();
                        orderentity.mp           = odDT.Rows[i]["mp"].ToString();
                        orderentity.totalprice   = odDT.Rows[i]["totalprice"].ToString();
                        orderentity.outtradeno   = odDT.Rows[i]["outtradeno"].ToString();
                        orderentity.status       = odDT.Rows[i]["status"].ToString();
                        orderentity.orderid      = odDT.Rows[i]["orderid"].ToString();
                        orderentity.createdate   = odDT.Rows[i]["createdate"].ToString();
                        orderentity.unitprice    = odDT.Rows[i]["unitprice"].ToString();
                        orderentity.otheraddr    = odDT.Rows[i]["otheraddr"].ToString();
                        orderentity.deduction    = odDT.Rows[i]["deduction"].ToString();
                        orderentity.actualprice  = odDT.Rows[i]["actualprice"].ToString();

                        string    getfruitssql = "select * from t_orderfruts where orderid=" + UtilityFn.formatstring(orderentity.orderid);
                        DataTable frDT         = MySqlHelp.ExecuteDataTable(getfruitssql);
                        orderentity.fruits = new List <Entity.OrderFruit>();
                        for (int j = 0; j < frDT.Rows.Count; j++)
                        {
                            Entity.OrderFruit ordereFruitntity = new Entity.OrderFruit();
                            ordereFruitntity.FruitID = frDT.Rows[j]["fruitid"].ToString();
                            ordereFruitntity.Name    = frDT.Rows[j]["name"].ToString();
                            orderentity.fruits.Add(ordereFruitntity);
                        }

                        _Orders.Add(orderentity);
                    }
                    result = "{\"result\":\"successed\",\"orders\":" + JsonUtility.ToJSONString(_Orders) + "}";



                    break;

                case "cancelorder":
                    string cancelorderid = context.Request["orderid"].ToString();
                    MySqlHelp.ExecuteNonQuery("update t_order set status='Canceled',statusid='5' where orderid=" + UtilityFn.formatstring(cancelorderid));
                    result = "{\"result\":\"successed\"}";
                    break;

                case "deleteorder":
                    string deleteorderorderid = context.Request["orderid"].ToString();
                    MySqlHelp.ExecuteNonQuery("update t_order set status='Deleted',statusid='4' where orderid=" + UtilityFn.formatstring(deleteorderorderid));
                    result = "{\"result\":\"successed\"}";
                    break;

                case "saveuserinfo":
                    string userdata = context.Request["userdata"].ToString();
                    openid = context.Request["openid"].ToString();

                    Dictionary <string, object> Dic = JsonUtility.ToDictionary(userdata);
                    var nickname = Dic["nickname"].ToString();
                    var country  = Dic["country"].ToString();
                    var province = Dic["province"].ToString();
                    var city     = Dic["city"].ToString();
                    var sex      = "";
                    if (!string.IsNullOrEmpty(Dic["sex"].ToString()))
                    {
                        if (Dic["sex"].ToString().Contains("男"))
                        {
                            sex = "1";
                        }
                        else
                        {
                            sex = "2";
                        }
                    }
                    else
                    {
                        sex = "1";
                    }

                    var mp = Dic["mp"].ToString();

                    ((WeXUser)context.Session["CurrentWeXUser"]).MP       = mp;
                    ((WeXUser)context.Session["CurrentWeXUser"]).city     = city;
                    ((WeXUser)context.Session["CurrentWeXUser"]).country  = country;
                    ((WeXUser)context.Session["CurrentWeXUser"]).nickname = nickname;
                    ((WeXUser)context.Session["CurrentWeXUser"]).sex      = sex;
                    ((WeXUser)context.Session["CurrentWeXUser"]).province = province;
                    MySqlHelp.ExecuteNonQuery("update t_user set mp=" + UtilityFn.formatstring(mp)
                                              + ",nickname=" + UtilityFn.formatstring(nickname)
                                              + ",country=" + UtilityFn.formatstring(country)
                                              + ",province=" + UtilityFn.formatstring(province)
                                              + ",city=" + UtilityFn.formatstring(city)
                                              + ",sex=" + UtilityFn.formatstring(sex)
                                              + " where openid=" + UtilityFn.formatstring(openid));

                    //((WeXUser)context.Session["CurrentWeXUser"]).MP = mp;

                    result = "{\"result\":\"successed\"}";

                    break;

                case "getDeliveryDetail":
                    var Deliveryorderid         = context.Request["orderid"].ToString();
                    List <Entity.Delivery> deli = new List <Entity.Delivery>();
                    string    Deligetsql        = "select * from t_delivery where orderid=" + UtilityFn.formatstring(Deliveryorderid);
                    DataTable DeliDT            = MySqlHelp.ExecuteDataTable(Deligetsql);

                    for (int i = 0; i < DeliDT.Rows.Count; i++)
                    {
                        Entity.Delivery ent = new Entity.Delivery();
                        ent.ID             = DeliDT.Rows[i]["ID"].ToString();
                        ent.OrderID        = Deliveryorderid;
                        ent.Date           = DeliDT.Rows[i]["Date"].ToString();
                        ent.Count          = DeliDT.Rows[i]["Count"].ToString();
                        ent.deliverystatus = DeliDT.Rows[i]["status"].ToString();
                        deli.Add(ent);
                    }

                    result = "{\"result\":\"successed\",\"deliverys\":" + JsonUtility.ToJSONString(deli) + "}";
                    break;

                case "orderRefund":
                    string    orderRefundorderid = context.Request["orderid"].ToString();
                    DataTable orderDT            = MySqlHelp.ExecuteDataTable(string.Format("select * from t_order where orderid={0}", orderRefundorderid));
                    var       outtradeno         = orderDT.Rows[0]["outtradeno"].ToString();
                    var       transaction_id     = orderDT.Rows[0]["transaction_id"].ToString();
                    var       totalprice         = orderDT.Rows[0]["totalprice"].ToString();
                    var       actualprice        = orderDT.Rows[0]["actualprice"].ToString();
                    try
                    {
                        string Refundresult = Refund.Run(transaction_id, outtradeno, (int.Parse(actualprice) * 100).ToString(), (int.Parse(actualprice) * 100).ToString());

                        Dictionary <string, object> di = JsonUtility.ToDictionary(Refundresult);
                        EmailHelper eh = new EmailHelper();
                        if (di["result_code"].ToString().ToUpper() == "FAIL")
                        {
                            result = "{\"result\":\"failed\"}";
                            eh.SendMail("Squirel Refunded Order failed[" + orderRefundorderid + "]", UtilityFn.JsonToHTMLTable(Refundresult));
                        }
                        else
                        {
                            result = "{\"result\":\"successed\"}";
                            MySqlHelp.ExecuteNonQuery(string.Format("update t_order set status='Refunded',statusid='100' where  orderid={0}", orderRefundorderid));
                            eh.SendMail("Squirel Refunded Order Successed[" + orderRefundorderid + "]", UtilityFn.JsonToHTMLTable(Refundresult));
                        }
                        Log.Info(this.GetType().ToString(), Refundresult);

                        //Response.Write("<span style='color:#00CD00;font-size:20px'>" + result + "</span>");
                    }
                    catch (WxPayException ex)
                    {
                        result = "{\"result\":\"failed\"}";
                        //Response.Write("<span style='color:#FF0000;font-size:20px'>" + ex.ToString() + "</span>");
                    }
                    catch (Exception ex)
                    {
                        result = "{\"result\":\"failed\"}";
                        //Response.Write("<span style='color:#FF0000;font-size:20px'>" + ex.ToString() + "</span>");
                    }


                    break;

                case "getgiftcode":
                    string    giftcode   = context.Request["giftcode"].ToString().Replace("-", "");
                    DataTable giftcodeDT = MySqlHelp.ExecuteDataTable(string.Format("select * from giftcard where isused='0' and giftcardcode='{0}'", giftcode));
                    if (giftcodeDT.Rows.Count > 0)
                    {
                        Giftcard gc = new Giftcard();
                        gc.id           = Convert.ToInt32(giftcodeDT.Rows[0]["id"]);
                        gc.giftcardcode = giftcodeDT.Rows[0]["giftcardcode"].ToString();
                        gc.amount       = giftcodeDT.Rows[0]["amount"].ToString();
                        gc.generatedate = giftcodeDT.Rows[0]["generatedate"].ToString();
                        gc.isused       = giftcodeDT.Rows[0]["isused"].ToString();
                        gc.usedorderid  = giftcodeDT.Rows[0]["usedorderid"].ToString();
                        gc.useddate     = giftcodeDT.Rows[0]["useddate"].ToString();
                        gc.forcompany   = giftcodeDT.Rows[0]["forcompany"].ToString();
                        gc.expireddate  = giftcodeDT.Rows[0]["expireddate"].ToString();

                        result = "{\"result\":\"successed\",\"giftcard\":" + JsonUtility.ToJSONString(gc) + "}";
                    }
                    else
                    {
                        result = "{\"result\":\"failed\"}";
                    }
                    break;

                default:
                    break;
                }
            }
            context.Response.Write(result);
        }
예제 #11
0
파일: Challan.cs 프로젝트: Bunty009/ColMan
        private void btnSaveandPrint_Click(object sender, EventArgs e)
        {
            Entity.Order             order          = new Entity.Order();
            List <Entity.OrderItems> listOrderItems = new List <Entity.OrderItems>();

            try
            {
                order.OrderDate = Convert.ToDateTime(dtpInvoiceDate.Text);
            }
            catch { }
            try
            {
                order.BillToContact = cbCustomer.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToEmail = txtEmailId.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToPhone = txtContactNo.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToGSTN = txtGSTN.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToAddress1 = txtAddressLine1.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToAddress2 = txtAddressLine2.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToCity = txtCity.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToState = txtState.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToZip = Convert.ToInt32(txtZip.Text.ToString());
            }
            catch { }
            try
            {
                order.Discount = Convert.ToInt32(txtDiscount.Text.ToString());
            }
            catch { }
            try
            {
                order.CGSTRate = Convert.ToInt32(txtCGST.Text.ToString());
            }
            catch { }
            try
            {
                order.SGSTRate = Convert.ToInt32(txtSGST.Text.ToString());
            }
            catch { }
            try
            {
                order.IGSTRate = Convert.ToInt32(txtIGST.Text.ToString());
            }
            catch { }
            try
            {
                order.TaxablePrice = Convert.ToDouble(lblDiscountedPrice.Text.ToString());
            }
            catch { }
            double _totalProductPrice = 0;

            foreach (DataGridViewRow dr in dgvProducts.Rows)
            {
                Entity.OrderItems orderItem = new Entity.OrderItems();
                try
                {
                    orderItem.MaterialId = Convert.ToInt32(dr.Cells["Id"].Value.ToString());
                }
                catch { }
                try
                {
                    orderItem.MaterialName = dr.Cells["Product Name"].Value.ToString();
                }
                catch { }
                try
                {
                    orderItem.HSNCode = dr.Cells["HSNCode"].Value.ToString();
                }
                catch { }
                try
                {
                    string val = dr.Cells["Qty"].Value.ToString();
                    orderItem.Quantity = Convert.ToInt32(val);
                }
                catch { }
                try
                {
                    orderItem.UnitPrice = Convert.ToDouble(dr.Cells["Rate"].Value.ToString());
                }
                catch { }
                try
                {
                    orderItem.TotalPrice = Convert.ToDouble(dr.Cells["Total"].Value.ToString());
                }
                catch { }
                _totalProductPrice += orderItem.TotalPrice;
                listOrderItems.Add(orderItem);
            }
            try
            {
                order.TotalProductPrice = Convert.ToDouble(_totalProductPrice);
            }
            catch { }
            try
            {
                if (!String.IsNullOrEmpty(lblGrandTotal.Text.ToString()))
                {
                    order.Grandtotal = Convert.ToDouble(lblGrandTotal.Text.ToString());
                }
                else
                {
                    order.Grandtotal = Convert.ToDouble(lblDiscountedPrice.Text.ToString());
                }
            }
            catch { }

            int response = orderBAL.addOrder(order, listOrderItems);

            using (Report rpt = new Report(response))
            {
                rpt.ShowDialog();
            }

            if (response != null && response != 0)
            {
                MessageBox.Show("Invoice saved successfully.");
            }
            else
            {
                MessageBox.Show("Something Went Wrong.");
            }
        }
예제 #12
0
파일: Challan.cs 프로젝트: Bunty009/ColMan
        private void btnSave_Click(object sender, EventArgs e)
        {
            Entity.Order             order          = new Entity.Order();
            List <Entity.OrderItems> listOrderItems = new List <Entity.OrderItems>();

            try
            {
                order.OrderDate = Convert.ToDateTime(dtpInvoiceDate.Text);
            }
            catch { }
            try
            {
                order.BillToContact = cbCustomer.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToEmail = txtEmailId.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToPhone = txtContactNo.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToGSTN = txtGSTN.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToAddress1 = txtAddressLine1.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToAddress2 = txtAddressLine2.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToCity = txtCity.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToState = txtState.Text.ToString();
            }
            catch { }
            try
            {
                order.BillToZip = Convert.ToInt32(txtZip.Text.ToString());
            }
            catch { }
            try
            {
                order.Discount = Convert.ToInt32(txtDiscount.Text.ToString());
            }
            catch { }
            try
            {
                order.CGSTRate = Convert.ToInt32(txtCGST.Text.ToString());
            }
            catch { }
            try
            {
                order.SGSTRate = Convert.ToInt32(txtSGST.Text.ToString());
            }
            catch { }
            try
            {
                order.IGSTRate = Convert.ToInt32(txtIGST.Text.ToString());
            }
            catch { }
            try
            {
                order.TaxablePrice = Convert.ToDouble(lblDiscountedPrice.Text.ToString());
            }
            catch { }
            double _totalProductPrice = 0;

            foreach (DataGridViewRow dr in dgvProducts.Rows)
            {
                Entity.OrderItems orderItem = new Entity.OrderItems();
                try
                {
                    orderItem.MaterialId = Convert.ToInt32(dr.Cells["Id"].Value.ToString());
                }
                catch { }
                try
                {
                    orderItem.MaterialName = dr.Cells["Product Name"].Value.ToString();
                }
                catch { }
                try
                {
                    orderItem.HSNCode = dr.Cells["HSNCode"].Value.ToString();
                }
                catch { }
                try
                {
                    string val = dr.Cells["Qty"].Value.ToString();
                    orderItem.Quantity = Convert.ToInt32(val);
                }
                catch { }
                try
                {
                    orderItem.UnitPrice = Convert.ToDouble(dr.Cells["Rate"].Value.ToString());
                }
                catch { }
                try
                {
                    orderItem.TotalPrice = Convert.ToDouble(dr.Cells["Total"].Value.ToString());
                }
                catch { }
                _totalProductPrice += orderItem.TotalPrice;
                listOrderItems.Add(orderItem);
            }
            try
            {
                order.TotalProductPrice = Convert.ToDouble(_totalProductPrice);
            }
            catch { }
            try
            {
                if (!String.IsNullOrEmpty(lblGrandTotal.Text.ToString()))
                {
                    order.Grandtotal = Convert.ToDouble(lblGrandTotal.Text.ToString());
                }
                else
                {
                    order.Grandtotal = Convert.ToDouble(lblDiscountedPrice.Text.ToString());
                }
            }
            catch { }
            try
            {
                string   s     = order.Grandtotal.ToString("0.00", CultureInfo.InvariantCulture);
                string[] parts = s.Split('.');
                int      i1    = int.Parse(parts[0]);
                int      i2    = int.Parse(parts[1]);
                long     l1    = (long)i1;
                long     l2    = (long)i2;
                string   s1    = ConvertNumbertoWords(l1);
                string   s2    = ConvertNumbertoWords(l2);
                string   s3    = s1 + " And " + s2 + " Paise Only.";
                order.GrandtotalInWords = s3;
            }
            catch { }
            int response = orderBAL.addOrder(order, listOrderItems);

            //using (Report rpt = new Report(response))
            //{
            //    rpt.ShowDialog();
            //}
            if (response != null && response != 0)
            {
                MessageBox.Show("Invoice saved successfully.");
            }
            else
            {
                MessageBox.Show("Something Went Wrong.");
            }
        }
		private void submit_Click(object sender, RoutedEventArgs e)
		{
			if (((customId.Text == string.Empty) || (firstName.Text == string.Empty) || (lastName.Text == string.Empty) ||
				(street.Text == string.Empty) || (city.Text == string.Empty) ||
				(zip.Text == string.Empty) || (email.Text == string.Empty) ||
			  (name.Text == string.Empty) || (country.SelectedValue == null) || !this.marked)
				|| (this.c != "FO" && (this.ico.Text == string.Empty || this.icDph.Text == string.Empty
					|| this.dic.Text == string.Empty || this.name.Text == string.Empty)))
			{
				System.Windows.MessageBox.Show("Musia byť vyplnené poviné údaje");
				return;
			}
			if ((customId.Text.Contains(";")) || (titlePrefix.Text.Contains(";")) ||
						(firstName.Text.Contains(";")) || (lastName.Text.Contains(";")) ||
						(titleSuffix.Text.Contains(";")) || (street.Text.Contains(";")) ||
						(city.Text.Contains(";")) || (zip.Text.Contains(";")) || (email.Text.Contains(";")) ||
					  (name.Text.Contains(";")) || (mobile.Text.Contains(";")) || (ico.Text.Contains(";"))
			 || (dic.Text.Contains(";")) || (icDph.Text.Contains(";")))
			{
				System.Windows.MessageBox.Show("Znak ; je vyhradeni, prosím zmente vstup tak aby neobsahoval znak ; ");
				return;
			}
			Entity.Order order = new Entity.Order();
			order.products = new List<Interface.IOrderItem>();
			Entity.Company company = new Entity.Company();
			company.custom_id = customId.Text.ToString();

			Entity.Person person = new Entity.Person();
			person.titlePrefix = titlePrefix.Text.ToString();
			person.firstName = firstName.Text.ToString();
			person.lastName = lastName.Text.ToString();
			person.titleSuffix = titleSuffix.Text.ToString();

			Entity.Address address = new Entity.Address();
			address.street = street.Text.ToString();
			address.city = city.Text.ToString();
			address.zip = zip.Text.ToString();
			address.country = country.Text.ToString() == "Vyberte krajinu" ? "SVK" : country.Text.ToString();

			Entity.Contact contact = new Entity.Contact();
			contact.email = email.Text.ToString();
			contact.mobile = mobile.Text.ToString();

			company.person = person;
			company.address = address;
			company.contact = contact;

			switch (this.c.ToUpper())
			{
				case "PO":
					{ company.corporatePerson = Interface.CorporatePerson.PO; break; }
				default:
					{ company.corporatePerson = Interface.CorporatePerson.FO; break; }
			}
			if (this.c.ToUpper() != "FO")
			{
				company.name = name.Text.ToString();
				company.ico = ico.Text.ToString();
				company.dic = dic.Text.ToString();
				company.icDph = icDph.Text.ToString();
			}
			else
				company.name = company.person.getFullName();

			//company.id = 1;
			//if (Settings.Config.getCompanies().Count > 0)
			//	company.id = Settings.Config.getCompanies().LastOrDefault(x => x.id > 0).id + 1;

			//order.id = 1;
			//if (Settings.Config.getOrders().Count > 0)
			//	order.id = Settings.Config.getOrders().LastOrDefault(x => x.id > 0).id + 1;

			order.company = company;
			//Settings.Config.getCompanies().Add(company);
			//Settings.Config.getOrders().Add(order);
			Settings.Config.setTempOrder(order);
			onCreatedOrder(new EventArgs());
		}
예제 #14
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                string openid    = Request.QueryString["openid"];
                string total_fee = Request.QueryString["total_fee"];
                order_id = Request.QueryString["order_id"];
                string ActualPay = ConfigurationManager.AppSettings["ActualPay"].ToString();
                OrderPay = new Entity.Order();
                DataSet orderDS = MySqlHelp.ExecuteDataSet(string.Format("select * from t_order where orderid={0};select * from t_orderfruts where orderid={0};", order_id));
                if (orderDS.Tables.Count == 2)
                {
                    if (orderDS.Tables[0].Rows[0]["status"].ToString() != "NotPaid")
                    {
                        return;
                    }
                    OrderPay.fruittype    = orderDS.Tables[0].Rows[0]["fruittype"].ToString();
                    OrderPay.startdate    = orderDS.Tables[0].Rows[0]["startdate"].ToString();
                    OrderPay.enddate      = orderDS.Tables[0].Rows[0]["enddate"].ToString();
                    OrderPay.days         = orderDS.Tables[0].Rows[0]["days"].ToString();
                    OrderPay.count        = orderDS.Tables[0].Rows[0]["count"].ToString();
                    OrderPay.deliveryaddr = orderDS.Tables[0].Rows[0]["deliveryaddr"].ToString();
                    OrderPay.user         = orderDS.Tables[0].Rows[0]["user"].ToString();
                    OrderPay.mp           = orderDS.Tables[0].Rows[0]["mp"].ToString();
                    OrderPay.totalprice   = orderDS.Tables[0].Rows[0]["totalprice"].ToString();
                    OrderPay.outtradeno   = orderDS.Tables[0].Rows[0]["outtradeno"].ToString();
                    OrderPay.createdate   = orderDS.Tables[0].Rows[0]["createdate"].ToString();
                    OrderPay.unitprice    = orderDS.Tables[0].Rows[0]["unitprice"].ToString();
                    OrderPay.deduction    = orderDS.Tables[0].Rows[0]["deduction"].ToString();
                    OrderPay.actualprice  = orderDS.Tables[0].Rows[0]["actualprice"].ToString();

                    for (int i = 0; i < orderDS.Tables[1].Rows.Count; i++)
                    {
                        if (OrderPay.fruittype.Contains("社区预定"))
                        //{
                        //    Fruitslist += orderDS.Tables[1].Rows[i]["name"].ToString() + ";";
                        //}
                        //else
                        {
                            Fruitslist += orderDS.Tables[1].Rows[i]["name"].ToString()
                                          + (Convert.ToInt32(orderDS.Tables[1].Rows[i]["fruitNum"]) * Convert.ToInt32(orderDS.Tables[1].Rows[i]["count"])).ToString()
                                          + orderDS.Tables[1].Rows[i]["unit"] + ";";
                            divunit.Visible     = false;
                            divdelivery.Visible = false;
                        }
                    }
                }
                else
                {
                    return;
                }
                //return;
                //检测是否给当前页面传递了相关参数
                if (string.IsNullOrEmpty(openid) || string.IsNullOrEmpty(total_fee) || string.IsNullOrEmpty(order_id))
                {
                    Response.Write("<span style='color:#FF0000;font-size:20px'>" + "页面传参出错,请返回重试" + "</span>");
                    Log.Error(this.GetType().ToString(), "This page have not get params, cannot be inited, exit...");
                    //submit.Visible = false;
                    return;
                }

                //若传递了相关参数,则调统一下单接口,获得后续相关接口的入口参数
                JsApiPay jsApiPay = new JsApiPay(this);
                jsApiPay.openid = openid;
                try
                {
                    if (Convert.ToBoolean(ActualPay))
                    {
                        jsApiPay.total_fee = int.Parse(total_fee);
                    }
                    else
                    {
                        jsApiPay.total_fee = 1;
                    }
                }
                catch (Exception ex)
                {
                    Response.Write(ex.Message + ex.StackTrace);
                }

                //jsApiPay.total_fee = 1;
                //JSAPI支付预处理
                WxPayData unifiedOrderResult = new WxPayData();
                try
                {
                    unifiedOrderResult = jsApiPay.GetUnifiedOrderResult(OrderPay.outtradeno);
                    wxJsApiParam       = jsApiPay.GetJsApiParameters();//获取H5调起JS API参数
                    Log.Debug(this.GetType().ToString(), "wxJsApiParam : " + wxJsApiParam);
                    //在页面上显示订单信息
                    //Response.Write("<span style='color:#00CD00;font-size:20px'>订单详情:</span><br/>");
                    //Response.Write("<span style='color:#00CD00;font-size:20px'>" + unifiedOrderResult.ToPrintStr() + "</span>");
                }
                catch (Exception ex)
                {
                    Response.Write("<span style='color:#FF0000;font-size:20px;margin-left:10px'>" + "初始化失败,无法支付,请返回重试。" + "</span>");
                    //Response.Write("<span style='color:#00CD00;font-size:20px'>" + unifiedOrderResult.ToPrintStr() + "</span>");
                    //Response.Write("wxJsApiParam : " + wxJsApiParam);
                    divbutton.Visible = false;
                }
            }
        }
예제 #15
0
 public ViewModel.Order ToOrder(Entity.Order value)
 {
     return(new ViewModel.Order {
     });
 }
예제 #16
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                canRefund = false;
                order_id  = Request.QueryString["order_id"];

                OrderPay = new Entity.Order();
                DataSet orderDS = MySqlHelp.ExecuteDataSet(string.Format("select * from t_order where orderid={0};select * from t_orderfruts where orderid={0};", order_id));
                if (orderDS.Tables.Count == 2)
                {
                    OrderPay.openid         = orderDS.Tables[0].Rows[0]["openid"].ToString();
                    OrderPay.fruittype      = orderDS.Tables[0].Rows[0]["fruittype"].ToString();
                    OrderPay.startdate      = orderDS.Tables[0].Rows[0]["startdate"].ToString();
                    OrderPay.enddate        = orderDS.Tables[0].Rows[0]["enddate"].ToString();
                    OrderPay.days           = orderDS.Tables[0].Rows[0]["days"].ToString();
                    OrderPay.count          = orderDS.Tables[0].Rows[0]["count"].ToString();
                    OrderPay.deliveryaddr   = orderDS.Tables[0].Rows[0]["deliveryaddr"].ToString();
                    OrderPay.user           = orderDS.Tables[0].Rows[0]["user"].ToString();
                    OrderPay.mp             = orderDS.Tables[0].Rows[0]["mp"].ToString();
                    OrderPay.totalprice     = orderDS.Tables[0].Rows[0]["totalprice"].ToString();
                    OrderPay.outtradeno     = orderDS.Tables[0].Rows[0]["outtradeno"].ToString();
                    OrderPay.createdate     = orderDS.Tables[0].Rows[0]["createdate"].ToString();
                    OrderPay.unitprice      = orderDS.Tables[0].Rows[0]["unitprice"].ToString();
                    OrderPay.deliverystatus = orderDS.Tables[0].Rows[0]["deliverystatus"].ToString();
                    OrderPay.otheraddr      = orderDS.Tables[0].Rows[0]["otheraddr"].ToString();
                    OrderPay.deduction      = orderDS.Tables[0].Rows[0]["deduction"].ToString();
                    OrderPay.actualprice    = orderDS.Tables[0].Rows[0]["actualprice"].ToString();
                    OrderPay.ExpressNumber  = orderDS.Tables[0].Rows[0]["ExpressNumber"].ToString();

                    switch (orderDS.Tables[0].Rows[0]["status"].ToString())
                    {
                    case "NotPaid":
                        OrderPay.status = "未支付";
                        break;

                    case "PaidSuccessed":
                        OrderPay.status = "已支付";
                        if (DateTime.Compare(DateTime.Now, Convert.ToDateTime(OrderPay.startdate)) < 0)
                        {
                            canRefund = true;
                        }
                        break;

                    case "Completed":
                        OrderPay.status = "已完成";
                        break;

                    case "Canceled":
                        OrderPay.status = "已取消";
                        break;

                    case "Expiry":
                        OrderPay.status = "已过期";
                        break;

                    case "Refunded":
                        OrderPay.status = "已退款";
                        break;

                    default:
                        break;
                    }

                    for (int i = 0; i < orderDS.Tables[1].Rows.Count; i++)
                    {
                        if (OrderPay.fruittype.Contains("社区预定"))
                        //{
                        //    Fruitslist += orderDS.Tables[1].Rows[i]["name"].ToString() + ";";
                        //}
                        //else
                        {
                            Fruitslist += orderDS.Tables[1].Rows[i]["name"].ToString()
                                          + (Convert.ToInt32(orderDS.Tables[1].Rows[i]["fruitNum"]) * Convert.ToInt32(orderDS.Tables[1].Rows[i]["count"])).ToString()
                                          + orderDS.Tables[1].Rows[i]["unit"] + ";";
                            divunit.Visible           = false;
                            divdelivery.Visible       = false;
                            divdeliverystatus.Visible = true;
                        }
                    }
                }
            }
        }