//This method should be used to create a new note. NoteId should be autogenerated and // must start with 101.This should create a new NotUser if not exists else should push //new note entry into existing NoteUser collection. UserId is identified by CreatedBy public bool CreateNote(Note note) { var user = context.Notes.Find(u => u.UserId == note.CreatedBy).FirstOrDefault(); if (user == null) { NoteUser noteuser = new NoteUser(); noteuser.UserId = note.CreatedBy; noteuser.Notes = new List <Note>(); note.Id = 101; note.CreationDate = DateTime.Now; noteuser.Notes.Add(note); context.Notes.InsertOne(noteuser); } else { note.Id = this.Getid(note.CreatedBy); note.CreationDate = DateTime.Now; var filter = Builders <NoteUser> .Filter.Eq(n => n.UserId, note.CreatedBy); var update = Builders <NoteUser> .Update.Push <Note>(n => n.Notes, note); context.Notes.FindOneAndUpdate(filter, update); } return(true); }
public NoteUser CreateNote(NoteUser noteUser) { FilterDefinition <NoteUser> filterDefinition = Builders <NoteUser> .Filter.Eq(user => user.UserId, noteUser.UserId); NoteUser note = _notesDbContext.Notes.Find(filterDefinition).FirstOrDefault(); if (note == null || note.Notes.Count == 0) { noteUser.Notes[0].Id = 1; } else { noteUser.Notes[0].Id = FindMaxId(noteUser.UserId) + 1; } if (note == null) { _notesDbContext.Notes.InsertOne(noteUser); return(_notesDbContext.Notes.Find(filterDefinition).FirstOrDefault()); } else { Note note1 = noteUser.Notes.FirstOrDefault(); var filter = Builders <NoteUser> .Filter.Where(ntusr => ntusr.UserId.ToLower() == noteUser.UserId.ToLower()); var update = Builders <NoteUser> .Update .Push(f => f.Notes, note1); return(_notesDbContext.Notes.FindOneAndUpdate(filter, update)); } }
public ActionResult EditProfile(NoteUser model, HttpPostedFileBase ProfileImage) { ModelState.Remove("ModifiedUsername");//istemediğimiz özelliği kaldırabiliriz. if (ModelState.IsValid) { if (ProfileImage != null && (ProfileImage.ContentType == "image/jpeg" || ProfileImage.ContentType == "image/jpg" || ProfileImage.ContentType == "image/png")) { string fileName = $"user_{model.Id}.{ProfileImage.ContentType.Split('/')[1]}"; ProfileImage.SaveAs(Server.MapPath($"~/img/{fileName}")); model.ProfileImageFilename = fileName; } LayerResult <NoteUser> res = um.UpdateProfile(model); if (res.Errors.Count > 0) { ErrorViewModel evm = new ErrorViewModel() { Title = "Hata oluştu..", Items = res.Errors, RedirectingUrl = "/Home/EditProfile" }; return(View("Error", evm)); } CurrentSession.Set <NoteUser>("login", res.Result); return(RedirectToAction("ShowProfile")); } return(View(model)); }
public void PostShouldReturnCreated() { string userId = "Mukesh"; var note = this.GetNote(); //var noteUser = new NoteUser {UserId="Mukesh", Notes=this.GetNotes() }; var mockService = new Mock <INoteService>(); NoteUser noteUser = new NoteUser(); noteUser.UserId = userId; noteUser.Notes = new List <Note>(); noteUser.Notes.Add(note); mockService.Setup(svc => svc.CreateNote(noteUser)).Throws(new Exception("Rajesh")); //mockService.Setup(svc => svc.GetAllNotes(noteUser.UserId)).Returns(this.GetNotes()); var controller = new NotesController(mockService.Object); var actual = controller.Post(userId, note); var actionResult = Assert.IsType <OkObjectResult>(actual); Assert.IsAssignableFrom <Note>(actionResult.Value); }
public void PutShouldReturnOk() { int noteId = 101; string userId = "Mukesh"; Note note = new Note(); note.Id = 101; note.Title = "IPL 2018"; note.Content = "Mumbai Indians vs RCB match scheduled for 4 PM is cancelled"; note.Category = this.GetCategory(); note.Reminders = this.GetReminder(); note.CreatedBy = "Mukesh"; note.CreationDate = new DateTime(); var noteUser = new NoteUser { UserId = "Mukesh", Notes = this.GetNotes() }; var mockService = new Mock <INoteService>(); mockService.Setup(svc => svc.UpdateNote(noteId, userId, note)).Returns(noteUser); var controller = new NotesController(mockService.Object); var actual = controller.Put(noteId, userId, note); var actionResult = Assert.IsType <OkObjectResult>(actual); Assert.IsAssignableFrom <Note>(actionResult.Value); }
public async Task <ActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { var user = new ApplicationUser { UserName = model.Email, Email = model.Email }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false); NoteUser userCreate = new NoteUser(); userCreate.NickName = model.NickName; userCreate.Email = model.Email; userCreate.ImageAddress = model.ImageAddress; // For more information on how to enable account confirmation and password reset please visit https://go.microsoft.com/fwlink/?LinkID=320771 // Send an email with this link // string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id); // var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme); // await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>"); userContext.Insert(userCreate); userContext.Commit(); return(RedirectToAction("Index", "Home")); } AddErrors(result); } // If we got this far, something failed, redisplay form return(View(model)); }
public void UpdateNoteShouldReturnNoteUser() { //var note = this.GetNote(); var noteUser = new NoteUser { UserId = "Mukesh", Notes = this.GetNotes() }; int noteId = 101; string userId = "Mukesh"; Note note = new Note(); note.Id = 101; note.Title = "IPL 2018"; note.Content = "Mumbai Indians vs RCB match scheduled for 4 PM is cancelled"; note.Category = this.GetCategory(); note.Reminders = this.GetReminder(); note.CreatedBy = "Mukesh"; note.CreationDate = new DateTime(); var mockRepo = new Mock <INoteRepository>(); mockRepo.Setup(repo => repo.UpdateNote(noteId, userId, note)).Returns(noteUser); var service = new API.Service.NoteService(mockRepo.Object); var actual = service.UpdateNote(noteId, userId, note); Assert.NotNull(actual); Assert.IsAssignableFrom <NoteUser>(actual); }
public void DeleteTest() { NoteUser noteUser = repo_user.Find(x => x.UserName == "Burçin"); if (noteUser != null) { repo_user.Delete(noteUser); } }
//This method should be used to create a new note. NoteId should be autogenerated and // must start with 101.This should create a new NotUser if not exists else should push //new note entry into existing NoteUser collection. UserId is identified by CreatedBy public bool CreateNote(Note note) { bool status = false; try { var NoteVal = context.Notes.Find(f => f.UserId == note.CreatedBy).FirstOrDefault(); Note latestNotes = null; if (NoteVal != null) { latestNotes = NoteVal.Notes.OrderByDescending(o => o.Id).FirstOrDefault(); } var id = 101; if (latestNotes != null) { id = latestNotes.Id + 1; } var userExists = context.Notes.Find(N => N.UserId == note.CreatedBy).FirstOrDefault(); if (userExists == null || userExists.Notes.Count() == 0) { List <Note> NoteList = new List <Note>(); note.Id = id; note.CreationDate = DateTime.Now; NoteList.Add(note); var noteuser = new NoteUser { UserId = note.CreatedBy, Notes = NoteList }; context.Notes.InsertOne(noteuser); status = true; } else { var existingNotes = userExists.Notes; note.Id = id; note.CreationDate = DateTime.Now; existingNotes.Add(note); var filter = Builders <NoteUser> .Filter.Where(C => C.UserId == userExists.UserId); var update = Builders <NoteUser> .Update.Set(S => S.Notes, existingNotes); var updateResult = context.Notes.UpdateOne(filter, update); status = updateResult.IsAcknowledged == true ? true : false; } return(status); } catch (Exception ex) { } return(status); }
public void UpdateTest() { NoteUser noteUser = repo_user.Find(x => x.UserName == "Burçin"); if (noteUser != null) { noteUser.UserName = "******"; //repo_user.Update(); } }
public NoteUser CreateNote(NoteUser noteUser) { var result = _notesRepository.CreateNote(noteUser); if (result == null) { throw new NoteNotFoundExeption("This category id already exists"); } return(result); }
public ActionResult Delete(int?Id) { if (Id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } noteUser = um.Find(x => x.Id == Id); if (noteUser == null) { return(HttpNotFound()); } return(View(noteUser)); }
public string GetUsername() { NoteUser user = CurrentSession.user; if (user != null) { return(user.UserName); } else { return("_system"); } }
/// <summary> /// 관리자 개인 쪽지 보내기 /// </summary> /// <param name="progCode">프로그램코드</param> /// <param name="subClassCode">서브클래스코드</param> /// <param name="comment">쪽지내용</param> /// <param name="progImg">프로그램Img</param> /// <param name="al">받는사용자정보들</param> /// <returns>성공여부</returns> public bool RegisterAdminNoteInfo(string progCode, string subClassCode, string comment, string progImg, ArrayList al) { // comment = "<table cellspacing=0 cellpadding=0><tr><td><img src='http://mini1.imbc.com/manager/upload/RAMFM300/bcs.jpg'></td><td>" + comment + "</td></tr></table>"; // SqlConnection conn = DbConnection.DbCon; SqlConnection conn = DbConnection.DbCon; SQLHelper.OpenConnection(conn); SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandText = "RegisterAdminNoteInfo"; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@progCode", SqlDbType.VarChar, 13).Value = progCode; sqlCmd.Parameters.Add("@comment", SqlDbType.Text).Value = comment; sqlCmd.Parameters.Add("@progImg", SqlDbType.VarChar, 255).Value = progImg; int noteID = SQLHelper.ExecuteScalarRetInt(conn, sqlCmd); sqlCmd = new SqlCommand(); sqlCmd.CommandText = "ReigsterUserNoteInfo"; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@noteID", SqlDbType.Int).Value = noteID; sqlCmd.Parameters.Add("@uno", SqlDbType.Int); sqlCmd.Parameters.Add("@userID", SqlDbType.VarChar, 30); sqlCmd.Parameters.Add("@userNm", SqlDbType.VarChar, 30); string userID = ""; for (int i = 0; i < al.Count; i++) { NoteUser user = (NoteUser)al[i]; sqlCmd.Parameters["@uno"].Value = user.uno; sqlCmd.Parameters["@userID"].Value = user.userID; sqlCmd.Parameters["@userNm"].Value = user.userNm; SQLHelper.ExecuteNonQuery(conn, sqlCmd); userID += user.userID + (char)9; } SQLHelper.CloseConnection(conn); EncoderUtils.EncScriptSender enc = new EncoderUtils.EncScriptSender(); // enc.SendScript("211.233.27.178", 7000, "0002", subClassCode, "http://mini.imbc.com/UserNote/RetrieveUserNoteInfo.aspx?noteID=" + noteID, " ", " ", userID); enc.SendScript("relay2.imbc.com", 7000, "0002", subClassCode, "http://mini.imbc.com/UserNote/RetrieveUserNoteInfo.aspx?noteID=" + noteID, " ", " ", userID); return(true); }
protected void btnSave_Click(object sender, System.EventArgs e) { NoteUser user = new NoteUser(); user.uno = uInfo.Uno; user.userID = uInfo.UserID; user.userNm = uInfo.UserName; NoteData data = new NoteData(); data.RegisterUserReplyNoteInfo(this.noteID, note.progCode, user, txtComment.Text); JS.AlertCommand("쪽지주셔서 감사합니다.", "document.location.href='EVENT:CLOSE';"); }
protected void btnSend_Click(object sender, System.EventArgs e) { NoteUser user = new NoteUser(); user.uno = uInfo.Uno; user.userID = uInfo.UserID; user.userNm = uInfo.UserName; NoteData data = new NoteData(); data.RegisterUserReplyNoteInfo(this.noteID, this.progCode, user, comment.Text); JS.AlertCommand("쪽지를 보냈습니다.", "opener.location.reload(); window.close();"); }
public void CreateNoteShouldReturnNoteUser() { var note = new NoteUser { UserId = "Mukesh", Notes = this.GetNotes() }; var mockRepo = new Mock <INoteRepository>(); mockRepo.Setup(repo => repo.CreateNote(note)).Returns(note); var service = new API.Service.NoteService(mockRepo.Object); var actual = service.CreateNote(note); Assert.NotNull(actual); Assert.IsAssignableFrom <NoteUser>(actual); }
public void CommentTest() { NoteUser noteUser = repo_user.Find(x => x.Id == 2); Note note = repo_note.Find(x => x.Id == 2); Comment comment = new Comment() { Text = "Bu bir testtir.", CreatedOn = DateTime.Now, ModifiedOn = DateTime.Now, ModifiedUsername = "******", Note = note, NoteUser = noteUser }; repo_comment.Insert(comment); }
/// <summary> /// 사용자 답변쪽지 보내기 /// </summary> /// <param name="noteID">쪽지ID</param> /// <param name="progCode"></param> /// <param name="user"></param> /// <param name="comment"></param> /// <returns></returns> public bool RegisterUserReplyNoteInfo(int noteID, string progCode, NoteUser user, string comment) { SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandText = "RegisterUserReplyNoteInfo"; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@noteID", SqlDbType.Int).Value = noteID; sqlCmd.Parameters.Add("@progCode", SqlDbType.VarChar, 13).Value = progCode; sqlCmd.Parameters.Add("@uno", SqlDbType.Int).Value = user.uno; sqlCmd.Parameters.Add("@userID", SqlDbType.VarChar, 30).Value = user.userID; sqlCmd.Parameters.Add("@userNm", SqlDbType.VarChar, 30).Value = user.userNm; sqlCmd.Parameters.Add("@comment", SqlDbType.Text).Value = comment; return(SQLHelper.ExecuteNonQuery(sqlCmd)); }
public void CreateNoteShouldReturnNoteUser() { var noteUser = new NoteUser { UserId = "Mukesh", Notes = this.GetNotes() }; var actual = repository.CreateNote(noteUser); Assert.NotNull(actual); Assert.IsAssignableFrom <NoteUser>(actual); //List<Note> notes = repository.FindByUserId("Mukesh"); //var note = notes.Where(n => n.Id == 101).FirstOrDefault(); //Assert.NotNull(notes); }
public ActionResult Edit(NoteUser noteUser) { ModelState.Remove("CreatedOn"); ModelState.Remove("ModifiedOn"); ModelState.Remove("ModifiedUsername"); if (ModelState.IsValid) { LayerResult <NoteUser> res = um.Update(noteUser); if (res.Errors.Count > 0) { res.Errors.ForEach(x => ModelState.AddModelError("", x.Message)); return(View(noteUser)); } return(RedirectToAction("Index")); } return(View(noteUser)); }
public void AddNoteShouldReturnNoteUser() { var note = this.GetNote(); var noteUser = new NoteUser { UserId = "Mukesh", Notes = this.GetNotes() }; int noteId = 101; string userId = "Mukesh"; var mockRepo = new Mock <INoteRepository>(); mockRepo.Setup(repo => repo.UpdateNote(noteId, userId, note)).Returns(noteUser); var service = new API.Service.NoteService(mockRepo.Object); var actual = service.AddNote(userId, note); Assert.NotNull(actual); Assert.IsAssignableFrom <NoteUser>(actual); }
public ActionResult Create(NoteViewModel n) { if (!ModelState.IsValid) { return(View(n)); } else { NoteUser noteUser = userContext.Collections().FirstOrDefault(i => i.Email == User.Identity.Name); n.note.UserEmail = User.Identity.Name; n.note.dateModified = n.note.createdAt; noteContext.Insert(n.note); noteContext.Commit(); return(RedirectToAction("Index")); } }
public BusinessLayerResult <NoteUser> RegisterUser(RegisterViewModel data) { //Kullanıcı Username kontrolü.. //Kullanıcı eposta kontrolü.. //kayıt işlemi //aktivasyon epostası gönderimi NoteUser user = repo_user.Find(x => x.UserName == data.Username || x.Email == data.Email); BusinessLayerResult <NoteUser> layerResult = new BusinessLayerResult <NoteUser>(); if (user != null) { if (user.UserName == data.Username) { layerResult.Errors.Add("Kullanıcı adı kayıtlı."); } if (user.Email == data.Email) { layerResult.Errors.Add("Eposta adresi kayıtlı."); } } else { int dbResult = repo_user.Insert(new NoteUser() { UserName = data.Username, Email = data.Email, Password = data.Password, ActivateGuid = Guid.NewGuid(), IsActive = false, IsAdmin = false }); if (dbResult > 0) { layerResult.Result = repo_user.Find(x => x.Email == data.Email && x.UserName == data.Username); //layerResult.Act } } return(layerResult); }
public async Task <IActionResult> OnPostAsync() { if (ModelState.IsValid) { var user = new NoteUser { UserName = Register.UserName, Email = Register.Email }; var result = await _userManager.CreateAsync(user, Register.Password); if (result.Succeeded) { return(RedirectToPage("Login")); } foreach (var error in result.Errors) { ModelState.AddModelError("", error.Description); } } return(Page()); }
public async Task <IActionResult> Register(RegisterViewModel model) { if (ModelState.IsValid) { var user = new NoteUser { UserName = model.UserName, Email = model.Email }; var result = await UserManager.CreateAsync(user, model.Password); if (result.Succeeded) { _logger.LogInformation("User {userName} was created.", model.Email); return(RedirectToAction("Login")); } foreach (var error in result.Errors) { ModelState.AddModelError("", error.Description); } } return(View(model)); }
private ArrayList getUser() { string[] arrReceiver = receiver.Split(','); ArrayList al = new ArrayList(); NoteUser user; for (int i = 0; i < arrReceiver.Length; i++) { string[] arrRec = arrReceiver[i].Split('│'); user = new NoteUser(); user.uno = int.Parse(arrRec[0]); user.userID = arrRec[1]; user.userNm = arrRec[2]; al.Add(user); } return(al); }
public IActionResult Post(string userId, [FromBody] Note note) { try { if (userId != null && userId.Length > 0 && note != null) { NoteUser noteUser = new NoteUser(); noteUser.UserId = userId; noteUser.Notes = new List <Note>(); noteUser.Notes.Add(note); return(Ok(service.CreateNote(noteUser).Notes)); } else { return(StatusCode((int)HttpStatusCode.BadRequest)); } } catch (Exception ex) { return(StatusCode((int)HttpStatusCode.InternalServerError, ServerError)); } }
private void InitData(IServiceProvider serviceProvider) { using (var serviceScope = serviceProvider.GetRequiredService <IServiceScopeFactory>().CreateScope()) { //获取注入的NoteContext var context = serviceScope.ServiceProvider.GetRequiredService <NoteContext>(); context.Database.EnsureCreated(); //如果数据库不存在则创建,存在则不做操作 if (!context.NoteTypes.Any()) //不存在类型则添加 { var notetypes = new List <NoteType> { new NoteType { Name = "日常记录" }, new NoteType { Name = "代码收藏" }, new NoteType { Name = "消费记录" }, new NoteType { Name = "网站收藏" } }; context.NoteTypes.AddRange(notetypes); context.SaveChanges(); } if (!context.Users.Any()) //不存在用户,默认添加admin用户 { var userManager = serviceScope.ServiceProvider.GetRequiredService <UserManager <NoteUser> >(); var noteUser = new NoteUser { UserName = "******", Email = "*****@*****.**" }; userManager.CreateAsync(noteUser, "admin123").Wait(); } } }
public ActionResult DeleteConfirmed(int Id) { noteUser = um.Find(x => x.Id == Id); um.Delete(noteUser); return(RedirectToAction("Index")); }