public void AddTest()
{
Notebook notebook1 = new Notebook()
{
NotebookId = SnowFlake_Net.GenerateSnowFlakeID()
};
Notebook notebook2 = new Notebook()
{
NotebookId = SnowFlake_Net.GenerateSnowFlakeID()
};
Notebook notebook3 = new Notebook()
{
NotebookId = SnowFlake_Net.GenerateSnowFlakeID()
};
notebook2.ParentNotebookId = notebook1.NotebookId;
notebook3.ParentNotebookId = notebook1.NotebookId;
NotebookService.AddNotebook(notebook1);
NotebookService.AddNotebook(notebook2);
NotebookService.AddNotebook(notebook3);
// Assert.Fail();
}
public void NotebookService_Should_return_Notebook_After_Initialization(string text)
{
var mockedRepository = new Mock <INotebooksRepository>();
mockedRepository.Setup(r => r.Find(It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>()))
.Returns(
new Notebook()
{
Id = 0,
Content = text,
Subject = text,
Type = text,
Username = text
});
var mockedUnitOfWork = new Mock <IUnitOfWork>();
mockedUnitOfWork.Setup(u => u.Commit());
var mockedDbContext = new Mock <INotebookDbContext>();
var service = new NotebookService(mockedRepository.Object, mockedUnitOfWork.Object, new MockedDbContext());
service.Initialize();
Assert.IsInstanceOf <Notebook>(service.Notebook);
}
//todo:删除笔记本
public IActionResult DeleteNotebook(string token, string notebookId, int usn)
{
User user = TokenSerivce.GetUserByToken(token);
if (user == null)
{
ApiRe apiRe = new ApiRe()
{
Ok = false,
Msg = "Not logged in",
};
return(Json(apiRe, MyJsonConvert.GetOptions()));
}
if (NotebookService.DeleteNotebookForce(user.UserId, MyConvert.HexToLong(notebookId), usn))
{
ApiRe apiRe = new ApiRe()
{
Ok = true,
Msg = "success",
};
return(Json(apiRe, MyJsonConvert.GetOptions()));
}
else
{
ApiRe apiRe = new ApiRe()
{
Ok = false,
Msg = "conflict",
};
return(Json(apiRe, MyJsonConvert.GetOptions()));
}
}
public RemoteFileController(AttachService attachService
, TokenSerivce tokenSerivce
, NoteFileService noteFileService
, UserService userService
, ConfigFileService configFileService
, IHttpContextAccessor accessor
, AccessService accessService
, ConfigService configService
, TagService tagService
, NoteService noteService
, NotebookService notebookService
, IWebHostEnvironment webHostEnvironment
, ISevenZipCompressor sevenZipCompressor
, BlogService blogService
) :
base(attachService, tokenSerivce, noteFileService, userService, configFileService, accessor)
{
this.accessService = accessService;
this.blogService = blogService;
this.configService = configService;
this.tagService = tagService;
this.notebookService = notebookService;
this.noteService = noteService;
this.HostEnvironment = webHostEnvironment;
this.SevenZipCompressor = sevenZipCompressor;
if (RuntimeEnvironment.IsWindows)
{
PathRoot = @"C:\";
}
}
public void NotebookService_Should_Call_Commit_When_SaveContent(string text)
{
var mockedRepository = new Mock <INotebooksRepository>();
mockedRepository.Setup(r => r.Find(It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>()))
.Returns(
new Notebook()
{
Id = 0,
Content = text,
Subject = text,
Type = text,
Username = text
});
mockedRepository.Setup(r => r.Update(It.IsAny <Notebook>(), It.IsAny <string>()));
var mockedUnitOfWork = new Mock <IUnitOfWork>();
mockedUnitOfWork.Setup(u => u.Commit());
var mockedDbContext = new Mock <INotebookDbContext>();
var service = new NotebookService(mockedRepository.Object, mockedUnitOfWork.Object, new MockedDbContext());
service.Initialize();
service.SaveContent(text);
mockedUnitOfWork.Verify(u => u.Commit(), Times.AtLeast(2));
}
public void NotebookService_Should_Get_Content_When_Call_GetContent(string text)
{
var mockedRepository = new Mock <INotebooksRepository>();
mockedRepository.Setup(r => r.Find(It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>()))
.Returns(
new Notebook()
{
Id = 0,
Content = text,
Subject = text,
Type = text,
Username = text
});
var mockedUnitOfWork = new Mock <IUnitOfWork>();
mockedUnitOfWork.Setup(u => u.Commit());
var mockedDbContext = new Mock <INotebookDbContext>();
var service = new NotebookService(mockedRepository.Object, mockedUnitOfWork.Object, new MockedDbContext());
service.Initialize();
Assert.AreEqual(text, service.GetContent());
}
public NoteAPIController(AttachService attachService
, TokenSerivce tokenSerivce
, NoteFileService noteFileService
, UserService userService
, ConfigFileService configFileService
, IHttpContextAccessor accessor,
NoteService noteService,
NoteContentService noteContentService,
NotebookService notebookService,
NoteRepositoryService noteRepositoryService,
TrashService trashService,
EPassService ePass,
GMService gMService,
DataSignService dataSignService
) :
base(attachService, tokenSerivce, noteFileService, userService, configFileService, accessor)
{
this.attachService = attachService;
this.noteService = noteService;
this.tokenSerivce = tokenSerivce;
this.noteContentService = noteContentService;
this.trashService = trashService;
this.accessor = accessor;
this.notebookService = notebookService;
this.noteRepositoryService = noteRepositoryService;
this.ePassService = ePass;
this.dataSignService = dataSignService;
this.gMService = gMService;
}
//修改笔记
public IActionResult UpdateNotebook(string token, string notebookId, string title, string parentNotebookId, int seq, int usn)
{
User user = TokenSerivce.GetUserByToken(token);
if (user == null)
{
ApiRe apiRe = new ApiRe()
{
Ok = false,
Msg = "Not logged in",
};
return(Json(apiRe, MyJsonConvert.GetOptions()));
}
else
{
Notebook notebook;
if (NotebookService.UpdateNotebookApi(user.UserId, MyConvert.HexToLong(notebookId), title, MyConvert.HexToLong(parentNotebookId), seq, usn, out notebook))
{
ApiNotebook apiNotebook = fixNotebook(notebook);
return(Json(apiNotebook, MyJsonConvert.GetOptions()));
}
else
{
ApiRe apiRe = new ApiRe()
{
Ok = false,
Msg = "UpdateNotebook is error",
};
return(Json(apiRe, MyJsonConvert.GetOptions()));
}
}
}
private void InsertALL(Notebook notebook)
{
NotebookService.AddNotebook(notebook);
foreach (Notebook n in notebook.Subs)
{
InsertALL(n);
}
}
public void GetNoteBookTreeTest()
{
Notebook[] notebooks = NotebookService.GetNoteBookTree(1208692382644703232);
string json = JsonSerializer.Serialize(notebooks, MyJsonConvert.GetOptions());
Console.WriteLine(json);
// Assert.Fail();
}
public IActionResult GetNotebooks()
{
long userid = 1208692382644703232;
Notebook[] noteBoooks = NotebookService.GetNoteBookTree(userid);
string json = JsonSerializer.Serialize(noteBoooks, MyJsonConvert.GetOptions());
return(Content(json));
}
public void NotebookService_Should_ReturnNull_When_Try_To_Get_Notebook_Before_Initialization()
{
var mockedRepository = new Mock <INotebooksRepository>();
var mockedUnitOfWork = new Mock <IUnitOfWork>();
var mockedDbContext = new Mock <INotebookDbContext>();
var service = new NotebookService(mockedRepository.Object, mockedUnitOfWork.Object, new MockedDbContext());
Assert.AreEqual(null, service.Notebook);
}
public void NotebookService_Should_Throw_When_Try_To_Get_Content_Before_Initialization()
{
var mockedRepository = new Mock <INotebooksRepository>();
var mockedUnitOfWork = new Mock <IUnitOfWork>();
var mockedDbContext = new Mock <INotebookDbContext>();
var service = new NotebookService(mockedRepository.Object, mockedUnitOfWork.Object, new MockedDbContext());
Assert.Throws <NullReferenceException>(() => service.GetContent());
}
public void NotebookService_Constructor_Should_Construct_Object_Successfully()
{
var mockedRepository = new Mock <INotebooksRepository>();
var mockedUnitOfWork = new Mock <IUnitOfWork>();
var mockedDbContext = new Mock <INotebookDbContext>();
var service = new NotebookService(mockedRepository.Object, mockedUnitOfWork.Object, new MockedDbContext());
Assert.IsInstanceOf <NotebookService>(service);
}
public void NotebookService_Should_Set_Subject_Type(string type)
{
var mockedRepository = new Mock <INotebooksRepository>();
var mockedUnitOfWork = new Mock <IUnitOfWork>();
var mockedDbContext = new Mock <INotebookDbContext>();
var service = new NotebookService(mockedRepository.Object, mockedUnitOfWork.Object, new MockedDbContext());
service.Type = type;
Assert.AreEqual(type, service.Type);
}
public NoteBookController(AttachService attachService
, TokenSerivce tokenSerivce
, NoteFileService noteFileService
, UserService userService
, ConfigFileService configFileService
, IHttpContextAccessor accessor,
NotebookService notebookService
) :
base(attachService, tokenSerivce, noteFileService, userService, configFileService, accessor)
{
this.notebookService = notebookService;
}
public void NotebookService_Should_Set_Subject_Successfully(string subject)
{
var mockedRepository = new Mock <INotebooksRepository>();
var mockedUnitOfWork = new Mock <IUnitOfWork>();
var mockedDbContext = new Mock <INotebookDbContext>();
var service = new NotebookService(mockedRepository.Object, mockedUnitOfWork.Object, new MockedDbContext());
service.Subject = subject;
Assert.AreEqual(subject, service.Subject);
}
public void NotebookService_Should_Set_Username_Successfully(string username)
{
var mockedRepository = new Mock <INotebooksRepository>();
var mockedUnitOfWork = new Mock <IUnitOfWork>();
var mockedDbContext = new Mock <INotebookDbContext>();
var service = new NotebookService(mockedRepository.Object, mockedUnitOfWork.Object, new MockedDbContext());
service.Username = username;
Assert.AreEqual(username, service.Username);
}
public void NotebookService_Repo_Should_Call_SetContext()
{
var mockedRepository = new Mock <INotebooksRepository>();
mockedRepository.Setup(r => r.setNotebookDbContext(It.IsAny <INotebookDbContext>()));
var mockedUnitOfWork = new Mock <IUnitOfWork>();
var mockedDbContext = new MockedDbContext();
var service = new NotebookService(mockedRepository.Object, mockedUnitOfWork.Object, mockedDbContext);
mockedRepository.Verify(r => r.setNotebookDbContext(It.IsAny <INotebookDbContext>()), Times.Once);
}
public static void FillTestSummaries(ref NotebookService s)
{
List <TestSummary> _testSummaries = null;
_testSummaries = HttpRuntime.Cache.Get(CacheKey) as List <TestSummary>;
int id = s.TicketRequestID_API;
int id2 = s.TicketRequestID_UI;
if (_testSummaries == null)
{
_testSummaries = new List <TestSummary>();
SqlConnection _conn = null;
using (
_conn =
new SqlConnection(
"Data Source=auto-test-data;Initial Catalog=TestAutomation;Persist Security Info=True;User ID=sa;Password=Kr0ken!;Pooling=True")
)
{
_conn.Open();
var command = _conn.CreateCommand();
command.CommandType = CommandType.Text;
command.CommandText = "select t.ticketid, startdate, tests, passed,t.ticketrequestid,ignored,tsv.version from [TestAutomation].[dbo].[TicketStatusView] tsv, [TestAutomation].[dbo].[Ticket] t where tsv.Tests = tsv.Finished and t.ticketid = tsv.ticketid and t.TicketRequestID in (1089,1090,1091,1093,1094,1095,1472,1473,1474,1475,1476,1477,2214,2215 ) order by ticketid desc";
var reader = command.ExecuteReader();
while (reader.Read())
{
var t = new TestSummary {
Executed = reader.GetDateTime(1), Passed = reader.GetInt32(3)
};
t.TicketID = (int)reader.GetFieldValue <long>(0);
t.NotPassed = reader.GetInt32(2) - t.Passed - reader.GetInt32(5);
t.TicketRequestID = (int)reader.GetFieldValue <long>(4);
t.DetailsUri = string.Format("http://auto-test-data/report/Report.aspx?TicketIDs={0}&Details=true&SortExpr=Failcount desc", t.TicketID);
t.Build = !reader.IsDBNull(6) ? reader.GetString(6) : "(unknown)";
_testSummaries.Add(t);
}
reader.Close();
_conn.Close();
}
HttpRuntime.Cache.Add(CacheKey, _testSummaries, null, DateTime.Now.AddHours(4), Cache.NoSlidingExpiration,
CacheItemPriority.Default, null);
}
s.APITestSummaries = _testSummaries.FindAll(m => m.TicketRequestID == id);
s.UITestSummaries = _testSummaries.FindAll(m => m.TicketRequestID == id2);
}
public OrganizationController(AttachService attachService
, TokenSerivce tokenSerivce
, NoteFileService noteFileService
, UserService userService
, ConfigFileService configFileService
, IHttpContextAccessor accessor,
NotebookService notebookService,
OrganizationService organizationService,
NoteRepositoryService noteRepositoryService
) :
base(attachService, tokenSerivce, noteFileService, userService, configFileService, accessor)
{
this.organizationService = organizationService;
}
public IActionResult Note()
{
ViewBag.msg = LanguageResource.GetMsg();
Dictionary <string, string> js = new Dictionary <string, string>();
long userid = 1208692382644703232;
Notebook[] noteBoooks = NotebookService.GetNoteBookTree(userid);
string json = JsonSerializer.Serialize(noteBoooks, MyJsonConvert.GetOptions());
//json = System.IO.File.ReadAllText(@"E:\Project\JSON\notebook\GetNotebooks.json");
js.Add("notebooks", json);
ViewBag.js = js;
return(View());
}
//获取同步的笔记本
//[HttpPost]
public JsonResult GetSyncNotebooks(string token, int afterUsn, int maxEntry)
{
User user = TokenSerivce.GetUserByToken(token);
if (user == null)
{
ApiRe apiRe = new ApiRe()
{
Ok = false,
Msg = "Not logged in",
};
return(Json(apiRe, MyJsonConvert.GetOptions()));
}
Notebook[] notebook = NotebookService.GeSyncNotebooks(user.UserId, afterUsn, maxEntry);
return(Json(notebook, MyJsonConvert.GetOptions()));
}
public NotesRepositoryController(AttachService attachService
, TokenSerivce tokenSerivce
, NoteFileService noteFileService
, UserService userService
, ConfigFileService configFileService
, IHttpContextAccessor accessor,
NotebookService notebookService,
NoteRepositoryService noteRepositoryService,
OrganizationService organizationService,
EPassService ePassService,
DataSignService dataSignService
) :
base(attachService, tokenSerivce, noteFileService, userService, configFileService, accessor)
{
this.notebookService = notebookService;
this.noteRepositoryService = noteRepositoryService;
this.ePassService = ePassService;
this.dataSignService = dataSignService;
}
//添加notebook
public IActionResult AddNotebook(string token, string title, string parentNotebookId, int seq)
{
User user = TokenSerivce.GetUserByToken(token);
if (user == null)
{
ApiRe apiRe = new ApiRe()
{
Ok = false,
Msg = "Not logged in",
};
return(Json(apiRe, MyJsonConvert.GetOptions()));
}
else
{
Notebook notebook = new Notebook()
{
NotebookId = SnowFlake_Net.GenerateSnowFlakeID(),
Title = title,
Seq = seq,
UserId = user.UserId,
ParentNotebookId = MyConvert.HexToLong(parentNotebookId)
};
if (NotebookService.AddNotebook(ref notebook))
{
ApiNotebook apiNotebook = fixNotebook(notebook);
return(Json(apiNotebook, MyJsonConvert.GetOptions()));
}
else
{
ApiRe apiRe = new ApiRe()
{
Ok = false,
Msg = "AddNotebook is error",
};
return(Json(apiRe, MyJsonConvert.GetOptions()));
}
}
}
public CommonController(AttachService attachService
, TokenSerivce tokenSerivce
, NoteFileService noteFileService
, UserService userService
, ConfigFileService configFileService
, IHttpContextAccessor accessor,
NoteService noteService,
NoteContentService noteContentService,
NotebookService notebookService,
NoteRepositoryService noteRepositoryService,
TrashService trashService
) :
base(attachService, tokenSerivce, noteFileService, userService, configFileService, accessor)
{
this.attachService = attachService;
this.noteService = noteService;
this.tokenSerivce = tokenSerivce;
this.noteContentService = noteContentService;
this.trashService = trashService;
this.accessor = accessor;
this.notebookService = notebookService;
this.noteRepositoryService = noteRepositoryService;
}
public NoteController(AttachService attachService
, TokenSerivce tokenSerivce
, NoteFileService noteFileService
, UserService userService
, ShareService shareService
, ConfigFileService configFileService
, IWebHostEnvironment env
, TagService tagService
, TrashService trashService
, IHttpContextAccessor accessor
, NotebookService notebookService
, NoteService noteService
, NoteContentService noteContentService
) :
base(attachService, tokenSerivce, noteFileService, userService, configFileService, accessor)
{
this.notebookService = notebookService;
this.noteService = noteService;
this.noteContentService = noteContentService;
this.env = env;
this.tagService = tagService;
this.trashService = trashService;
}
//得到用户的所有笔记本
public IActionResult GetNotebooks(string token)
{
User user = TokenSerivce.GetUserByToken(token);
if (user == null)
{
ApiRe apiRe = new ApiRe()
{
Ok = false,
Msg = "Not logged in",
};
return(Json(apiRe, MyJsonConvert.GetOptions()));
}
else
{
Notebook[] notebooks = NotebookService.GetAll(user.UserId);
ApiNotebook[] apiNotebooks = fixNotebooks(notebooks);
return(Json(apiNotebooks, MyJsonConvert.GetOptions()));
}
return(null);
}
public BlogController(AttachService attachService
, TokenSerivce tokenSerivce
, NoteFileService noteFileService
, UserService userService
, ConfigFileService configFileService
, IHttpContextAccessor accessor
, AccessService accessService
, ConfigService configService
, TagService tagService
, NoteService noteService
, NotebookService notebookService
, BlogService blogService
, NoteRepositoryService noteRepository
) :
base(attachService, tokenSerivce, noteFileService, userService, configFileService, accessor)
{
this.accessService = accessService;
this.blogService = blogService;
this.configService = configService;
this.tagService = tagService;
this.notebookService = notebookService;
this.noteService = noteService;
this.noteRepository = noteRepository;
}
public NotebookCommentController(SchoolNotebookContext context)
{
_context = context;
_notebookService = new NotebookService(_context);
}
