public FindController( IPaginatedMetaService paginatedMetaService, WebDbContext Context, IAddresServices Address, WebEventoo_DomainClasses.Services.IExhibitionServices Cermoney, IColorService Color, ICommentService Comment, IEductionservices Eduction, IEventServices Event, WebExhibitionoo_DomainClasses.Services.IExhibitionServices Exhibition, IInformationService Information, IPlaceServices Place ) { FAddressServices = Address; FCermoneyServices = Cermoney; FColorServices = Color; FCommentServices = Comment; FEductionServices = Eduction; FEventServices = Event; FExhibitionServices = Exhibition; FInformtionSErvices = Information; FPlacesServices = Place; context = Context; _paginatedMetaService = paginatedMetaService; }
public ActionResult NewsList() { using (var context = new WebDbContext()) { return(View(context.News.ToList())); } }
public static string pwdEncrypt(string password) { using (var db = new WebDbContext()) { //string sql = @"select PWDENCRYPT({0})"; // string commandString = @"UPDATE SC_USR set LOGIN_PW = PWDENCRYPT({0}) where LOGIN_ID = {1}"; string commandString = string.Format(@"UPDATE SC_USR set LOGIN_PW = PWDENCRYPT('{0}') where LOGIN_ID = '{1}'", password, "shinkoooooo"); var result = db.Database.ExecuteSqlCommand(commandString); //var result = db.Database.SqlQuery<>(commandString, sqlParamsList.ToArray()).FirstOrDefault(); //var comps = db.ScUsrs.Where(ci => ci.LoginId == "shinkoooooo").ToList(); //comps.ForEach(cis => //{ // cis.LoginPw = result.;+ //}); db.SaveChanges(); //return System.Text.Encoding.ASCII.GetString(result); return("TRUE"); } }
public DeleteController( WebDbContext Context, IAddresServices Address, WebEventoo_DomainClasses.Services.IExhibitionServices Cermoney, IColorService Color, ICommentService Comment, IEductionservices Eduction, IEventServices Event, INotPublishedServices notpublish, WebExhibitionoo_DomainClasses.Services.IExhibitionServices Exhibition, IInformationService Information, IPlaceServices Place ) { context = Context; FAddressServices = Address; FCermoneyServices = Cermoney; FColorServices = Color; FCommentServices = Comment; FEductionServices = Eduction; FEventServices = Event; FExhibitionServices = Exhibition; FInformtionSErvices = Information; FPlacesServices = Place; FnotPublished = notpublish; }
public HomeController( WebDbContext Context, IAddresServices Address, WebEventoo_DomainClasses.Services.IExhibitionServices Cermoney, IColorService Color, ICommentService Comment, IEductionservices Eduction, IEventServices Event, WebExhibitionoo_DomainClasses.Services.IExhibitionServices Exhibition, IInformationService Information, IHostingEnvironment hostingEnvironment, IReportServices ReportServices, IPlaceServices Place) { FAddressServices = Address; FCermoneyServices = Cermoney; FColorServices = Color; FCommentServices = Comment; FEductionServices = Eduction; FEventServices = Event; FExhibitionServices = Exhibition; FInformtionSErvices = Information; FPlacesServices = Place; FreportServices = ReportServices; context = Context; this._hostingEnvironment = hostingEnvironment; }
public List <ClssRules> GetRulesXetTuyen(double sup, double con) { //double minSupport = Double.Parse(formCollection["MinSupport"]); //double minConfidence = Double.Parse(formCollection["MinConfidence"]); WebDbContext dbContext = new WebDbContext(); var dataListView = (from HoSoXetTuyens in dbContext.HoSoXetTuyens from Tinhs in dbContext.Tinhs where HoSoXetTuyens.TruongTHPT.MaTinh == Tinhs.MaTinh select new { HoSoXetTuyens.CMDN, HoSoXetTuyens.TruongTHPT.TenTruong, Tinhs.TenTinh, HinhThucXetTuyen = (bool?)HoSoXetTuyens.DiemXetTuyen.HinhThucXetTuyen }).ToList(); string result = ""; foreach (var item in dataListView) { db.Add(new clssItemSet() { (item.HinhThucXetTuyen == true ? "Thi tuyển" : "Học bạ"), item.TenTinh }); } clssItemSet uniqueItems = db.GetUniqueItems(); ClssItemCollection L = clssApriori.DoApriori(db, sup); List <ClssRules> allRules = clssApriori.Mine(db, L, con); result = "\n" + allRules.Count + " rules \n"; return(allRules); }
public IActionResult RegisterUser([Bind] UserModel user) { WebDbContext db = HttpContext.RequestServices.GetService(typeof(Web.Utils.WebDbContext)) as WebDbContext; if (ModelState.IsValid) { // Check if email already exists in db if (db.GetLoginUsername(user) > 0) { return(RedirectToAction("RegisterUserExists")); } // Generate new salt and hash password var password = user.Password.ToString(); PasswordHasher pwHasher = new PasswordHasher(); HashResult hashedPassword = pwHasher.HashNewSalt(password, 20, SHA512.Create()); user.Salt = hashedPassword.Salt; user.Password = hashedPassword.Digest; // Register new user db.RegisterUser(user); // Redirect to user area ModelState.Clear(); return(RedirectToAction("UserLogin")); } // Model data invalid return(RedirectToAction("RegisterModelFailed")); }
public ActionResult Index() { var ctx = new WebDbContext(); var companies = ctx.Set<Company>().ToList(); return View(); }
public ProgenyController(IProgenyHttpClient progenyHttpClient, IMediaHttpClient mediaHttpClient, WebDbContext context, ImageStore imagestore) { _progenyHttpClient = progenyHttpClient; _mediaHttpClient = mediaHttpClient; _context = context; // Todo: Replace _context with httpClient _imageStore = imagestore; }
public static async Task UpdateScCompInfoAsync() { using (var db = new WebDbContext()) { var compinfo = await db.ScCompInfoes.FindAsync(6); if (compinfo != null) { compinfo.CompNm = "업데이트111"; } else { var comp = new ScCompInfo { Addr1 = "테스트업데이트주소", CompNm = "업데이트당ㅇ앙아앙아", CompType = "A" }; db.ScCompInfoes.Add(comp); } await db.SaveChangesAsync(); } }
public static void DeleteScCompInfoWithoutSelect() { var comp = new ScCompInfo { CompSn = 30 }; using (var db = new WebDbContext()) { //db.ScCompInfoes.Attach(comp); //db.ScCompInfoes.Remove(comp); db.Entry(comp).State = System.Data.Entity.EntityState.Deleted; try { db.SaveChanges(); } catch (System.Data.Entity.Infrastructure.DbUpdateConcurrencyException ex) { ex.Entries.Single().Reload(); } } }
public void ExecuteStatistics() { using (WebDbContext db = new WebDbContext()) { db.Database.ExecuteSqlCommand("spThongKe_Edit"); } }
public SachController() { _context = new WebDbContext(); _bookService = new BookService(_context); _nhaXuatBanService = new NhaXuatBanService(_context); _tacGiaService = new TacGiaService(_context); _bookCategoriesService = new BookCategoriesService(_context); }
public AccountController(WebDbContext context, IEmailSender emailSender, UserManager <Users> userManager, SignInManager <Users> signInManager) { this.signInManager = signInManager; _context = context; _userManager = userManager; Vmodel = new ViewModel.InformationViewModel(); this.emailSender = emailSender; _context.Database.EnsureCreated(); }
public AdminController(IProgenyHttpClient progenyHttpClient, WebDbContext context, IBackgroundTaskQueue queue, IHubContext <WebNotificationHub> hubContext, IPushMessageSender pushMessageSender) { _progenyHttpClient = progenyHttpClient; _context = context; Queue = queue; _hubContext = hubContext; _pushMessageSender = pushMessageSender; }
public HomeController(WebDbContext db, UserManager <Employee> userManager, SignInManager <Employee> signInManager, RoleManager <IdentityRole> roleManager) { this.db = db; this.userManager = userManager; this.signInManager = signInManager; this.roleManager = roleManager; db.SaveChanges(); }
public ActionResult NewsDelete(int id) { using (var c = new WebDbContext()) { c.News.Remove(c.News.Find(id)); c.SaveChanges(); } GameCache.ReCache(false, false, true); return(RedirectToAction("NewsList")); }
public IEnumerable<Statistics> LoadStatistics() { IList<Statistics> statistics = new List<Statistics>(); using (WebDbContext db = new WebDbContext()) { var result = db.Database.SqlQuerySmart<Statistics>("spThongKe"); if (result != null && result.Any()) statistics = result.ToList(); } return statistics; }
public OperationController(WebDbContext db, ICommentService Comment, IEventServices Event, INotPublishedServices NotPublish, ITranctionServices TranctionServices) { Dbcontext = db; vmodel = new ViewModel.InformationViewModel(); FNotPublishServices = NotPublish; FEventServices = Event; FTranctionServices = TranctionServices; FCommentServices = Comment; }
public static void DeleteCompInfo() { using (var db = new WebDbContext()) { var compinfo = db.ScCompInfoes.Find(30); db.ScCompInfoes.Remove(compinfo); db.SaveChanges(); } }
public static void ReCache(bool c_rank, bool g_rank, bool news) { if (g_rank) { cache_g_rank = new List <Rank_Guild>(); using (var context = new GameDbContext()) { List <Guild> guilds = context.Guilds.ToList(); foreach (var guild in guilds) { Rank_Guild rguild = new Rank_Guild(); rguild.Name = guild.G_Name; rguild.Master = guild.G_Master; rguild.Mark = guild.G_Mark; rguild.Members = 0; int reset_count = 0; foreach (var gm in context.GuildMembers.Where(m => m.G_Name == rguild.Name).ToList()) { rguild.Members += 1; int temp = context.Characters.Find(gm.Name).Resets; reset_count += temp; } rguild.Resets = reset_count; cache_g_rank.Add(rguild); } } cache_g_rank_date = DateTime.Now; cache_g_rank.Sort(); } if (c_rank) { if (cache_c_rank == null) { cache_c_rank = new Dictionary <RankType, List <Rank_Char> >(); } foreach (RankType rt in Enum.GetValues(typeof(RankType))) { cache_c_rank[rt] = GetRankCharFromDB(rt); } cache_c_rank_date = DateTime.Now; } if (news) { if (cache_news == null) { cache_news = new List <NewsPost>(); } using (var c = new WebDbContext()) { cache_news = c.News.OrderByDescending(m => m.Date).ToList(); } } }
public static void UpdateScCompInfoWithQuery1() { string sql = @"update SC_COMP_INFO set COMP_NM=@compNm where COMP_TYPE=@compType"; using (var db = new WebDbContext()) { System.Data.SqlClient.SqlParameter p1 = new System.Data.SqlClient.SqlParameter("@compNm", "test114"); System.Data.SqlClient.SqlParameter p2 = new System.Data.SqlClient.SqlParameter("@compType", "A"); db.Database.ExecuteSqlCommand(sql, p1, p2); } }
public HomeController( UserManager <ApplicationUser> userManager, SignInManager <ApplicationUser> signInManager, ApplicationDbContext applicationDbContext, RoleManager <IdentityRole> roleManager, WebDbContext context ) { _roleManager = roleManager; _applicationDbContext = applicationDbContext; _userManager = userManager; _signInManager = signInManager; _context = context; }
public static void UpdateCompInfoMulti() { using (var db = new WebDbContext()) { var comps = db.VcCompInfoes.Where(ci => ci.CompNm == "test113").ToList(); comps.ForEach(cis => { cis.OwnEmail = "*****@*****.**"; }); db.SaveChanges(); } }
//******************************************** #region Ham lay ra danh sach cac luat:Khoa =>Mon cai thien public List <ClssRules> LuatCaiThien(double sup, double con) { //double minSupport = Double.Parse(formCollection["MinSupport"]); //double minConfidence = Double.Parse(formCollection["MinConfidence"]); WebDbContext dbContext = new WebDbContext(); var dataListView = (from a in ( (from dcthk in dbContext.DiemCTHKys from sv in dbContext.SinhViens where dcthk.MSSV == sv.MSSV select new { dcthk.MaMon, dcthk.MSSV, dcthk.DiemTKHe4, dcthk.MonHoc.TenMon, sv.Lop.Khoa.TenKhoa })) group a by new { a.MaMon, a.MSSV, a.TenMon, a.TenKhoa } into g where g.Count() > 1 select new { g.Key.TenMon, g.Key.TenKhoa }).ToList(); string result = ""; foreach (var item in dataListView) { db.Add(new clssItemSet() { item.TenMon, item.TenKhoa }); } clssItemSet uniqueItems = db.GetUniqueItems(); ClssItemCollection L = clssApriori.DoApriori(db, sup); List <ClssRules> allRules = clssApriori.Mine(db, L, con); result = "\n" + allRules.Count + " rules \n"; return(allRules); }
public static async void UpdateCompInfoMultiAsync() { using (var db = new WebDbContext()) { var comps = db.ScCompInfoes.Where(ci => ci.CompType == "A" && ci.CompNm == "test113").ToList(); comps.ForEach(cis => { cis.Email = "*****@*****.**"; }); await db.SaveChangesAsync(); } }
public static void UpdateScCompInfoWithQuery() { string sql = @"update SC_COMP_INFO set COMP_NM={0} where COMP_TYPE={1}"; using (var db = new WebDbContext()) { List <Object> sqlParamsList = new List <object>(); sqlParamsList.Add("test117"); sqlParamsList.Add("A"); db.Database.ExecuteSqlCommand(sql, sqlParamsList.ToArray()); // var entry = db.Entry(new ScCompInfo { CompSn = 10 }); } }
public List <ClssRules> GetRulesHocCaiThien(double sup, double con) { WebDbContext dbContext = new WebDbContext(); var dataListView = ((from a in ( (from dcthk in dbContext.DiemCTHKys where dcthk.DiemTKHe10 >= dcthk.MonHoc.DiemDat select new { dcthk.MSSV, dcthk.MonHoc.MaMon, dcthk.DiemTKHe10, dcthk.MonHoc.TenMon, dcthk.ID_HocKi })) group a by new { a.MSSV, a.MaMon, a.TenMon } into g where (g.Max(p => p.DiemTKHe10) - g.Min(p => p.DiemTKHe10)) > 0 select new { g.Key.MSSV, g.Key.MaMon, g.Key.TenMon, chechlech = (double?)(g.Max(p => p.DiemTKHe10) - g.Min(p => p.DiemTKHe10)) })).ToList(); string result = ""; foreach (var item in dataListView) { db.Add(new clssItemSet() { item.TenMon, item.chechlech.ToString() }); } clssItemSet uniqueItems = db.GetUniqueItems(); ClssItemCollection L = clssApriori.DoApriori(db, sup); List <ClssRules> allRules = clssApriori.Mine(db, L, con); result = "\n" + allRules.Count + " rules \n"; return(allRules); }
public static void UpdateScCompInfoWithoutSelect() { var comp = new ScCompInfo { CompSn = 85 }; using (var db = new WebDbContext()) { db.ScCompInfoes.Attach(comp); comp.CompNm = "bizon188"; db.SaveChanges(); } }
public ActionResult NewsEdit(int id) { using (var c = new WebDbContext()) { var post = c.News.Find(id); if (post == null) { return(new HttpNotFoundResult()); } NewsViewModel mdl = new NewsViewModel(); mdl.Id = post.Id; mdl.ImageFile = post.Image; mdl.Title = post.Title; mdl.HtmlContent = post.HtmlContent; return(View(mdl)); } }
public ActionResult NewsEdit(NewsViewModel model) { if (ModelState.IsValid) { using (var c = new WebDbContext()) { var oPost = c.News.Find(model.Id); oPost.HtmlContent = model.HtmlContent; oPost.Image = model.ImageFile; oPost.Title = model.Title; oPost.Date = DateTime.Now; c.SaveChanges(); } GameCache.ReCache(false, false, true); return(RedirectToAction("NewsList")); } return(View(model)); }
public static async void insertScCompInfoAsync() { var comp = new ScCompInfo { Addr1 = "테스트주소", CompNm = "테스트회사", CompType = "A" }; using (var db = new WebDbContext()) { db.ScCompInfoes.Add(comp); //이것도 가능 //db.Entry<ScCompInfo>(comp).State = System.Data.Entity.EntityState.Added; await db.SaveChangesAsync(); } }
public static void insertScCompInfo() { var comp = new VcCompInfo { //Addr1 = "테스트주소", CompNm = "테스트회사" //CompType = "A" }; using (var db = new WebDbContext()) { db.VcCompInfoes.Add(comp); //이것도 가능 //db.Entry<ScCompInfo>(comp).State = System.Data.Entity.EntityState.Added; db.SaveChanges(); } }