public IHttpActionResult PuttblUserData(int id, tblUserData tblUserData)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != tblUserData.ID)
{
return(BadRequest());
}
db.Entry(tblUserData).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblUserDataExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public Boolean Delete(User user)
{
_context.Users.Remove(user);
_context.SaveChanges();
_logger.LogInformation("Delete Task Group " + user.UserId + " " + user.FirstName);
return(true);
}
/// <summary>
/// 创建新用户
/// </summary>
/// <param name="data">用户数据</param>
/// <returns>新用户ID</returns>
public async Task <int> CreateUserAsync([NotNull] PureUserData data)
{
UserCreateRequest request = new UserCreateRequest
{
Connection = configuration.GetAuth0Config(ConfigurationKeyConstants.Auth0Connection),
Email = data.Email,
PhoneNumber = data.PhoneNumber
};
User user = await userClient.CreateAsync(request);
if (user == null)
{
return(-1);
}
int nextId = dataContext.UserDatas.Select((data) => data.ID).Max() + 1;
// 获取可用身份列表
Role[] availableRoles = await roleGetter.GetAvailableRoles();
// 去除重复项与不在身份列表内的项
string[] roles = data.Role.Split(' ').Distinct()
.Where((name) => availableRoles.Any((role) => role.Name == name)).ToArray();
await userClient.AssignRolesAsync(user.UserId, new AssignRolesRequest { Roles = roles });
data.Role = roles.Aggregate((r1, r2) => r1 + ' ' + r2);
dataContext.Add <UserData>(data.ToUserData(nextId, user.UserId));
dataContext.SaveChanges();
return(nextId);
}
public Boolean Delete(TaskGroup taskGroup)
{
_context.TaskGroups.Remove(taskGroup);
_context.SaveChanges();
_logger.LogInformation("Delete Task Group " + taskGroup.TaskGroupId + " " + taskGroup.Name);
return(true);
}
public Boolean Delete(UserTask userTask)
{
_context.UserTasks.Remove(userTask);
_context.SaveChanges();
_logger.LogInformation("Delete Task Group " + userTask.UserTaskId + " " + userTask.Name);
return(true);
}
public ActionResult Create([Bind(Include = "ID,FirstName,LastName,BirthDay,Job,Address")] User user)
{
if (ModelState.IsValid)
{
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create([Bind(Include = "userID,firstName,lastName,userName,email,joined")] User user)
{
if (ModelState.IsValid)
{
user.joined = DateTime.Now;
db.Users.Add(user);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(user));
}
public ActionResult Create([Bind(Include = "ID,Name,Price")] UserData userData)
{
if (ModelState.IsValid)
{
userData.PriceinWord = AmountInWords.ConvertToWords(userData.Price);
db.Users.Add(userData);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(userData));
}
public bool AddUser(User user)
{
try
{
db.Users.Add(user);
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
logger.LogError(ex.Message);
return(false);
}
}
public int SaveProfile(MySettingsViewModel Data)
{
using (UserDataContext db = new UserDataContext())
{
var User = db.tblUserData.Single(o => o.UserName.Equals(Data.UserName));
if (Data.ConfirmPassword == User.UserPassword)
{
User.UserName = Data.UserName;
User.Email = Data.Email;
User.FirstName = Data.FirstName;
User.LastName = Data.LastName;
User.Gender = Data.Gender;
User.BirthDate = Data.BirthDate;
var Address = db.tblAddress.Single(o => o.ID.Equals(User.AddressID));
Address.Country = Data.Country;
Address.City = Data.City;
Address.Region = Data.Region;
Address.ZipCode = Data.ZipCode;
Address.Street = Data.Street;
Address.Number = Data.Number;
Address.ApartmentNumber = Data.ApartmentNumber;
db.SaveChanges();
return(0);
}
else
{
return(1);
}
}
}
public void PlaceBet(string teams, string formula, double coefficient, int id, double price, DateTime date)
{
using (UserDataContext db = new UserDataContext())
{
BetEntity bet = new BetEntity();
bet.Holder = db.Users.Find(id);
if (bet.Holder.Cash >= price)
{
db.Users.Find(id).Cash -= price;
}
else
{
throw new NotEnoughMoneyUserClientException("Недостаточно средств!");
}
bet.Date = date;
bet.Coeff = coefficient;
bet.Teams = teams;
bet.Formula = formula;
bet.BetPrice = price;
db.Bets.Add(bet);
db.SaveChanges();
}
MessageBox.Show("Готово!");
}
public void AddUser(string FirstName, string SecondName, string Email, string Password)
{
if (FirstName == string.Empty || SecondName == string.Empty || Email == string.Empty || Password == string.Empty)
{
throw new EmptyParameterException("Заполните все данные!");
}
using (UserDataContext db = new UserDataContext())
{
if (db.Users.FirstOrDefault(row => row.Email == Email) == null)
{
UserEntity user = new UserEntity();
user.FirstName = FirstName;
user.SecondName = SecondName;
user.Email = Email;
user.Password = Password;
user.UserStatus = "User";
user.Cash = 10;
db.Users.Add(user);
db.SaveChanges();
}
else
{
throw new AlreadyExistsUserClientException("Пользователь с таким адресом уже существует!");
}
}
}
public void Create(string roleName)
{
_context.Roles.Add(new RoleEntity {
Name = roleName
});
_context.SaveChanges();
}
public IActionResult Create([FromBody] UserData data)
{
if (data == null)
{
return(BadRequest());
}
var item = _UserDataContext.UserDatas.OrderByDescending(x => x.ID).FirstOrDefault();
data.ID = item.ID + 1;
data.CreateTime = DateTime.Now;
_UserDataContext.UserDatas.Add(data);
_UserDataContext.SaveChanges();
return(CreatedAtRoute("GetUser", new { id = data.ID }, data));
}
public Chart Index(UserData udInput)
{
if (ModelState.IsValid)
{
Point pt = new Point {
ChartId = p
};
p++;
int n = (udInput.RangeTo - udInput.RangeFrom) / (int)udInput.step;
px = new int[n + 1];
py = new int[n + 1];
int i;
for (i = 0, pt.PointX = udInput.RangeFrom; pt.PointX <= udInput.RangeTo; pt.PointX += (int)udInput.step, i++)
{
pt.PointY = udInput.a * (pt.PointX * pt.PointX) + udInput.b * pt.PointX + udInput.c;
px[i] = pt.PointX;
py[i] = pt.PointY;
db.Points.Add(pt);
db.SaveChanges();
}
// добавляем информацию о графике в базу данных
db.UserDatas.Add(udInput);
// сохраняем в бд все изменения
db.SaveChanges();
title = "y = " + udInput.a + "x^2 + " + udInput.b + "x + " + udInput.c;
return(new Chart(600, 400, ChartTheme.Blue)
.AddTitle("y = ax^2 + bx + c")
.AddLegend()
.AddSeries(
name: title,
chartType: "Spline", //not Line :)
xValue: px,
yValues: py)
.Write(format: "png"));
}
else
{
return(new Chart(300, 300, ChartTheme.Blue)
.AddTitle("Sorry, your data is not valid :( ")
.Write(format: "png"));
}
}
public void TraceError(string title, string message, SeverityLevel severityLevel)
{
using (var context = new UserDataContext()){
context.TraceMessage.Add(
new TraceMessage(title, message, severityLevel, DateTime.UtcNow)
);
context.SaveChanges();
}
}
/// <summary>
/// 释放由当前对象占有的所有资源。
/// </summary>
public void Dispose()
{
if (!m_readonly)
{
m_context.SaveChanges();
}
m_context.Dispose();
m_disposed = true;
}
public void PurchaseProduct(int userId, int productId)
{
using (var context = new UserDataContext()){
var product = context.Products.Find(productId);
product.OwnerId = userId;
product.IsPurchased = true;
context.SaveChanges();
}
}
public void ChangeGroupName(int id, string name)
{
using (var db = new UserDataContext())
{
var group = db.Groups.Find(id);
if (group != null)
{
group.Name = name;
db.SaveChanges();
}
}
}
public void Remove(DictionaryType type, int id)
{
using (var db = new UserDataContext())
{
var history = db.Histories.FirstOrDefault(t => t.Type == type && t.Id == id);
if (history != null)
{
db.Histories.Remove(history);
db.SaveChanges();
}
}
}
public bool AddNewProduct(Product product)
{
using (var context = new UserDataContext()){
if (DoesProductExist(product.ProductName) || product == null)
{
return(false);
}
context.Products.Add(product);
context.SaveChanges();
return(true);
}
}
public void Save(List <LogDTO> logDTO)
{
try
{
_context.Set <LogDTO>().AddRange(logDTO);
_context.ChangeTracker.DetectChanges();
_context.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("{0} Exception caught.", e);
}
}
public void DeleteGroup(int id)
{
using (var db = new UserDataContext())
{
var group = new Group()
{
Id = id
};
db.Groups.Attach(group);
db.Groups.Remove(group);
db.SaveChanges();
}
}
public bool SaveUser(User user)
{
using (var context = new UserDataContext()){
if (DoesUserExist(user.UserId, context))
{
return(false);
}
context.Users.Add(user);
context.SaveChanges();
}
return(true);
}
public IActionResult Create(UserInfo ui)
{
if (!ModelState.IsValid)
{
return(View());
}
ui.TodayDate = DateTime.Now;
_db.Posts.Add(ui);
_db.SaveChanges();
return(View());
}
private void Add(object sender, RoutedEventArgs e)
{
using (var context = new UserDataContext())
{
context.userData.Add(new UserData()
{
Id = ++id,
Email = Email.Text,
FirstName = txtBxName.Text,
LastName = txtBxLastName.Text,
});
context.SaveChanges();
}
}
public bool DeleteUser(int userId)
{
using (var context = new UserDataContext()){
if (!DoesUserExist(userId, context))
{
return(false);
}
var user = context.Users.SingleOrDefault(u => u.UserId == userId);
context.Users.Remove(user);
context.SaveChanges();
}
return(true);
}
public UserEntity Create(UserEntity user, string password, string userRole = "user")
{
if (string.IsNullOrWhiteSpace(password))
{
throw new AppException("Password is required");
}
if (_context.Users.Any(x => x.Username == user.Username))
{
throw new AppException("Username \"" + user.Username + "\" is already taken");
}
byte[] passwordHash, passwordSalt;
CreatePasswordHash(password, out passwordHash, out passwordSalt);
user.PasswordHash = passwordHash;
user.PasswordSalt = passwordSalt;
user.Roles.Add(userRole);
_context.Users.Add(user);
_context.SaveChanges();
return(user);
}
public UserController(UserDataContext userDataContext)
{
_UserDataContext = userDataContext;
if (_UserDataContext.UserDatas.Count() == 0)
{
_UserDataContext.UserDatas.Add(new UserData {
ID = 1,
Name = "Vacvin",
Birthday = DateTime.Parse("1982/01/01"),
CreateTime = DateTime.Now
});
_UserDataContext.SaveChanges();
}
}
public IActionResult Get()
{
if (_userDataContext.Users.ToList().Count == 0)
{
List <UserData> udata = new List <UserData>();
udata.Add(new UserData {
Email = "*****@*****.**", Name = "Ahmet", Password = "******"
});
udata.Add(new UserData {
Email = "*****@*****.**", Name = "Tarik", Password = "******"
});
udata.Add(new UserData {
Email = "*****@*****.**", Name = "Veli", Password = "******"
});
udata.Add(new UserData {
Email = "*****@*****.**", Name = "Ali", Password = "******"
});
_userDataContext.Users.AddRange(udata);
_userDataContext.SaveChanges();
}
var usersData = _userDataContext.Users.ToList();
return(Ok(usersData));
}