Exemple #1
0
        public static double ShippingPrice(string shopCode = "culture")
        {
            double result = 0;

            try
            {
                OhayooDB db = new OhayooDB();
                result = db.proShippingJapan(RakutenInfo(shopCode)).FirstOrDefault().price.Value;
            }
            catch (Exception ex) { Console.WriteLine(ex.Message); }
            return(result);
        }
        public HttpResponseMessage Get()
        {
            double rate = 0; OhayooDB db = new OhayooDB();

            try
            {
                rate = ExchangeRateVietComBankUtils.VietComBank(url);
                //update exchage rate
                if (db.ExchageRates.Count() > 0)
                {
                    if (db.ExchageRates.OrderByDescending(n => n.id).FirstOrDefault().exRate != rate)
                    {
                        ExchageRate model = new ExchageRate()
                        {
                            createDate = DateTime.Now,
                            exRate     = rate
                        };
                        db.ExchageRates.Add(model);
                        db.SaveChangesAsync();
                    }
                }
                else
                {
                    ExchageRate model = new ExchageRate()
                    {
                        createDate = DateTime.Now,
                        exRate     = rate
                    };
                    db.ExchageRates.Add(model);
                    db.SaveChangesAsync();
                }

                if (db.ExchageRateCharts.Count() == 0)
                {
                    rate = rate * 1.02;
                }
                else
                {
                    rate = rate * db.ExchageRateCharts.OrderByDescending(n => n.id).FirstOrDefault().exRate.Value;
                }
            }
            catch
            {
                if (db.ExchageRates.Count() > 0)
                {
                    rate = db.ExchageRates.OrderByDescending(n => n.id).FirstOrDefault().exRate.Value;
                }
            }
            return(Request.CreateResponse(HttpStatusCode.OK, rate));
        }
Exemple #3
0
        public HttpResponseMessage Post()
        {
            List <CategoryResponse> list = new List <CategoryResponse>();

            try
            {
                OhayooDB db = new OhayooDB();
                list.AddRange(db.Categories.Select(n => new CategoryResponse()
                {
                    description = n.description, id = n.id,
                    is_leaf     = n.is_leaf.Value, level = n.levelCate.Value,
                    name        = n.name, parent_id = n.parent_id.Value,
                    status      = n.status.Value
                }));
            }
            catch { }
            return(Request.CreateResponse(HttpStatusCode.OK, list));
        }
        public static double ExchangeRate()
        {
            double rate = 219.22; OhayooDB db = new OhayooDB();

            try
            {
                if (db.ExchageRates.Count() > 0)
                {
                    rate = db.ExchageRates.OrderByDescending(n => n.id).FirstOrDefault().exRate.Value;
                }

                if (db.ExchageRateCharts.Count() == 0)
                {
                    rate = rate * 1.02;
                }
                else
                {
                    rate = rate * db.ExchageRateCharts.OrderByDescending(n => n.id).FirstOrDefault().exRate.Value;
                }
            }
            catch { }
            return(rate);
        }