public override bool DeleteUserRole(AUser user, AUserRole userRole)
{
context.UserRoleMap.Remove(new UserRoleMap {
User = user as AppUser, Role = userRole as Role
});
return(true);
}
// 删除用户
public ActionResult Delete(string name)
{
name = Request["name"].Trim();
AUser user = new AUser();
var rs = user.select(name);
if (rs != null)
{
user.delete(name);
if (user.select(name) == null)
{
return(Content(JsonConvert.SerializeObject(new
{
code = 1,
des = "删除成功",
})));
}
else
{
return(Content(JsonConvert.SerializeObject(new
{
code = 0,
des = "删除失败",
})));
}
}
else
{
return(Content(JsonConvert.SerializeObject(new
{
code = -1,
des = "不存在此用户",
})));
}
}
// 用户注册
public ActionResult Register(user usr)
{
AUser user = new AUser();
var rs = user.select(usr.User_name);
if (rs == null)
{
user.insert(usr);
if (user.select(usr.User_name) != null)
{
return(Content(JsonConvert.SerializeObject(new
{
code = 1,
des = "注册成功",
})));
}
else
{
return(Content(JsonConvert.SerializeObject(new
{
code = 0,
des = "注册失败,未能写入数据库",
})));
}
}
else
{
return(Content(JsonConvert.SerializeObject(new
{
code = -1,
des = "注册失败,已有该用户",
})));
}
}
/// <summary>
/// 添加用户
/// </summary>
/// <param name="AdUser"></param>
public void Create(AUser AdUser)
{
DirectoryEntry UserGroup = Get("(&(OU=" + AdUser.Orginzation + "))");
if (UserGroup == null)
{
throw new ArgumentException("未找到创建用户的组织单元");
}
DirectoryEntry user = UserGroup.Children.Add("CN=" + AdUser.Initial, "user");
UserGroup.Close();
user.Properties["sAMAccountName"].Value = AdUser.sAMAccountName;
user.Properties["sn"].Value = AdUser.Sn;
user.Properties["givenName"].Value = AdUser.GivenName;
if (AdUser.Day != 0 || AdUser.Month != 0 || AdUser.Year != 0)
{
if (user.Properties.Contains("accountExpires"))
{
user.Properties["accountExpires"].Value = DateTime.Now.ToString();
}
}
user.CommitChanges();
user.Close();
}
public static ForumEstCommentbyUser getoneForumCommentbyID(string forumcommentID)
{
ForumEstCommentbyUser fu = new ForumEstCommentbyUser();
try
{
SqlCommand command = new SqlCommand("Select * from ForumEstCommentbyUser where forumcommentID=@forumcommentID");
command.Parameters.AddWithValue("@forumcommentID", forumcommentID);
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
fu.forumcommentID = reader["forumcommentID"].ToString();
ForumEstablishments onef = ForumEstablishmentsDB.getForumEstbyID(reader["forumID"].ToString());
fu.forumID = onef;
fu.comments = reader["comments"].ToString();
AUser u = AUserDB.getUserbyID(reader["commentby"].ToString());
fu.commentby = u;
fu.date = Convert.ToDateTime(reader["date"]);
fu.status = reader["status"].ToString();
}
reader.Close();
}
finally
{
connection.Close();
}
return(fu);
}
public static List <ForumEstCommentbyUser> getalloneForumAllComment()
{
List <ForumEstCommentbyUser> fulists = new List <ForumEstCommentbyUser>();
try
{
SqlCommand command = new SqlCommand("Select * from ForumEstCommentbyUser");
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
ForumEstCommentbyUser fu = new ForumEstCommentbyUser();
fu.forumcommentID = reader["forumcommentID"].ToString();
ForumEstablishments onef = ForumEstablishmentsDB.getForumEstbyID(reader["forumID"].ToString());
fu.forumID = onef;
fu.comments = reader["comments"].ToString();
AUser u = AUserDB.getUserbyID(reader["commentby"].ToString());
fu.commentby = u;
fu.date = Convert.ToDateTime(reader["date"]);
fu.status = reader["status"].ToString();
fulists.Add(fu);
}
reader.Close();
}
finally
{
connection.Close();
}
return(fulists);
}
/// <summary>
/// Obtiene un usuario a partir de su ID.
/// </summary>
/// <param name="id">ID del usuario a consultar.</param>
/// <returns>Usuario encontrado o null</returns>
public AUser GetUser(int id)
{
conn.Open();
SqlCommand command = new SqlCommand("select * from [dbo].[fGetUser] (" + id + ")", conn);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataTable table = new DataTable("user");
adapter.Fill(table);
conn.Close();
if (table.Rows.Count > 0)
{
int rowid = (int)table.Rows[0]["ID"];
string email = table.Rows[0]["Email"].ToString();
string password = table.Rows[0]["Password"].ToString();
string name = table.Rows[0]["Name"].ToString();
AUser result = new AUser(email, password);
result.Name = name;
result.ID = rowid;
return(result);
}
else
{
return(null);
}
}
private async void UserAdd_BTN_Click(object sender, RoutedEventArgs e)
{
try
{
tempuser = new AUser(Username_TextBox.Text, Password_PasswordBox.Password, IsAdmin_ToggleSwitch.IsOn);
if (Username_TextBox.Text != string.Empty || Password_PasswordBox.Password != string.Empty)
{
data.Users.Users.Add(tempuser);
FillList();
}
if (Username_TextBox.Text == "")
{
throw new NullReferenceException("Wrong input please try again!");
}
if (Password_PasswordBox.Password == "")
{
data.Users.Users.Remove(tempuser);
throw new NullReferenceException("Wrong input please try again!");
}
}
catch (NullReferenceException)
{
await new MessageDialog("No input received, please try again!").ShowAsync();
}
}
private async void UserRemove_BTN_Click(object sender, RoutedEventArgs e)
{
try
{
tempuser = data.Users.FindUser(UserMGMT_ListView.SelectedItem.ToString());
{
if (tempuser.isAdmin)
{
throw new InvalidDataException("You cannot remove youserlf from the user list!");
}
data.Users.Users.Remove(tempuser);
FillList();
}
}
catch (NullReferenceException)
{
await new MessageDialog("No input received, please try again!").ShowAsync();
}
catch (InvalidDataException)
{
await new MessageDialog("You cannot remove youserlf from the user list!").ShowAsync();
}
}
// 添加用户
public ActionResult Add(user usr)
{
AUser user = new AUser();
var rs = user.select(usr.User_name);
// 本来没有该用户
if (rs == null)
{
user.insert(usr);
if (user.select(usr.User_name) != null)
{
return(Content(JsonConvert.SerializeObject(new
{
code = 1,
des = "添加成功",
})));
}
else
{
return(Content(JsonConvert.SerializeObject(new
{
code = 0,
des = "添加失败,未添加到数据库",
})));
}
}
else
{
return(Content(JsonConvert.SerializeObject(new
{
code = -1,
des = "添加失败，系统已有该用户"
})));
}
}
public async Task <IActionResult> Post([FromBody] LoginViewModel loginViewModel)
{
if (ModelState.IsValid)
{
try{
var user = new AUser()
{
UserName = loginViewModel.UserName
};
var result = await _userManager.CreateAsync(user, loginViewModel.Password);
// var roleResult = await _userManager.AddToRoleAsync(user, "Admin");
if (result.Succeeded)
{
foreach (string c in loginViewModel.Claims)
{
var claimResult = await _userManager.AddClaimAsync(user, new Claim(c, "True"));
if (!claimResult.Succeeded)
{
LogMessage("Claim failed: {c}");
break;
}
}
return(Ok());
}
}
catch (System.Exception ex)
{
LogMessage("Exception thrown while Registering User in: {ex}");
}
}
return(BadRequest("Failed to register"));
}
public static List <AForumUser> getAllForumUser()
{
List <AForumUser> forumlists = new List <AForumUser>();
try
{
SqlCommand command = new SqlCommand("Select * from ForumUser");
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
AForumUser fu = new AForumUser();
fu.ForumID = reader["forumID"].ToString();
fu.title = reader["title"].ToString();
fu.message = reader["message"].ToString();
fu.date = Convert.ToDateTime(reader["date"]);
fu.status = reader["status"].ToString();
AUser u = AUserDB.getUserbyID(reader["UserID"].ToString());
fu.userID = u;
forumlists.Add(fu);
}
reader.Close();
}
finally
{
connection.Close();
}
return(forumlists);
}
public static AForumUser getForumUserbyID(string id)
{
AForumUser fu = new AForumUser();
try
{
SqlCommand command = new SqlCommand("Select * from ForumUser where forumID=@forumID");
command.Parameters.AddWithValue("@forumID", id);
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
fu.ForumID = reader["forumID"].ToString();
fu.title = reader["title"].ToString();
fu.message = reader["message"].ToString();
fu.date = Convert.ToDateTime(reader["date"]);
fu.status = reader["status"].ToString();
AUser u = AUserDB.getUserbyID(reader["UserID"].ToString());
fu.userID = u;
}
reader.Close();
}
finally
{
connection.Close();
}
return(fu);
}
public async Task <AUser> GetUserById(long userId)
{
AUser user = null;
try
{
using (var messDbContext = new MessageDatabaseCont())
{
user = (await messDbContext.Users.SingleAsync <User>(u => u.UserId == userId)).ConvertToAUser();
var messages = messDbContext.Messages.Where(m => m.UserId == userId);
var aMessages = new List <AMessage>();
foreach (var message in messages)
{
aMessages.Add(message.ConvertToAMessage());
}
user.Messages = aMessages;
}
}
catch (InvalidOperationException)
{
throw;
}
return(user);
}
public AForumUser(string title, string message, DateTime date, string status, AUser userID)
{
this.title = title;
this.message = message;
this.userID = userID;
this.status = status;
this.date = date;
}
public ForumUserCommentbyUser(AForumUser forumID, string comments, AUser commentby, DateTime date, string status)
{
this.forumID = forumID;
this.comments = comments;
this.commentby = commentby;
this.date = date;
this.status = status;
}
public User(AUser user)
{
idUser = user.idUser;
FirstName = user.FirstName;
LastName = user.LastName;
MiddleName = user.MiddleName;
Email = user.Email;
idState = 1;
}
public ActionResult SaveUser(AUser user)
{
if (ModelState.IsValid)
{
Repository.Save(user);
return(View("Index"));
}
ViewBag.btnRetunn = false;
return(View("EditUser", user));
}
public override bool AddUserRole(AUser user, AUserRole userRole)
{
var urmap = new UserRoleMap()
{
User = user as AppUser, Role = userRole as Role
};
context.UserRoleMap.Add(urmap);
return(true);
}
public CharPageViewModel(AUser a, AUser b, string[] msgs)
{
messages = new ObservableCollection <object>();
currentUser = a;
sendToUser = b;
msgs.ForEach(msg => messages.Add(new TextMessage()
{
Author = sendToUser,
Text = msg,
}));
}
// 编辑用户
public ActionResult Update(user usr)
{
AUser user = new AUser();
user.update(usr);
return(Content(JsonConvert.SerializeObject(new
{
code = 1,
des = "修改成功"
})));
}
public CharPageViewModel()
{
messages = new ObservableCollection <object>();
currentUser = new AUser()
{
Name = "张俊杰", Avatar = "person.png", UserId = 14
};
sendToUser = new AUser {
Name = "朋友", Avatar = "person.png", UserId = 14
};
GenerateMessages();
}
public async Task <bool> TryRegister(AUser user)
{
bool result = false;
try
{
if (user != null)
{
string mess;
if (UserValidate(user, out mess))
{
bool userIsExist = await _repository.IsUserExist(user.Email);
if (!userIsExist)
{
_repository.AddUser(user);
result = true;
}
else
{
throw new UserExistException("User is exist");
}
}
else
{
throw new UserValidateException(mess);
}
}
else
{
throw new NullReferenceException("User is null");
}
}
catch (NullReferenceException e)
{
throw;
}
catch (UserValidateException e)
{
throw;
}
catch (UserExistException e)
{
throw;
}
catch (Exception e)
{
throw new NotImplementedException();
}
return(result);
}
static void Main(string[] args)
{
IFactory factory = FactoryUsers.getInstance();
AUser client = factory.createUser(UserType.CLIENT);
AUser administrator = factory.createUser(UserType.ADMINISTRATOR);
AUser contributor = factory.createUser(UserType.CONTRIBUTOR);
client.printInfo();
administrator.printInfo();
contributor.printInfo();
Console.ReadLine();
}
public void CreateUserTest()
{
IFactory factory = new Factory();
List <string> mockData = new List <string>()
{
"7", "TestFirst", "TestLast", "Testuser777", "testsalt", "testhash", "0000000000", "*****@*****.**", "7", "7"
};
IAUser expected = new AUser(mockData, new ConsoleLogger());
IAUser actual = factory.CreateUser(mockData, new ConsoleLogger());
Assert.True(expected.Username.Equals(actual.Username));
}
public static AUser ConvertToAUser(this User user)
{
AUser aUser = new AUser()
{
UserId = user.UserId,
FirstName = user.FirstName,
SecondName = user.SecondName,
Email = user.Email,
Messages = null
};
return(aUser);
}
public List <Order> BuildListByUser(AUser user)
{
List <Order> ordersByUser = new List <Order>();
foreach (Order order in this.OrderLibrary)
{
if (order.User == user.Email)
{
ordersByUser.Add(order);
}
}
return(ordersByUser);
}
//get all user list from database where the photo is from external side
public static List <AUser> getallUserswithlink()
{
List <AUser> users = new List <AUser>();
try
{
SqlCommand command = new SqlCommand("select * from Users where profile like '%http%'");
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
AUser u = new AUser();
u.userId = reader["UserId"].ToString();
u.email = reader["Email"].ToString();
u.name = reader["Name"].ToString();
u.dob = Convert.ToDateTime(reader["DOB"]);
u.gender = reader["Gender"].ToString();
u.rstatus = reader["Rstatus"].ToString();
u.height = Convert.ToInt32(reader["Height"]);
u.weight = Convert.ToInt32(reader["Weight"]);
u.bloodtype = reader["BloodType"].ToString();
u.username = reader["Username"].ToString();
u.password = reader["Password"].ToString();
u.phone = Convert.ToInt32(reader["Phone"]);
u.nric = reader["NRICNo"].ToString();
u.emergencyname = reader["EmergencyName"].ToString();
u.emergencyphone = Convert.ToInt32(reader["EmergencyPhone"]);
u.emergencyrelationship = reader["EmergencyRelationship"].ToString();
u.status = reader["Status"].ToString();
u.address = reader["Address"].ToString();
u.zipcode = Convert.ToInt32(reader["Zipcode"]);
u.nationality = reader["Nationality"].ToString();
u.profilepic = reader["Profile"].ToString();
u.doneby = reader["Doneby"].ToString();
u.medicalStatus = reader["medicalStatus"].ToString();
u.medicalStatusUpdateBy = reader["mediStatusUpdateBy"].ToString();
u.longtitude = reader["longitude"].ToString();
u.latitude = reader["latitude"].ToString();
users.Add(u);
}
reader.Close();
}
finally
{
connection.Close();
}
return(users);
}
public ActionResult CreateUser(AUser AdUser)
{
if (string.IsNullOrEmpty(AdUser.sAMAccountName))
{
throw new ArgumentException("账户名不能为空");
}
try
{
Core.ADManager.Create(AdUser);
}
catch (Exception ex)
{
throw new ArgumentException(ex.Message);
}
return(RedirectToAction("User"));
}
private bool UserValidate(AUser user, out string mess)
{
bool result = true;
UserValidator validator = new UserValidator(user);
validator.Validate();
if (validator.IsValid != true)
{
result = false;
mess = validator.Message;
}
else
{
mess = null;
}
return(result);
}
