public static void AddUser(User user)
{
using (var hdc = new WebserviceDataContext())
{
hdc.Users.InsertOnSubmit(new User
{
Username = user.Username,
Password = user.Password,
Description = user.Description,
UpdateUser = user.UpdateUser,
UpdateDateTime = DateTime.Now
});
try
{
hdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static bool IsUserExist(string username)
{
var user = false;
using (var hdc = new WebserviceDataContext())
{
var count = hdc.Users.Count(item => item.Username == username);
if (count != 0)
{
user = true;
}
}
return user;
}
public static int Authentication(string username, string password)
{
var userId = 0;
using (var hdc = new WebserviceDataContext())
{
var count = hdc.Users.Count(item => item.Username.Equals(username)&&item.Password.Equals(password));
if (count != 0)
{
var user = hdc.Users.Single(item => item.Username.Equals(username) && item.Password.Equals(password));
userId = user.UserId;
}
}
return userId;
}
public static void DeleteUser(int userId)
{
using (var hdc = new WebserviceDataContext())
{
var user = hdc.Users.Single(item => item.UserId == userId);
hdc.Users.DeleteOnSubmit(user);
try
{
hdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static void UpdateUser(User user)
{
using (var hdc = new WebserviceDataContext())
{
var usr = hdc.Users.Single(item => item.UserId == user.UserId);
usr.Username = user.Username;
usr.Password = user.Password;
usr.Description = user.Description;
usr.UpdateUser = user.UpdateUser;
usr.UpdateDateTime = DateTime.Now;
try
{
hdc.SubmitChanges();
}
catch (SqlException ex)
{
if (ex.Number == 2601 || ex.Number == 2627)
{
throw;
}
}
}
}
public static List<User> ListUser()
{
var wdc = new WebserviceDataContext();
return wdc.Users.ToList();
}
