public void DoubleValuesNonEnglish() { CultureInfo curCulture = Thread.CurrentThread.CurrentCulture; CultureInfo curUICulture = Thread.CurrentThread.CurrentUICulture; CultureInfo newCulture = new CultureInfo("da-DK"); Thread.CurrentThread.CurrentCulture = newCulture; Thread.CurrentThread.CurrentUICulture = newCulture; try { using (testEntities context = new testEntities()) { Child c = new Child(); c.Id = 20; c.EmployeeID = 1; c.FirstName = "Bam bam"; c.LastName = "Rubble"; c.BirthWeight = 8.65; c.Modified = DateTime.Now; context.AddToChildren(c); context.SaveChanges(); } } finally { Thread.CurrentThread.CurrentCulture = curCulture; Thread.CurrentThread.CurrentUICulture = curUICulture; } }
public void SimpleDeleteRowByParameter() { //Make sure the table exists var createTableSql = "CREATE TABLE IF NOT EXISTS Toys ( `Id` INT NOT NULL AUTO_INCREMENT, `SupplierId` INT NOT NULL, `Name` varchar(100) NOT NULL,`MinAge` int NOT NULL, CONSTRAINT PK_Toys PRIMARY KEY (Id)) ENGINE=InnoDB;"; if (st.conn.State != ConnectionState.Open) { st.conn.Open(); } MySqlHelper.ExecuteNonQuery(st.conn, createTableSql); MySqlHelper.ExecuteNonQuery(st.conn, "DELETE FROM Toys"); MySqlHelper.ExecuteNonQuery(st.conn, "INSERT INTO Toys VALUES (1, 3, 'Slinky', 2), (2, 2, 'Rubiks Cube', 5), (3, 1, 'Lincoln Logs', 3), (4, 4, 'Legos', 4)"); using (testEntities context = new testEntities()) { MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM toys WHERE minage=3", st.conn); DataTable dt = new DataTable(); da.Fill(dt); Assert.True(dt.Rows.Count > 0); ObjectQuery <Toy> toys = context.Toys.Where("it.MinAge = @age", new ObjectParameter("age", 3)); foreach (Toy t in toys) { context.DeleteObject(t); } context.SaveChanges(); dt.Clear(); da.Fill(dt); Assert.Equal(0, dt.Rows.Count); } }
public async Task <string> Create(string stock) { using (db = new testEntities()) { ApplicationUser currentUser = await UserManager.FindByIdAsync(User.Identity.GetUserId()); var countStockFollowr = await db.FollowStocks.CountAsync(f => f.UserId == currentUser.UserExtentLogin.Id); var followrStockByUser = await db.FollowStocks.FirstOrDefaultAsync(f => f.UserId == currentUser.UserExtentLogin.Id && f.StockFollowed == stock); if (countStockFollowr >= 10 && followrStockByUser == null) { return("M"); } if (followrStockByUser == null && countStockFollowr < 10) { var stockfollow = new FollowStock { UserId = currentUser.UserExtentLogin.Id, StockFollowed = stock, CreatedDate = DateTime.Now }; db.FollowStocks.Add(stockfollow); await db.SaveChangesAsync(); return("A"); } else { db.FollowStocks.Remove(followrStockByUser); await db.SaveChangesAsync(); return("R"); } } }
public void LeftRight() { using (testEntities context = new testEntities()) { string entitySQL = "CONCAT(LEFT('foo',3),RIGHT('bar',3))"; ObjectQuery <String> query = context.CreateQuery <String>(entitySQL); foreach (string s in query) { Assert.AreEqual("foobar", s); } entitySQL = "CONCAT(LEFT('foobar',3),RIGHT('barfoo',3))"; query = context.CreateQuery <String>(entitySQL); foreach (string s in query) { Assert.AreEqual("foofoo", s); } entitySQL = "CONCAT(LEFT('foobar',8),RIGHT('barfoo',8))"; query = context.CreateQuery <String>(entitySQL); foreach (string s in query) { Assert.AreEqual("foobarbarfoo", s); } } }
public void JoinOfNestedUnionsWithLimit() { using (testEntities context = new testEntities()) { var q = context.Books.Include("Author"); q = q.Include("Publisher"); q = q.Include("Publisher.Books"); string sql = q.ToTraceString(); var i = 0; foreach (var o in q.Where(p => p.Id > 0).OrderBy(p => p.Name).ThenByDescending(p => p.Id).Skip(0).Take(32).ToList()) { switch (i) { case 0: Assert.Equal(5, o.Id); Assert.Equal("Debt of Honor", o.Name); break; case 1: Assert.Equal(1, o.Id); Assert.Equal("Debt of Honor", o.Name); break; case 4: Assert.Equal(3, o.Id); Assert.Equal("Rainmaker", o.Name); break; } i++; } } }
public void AverageWithGrouping() { MySqlDataAdapter da = new MySqlDataAdapter( "SELECT AVG(Freight) FROM Orders GROUP BY StoreId", conn); DataTable dt = new DataTable(); da.Fill(dt); using (testEntities context = new testEntities()) { string eSql = "SELECT AVG(o.Freight) FROM Orders AS o GROUP BY o.Store.Id"; ObjectQuery <DbDataRecord> q = context.CreateQuery <DbDataRecord>(eSql); string sql = q.ToTraceString(); CheckSql(sql, SQLSyntax.AverageWithGrouping); foreach (object x in q) { string s = x.GetType().ToString(); } int i = 0; foreach (var freight in q) { // Assert.AreEqual(Convert.ToInt32(dt.Rows[i++][0]), Convert.ToInt32(freight)); } } }
public void AverageSimple() { MySqlCommand trueCmd = new MySqlCommand("SELECT AVG(minAge) FROM Toys", st.conn); //#if EF6 // int avgAge = (int)trueCmd.ExecuteScalar(); //#else Decimal avgAge = (Decimal)trueCmd.ExecuteScalar(); //#endif using (testEntities context = new testEntities()) { string eSql = "SELECT VALUE Avg(t.MinAge) FROM Toys AS t"; //#if EF6 // ObjectQuery<int> q = context.CreateQuery<int>(eSql); //#else ObjectQuery <Decimal> q = context.CreateQuery <Decimal>(eSql); //#endif string sql = q.ToTraceString(); st.CheckSql(sql, SQLSyntax.AverageSimple); //#if EF6 // foreach (int r in q) //#else foreach (Decimal r in q) { //#endif Assert.Equal(avgAge, r); } } }
public void TakeWithUnion() { int[] ids = new int[] { 1, 2, 3, 4 }; string[] names = new string[] { "Slinky", "Rubiks Cube", "Lincoln Logs", "Legos" }; using (testEntities ctx = new testEntities()) { var q = ctx.Toys; var q2 = ctx.Toys.Take(0).Concat(q); var q3 = q.Concat(q.Take(0)); int i = 0; string sql = q2.ToTraceString(); st.CheckSql(sql, SQLSyntax.UnionWithLimit2); foreach (var row in q2) { Assert.Equal <int>(ids[i], row.Id); Assert.Equal <string>(names[i], row.Name); i++; } i = 0; sql = q3.ToTraceString(); st.CheckSql(sql, SQLSyntax.UnionWithLimit); foreach (var row in q) { Assert.Equal <int>(ids[i], row.Id); Assert.Equal <string>(names[i], row.Name); i++; } } }
public Product Find(int Id) { using (var context = new testEntities()) { return(context.Products.FirstOrDefault(u => u.Id == Id)); } }
public void SimpleJoinWithPredicate() { MySqlDataAdapter da = new MySqlDataAdapter( @"SELECT b.id,b.name,a.name as author_name from books b JOIN authors a ON b.author_id=a.id WHERE b.pages > 300", st.conn); DataTable dt = new DataTable(); da.Fill(dt); using (testEntities context = new testEntities()) { var q = from b in context.Books join a in context.Authors on b.Author.Id equals a.Id where b.Pages > 300 select new { bookId = b.Id, bookName = b.Name, authorName = a.Name }; string sql = q.ToTraceString(); st.CheckSql(sql, SQLSyntax.SimpleJoinWithPredicate); int i = 0; foreach (var o in q) { Assert.Equal(dt.Rows[i++][0], o.bookId); } Assert.Equal(dt.Rows.Count, i); } }
public int UpdateData(test data, testEntities entity) { int success = 0; //entity需一樣,所以移除 //testEntities entity = (testEntities)base.GetCurrentContext(); var entry = entity.Entry(data); if (entry.State == EntityState.Detached) { var set = entity.Set <test>(); test attachedEntity = set.Find(data.id); if (attachedEntity != null) { var attachedEntry = entity.Entry(attachedEntity); attachedEntry.CurrentValues.SetValues(data); } else { entry.State = EntityState.Modified; } } success = entity.SaveChanges(); return(success); }
public void Update() { MySqlDataAdapter da = new MySqlDataAdapter("SELECT * FROM Authors", conn); DataTable dt = new DataTable(); da.Fill(dt); int count = dt.Rows.Count; using (testEntities context = new testEntities()) { var q = from a in context.Authors where a.Name == "Don Box" select a; foreach (Author a in q) { a.Name = "Dummy"; } context.SaveChanges(); } da.SelectCommand.CommandText = "SELECT * FROM Authors WHERE name='Dummy'"; dt.Clear(); da.Fill(dt); Assert.AreEqual(1, dt.Rows.Count); }
public void CreateDatabaseScript() { using (testEntities ctx = new testEntities()) { string s = ctx.CreateDatabaseScript(); } }
public ActionResult ValidateUserRegistration(UserRegistration LoginObject) { testEntities db = new testEntities(); db.SaveChanges(); // return RedirectToAction("UserLogin"); return(Json(new { isRedirect = true }, JsonRequestBehavior.AllowGet)); }
public List <student> GetStudents() { using (testEntities db = new testEntities()) { var students = db.student.ToList(); return(students); } }
public student GetStudent(int id) { using (testEntities db = new testEntities()) { var student = db.student.FirstOrDefault(r => r.id == id); return(student); } }
int IDAL <T> .Add(T model) { using (testEntities db = new testEntities()) { db.Set <T>().Add(model); return(db.SaveChanges()); } }
// GET: /FollowStock/ public async Task <ActionResult> Index() { using (db = new testEntities()) { var followstocks = db.FollowStocks.Include(f => f.UserLogin); return(View(await followstocks.ToListAsync())); } }
// GET: /FollowStock/Create public ActionResult Create() { using (db = new testEntities()) { ViewBag.UserId = new SelectList(db.UserLogins, "Id", "KeyLogin"); return(View()); } }
/// <summary> /// Get Employee With Id /// </summary> /// <param name="Id"></param> /// <returns></returns> public JsonResult Get_EmployeeById(string Id) { using (testEntities Obj = new testEntities()) { int EmpId = int.Parse(Id); return(Json(Obj.employees.Find(EmpId), JsonRequestBehavior.AllowGet)); } }
public void Dispose() { if (_dataContext != null) { _dataContext.Dispose(); _dataContext = null; } }
public void TakeWithCount() { using (testEntities context = new testEntities()) { int cnt = context.Companies.Take(2).Count(); Assert.Equal(2, cnt); } }
/// <summary> /// /// Get All Employee /// </summary> /// <returns></returns> public JsonResult Get_AllEmployee() { using (testEntities Obj = new testEntities()) { List <employee> Emp = Obj.employees.ToList(); return(Json(Emp, JsonRequestBehavior.AllowGet)); } }
public async Task <ActionResult> Profile(ProfileUserViewModel model) { ApplicationUser user = UserManager.FindById(User.Identity.GetUserId()); loadInfoUser(user); if (ModelState.IsValid) { using (db = new testEntities()) { if (user != null) { if (model.Email != user.UserExtentLogin.Email) { // kiem tra ton tai email trong he thong //checkemail exists int checkemail = await db.UserLogins.CountAsync(ue => ue.Email == model.Email && ue.UserNameCopy != user.UserName); if (checkemail > 0) { ModelState.AddModelError("Email", "Email đã tồn tại trong hệ thống, Vui lòng chọn Email khác"); return(View(model)); } else { user.UserExtentLogin.Email = model.Email; } } user.UserExtentLogin.FullName = model.FullName; user.UserExtentLogin.Mobile = model.Mobile; user.UserExtentLogin.BirthDate = model.BirthDay; user.UserExtentLogin.Status = model.Status; user.UserExtentLogin.JobTitle = model.JobTitle; user.UserExtentLogin.URLFacebook = string.IsNullOrEmpty(model.URLFacebook) ? "" : "http://" + model.URLFacebook.Replace("http://", "").Replace("https://", "").Replace("www.", ""); user.UserExtentLogin.CVInfo = model.CVInfo; user.UserExtentLogin.NumberExMarketYear = model.NumberExMarketYear; user.UserExtentLogin.PhilosophyMarket = model.PhilosophyMarket; user.UserExtentLogin.AvatarSyn = model.AvatarSyn; } else { return(RedirectToAction("Login")); } IdentityResult result = await UserManager.UpdateAsync(user); if (result.Succeeded) { return(RedirectToAction("Profile", new { Message = ManageMessageId.UpdateSucess })); } else { AddErrors(result); } } } return(View(model)); }
/// <summary> /// 根据员工id删除该员工的工资发放记录(单条) /// </summary> /// <param name="_id"></param> /// <returns></returns> public bool DelByID(int _id) { testEntities t = new testEntities(); t.Entry <SalaryRecord>(new SalaryRecord { ID = _id }).State = System.Data.EntityState.Deleted; return(t.SaveChanges() > 0); }
// GET api/values public IEnumerable <Book> Getbooks() { using (testEntities entities = new testEntities()) { //return entities.Books.AsEnumerable(); var ls = entities.Books.ToList <Book>(); return(ls); } }
public void UnsignedValues() { using (testEntities context = new testEntities()) { var row = context.Children.First(); context.Detach(row); context.Attach(row); } }
public List <Employee> EmpGetAll() { testEntities db = new testEntities(); var query = from Employee in db.Employees select Employee; List <Employee> emplist = query.ToList(); return(emplist); }
// Post: Register public ActionResult PostRegiter(User userData) { using (testEntities msContext = new testEntities()) { msContext.User.Add(userData); msContext.SaveChanges(); } return(RedirectToAction("Loginuser")); }
public void Delete(int id) { using (testEntities db = new testEntities()) { var student = db.student.FirstOrDefault(r => r.id == id); db.student.Remove(student); db.SaveChanges(); } }
public ProductService() { _commerceObjectContext = new testEntities(); }