public JsonResult CreateUser_Click(string username, string password)
        {
            bool status = false;

            using (teamfourEntities dc = new teamfourEntities())
            {
                if (dc.Users.Where(i => i.Username == username).ToList() != null)
                {
                    User newUser = new User
                    {
                        FirstName  = "",
                        LastName   = "",
                        Username   = username,
                        Password   = password,
                        MiddleName = "",
                        Type       = 2
                    };
                    dc.Users.Add(newUser);
                }

                dc.SaveChanges();
                status = true;
            }
            return(new JsonResult {
                Data = new { status = status }
            });
        }
        public JsonResult SaveEvent(Event e)
        {
            var status = false;

            using (teamfourEntities dc = new teamfourEntities())
            {
                if (e.EventID > 0)
                {
                    //Update the event
                    var v = dc.Events.Where(a => a.EventID == e.EventID).FirstOrDefault();
                    if (v != null)
                    {
                        v.Doctor      = e.Doctor;
                        v.DoctorName  = e.DoctorName;
                        v.Start       = e.Start;
                        v.End         = e.End;
                        v.Description = e.Description;
                        v.IsFullDay   = e.IsFullDay;
                        v.ThemeColor  = e.ThemeColor;
                    }
                }
                else
                {
                    dc.Events.Add(e);
                }

                dc.SaveChanges();
                status = true;
            }
            return(new JsonResult {
                Data = new { status = status }
            });
        }
 public JsonResult GetEvents()
 {
     using (teamfourEntities dc = new teamfourEntities())
     {
         var events = dc.Events.ToList();
         return(new JsonResult {
             Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet
         });
     }
 }
 public JavaScriptResult LoginAuth(string username, string password)
 {
     using (teamfourEntities dc = new teamfourEntities())
     {
         if (dc.Users.Where(i => i.Username == username && i.Password == password).ToList() != null)
         {
             return(JavaScript("alert('Login Success');"));
         }
         return(JavaScript("alert('Login Fail');"));
     }
 }
        // GET: Home
        public ActionResult Index()
        {
            using (teamfourEntities dc = new teamfourEntities())
            {
                var docs = dc.Users.Where(i => i.Type == 1).Select(i => new ViewBag
                {
                    Username = i.Username,
                    FullName = i.FirstName + " " + i.LastName
                }).ToList();

                ViewData["Username"] = new SelectList(docs, "Username", "FullName");
                return(View());
            }
        }
        public JsonResult DeleteEvent(int eventID)
        {
            var status = false;

            using (teamfourEntities dc = new teamfourEntities())
            {
                var v = dc.Events.Where(a => a.EventID == eventID).FirstOrDefault();
                if (v != null)
                {
                    dc.Events.Remove(v);
                    dc.SaveChanges();
                    status = true;
                }
            }
            return(new JsonResult {
                Data = new { status = status }
            });
        }