public ActionResult ExistingPatient() { WallEntities wb = new WallEntities(); //users from usersinrole patient.... IEnumerable <aspnet_UsersInRoles> users = wb.aspnet_UsersInRoles.Where(p => p.aspnet_Roles.RoleName == "Patient"); var musers = new List <MembershipUser>(); foreach (var u in users) { MembershipUser pat = Membership.GetUser(u.UserId); musers.Add(pat); } List <ExistingPatient> patients = new List <ExistingPatient>(); foreach (var u in musers) { if (u != null) { var userId = u.ProviderUserKey.ToString(); patients.Add(new ExistingPatient() { UserId = userId, PatientName = u.UserName, EmailId = u.Email }); } } return(View(patients)); }
public IEnumerable <AppointmentNew> Get(string PatientId) { WallEntities db = new WallEntities(); IEnumerable <Appointment> app = _appointments.GetByUserId(PatientId); List <AppointmentNew> appoint = new List <AppointmentNew>(); foreach (var a in app) { Guid userid = new Guid(a.UserId); MembershipUser pat = Membership.GetUser(userid); AppointmentNew appnew = new AppointmentNew(); appnew._id = a._id; appnew.Address = a.Address; appnew.AppointmentsID = a.AppointmentsID; appnew.CenterName = a.CenterName; appnew.Reason = a.Reason; appnew.Date = a.Date; appnew.Time = a.Time; appnew.EncounterType = a.EncounterType; appnew.Physician = a.Physician; appnew.Patient = pat.UserName; appnew.UserId = a.UserId; appoint.Add(appnew); } //return appoint.AsEnumerable(); IEnumerable <AppointmentNew> appointnew = appoint.AsEnumerable(); return(appointnew); }
// GET api/WallPost public void GetPosts() { using (WallEntities db = new WallEntities()) { var ret = (from post in db.Posts.ToList() orderby post.PostedDate descending select new { Message = post.Message, PostedBy = post.PostedBy, PostedByName = post.UserProfile.UserName, PostedByAvatar = imgFolder + (String.IsNullOrEmpty(post.UserProfile.AvatarExt) ? defaultAvatar : post.PostedBy + "." + post.UserProfile.AvatarExt), PostedDate = post.PostedDate, PostId = post.PostId, PostComments = from comment in post.PostComments.ToList() orderby comment.CommentedDate select new { CommentedBy = comment.CommentedBy, CommentedByName = comment.UserProfile.UserName, CommentedByAvatar = imgFolder + (String.IsNullOrEmpty(comment.UserProfile.AvatarExt) ? defaultAvatar : comment.CommentedBy + "." + comment.UserProfile.AvatarExt), CommentedDate = comment.CommentedDate, CommentId = comment.CommentId, Message = comment.Message, PostId = comment.PostId } }).ToArray(); Clients.All.loadPosts(ret); } }
// // GET: /Verification/ public ActionResult Verify(string useradminid, string Useraccess) { if (Useraccess != null) { using (WallEntities db = new WallEntities()) { AuthenticationUser authuser = db.AuthenticationUsers.Where(a => a.UserAccess == Useraccess && a.UserAdmin == useradminid).FirstOrDefault(); authuser.Verification = "Verify"; db.SaveChanges(); } } return(View()); }
// POST api/WallPost public HttpResponseMessage PostPost(Post post) { using (var db = new WallEntities()) { post.PostedBy = WebSecurity.CurrentUserId; post.PostedDate = DateTime.UtcNow; ModelState.Remove("post.PostedBy"); ModelState.Remove("post.PostedDate"); if (ModelState.IsValid) { try { db.Database.Connection.Open(); db.Posts.Add(post); db.SaveChanges(); } catch (Exception e) { string err = e.Message; } var usr = db.UserProfiles.FirstOrDefault(x => x.UserId == post.PostedBy); var ret = new { Message = post.Message, PostedBy = post.PostedBy, PostedByName = usr.UserName, PostedByAvatar = imgFolder + (String.IsNullOrEmpty(usr.AvatarExt) ? defaultAvatar : post.PostedBy + "." + post.UserProfile.AvatarExt), PostedDate = post.PostedDate, PostId = post.PostId }; HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, ret); response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = post.PostId })); return(response); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } } }
public dynamic AddComment(PostComment postcomment) { postcomment.CommentedBy = WebSecurity.CurrentUserId; postcomment.CommentedDate = DateTime.UtcNow; using (WallEntities db = new WallEntities()) { db.PostComments.Add(postcomment); db.SaveChanges(); var usr = db.UserProfiles.FirstOrDefault(x => x.UserId == postcomment.CommentedBy); var ret = new { CommentedBy = postcomment.CommentedBy, CommentedByName = usr.UserName, CommentedByAvatar = imgFolder + (String.IsNullOrEmpty(usr.AvatarExt) ? defaultAvatar : postcomment.CommentedBy + "." + postcomment.UserProfile.AvatarExt), CommentedDate = postcomment.CommentedDate, CommentId = postcomment.CommentId, Message = postcomment.Message, PostId = postcomment.PostId }; Clients.Others.newComment(ret, postcomment.PostId); return(ret); } }
public void AddPost(Post post) { post.PostedBy = WebSecurity.CurrentUserId; post.PostedDate = DateTime.UtcNow; using (WallEntities db = new WallEntities()) { db.Posts.Add(post); db.SaveChanges(); var usr = db.UserProfiles.FirstOrDefault(x => x.UserId == post.PostedBy); var ret = new { Message = post.Message, PostedBy = post.PostedBy, PostedByName = usr.UserName, PostedByAvatar = imgFolder + (String.IsNullOrEmpty(usr.AvatarExt) ? defaultAvatar : post.PostedBy + "." + post.UserProfile.AvatarExt), PostedDate = post.PostedDate, PostId = post.PostId }; Clients.Caller.addPost(ret); Clients.Others.newPost(ret); } }