public void CleanupTest() { this.TestNewsContext.Database.ExecuteSqlCommand("TRUNCATE TABLE NewsStories"); this.TestNewsContext.SaveChanges(); this.TestNewsContext = null; this.testNewsStories = null; }
public void InitTest() { this.TestNewsContext = new TestDBContext(); this.testNewsStories = new List<NewsStory>() { new NewsStory() {Title = "TestNewsStory1", Content = "TestNewsStory1", PublishDate = DateTime.Now}, new NewsStory() { Title = "TestNewsStory2", Content = "TestNewsStory2", PublishDate = DateTime.Now.AddDays(-6) }, new NewsStory() { Title = "TestNewsStory3", Content = "TestNewsStory3", PublishDate = DateTime.Now.AddDays(-2) } }; foreach (NewsStory newsStory in this.testNewsStories) { this.TestNewsContext.News.Add(newsStory); } this.TestNewsContext.SaveChanges(); }
public void TestDBContext_Controller_Delete_Test() { foreach (LanguageEnum LanguageRequest in AllowableLanguages) { foreach (int ContactID in new List <int>() { AdminContactID }) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID }) { TestDBContextController testDBContextController = new TestDBContextController(DatabaseTypeEnum.SqlServerTestDB); Assert.IsNotNull(testDBContextController); Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, testDBContextController.DatabaseType); TestDBContext testDBContextLast = new TestDBContext(); using (CSSPDBContext db = new CSSPDBContext(DatabaseType)) { Query query = new Query(); query.Language = LanguageRequest; query.Asc = ""; query.Desc = ""; TestDBContextService testDBContextService = new TestDBContextService(query, db, ContactID); testDBContextLast = (from c in db.TestDBContexts select c).FirstOrDefault(); } // ok with TestDBContext info IHttpActionResult jsonRet = testDBContextController.GetTestDBContextWithID(testDBContextLast.TestDBContextID); Assert.IsNotNull(jsonRet); OkNegotiatedContentResult <TestDBContext> Ret = jsonRet as OkNegotiatedContentResult <TestDBContext>; TestDBContext testDBContextRet = Ret.Content; Assert.AreEqual(testDBContextLast.TestDBContextID, testDBContextRet.TestDBContextID); BadRequestErrorMessageResult badRequest = jsonRet as BadRequestErrorMessageResult; Assert.IsNull(badRequest); // Post to return newly added TestDBContext testDBContextRet.TestDBContextID = 0; testDBContextController.Request = new System.Net.Http.HttpRequestMessage(); testDBContextController.Request.RequestUri = new System.Uri("http://localhost:5000/api/testDBContext"); IHttpActionResult jsonRet3 = testDBContextController.Post(testDBContextRet, LanguageRequest.ToString()); Assert.IsNotNull(jsonRet3); CreatedNegotiatedContentResult <TestDBContext> testDBContextRet3 = jsonRet3 as CreatedNegotiatedContentResult <TestDBContext>; Assert.IsNotNull(testDBContextRet3); TestDBContext testDBContext = testDBContextRet3.Content; BadRequestErrorMessageResult badRequest3 = jsonRet3 as BadRequestErrorMessageResult; Assert.IsNull(badRequest3); // Delete to return success IHttpActionResult jsonRet2 = testDBContextController.Delete(testDBContextRet, LanguageRequest.ToString()); Assert.IsNotNull(jsonRet2); OkNegotiatedContentResult <TestDBContext> testDBContextRet2 = jsonRet2 as OkNegotiatedContentResult <TestDBContext>; Assert.IsNotNull(testDBContextRet2); BadRequestErrorMessageResult badRequest2 = jsonRet2 as BadRequestErrorMessageResult; Assert.IsNull(badRequest2); // Delete to return CSSPError because TestDBContextID of 0 does not exist testDBContextRet.TestDBContextID = 0; IHttpActionResult jsonRet4 = testDBContextController.Delete(testDBContextRet, LanguageRequest.ToString()); Assert.IsNotNull(jsonRet4); OkNegotiatedContentResult <TestDBContext> testDBContextRet4 = jsonRet4 as OkNegotiatedContentResult <TestDBContext>; Assert.IsNull(testDBContextRet4); BadRequestErrorMessageResult badRequest4 = jsonRet4 as BadRequestErrorMessageResult; Assert.IsNotNull(badRequest4); } } }
public ArticleService(TestDBContext context) : base(context) { _context = context; }
public QuestionsController(TestDBContext context) { this.context = context; }
public TestSuiteRepository(TestDBContext context) { _context = context; }
public Repository(TestDBContext context) { this.context = context; entities = context.Set <T>(); }
public UserDetailsController(TestDBContext context) { _context = context; }
public ObjectsWithManualExpandingController(TestDBContext database) { this.objectRepository = new ObjectRepository(database); }
public GenericService(TestDBContext context) { _context = context; _dbSet = _context.Set <T>(); }
public HomeController(TestDBContext db) { _dbContext = db; }
public DataRepository(TestDBContext _db) { db = _db; }
public void Initialize() { db = new TestDBContext(); unitOfWork = new UnitOfWork(db); userService = new UserService(unitOfWork); }
public ObjectRepository(TestDBContext database) { this.database = database; }
public PostController(ILogger <PostController> logger, TestDBContext testDBContext) { _testDBContext = testDBContext; _logger = logger; }
public CategoryService(TestDBContext context) : base(context) { _context = context; }
public RegController(TestDBContext context) { _context = context; }
public ScheduleInfoesController(SchedulerDbContext context, ILogger <HomeController> logger, ISchedulerFactory schedulerFactory, IOptions <BASE_PATHS> settings, TestDBContext testDBContext) { _context = context; JobCenter.Manager = new ScheduleManager(_context); _logger = logger; _schedulerFactory = schedulerFactory; _BASE_PATHS = settings.Value; TaskJob.BASE_PATH = _BASE_PATHS.MedicalHealth; TaskJobS1.BASE_PATH = _BASE_PATHS.MedicalHealthS1; TaskJobSY.BASE_PATH = _BASE_PATHS.MedicalHealthSY; var users = testDBContext.Users.Where(a => a.Id < 10).ToList(); foreach (var item in users) { Console.Write(item.Id.ToString() + ", " + item.DisplayName); Console.WriteLine(); } User addone = new User() { DisplayName = "Admin", CreationDate = DateTime.Now, DownVotes = 100, UpVotes = 1000 }; testDBContext.Users.Add(addone); testDBContext.SaveChanges();//自增主键在插入成功后,会自动赋值过去 var delone = testDBContext.Users.FirstOrDefault(a => a.Id == addone.Id); if (delone != null) { testDBContext.Users.Remove(delone); testDBContext.SaveChanges();//本身就是一个事务 } }
public CommonRepository(TestDBContext ObjContext) { _ObjContext = ObjContext; }
public CategoriesController(TestDBContext context, ICategoryService categoryService) { _context = context; _categoryService = categoryService; }
public object findWsInfo() { StuInfoDBContext stuContext = new StuInfoDBContext(); TestDBContext testContext = new TestDBContext(); var wsList = testContext.T_WS.Where(t => t.IsValid != 0).OrderByDescending(o => new { o.City, o.WSCompany, o.goLiveDate }).ToList(); var implementItemList = testContext.T_ImplementPersonnel.Where(t => t.IsValid != 0).ToList(); var statusItemList = testContext.T_Status.Where(t => 1 == 1).ToList(); foreach (var item in wsList) { var implementItem1 = implementItemList.Where(t => t.T_Id == item.Personnel1).FirstOrDefault(); var implementItem2 = implementItemList.Where(t => t.T_Id == item.Personnel2).FirstOrDefault(); var statusItem = statusItemList.Where(t => t.Id == item.status).FirstOrDefault(); item.Personnel1Name = implementItem1 == null ? "" : implementItem1.T_Name; item.Personnel1Email = implementItem1 == null ? "" : implementItem1.T_Email; item.Personnel1Mobile = implementItem1 == null ? "" : implementItem1.T_Mobile; item.Personnel2Name = implementItem2 == null ? "" : implementItem2.T_Name; item.Personnel2Email = implementItem2 == null ? "" : implementItem2.T_Email; item.Personnel2Mobile = implementItem2 == null ? "" : implementItem2.T_Mobile; item.statusName = statusItem == null ? "" : statusItem.name; item.sszStatus = item.researchBeginDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) <= 0 && item.goLiveDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) > 0 ? 1 : 0; item.ysxStatus = item.goLiveDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) <= 0 ? 1 : 0; item.wsxStatus = item.goLiveDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) > 0 ? 1 : 0; item.planStatus = 1; ////获取工作日 //if(DateTime.Now.ToString("yyyy-MM")== item.goLiveDate.Value.ToString("yyyy-MM")) //{ // string str1 = DateTime.Now.ToString("yyyy-MM-dd"); // string str2 = item.goLiveDate.Value.ToString("yyyy-MM-dd"); // DateTime d1 = Convert.ToDateTime(str1); // DateTime d2 = Convert.ToDateTime(str2); // DateTime d3 = Convert.ToDateTime(string.Format("{0}-{1}-{2}", d1.Year, d1.Month, d1.Day)); // DateTime d4 = Convert.ToDateTime(string.Format("{0}-{1}-{2}", d2.Year, d2.Month, d2.Day)); // int days = (d3 - d4).Days; // item.gzrCount = days; //}else //{ // item.gzrCount = 30; //} } var sszWsNumber = wsList.Where(t => t.researchBeginDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) <= 0 && t.goLiveDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) > 0).Count(); var ysxWsNumber = wsList.Where(t => t.goLiveDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) <= 0).Count(); var wsxWsNumber = wsList.Where(t => t.goLiveDate.Value.CompareTo(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd"))) > 0).Count(); var planWsNumber = wsList.Count(); //获取正式库销量数据 StringBuilder strSql = new StringBuilder(); strSql.Append(@" select a.WSID, b.WSName, (select count(0) from Bas_Customer where isnull(isvalid,1)=1 and wsid=a.wsid) as custCount, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}01'then CONVERT(char(10),a.OrderDate,120) end) as xsCount1, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}02'then CONVERT(char(10),a.OrderDate,120) end) as xsCount2, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}03'then CONVERT(char(10),a.OrderDate,120) end) as xsCount3, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}04'then CONVERT(char(10),a.OrderDate,120) end) as xsCount4, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}05'then CONVERT(char(10),a.OrderDate,120) end) as xsCount5, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}06'then CONVERT(char(10),a.OrderDate,120) end) as xsCount6, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}07'then CONVERT(char(10),a.OrderDate,120) end) as xsCount7, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}08'then CONVERT(char(10),a.OrderDate,120) end) as xsCount8, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}09'then CONVERT(char(10),a.OrderDate,120) end) as xsCount9, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}10'then CONVERT(char(10),a.OrderDate,120) end) as xsCount10, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}11'then CONVERT(char(10),a.OrderDate,120) end) as xsCount11, count(distinct case when convert(varchar(6),a.OrderDate,112)='{1}12'then CONVERT(char(10),a.OrderDate,120) end) as xsCount12 from SFA_Order_Header a left join Bas_WS b on a.WSID=b.WSID and isnull(b.isvalid,1)=1 where a.OrderType='51' and (a.status=3 or a.status=4) and a.wsid in ({0}) group by a.WSID,b.WSName "); List <string> list = new List <string>(); foreach (var item in wsList) { list.Add(item.WSID); } var whereStr = string.Join(",", list.ToArray()); string str = String.Format(strSql.ToString(), whereStr.ToString(), DateTime.Now.ToString("yyyy")); var wsinfoTemp = stuContext.Database.SqlQuery <T_WS>(str).ToList(); foreach (var item in wsList) { var wsItem = wsinfoTemp.Where(w => w.WSID == item.WSID).FirstOrDefault(); if (wsItem != null) { item.WSName = wsItem.WSName; item.custCount = wsItem.custCount; item.xsCount1Name = wsItem.xsCount1 == 0 || item.goLiveDate.Value.Month > 1 ? "-" : wsItem.xsCount1.ToString() + " / " + getDays(item.goLiveDate, 1); item.xsCount2Name = wsItem.xsCount2 == 0 || item.goLiveDate.Value.Month > 2 ? "-" : wsItem.xsCount2.ToString() + " / " + getDays(item.goLiveDate, 2); item.xsCount3Name = wsItem.xsCount3 == 0 || item.goLiveDate.Value.Month > 3 ? "-" : wsItem.xsCount3.ToString() + " / " + getDays(item.goLiveDate, 3); item.xsCount4Name = wsItem.xsCount4 == 0 || item.goLiveDate.Value.Month > 4 ? "-" : wsItem.xsCount4.ToString() + " / " + getDays(item.goLiveDate, 4); item.xsCount5Name = wsItem.xsCount5 == 0 || item.goLiveDate.Value.Month > 5 ? "-" : wsItem.xsCount5.ToString() + " / " + getDays(item.goLiveDate, 5); item.xsCount6Name = wsItem.xsCount6 == 0 || item.goLiveDate.Value.Month > 6 ? "-" : wsItem.xsCount6.ToString() + " / " + getDays(item.goLiveDate, 6); item.xsCount7Name = wsItem.xsCount7 == 0 || item.goLiveDate.Value.Month > 7 ? "-" : wsItem.xsCount7.ToString() + " / " + getDays(item.goLiveDate, 7); item.xsCount8Name = wsItem.xsCount8 == 0 || item.goLiveDate.Value.Month > 8 ? "-" : wsItem.xsCount8.ToString() + " / " + getDays(item.goLiveDate, 8); item.xsCount9Name = wsItem.xsCount9 == 0 || item.goLiveDate.Value.Month > 9 ? "-" : wsItem.xsCount9.ToString() + " / " + getDays(item.goLiveDate, 9); item.xsCount10Name = wsItem.xsCount10 == 0 || item.goLiveDate.Value.Month > 10 ? "-" : wsItem.xsCount10.ToString() + " / " + getDays(item.goLiveDate, 10); item.xsCount11Name = wsItem.xsCount11 == 0 || item.goLiveDate.Value.Month > 11 ? "-" : wsItem.xsCount11.ToString() + " / " + getDays(item.goLiveDate, 11); item.xsCount12Name = wsItem.xsCount12 == 0 || item.goLiveDate.Value.Month > 12 ? "-" : wsItem.xsCount12.ToString() + " / " + getDays(item.goLiveDate, 12); } } var obj = new { rows = wsList, sszWsNumber = sszWsNumber, ysxWsNumber = ysxWsNumber, wsxWsNumber = wsxWsNumber, planWsNumber = planWsNumber }; return(Json(obj)); }
public HomeController(TestDBContext context) { db = context; }
public MoviesController(TestDBContext context) { _context = context; }
/// <summary> /// Ctor /// </summary> /// <param name="mapper"></param> /// <param name="testDB"></param> /// <param name="encryptUtil"></param> public UserSvc(IMapper mapper, TestDBContext testDB, IEncryptUtil encryptUtil) : base(mapper, testDB) { _encryptUtil = encryptUtil; }
public ArticleTypeSvc(TestDBContext testDB, IDbContextExtendSvc dbContextExtendSvc) : base(testDB) { _dbContextExtendSvc = dbContextExtendSvc; }
public UsersController(TestDBContext context) { this.context = context; }
public RepositoryBase(TestDBContext context) { this.context = context; }
public AppUserService(TestDBContext context) : base(context) { _context = context; }
public void TestDBContext_Controller_GetTestDBContextList_Test() { foreach (LanguageEnum LanguageRequest in AllowableLanguages) { foreach (int ContactID in new List <int>() { AdminContactID }) //, TestEmailValidatedContactID, TestEmailNotValidatedContactID }) { TestDBContextController testDBContextController = new TestDBContextController(DatabaseTypeEnum.SqlServerTestDB); Assert.IsNotNull(testDBContextController); Assert.AreEqual(DatabaseTypeEnum.SqlServerTestDB, testDBContextController.DatabaseType); TestDBContext testDBContextFirst = new TestDBContext(); int count = -1; Query query = new Query(); using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB)) { TestDBContextService testDBContextService = new TestDBContextService(query, db, ContactID); testDBContextFirst = (from c in db.TestDBContexts select c).FirstOrDefault(); count = (from c in db.TestDBContexts select c).Count(); count = (query.Take > count ? count : query.Take); } // ok with TestDBContext info IHttpActionResult jsonRet = testDBContextController.GetTestDBContextList(); Assert.IsNotNull(jsonRet); OkNegotiatedContentResult <List <TestDBContext> > ret = jsonRet as OkNegotiatedContentResult <List <TestDBContext> >; Assert.AreEqual(testDBContextFirst.TestDBContextID, ret.Content[0].TestDBContextID); Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count); List <TestDBContext> testDBContextList = new List <TestDBContext>(); count = -1; query = new Query(); using (CSSPDBContext db = new CSSPDBContext(DatabaseTypeEnum.SqlServerTestDB)) { TestDBContextService testDBContextService = new TestDBContextService(query, db, ContactID); testDBContextList = (from c in db.TestDBContexts select c).OrderBy(c => c.TestDBContextID).Skip(0).Take(2).ToList(); count = (from c in db.TestDBContexts select c).Count(); } if (count > 0) { query.Skip = 0; query.Take = 5; count = (query.Take > count ? query.Take : count); // ok with TestDBContext info jsonRet = testDBContextController.GetTestDBContextList(query.Language.ToString(), query.Skip, query.Take); Assert.IsNotNull(jsonRet); ret = jsonRet as OkNegotiatedContentResult <List <TestDBContext> >; Assert.AreEqual(testDBContextList[0].TestDBContextID, ret.Content[0].TestDBContextID); Assert.AreEqual((count > query.Take ? query.Take : count), ret.Content.Count); if (count > 1) { query.Skip = 1; query.Take = 5; count = (query.Take > count ? query.Take : count); // ok with TestDBContext info IHttpActionResult jsonRet2 = testDBContextController.GetTestDBContextList(query.Language.ToString(), query.Skip, query.Take); Assert.IsNotNull(jsonRet2); OkNegotiatedContentResult <List <TestDBContext> > ret2 = jsonRet2 as OkNegotiatedContentResult <List <TestDBContext> >; Assert.AreEqual(testDBContextList[1].TestDBContextID, ret2.Content[0].TestDBContextID); Assert.AreEqual((count > query.Take ? query.Take : count), ret2.Content.Count); } } } } }
public WorksiteController(TestDBContext context) { _context = context; }
public SessionAttendeesController(TestDBContext context) { _context = context; }
public ValuesController(TestDBContext context) { _context = context; }