public void InsertUser(Users user)
{
using (var cnn = OpenConnection())
{
var id = cnn.Insert(user);
}
}
public void UpdateUser(Users user)
{
using (var cnn = OpenConnection())
{
cnn.Update(user);
}
}
public Users Map(LoginForm form)
{
var user = new Users();
user.Id = 0;
user.MembName = form.MembName;
user.Password = form.Password;
user.Lastlogin = DateTime.Now;
return user;
}
public Users Verification(Users user)
{
using (var cnn = OpenConnection())
{
var query = "select * from Users where Username=@Username and Password =@Password";
var result = cnn.Query<Users>(query, new { MembName = user.MembName, Password = user.Password });
return result.FirstOrDefault();
}
}
public Users Map(CreatUserForm form)
{
var user = new Users();
user.HospLocation = form.HospLocation;
user.HospName = form.HospName;
user.IsAdmin = form.IsAdmin;
user.MembPosition = form.MembPosition;
user.Password = form.Password;
user.MembName = form.MembName;
user.Lastlogin = DateTime.Now;
return user;
}
