public ActionResult UserMain(int?p)
        {
            dbDemoDataContext db       = new dbDemoDataContext();
            tCustomer         customer = (new dbDemoDataContext()).tCustomer.FirstOrDefault(m => m.fId == p);

            customer = Session[CDictionary.LOGIN_USER] as tCustomer;
            Timer timer = new Timer(5000);

            timer.AutoReset = true;
            timer.Enabled   = true;
            if (customer != null)
            {
                ViewBag.Id      = customer.fId.ToString() + ".jpg";
                ViewBag.Name    = customer.fName;
                ViewBag.Phone   = customer.fPhone;
                ViewBag.Email   = customer.fEmail;
                ViewBag.Address = customer.fAddress;
                AllModel all = new AllModel();
                return(View(all));
            }
            else
            {
                return(RedirectToAction("../Home/Index"));
            }
        }
        public ActionResult Login(tCustomer p)
        {
            dbDemoDataContext db = new dbDemoDataContext();
            tCustomer         c  = db.tCustomer.FirstOrDefault(
                m => m.fEmail == p.fEmail);

            if (c == null)
            {
                ViewBag.kk = "郵件不可空白";
                return(View());
            }

            if ((c.fEmail != p.fEmail) || (c.fPassword != p.fPassword))
            {
                if (c.fPassword == "")
                {
                    ViewBag.kk = "請輸入密碼";
                    return(View());
                }
                else
                {
                    ViewBag.kk = "帳號或密碼輸入錯誤";
                    return(View());
                }
            }
            else
            {
                Session[CDictionary.LOGIN_USER] = c;
                return(RedirectToAction("../User/UserMain"));
            }
        }
Exemple #3
0
        public AllModel()
        {
            dbDemoDataContext db = new dbDemoDataContext();

            this.T1 = db.tCustomer.ToList();
            this.T2 = db.tMessage.ToList();
        }
Exemple #4
0
        public ActionResult List()
        {
            dbDemoDataContext db = new dbDemoDataContext();
            var table            = from c in db.tCustomer
                                   select c;

            return(View(table));
        }
Exemple #5
0
        public ActionResult New(tCustomer p)
        {
            dbDemoDataContext db = new dbDemoDataContext();

            db.tCustomer.InsertOnSubmit(p);
            db.SubmitChanges();

            return(RedirectToAction("List"));
        }
        public ActionResult Logout(tCustomer p)
        {
            Session.Clear();
            dbDemoDataContext db = new dbDemoDataContext();
            tCustomer         c  = db.tCustomer.FirstOrDefault(
                m => m.fId == p.fId);

            return(RedirectToAction("../Home/Index"));
        }
        public ActionResult NewMessage(tMessage m)
        {
            dbDemoDataContext db = new dbDemoDataContext();

            db.tMessage.InsertOnSubmit(m);
            db.SubmitChanges();

            return(RedirectToAction("UserMain"));
        }
Exemple #8
0
        public ActionResult Update(int qq)
        {
            dbDemoDataContext db   = new dbDemoDataContext();
            tCustomer         cust = db.tCustomer.FirstOrDefault(m => m.fId == qq);

            if (cust != null)
            {
                return(View(cust));
            }
            return(RedirectToAction("List"));
        }
Exemple #9
0
        public ActionResult Delete(int qq)
        {
            dbDemoDataContext db   = new dbDemoDataContext();
            tCustomer         cust = db.tCustomer.FirstOrDefault(m => m.fId == qq);

            if (cust != null)
            {
                db.tCustomer.DeleteOnSubmit(cust);
                db.SubmitChanges();
            }

            return(RedirectToAction("List"));
        }
Exemple #10
0
        public ActionResult Update(tCustomer p)
        {
            dbDemoDataContext db   = new dbDemoDataContext();
            tCustomer         cust = db.tCustomer.FirstOrDefault(m => m.fId == p.fId);

            if (cust != null)
            {
                cust.fName    = p.fName;
                cust.fPhone   = p.fPhone;
                cust.fEmail   = p.fEmail;
                cust.fAddress = p.fAddress;
                db.SubmitChanges();
            }
            return(RedirectToAction("List"));
        }
        public ActionResult SignUp(tCustomer p, UserData data)
        {
            if (string.IsNullOrEmpty(data.fName) || string.IsNullOrEmpty(data.fEmail))
            {
                ViewBag.pp = "暱稱和郵件不可空白";
                return(View(data));
            }
            if (string.IsNullOrEmpty(data.fPassword) || data.fPassword != data.fPassword2)
            {
                ViewBag.pp = "密碼不可空白或確認錯誤";
                return(View(data));
            }

            dbDemoDataContext db = new dbDemoDataContext();

            db.tCustomer.InsertOnSubmit(p);
            db.SubmitChanges();



            return(RedirectToAction("../Home/Index"));
        }
Exemple #12
0
 public AlumnoDA()
 {
     dc = new dbDemoDataContext();
 }