public async Task Can_create_tables_with_multiple_references_async()
{
using (var db = await OpenDbConnectionAsync())
{
InitDb(db);
}
var userMeta = new UserMeta();
var user = new User
{
Meta = userMeta
};
using (var db = await OpenDbConnectionAsync())
{
user.Branches = new List <UserBranch> {
new() { UserId = user.Id }
};
user.Addresses = new List <UserAddress> {
new() { UserId = user.Id }
};
await db.SaveAsync(user, references : true);
var fromDb = await db.LoadSingleByIdAsync <User>(user.Id);
fromDb.Dump().Print();
}
}
}
}
public void Can_create_tables_with_multiple_references()
{
using (var db = OpenDbConnection())
{
InitDb(db);
}
var userMeta = new UserMeta();
var user = new User
{
Meta = userMeta
};
using (var db = OpenDbConnection())
{
user.Branches = new List <UserBranch> {
new() { UserId = user.Id }
};
user.Addresses = new List <UserAddress> {
new() { UserId = user.Id }
};
db.Save(user, references: true);
var fromDb = db.LoadSingleById <User>(user.Id);
fromDb.Dump().Print();
}
}
public async Task UpdateUserMeta(UserMeta userMeta, User activeUser)
{
if (!await UserRepo.UpdateDescription(activeUser.Id, userMeta.Description))
{
throw new CritterException($"Failed to update user description for user ID {activeUser.Id} ({activeUser.Username}) - " +
$"Description: {userMeta.Description}", null, System.Net.HttpStatusCode.InternalServerError);
}
}
public async Task <IActionResult> AddCustomerShoppingArea([FromBody] Customer customer)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = await _context.Users.SingleAsync(x => x.UserName == HttpContext.User.Identity.Name);
if (user == null)
{
ModelState.AddModelError("", "Sory, your user is empty !");
return(BadRequest(ModelState));
}
UserMeta userMeta = _context.UserMeta.FirstOrDefault(u => u.Id == user.UserMetaId);
ShoppingArea shoppingArea = await _context.ShoppingArea.FirstOrDefaultAsync(x => x.ShoppingAreaId == userMeta.ShoppingAreaId);
if (shoppingArea == null)
{
ModelState.AddModelError("", "Sory, your Shoping Area is empty !");
return(BadRequest(ModelState));
}
_context.AttachRange(customer);
CustomerShoppingArea customerShoppingArea = _context.CustomerShoppingArea.FirstOrDefault(c => c.CustomerId == customer.CustomerId & c.ShoppingAreaId == shoppingArea.ShoppingAreaId);
if (customerShoppingArea != null)
{
customerShoppingArea.ShoppingArea = shoppingArea;
customerShoppingArea.Customer = customer;
customerShoppingArea.UpdateStatus = 1;
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCustomerShoppingArea", new CustomerShoppingAreaCode {
ShoppingAreaCode = shoppingArea.Code, CustomerCode = customer.Code
}));
}
else
{
customerShoppingArea = new CustomerShoppingArea();
customerShoppingArea.ShoppingArea = shoppingArea;
customerShoppingArea.Customer = customer;
customerShoppingArea.UpdateStatus = 1;
_context.CustomerShoppingArea.Add(customerShoppingArea);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetCustomerShoppingArea", new CustomerShoppingAreaCode {
ShoppingAreaCode = shoppingArea.Code, CustomerCode = customer.Code
}));
}
}
protected DialogItem(IStorageApi storageApi,ILogger logger,UserMeta user)
{
_storageApi = storageApi;
isProcessed = false;
_logger = logger;
itemId=Guid.NewGuid();
lastImpactTime=DateTime.Now;
storageUserId = user.StorageUserId;
}
public async Task <User> CreateAsync(UserMeta userMeta)
{
var userJson = JsonConvert.SerializeObject(userMeta);
var stringContent = new StringContent(userJson, Encoding.UTF8, "application/json");
var httpResponse = await httpClient.PostAsync($"{_address}/api/User", stringContent);
httpResponse.EnsureSuccessStatusCode();
return(JsonConvert.DeserializeObject <User>(await httpResponse.Content.ReadAsStringAsync()));
}
private void SaveUser()
{
UserMeta userMeta = new UserMeta {
userName = PlayerPrefs.GetString("userName"),
password = PlayerPrefs.GetString("password")
};
ApplicationManager.SaveUserInfo(userMeta);
}
public PagesListResult <Customer> GetCustomers(string filter, int?pageNumber, int?pageSize, bool ShoppingArea = false)
{
var itemsPerPage = pageSize.HasValue ? pageSize.Value : 50;
var currentPageNum = pageNumber.HasValue ? pageNumber.Value : 1;
ApplicationUser user;
int ShoppingAreaId = 0;
if (ShoppingArea)
{
user = _context.Users.Single(x => x.UserName == HttpContext.User.Identity.Name);
if (user != null)
{
UserMeta userMeta = _context.UserMeta.FirstOrDefault(u => u.Id == user.UserMetaId);
ShoppingAreaId = (int)userMeta.ShoppingAreaId;
}
if (ShoppingAreaId == 0)
{
ShoppingArea = false;
}
;
}
var qry = _context.Customers.AsNoTracking().AsQueryable();
if (ShoppingArea)
{
qry = _context.CustomerShoppingArea.AsNoTracking()
.Where(c => c.ShoppingAreaId == ShoppingAreaId && c.UpdateStatus != 2)
//.OrderBy(c => c.Customer.Descr)
.Include(c => c.Customer)
.Select(c => c.Customer);
if (!string.IsNullOrWhiteSpace(filter))
{
qry = qry.Where(c => c.Descr.StartsWith(filter));
}
qry = qry.OrderBy(c => c.Descr);
}
else
{
qry = _context.Customers.AsNoTracking().AsQueryable();
if (!string.IsNullOrWhiteSpace(filter))
{
qry = qry.Where(c => c.Descr.StartsWith(filter));
}
qry = qry.OrderBy(c => c.Descr);
}
return(PagesListResult <Customer> .Create(qry, currentPageNum, itemsPerPage));
}
public async Task <IActionResult> AddWarehouseShoppingArea([FromBody] Warehouse warehouse)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = await _context.Users.SingleAsync(x => x.UserName == HttpContext.User.Identity.Name);
if (user == null)
{
ModelState.AddModelError("", "Sory, your user is empty !");
return(BadRequest(ModelState));
}
UserMeta userMeta = _context.UserMeta.FirstOrDefault(u => u.Id == user.UserMetaId);
ShoppingArea shoppingArea = await _context.ShoppingArea.FirstOrDefaultAsync(x => x.ShoppingAreaId == userMeta.ShoppingAreaId);
if (shoppingArea == null)
{
ModelState.AddModelError("", "Sory, your Shoping Area is empty !");
return(BadRequest(ModelState));
}
_context.AttachRange(warehouse);
WarehouseShoppingArea warehouseShoppingArea = _context.WarehouseShoppingArea.FirstOrDefault(c => c.WarehouseId == warehouse.WarehouseId & c.ShoppingAreaId == shoppingArea.ShoppingAreaId);
if (warehouseShoppingArea != null)
{
warehouseShoppingArea.ShoppingArea = shoppingArea;
warehouseShoppingArea.Warehouse = warehouse;
warehouseShoppingArea.UpdateStatus = 1;
await _context.SaveChangesAsync();
}
else
{
warehouseShoppingArea = new WarehouseShoppingArea();
warehouseShoppingArea.ShoppingArea = shoppingArea;
warehouseShoppingArea.Warehouse = warehouse;
warehouseShoppingArea.UpdateStatus = 1;
_context.WarehouseShoppingArea.Add(warehouseShoppingArea);
await _context.SaveChangesAsync();
}
return(Ok());
}
public async Task <UserInfo> AddUser(UserMeta userMeta)
{
var userInfo = new UserInfo((await uuidProvider.GetUUID(userMeta)).ToString())
{
Meta = userMeta,
RegistrationDate = DateTime.UtcNow
};
await usersCollection.InsertOneAsync(userInfo);
users[userInfo.UserId] = userInfo;
return(userInfo);
}
public IDEWindow()
{
this.InitializeComponent();
Instance = this;
this.ViewModel = new IDEWindowViewModel();
UserMeta.Load();
this.WhenActivated(dispose =>
{
this.WhenAnyValue(x => x.ViewModel.CurrentProject)
.Select(x => x is null ? "Horizon" : $"Horizon - {x.Name}")
.BindTo(this, x => x.Title)
.DisposeWith(dispose);
});
}
private void Start()
{
Debug.Log("start login...");
appConfig = ApplicationManager.appConfig;
userMeta = ApplicationManager.userMeta;
//登录按钮增加事件
loginBut.onClick.AddListener(LoginHandle);
//loginBut.OnPointerClick()
//增加注册按钮事件
registerBut.onClick.AddListener(RegisterHandler);
//试玩按钮事件,游客登录
guestBut.onClick.AddListener(GuestLogin);
//找回密码按钮事件
findPwdBut.onClick.AddListener(FindPwd);
userNameInput.text = userMeta.userName;
passwordInput.text = userMeta.password;
}
public ActionResult Create([Bind(Include = "UserName,UserPass,UserBio,Email,Url,Links")] User user)
{
var array = new string[] { Request.Form["fb"], Request.Form["yt"], Request.Form["ins"], Request.Form["web"] };
var newArray = array.Select(x => new { link = x }).ToArray();
var serializer = new JavaScriptSerializer();
var json = serializer.Serialize(newArray); // Convert to JSON
// create meta to store avatar of new user
var avatar = Request.Form["upload"];
UserMeta userMeta = new UserMeta();
try
{
if (ModelState.IsValid)
{
// Store new user to DB
user.UserRelease = DateTime.Now;
user.Links = json;
db.Users.Add(user);
db.SaveChanges();
// Store UserMate prefer to newest (just created) user
userMeta.MetaKey = "avatar";
userMeta.MetaValue = avatar;
userMeta.UserID = user.UserID;
db.UserMetas.Add(userMeta);
// Update DB
db.SaveChanges();
user.UserMetas.Add(userMeta);
db.SaveChanges();
return(RedirectToAction("Edit", new { id = user.UserID }));
}
}
catch (DataException /*de*/)
{
//Log the error (uncomment dex variable name and add a line here to write a log.
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
}
return(View(user));
}
private static void AddUsers(StoreContext context)
{
if (UserManager.FindByEmailAsync("*****@*****.**").GetAwaiter().GetResult() == null)
{
var user = new ApplicationUser
{
FirstName = "Admin",
LastName = "Admin",
UserName = "******",
Email = "*****@*****.**",
EmailConfirmed = true,
LockoutEnabled = false
};
var registerResult = UserManager.CreateAsync(user, "Admin@2018").GetAwaiter().GetResult();
if (registerResult.Succeeded)
{
UserManager.AddToRoleAsync(user, "Admins").GetAwaiter().GetResult();
var shoppingArea = new ShoppingArea
{
Descr = "Site " + user.LastName + " " + user.FirstName,
Code = "",
Version = "",
IsMark = false
};
var userMeta = new UserMeta
{
UserId = user.Id,
FirstName = user.FirstName,
LastName = user.LastName,
ShoppingArea = shoppingArea
};
context.ShoppingArea.Add(shoppingArea);
context.UserMeta.Add(userMeta);
context.SaveChanges();
user.UserMetaId = userMeta.Id;
UserManager.UpdateAsync(user).GetAwaiter().GetResult();
}
}
}
public MilestoneViewModel(INavigation navigation = null) : base(navigation)
{
trackerService = DependencyService.Get <ITrackerService>();
metaService = DependencyService.Get <IMetaService>();
authenticationService = DependencyService.Get <IAuthenticationService>();
userMilestoneService = DependencyService.Get <IUserMilestoneService>();
SetPageImageSize();
ShowBadgeAchievedImage = false;
BadgeAchievedImage = string.Empty;
StringFemale = StringFemaleDefault;
StringMale = StringMaleDefault;
ColorFemale = ColorMale = ColorGenderDefault;
ActionType = ActionType.Check;
BaseContent = null;
CurrentWeightMinimumValue = 0;
CurrentWeightMaximumValue = App.Configuration.AppConfig.MAXIMUM_WEIGHT_LOSE;
CurrentWeightValue = CurrentWeightMinimumValue;
UserTrackers = new List <UserTracker>();
UserMetas = new UserMeta();
WeightLossGoal = 0;
PreviousWeight = 0;
GoalAchieved = false;
CurrentWeightEnabled = true;
MilestoneAchieved = false;
AchievedContent = null;
CurrentTitle = TextResources.CurrentWeight;
CurrentSubTitle = string.Empty;
IsCurrentSubTitle = false;
ImageFront = ImageDefault;
ImageSide = ImageDefault;
TShirtSize = string.Empty;
AboutYourJourney = ErrorMessage;
MilestoneExtended = new UserMilestoneExtended();
Milestones = new List <MilestonePercentage>();
UserMilestones = new List <UserMilestone>();
ViewComponents = new List <View>();
GetUserTracker();
}
private static async Task <string> Convert(List <Meta> metas, MetaEnum key)
{
var val = "";
if (metas == null || metas.Count == 0)
{
return(val);
}
var userMeta = new UserMeta();
await Task.Run(() =>
{
var meta = metas.FirstOrDefault(u => u.MetaKey.ToLower().Contains(key.ToString()));
if (meta != null)
{
val = meta.MetaValue;
}
});
return(val);
}
public bool Vote(Duel duel, UserMeta voter, Vote vote)
{
// this method should only been invoked with actual vote selected
if (vote == Models.Vote.None)
{
throw new InvalidOperationException();
}
// user can only vote for running duel
if (duel.Status != DuelStatus.Started)
{
return(false);
}
// user cannot vote if he participates is duel
if (duel.Creator.User.Id == voter.Id || duel.Opponent.User.Id == voter.Id)
{
return(false);
}
// user cannot vote if he already voted
if (duel.Creator.Voters.Concat(duel.Opponent.Voters).Any(v => v.Id == voter.Id))
{
return(false);
}
// vote for creator
if (vote == Models.Vote.Creator)
{
duel.Creator.Voters.Add(voter);
_dbService.PushAsync <Duel, UserMeta>(duel.Id, d => d.Creator.Voters, voter);
}
// vote for opponent
else
{
duel.Opponent.Voters.Add(voter);
_dbService.PushAsync <Duel, UserMeta>(duel.Id, d => d.Opponent.Voters, voter);
}
return(true);
}
public async Task <IActionResult> DeleteCustomerShoppingArea([FromBody] Customer customer)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = await _context.Users.SingleAsync(x => x.UserName == HttpContext.User.Identity.Name);
if (user == null)
{
ModelState.AddModelError("", "Sory, your user is empty !");
return(BadRequest(ModelState));
}
UserMeta userMeta = _context.UserMeta.FirstOrDefault(u => u.Id == user.UserMetaId);
ShoppingArea shoppingArea = await _context.ShoppingArea.FirstOrDefaultAsync(x => x.ShoppingAreaId == userMeta.ShoppingAreaId);
if (shoppingArea == null)
{
ModelState.AddModelError("", "Sory, your Shoping Area is empty !");
return(BadRequest(ModelState));
}
CustomerShoppingArea customerShoppingArea = _context.CustomerShoppingArea.FirstOrDefault(c => c.ShoppingAreaId == userMeta.ShoppingAreaId && c.CustomerId == customer.CustomerId);
if (customerShoppingArea != null)
{
customerShoppingArea.UpdateStatus = 2;
await _context.SaveChangesAsync();
}
return(Ok());
}
public async Task <IActionResult> PostShoppingAreaUsers([FromBody] List <UserShoppingArea> userShoppingArea)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
int count = 0;
foreach (var item in userShoppingArea)
{
var user = await _context.Users.FirstOrDefaultAsync(x => x.Id == item.UserId);
if (user != null)
{
UserMeta userMeta = _context.UserMeta.FirstOrDefault(u => u.Id == user.UserMetaId);
ShoppingArea shoppingarea = await _context.ShoppingArea.FirstOrDefaultAsync(c => c.Code == item.ShoppingAreaCode);
if (shoppingarea != null)
{
userMeta.ShoppingAreaId = shoppingarea.ShoppingAreaId;
_context.AttachRange(userMeta);
//user.ShoppingAreaId = shoppingarea.ShoppingAreaId;
//_context.AttachRange(user);
count++;
}
}
}
await _context.SaveChangesAsync();
return(Ok(new { count = count }));
}
public DialogItemFactory(IStorageApi storageApi, ILogger logger, UserMeta user)
{
_storageApi = storageApi;
_logger = logger;
_user = user;
}
public CaloricManagmentItem(IStorageApi storageApi, ILogger logger, UserMeta user) : base(storageApi, logger, user)
{
itemType = DialogItemType.CaloricManagement;
_possibleProducts = new Dictionary<Guid, ProductInfo>();
_productWeight = 0;
}
public WhatIsDialogItem(IStorageApi storageApi, ILogger logger, UserMeta user) : base(storageApi, logger, user)
{
itemType = DialogItemType.CommandExecution;
}
public async Task <IActionResult> Register([FromBody] RegisterViewModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = await _userManager.FindByEmailAsync(model.Name);
if (user != null)
{
//return BadRequest("A user with that e-mail address already exists!");
return(BadRequest(_localizer["UserExist"].Value));
}
user = new ApplicationUser
{
Email = model.Name,
UserName = model.Name,
EmailConfirmed = true,
LockoutEnabled = true,
FirstName = model.FirstName,
LastName = model.LastName
};
var registerResult = await _userManager.CreateAsync(user, model.Password);
if (registerResult.Succeeded)
{
_logger.LogInformation("User created a new account with password.");
await _userManager.AddToRoleAsync(user, "Users");
var shoppingArea = new ShoppingArea
{
Descr = "Site " + model.LastName + " " + model.FirstName,
Code = "",
Version = "",
IsMark = false
};
var userMeta = new UserMeta
{
User = user,
FirstName = model.FirstName,
LastName = model.LastName,
ShoppingArea = shoppingArea
};
_context.ShoppingArea.Add(shoppingArea);
_context.UserMeta.Add(userMeta);
await _context.SaveChangesAsync();
user.UserMetaId = userMeta.Id;
await _userManager.UpdateAsync(user);
var code = await _userManager.GenerateEmailConfirmationTokenAsync(user);
var callbackUrl = Url.EmailConfirmationLink(user.Id, code, Request.Scheme);
await _emailSender.SendEmailConfirmationAsync(model.Name, callbackUrl);
await _signInManager.SignInAsync(user, isPersistent : false);
_logger.LogInformation("User created a new account with password.");
}
else
{
return(BadRequest(registerResult.Errors));
}
return(Ok());
}
public async Task <ActionResult> GetUserMeta(string username)
{
UserMeta user = await domain.RetrieveUserMeta(username);
return(Ok(user));
}
public async Task <ActionResult> UpdateUserMeta([FromBody] UserMeta userMeta, [ModelBinder(typeof(LoggedInUserModelBinder))] User activeUser)
{
await domain.UpdateUserMeta(userMeta, activeUser);
return(NoContent());
}
