//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"));
}
