public static MobileModel Sale_SMS(int Id, String mobile, int collected, DateTime ExcTime, string detail = null)
        {
            s26webDataContext db = new s26webDataContext();
            IntroductionModel intro = new IntroductionModel();
            var msg = intro.Get_One(Id);
            var data = db.Volunteers.FirstOrDefault(f => f.Mobile == mobile);

            /////////////////////
            msg.Content = msg.Content.Replace("<--end_time-->", ExcTime.AddHours(8).ToString("yyyy/MM/dd HH:mm"));
            msg.Content = msg.Content.Replace("<--collected-->", collected.ToString());
            /////////////////////
            var mm = SMS_Send(msg, mobile);
            SMS sms = new SMS
            {
                sms_id = mm.error_code,
                content = mm.error_msg,
                CreateTime = DateTime.UtcNow,
                mobile = mobile,
                detail = detail
            };
            db.SMS.InsertOnSubmit(sms);
            db.SubmitChanges();
            db.Connection.Close();
            //return the response
            return mm;
        }

 public SiteOptionShow Get()
 {
     s26webDataContext db = new s26webDataContext();
     var data = db.WebConfig.FirstOrDefault();
     db.Connection.Close();
     if (data != null)
     {
         return new SiteOptionShow
         {
             Id = data.Id,
             WebTitle = data.WebTitle,
             WebIcon = data.WebIcon,
             WebLogo = Method.RootPath + data.WebLogo,
             WebSEO = data.WebSEO,
             WebDescription = data.WebDescription,
             SMTP_Server = data.SMTP_Server,
             SMTP_Port = data.SMTP_Port,
             SMTP_Login = data.SMTP_Login,
             SMTP_SSL = data.SMTP_SSL,
             SMTP_Account = data.SMTP_Account,
             SMTP_Password = data.SMTP_Password,
             Service_Mail = data.Service_Mail,
             FromName = data.FromName,
             ExportMail = data.Export_Mail,
             OrdersMail = data.OrdersMail,
             iOS_Version = data.iOS_Version,
             Android_Version = data.Android_Version
         };
     }
     return new SiteOptionShow();
 }

        public List<OnlineModelShow> Get_Data(int p = 1, int take = 10)
        {
            try
            {
                s26webDataContext db = new s26webDataContext();

                var data = Get().OrderByDescending(o => o.Id).Skip((p - 1) * take).Take(take);
                foreach (var i in data)
                {
                    string[] typestr = i.Type.Split(',');
                    string list = "";
                    foreach (var j in typestr)
                    {
                        if (j != "")
                        {
                            int typeint = int.Parse(j);
                            list += db.Category.FirstOrDefault(f => f.Id == typeint).Name + ",";
                        }
                    }
                    i.Type = list;
                };

                List<OnlineModelShow> item = Convert(data.ToList());
                db.Connection.Close();
                return item;
            }
            catch { return new List<OnlineModelShow>(); }
        }

        public static List<SelectListItem> Get_Area_Select(int city, int area, bool zip, bool all)
        {
            s26webDataContext db = new s26webDataContext();
            List<SelectListItem> data = new List<SelectListItem>();
            data.Add(new SelectListItem
            {
                Selected = area == 0,
                Text = all ? "全部" : "請選擇",
                Value = "0"
            });
            if (city == 0)
            {
                return data;
            }
            
                data.AddRange(db.Area.Where(w => w.City_Id == city).OrderBy(o => o.Id).ThenBy(t => t.ZipCode).Select(s =>
                    new SelectListItem
                    {
                        Selected = area == s.Id,
                        Text = (zip ? s.ZipCode : "") + s.Name,
                        Value = s.Id.ToString()
                    }));
            

            db.Connection.Close();
            return data;
        }

 public IQueryable<SalesPromotion> Get()
 {
     s26webDataContext db = new s26webDataContext();
     IQueryable<SalesPromotion> data = db.SalesPromotion;
     db.Connection.Close();
     return data;
 }

 public IQueryable<Online> Get()
 {
     s26webDataContext db = new s26webDataContext();
     IQueryable<Online> data = db.Online;
     db.Connection.Close();
     return data;
 }

 public List<GiftModelShow> Get_Data()
 {
     s26webDataContext db = new s26webDataContext();
     var gift = Convert(db.Gift.OrderByDescending(o => o.Id).ToList());
     foreach(var i in gift)
     {
         string[] typestr= i.MemberType.Split(',');
         string list = "";
         string item = "";
         foreach(var j in typestr)
         {
         if (j != "") 
         {
             int typeint = int.Parse(j);
             
             if(typeint == 1)
             { item = "懷孕中"; }
             else if (typeint == 2)
             { item = "使用S-26產品"; }
             else if (typeint == 3)
             { item = "全母乳餵哺"; }
             else if (typeint == 4)
             { item = "其他"; }
             
             //list += db.Category.FirstOrDefault(f => f.Id == typeint).Name + ",";
         }
         list += item + ",";
         }
         i.MemberType = list;
     };
     db.Connection.Close();
     return gift;
 }

 public List<Category> Get_MemberType()
 {
     s26webDataContext db = new s26webDataContext();
     GiftModelShow data = new GiftModelShow();
     data.membertype_list = db.Category.Where(w => w.Fun_Id == 2).ToList();
     db.Connection.Close();
     return data.membertype_list;
 }

 public List<Category> Get_Category()
 {
         s26webDataContext db = new s26webDataContext();
         PointModelShow data = new PointModelShow();
         data.Point_Category = db.Category.Where(w => w.Fun_Id == 3).ToList();
         db.Connection.Close();
         return data.Point_Category;
 }

 public ActionResult CheckMobile(string Mobile)
 {
     s26webDataContext db = new s26webDataContext();
     var result = db.Volunteers.FirstOrDefault(f => f.Mobile == Mobile);
     db.Connection.Close();
     if (result != null)
         return Json(false, JsonRequestBehavior.AllowGet);
     else
         return Json(true, JsonRequestBehavior.AllowGet);
 }

 public static int getSMSPoint()
 {
     s26web.Models.s26webDataContext db = new s26web.Models.s26webDataContext();
     int point = 0;
     var result = db.SMS.Where(w=>w.sms_id.Equals("000")).OrderByDescending(o => o.CreateTime).FirstOrDefault();
     List<string> sms_content = new List<string>();
     if(result != null)
         sms_content = result.content.Split('|').ToList();
     point = Convert.ToInt32(sms_content.LastOrDefault());
     return point;
 }

        public ActionResult Delivery_Order(string Osid, int Id)
        {
            string Session_name = Method.SessionUserId_Home;
            int memberid = int.Parse(Method.Get_Session(Session, Session_name));
            s26webDataContext db = new s26webDataContext();
            Osid = db.Orders.FirstOrDefault(f => f.Id == Id).Osid;
            db.Connection.Close();

            OrdersModel orders = new OrdersModel();
            var orderdetail = orders.Get_Detail(Osid);
            return View(orderdetail);
        }

 public void Update(string[] UserName, string[] FBUrl)
 {
     s26webDataContext db = new s26webDataContext();
     for (int i = 0; i < UserName.Count(); i++)
     {
         var data = db.eCRM.FirstOrDefault(f => f.Id == (i + 1));
         data.UserName = UserName[i];
         data.FBUrl = FBUrl[i];
     }
     db.SubmitChanges();
     db.Connection.Close();
 }

        public List<SalesPromotionModelShow> Get_Data(int p = 1, int take = 10)
        {
            try
            {
                s26webDataContext db = new s26webDataContext();

                var data = Get().OrderByDescending(o=>o.Id).Skip((p - 1) * take).Take(take);
                List<SalesPromotionModelShow> item = Convert(data.ToList());
                db.Connection.Close();
                return item;
            }
            catch { return new List<SalesPromotionModelShow>(); }
        }

        public ActionResult Index()//HttpSessionStateBase Session
        {
            s26webDataContext db = new s26webDataContext();
            string Session_name = Method.SessionUserId_Home;
            string account = Method.Get_Session(Session, Session_name);

            var vol = db.Volunteers.FirstOrDefault(w => w.Id == int.Parse(account));
            ViewData["Bir_year"] = vol.BabyBirthday.ToString("yyyy");
            ViewData["Bir_month"] = vol.BabyBirthday.ToString("MM");
            ViewData["Bir_date"] = vol.BabyBirthday.ToString("dd");

            return View();
        }

 public ActionResult Edit(SalesPromotionModel.SalesPromotionModelShow item, int p = 1)
 {
     {
         s26webDataContext db = new s26webDataContext();
         var old = db.SalesPromotion.FirstOrDefault(f => f.Id == item.Id);
         db.Connection.Close();
         if (data.Update(item) <= 0)
         {
             TempData["err"] = "SalesPromotion_5";
             return RedirectToAction("Index");
         }
     }
     return RedirectToAction("Index", new { p = p });
 }

 public static string Get_Title(int id)
 {
     try
     {
         s26webDataContext db = new s26webDataContext();
         var data = db.Introduction.FirstOrDefault(f => f.Id == id);
         db.Connection.Close();
         if (data != null)
         {
             return data.Title;
         }
     }
     catch { }
     return "";
 }

 public LoginRecordModelShow Get_One(int id)
 {
     try
     {
         s26webDataContext db = new s26webDataContext();
         var data = db.LoginRecord.FirstOrDefault(f => f.Id == id);
         if (data != null)
         {
             return Convert(data);
         }
         db.Connection.Close();
     }
     catch { }
     return null;
 }

 public List<CRMMemberInfo> Get_Data()
 {
     s26webDataContext db = new s26webDataContext();
     var data = db.eCRM;
     List<CRMMemberInfo> mm = new List<CRMMemberInfo>();
     foreach (var i in data)
     {
         mm.Add(new CRMMemberInfo
         {
             Id = i.Id,
             CategoryName = i.CategoryName,
             FBUrl = i.FBUrl,
             UserName = i.UserName
         });
     }
     db.Connection.Close();
     return mm;
 }

 public static List<SelectListItem> Get_City_Select(int city, bool all)
 {
     s26webDataContext db = new s26webDataContext();
     List<SelectListItem> data = new List<SelectListItem>();
     data.Add(new SelectListItem
     {
         Selected = city == 0,
         Text = all ? "全部" : "請選擇",
         Value = "0"
     });
     data.AddRange(db.City.OrderBy(o => o.Id).Select(s =>
         new SelectListItem
         {
             Selected = city == s.Id,
             Text = s.Name,
             Value = s.Id.ToString()
         }));
     db.Connection.Close();
     return data;
 }