/// <summary>
/// edit information a user
/// </summary>
/// <param name="user"></param>
public void EditedUser(AspNetUsers user)
{
using (var context = new GalaxyCoffeeEntities())
{
string f1 = " Name = N'" + user.Name + "'";
string f2 = ", Email = '" + user.Email + "'";
string f3 = ", PhoneNumber = '" + user.PhoneNumber + "'";
string f4 = ", [Identity] = '" + user.Identity + "'";
string f5 = ", BirthDay = '" + user.BirthDay.Value.ToString("MM-dd-yyyy") + "'";
string f6 = ", Sex = N'" + user.Sex + "'";
string f7 = ", Description = N'" + user.Description + "'";
string f8 = ", WardID = " + user.WardID.ToString();
string f9 = ", DetailAddress = N'" + user.DetailAddress + "'";
string query = "UPDATE AspNetUsers SET" + f1 + f2 + f3 + f4 + f5 + f6 + f7 + f8 + f9 + " WHERE Id = " + user.Id.ToString();
context.Database.ExecuteSqlCommand(query);
}
}
public CityRepository(GalaxyCoffeeEntities db) : base(db)
{
}
public BaseRepository(GalaxyCoffeeEntities db)
{
_db = db;
_table = _db.Set <T>();
}
public BaseRepository()
{
_db = new GalaxyCoffeeEntities();
_table = _db.Set <T>();
}
public DistrictRepository(GalaxyCoffeeEntities db) : base(db)
{
}
public WardRepository(GalaxyCoffeeEntities db) : base(db)
{
}
