public void CreateUser(User data)
{
DatabaseDataContext context = new DatabaseDataContext();
context.Users.InsertOnSubmit(data);
context.SubmitChanges();
}
public void RegisterUser(UserModel user)
{
databaseforassignmentEntities1 context = new databaseforassignmentEntities1();
User DBuser = new User();
if (context.Users.SingleOrDefault(u => u.email == user.email) == null)
{
DBuser.accountnumber = user.accountnumber;
DBuser.balance = 0;
DBuser.city = user.city;
DBuser.email = user.email;
DBuser.name = user.name;
DBuser.password = user.password;
DBuser.status = "active";
context.Users.Add(DBuser);
context.SaveChanges();
}
}
partial void DeleteUser(User instance);
partial void UpdateUser(User instance);
partial void InsertUser(User instance);
public void UpdateUser(User data)
{
DatabaseDataContext context = new DatabaseDataContext();
User user = context.Users.Where(u => u.UserID == data.UserID).SingleOrDefault();
user.Biography = data.Biography;
user.EmailAddress = data.EmailAddress;
user.Location = data.Location;
user.Name = data.Name;
user.Password = data.Password;
user.ProfilePictureID = data.ProfilePictureID;
user.Username = data.Username;
context.SubmitChanges();
}
public string Register(string nickname, string password, string firstName, string lastName, string info)
{
if (_db.User.Any() && _db.User.Any(u => u.Nickname == nickname))
return JsonConvert.SerializeObject(new JsonResult("another user have the same nickname"));
User user = new User
{
Nickname = nickname,
Password = password,
FirstName = firstName,
LastName = lastName,
Info = info,
ID = Guid.NewGuid()
};
JsonResult jsonResult;
try
{
_db.User.Add(user);
_db.SaveChanges();
}
catch (Exception)
{
jsonResult = new JsonResult("unknown error occured while adding a new record in data base");
return JsonConvert.SerializeObject(jsonResult);
}
jsonResult = new JsonResult(new List<Dictionary<string, object>>());
return JsonConvert.SerializeObject(jsonResult);
}