public void Get_UserInformation(string deviceId, string token)
{
VideoEntities ve = DBContextFactory.GetDbContext();
Device_user du = new Device_user();
List <WeChatUser> wlist = ve.WeChatUser.Where(x => x.DeviceId == deviceId).ToList();
if (wlist.Count == 0)
{
HttpContext.Current.Response.Write("null");
return;
}
foreach (var item in wlist)
{
item.Token = token;
ve.SaveChanges();
}
Dictionary <string, List <Dictionary <string, string> > > dic2 = new Dictionary <string, List <Dictionary <string, string> > >();
List <Dictionary <string, string> > list2 = new List <Dictionary <string, string> >();
foreach (var item in wlist)
{
Dictionary <string, string> dic3 = new Dictionary <string, string>();
dic3.Add("openid", item.OpenId);
dic3.Add("lang", "zh_CN");
list2.Add(dic3);
}
dic2.Add("user_list", list2);
string data2 = du.GetUserInformation2(JsonConvert.SerializeObject(dic2), GetToken());
HttpContext.Current.Response.Write(data2);
}
public static async Task PopulateDummyCars(int NumberOfCars)
{
// Ask the DBContextFactory to create the desired DbContext object for use for database access
DSuiteContext db = DBContextFactory.GetDbContext <DSuiteContext>();
for (int i = 0; i < NumberOfCars; ++i)
{
Car NewCar = GenerateCar();
await EFCrud.Create(db, NewCar);
}
}
public async Task CRUDUsingHelperClass()
{
Car newCar = GenerateCar();
// Demonstrate basic CRUD
DSuiteContext db = DBContextFactory.GetDbContext <DSuiteContext>();
await EFCrud.Create(db, newCar);
Car found = await EFCrud.GetByKey(db, newCar);
EFCrud.Delete(db, found);
}
public void FindMultipleUsingLINQ()
{
DSuiteContext dSuiteContext = DBContextFactory.GetDbContext <DSuiteContext>();
// Demonstrate the deferred execution POWER of IQueryable!
// Find a small list of cars that we don't need to page through.
IQueryable <Car> linqFordBunnies = (from c in dSuiteContext.Cars where c.Make == "Ford" && c.Model == "Bunny" && c.Year < 2006 select c);
// But I DO want to sort them too. Still no DB call here!
linqFordBunnies = linqFordBunnies.OrderBy(bunny => bunny.Mileage);
// NOW, go ahead and execute the query against the database
linqFordBunnies.DumpData("\r\n\r\n==============FindMultipleUsingLINQ==============================");
}
/// <summary>
/// All tests/work are performed here
/// </summary>
/// <returns></returns>
internal async Task DoWork()
{
// Create DSuite dummy data to play with
await PopulateDummyCars(500);
// Demonstrate the deferred execution POWER of IQueryable!
// Find a small list of cars that we don't need to page through.
FindMultipleUsingHelperClass(_dSuite);
//------- Same query using pure LINQ -----------------
FindMultipleUsingLINQ();
// Ask the DBContextFactory to create the desired DbContext object for use for database access
await CRUDUsingHelperClass();
// Equivalent CRUD using just linq
await CRUDUsingLINQ();
// Demonstrate data PAGING! Construct a pager that specifies the where clause, page size and column order criteria
EFPager <Car> pager = new EFPager <Car>(x => x.Mileage > 50000, 50, x => x.Make, x => x.Model, x => x.Mileage);
do
{
// Note: The database will NOT be accessed during this call.
IQueryable <Car> resultQuery = await EFHelper.QueryEntities <Car, DSuiteContext>(pager);
// Physically realize the data from the database. The act of enumeration causes the current thread
// to block while data is retrieved from the database. To perform this asynchronously, use the RealizeData extension.
resultQuery.DumpData($"\r\n\r\n==============Page {pager.PageIndex} of Car data==============================");
} while (pager.HasNextPage);
Console.WriteLine($"Query {pager}:: {pager.TotalRowCount} total rows in {pager.TotalPages} pages were displayed\r\n\r\n");
// Delete all play data
EFCrud.DeleteAll <Car, DSuiteContext>();
//-------------------- Use Code First ----------------------
// Ask the DBContextFactory to create the desired DbContext object for use for database access.
// NOTE: This is for demo purposes only! The DbContexts for this application were injected
// in the constructor, and this is how you would "USUALLY" access the DbContext to work with.
SchoolContext schoolContext = DBContextFactory.GetDbContext <SchoolContext>();
DbInitializer.Initialize(schoolContext);
IQueryable <Student> studentList = schoolContext.FindMultiple <Student, SchoolContext>((x) => x.LastName.StartsWith("A"), (x) => x.LastName, false);
studentList.DumpData($"\r\n\r\n==============EFCrud.FindMultiple==============================");
// Demonstrate basic CRUD with related tables
Student newStudent = new Student {
FirstMidName = "Tony", LastName = "Franklin", EnrollmentDate = DateTime.Parse("2009-09-09")
};
await schoolContext.Create(newStudent);
Course newCourse = new Course {
CourseID = 5022, Title = "Advanced C#", Credits = 4
};
await schoolContext.Create(newCourse);
Enrollment newEnrollment = new Enrollment {
StudentID = newStudent.Id, CourseID = newCourse.CourseID, Grade = Grade.A
};
await schoolContext.Create(newEnrollment);
// Now find a specific enrollment.
Enrollment enrollmentFound = schoolContext.FindSingle <Enrollment, SchoolContext>(x => x.EnrollmentID == newEnrollment.EnrollmentID);
string grade = enrollmentFound?.Grade.ToString() ?? "??";
Console.WriteLine($"Student({enrollmentFound.Student.FirstMidName} {enrollmentFound.Student.LastName}) Course({enrollmentFound.Course.Title}) Grade({grade})");
// Delete the student that was just added
schoolContext.Delete(newEnrollment);
schoolContext.Delete(newCourse);
schoolContext.Delete(newStudent);
// Find all classes a student is enrolled into. NOTE:!!!! DbContextFactory uses "UseLazyLoadingProxies"
// to ensure that properties "Student" and "Course" are lazy loaded when their properties are accessed.
// If that were not the case, then you've have to manually load the data based on ID values.
newStudent = schoolContext.FindSingle <Student, SchoolContext>(x => x.LastName == "Alonso" && x.FirstMidName == "Meredith");
IQueryable <Enrollment> enrolledList = schoolContext.FindMultiple <Enrollment, SchoolContext>(x => x.StudentID == newStudent.Id);
Console.WriteLine("\r\nMeredith Alonso was inrolled in the following courses:");
foreach (Enrollment enrolled in enrolledList.ToList())
{
Console.WriteLine($"{enrolled.Course.Title} enrolled on {enrolled.Student.EnrollmentDate}");
}
// Use the DbContext classes that were passed in using Dependency Injection
Car myCar = GenerateCar();
_dSuite.Cars.Add(myCar);
_dSuite.SaveChanges();
myCar.TraceInformation("Using DI created context");
Car foundMyCar = (from c in _dSuite.Cars where c.CarId == myCar.CarId select c).FirstOrDefault();
foundMyCar.TraceInformation("Example of how to use LINQ to find an entity");
// Use generic repository pattern (using dependency injection)
foundMyCar = _cars.GetById(myCar.CarId);
foundMyCar.TraceInformation("Found using generic repository");
// Remove the car to clean up the DB
_dSuite.Cars.Remove(myCar);
_dSuite.SaveChanges();
// Use the open generic type provided by dependency injection for the "school" repo
Student Bobby = new Student {
FirstMidName = "Bobby", LastName = "Simpson", EnrollmentDate = DateTime.Parse("2010-08-01")
};
_genericStudentDataRepository.Insert(Bobby);
Bobby.TraceInformation("New student inserted using dependency injection open generic");
Student foundStudent = _genericStudentDataRepository.GetById(Bobby.Id);
foundStudent.TraceInformation("Found student using dependency injection open generic");
_genericStudentDataRepository.Delete(Bobby.Id);
foundStudent = _genericStudentDataRepository.GetById(Bobby.Id);
if (foundStudent == null)
{
Bobby.TraceInformation("Successfully deleted student");
}
else
{
Bobby.TraceInformation("Failed to deleted student");
}
// Perform the same action with the IStudentRepository
Bobby = new Student {
FirstMidName = "Bobby", LastName = "Simpson", EnrollmentDate = DateTime.Parse("2010-08-01")
};
_students.Insert(Bobby);
Bobby.TraceInformation("New student inserted using dependency injection open generic");
foundStudent = _students.GetById(Bobby.Id);
foundStudent.TraceInformation("Found student using dependency injection open generic");
_students.Delete(Bobby.Id);
foundStudent = _students.GetById(Bobby.Id);
if (foundStudent == null)
{
Bobby.TraceInformation("Successfully deleted student");
}
else
{
Bobby.TraceInformation("Failed to deleted student");
}
}