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();
}
