public void GetAdmin()
{
var repository = new AdminList();
var newAdmin = new Admin()
{
Name = "Jimi Hendrix",
StreetAddress = "12th Ave",
City = "Minneapolis",
State = "MN",
ZipCode = "12446"
};
var newAdminId = repository.AddAdmin(newAdmin);
Assert.IsTrue(null != newAdminId, "addition fail");
var admin = repository.GetAdmin(newAdminId.Value);
Assert.IsTrue(null != admin, "get new admin failed.");
Assert.AreEqual(newAdmin.Name, admin.Name, "name are not equal.");
Assert.AreEqual(newAdmin.StreetAddress, admin.StreetAddress, "address are not equal.");
Assert.AreEqual(newAdmin.City, admin.City, "city are not equal.");
Assert.AreEqual(newAdmin.State, admin.State, "state are not equal.");
Assert.AreEqual(newAdmin.ZipCode, admin.ZipCode, "zip code are not equal.");
var success = repository.DeleteAdmin(newAdminId.Value);
Assert.IsTrue(success, "delete admin failed.");
}
public void addAdminIntoList()
{
string sqlQuery = "Select * From Admin";
using (SqlCommand selectCommand = new SqlCommand(sqlQuery, dbConnection))
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = selectCommand;
DataSet AdminDataset = new DataSet();
adapter.Fill(AdminDataset, "Admin");
DataTable AdminDataTable = AdminDataset.Tables["Admin"];
foreach (DataRow row in AdminDataTable.Rows)
{
Admin admin = new Admin
{
Name = row[0].ToString(),
UserName = row[1].ToString(),
MailId = row[2].ToString(),
PhoneNumber = double.Parse(row[3].ToString()),
Password = row[4].ToString(),
Role = row[5].ToString(),
AdminID = int.Parse(row[6].ToString())
};
AdminList.Add(admin.AdminID, admin);
}
};
}
public MainWindow()
{
InitializeComponent();
DataContext = new SignInViewModel();
var window = Application.Current.MainWindow as ModernWindow;
AdminList = window?.MenuLinkGroups.ToList();
EmployeeList = window?.MenuLinkGroups.ToList();
SignInList = window?.MenuLinkGroups.ToList();
var toRemove1 = window?.MenuLinkGroups.ElementAt(4);
var toRemove2 = window?.MenuLinkGroups.ElementAt(5);
var toRemove3 = window?.MenuLinkGroups.ElementAt(6);
AdminList?.Remove(toRemove3);
EmployeeList?.Remove(toRemove1);
EmployeeList?.Remove(toRemove2);
EmployeeList?.Remove(toRemove3);
SignInList?.Clear();
SignInList?.Add(toRemove3);
window?.MenuLinkGroups.Clear();
if (SignInList == null)
{
return;
}
foreach (var item in SignInList)
{
window?.MenuLinkGroups.Add(item);
}
}
/// <summary>
/// Add a user to the admin list.
/// It will not add if the name is already on the list.
/// </summary>
/// <param name="user">The user's username.</param>
public void AddAdmin(string user)
{
if (!AdminList.Contains(user))
{
AdminList.Add(user);
}
}
public IActionResult Users()
{
int?sId = HttpContext.Session.GetInt32("ID");
if (sId == null)
{
return(RedirectToAction("Index", "Home"));
}
AdminList adm = new AdminList();
adm = db.AdminList.Where(x => x.UserID == sId).FirstOrDefault();//suanki user superadmin mi ?
AdminViewModel model = new AdminViewModel();
model.userList = db.Users.ToList();
if (adm.AuthDegree == 1)//superadminse eğer diğer adminleri görebilmeli
{
model.useradminList = new List <Users>();
List <AdminList> admins = new List <AdminList>();
admins = db.AdminList.ToList();
foreach (var user in model.userList)
{
foreach (var admin in admins)
{
if (user.ID == admin.UserID)
{
model.useradminList.Add(user);//adminleri bulduk.
}
}
}
model.superadmin = true;
}
return(View(model));
}
public void ReadAdmins()
{
try
{
// Setup the admins array
Admins = new AdminList();
OleDbDataReader drAdmins = DB.GetData("select * from haloce_server_admins");
if (drAdmins.HasRows)
{
while (drAdmins.Read())
{
string name = drAdmins.GetString(drAdmins.GetOrdinal("name"));
string keyhash = drAdmins.GetString(drAdmins.GetOrdinal("key_hash"));
int id = drAdmins.GetInt32(drAdmins.GetOrdinal("id"));
PlayerRecord pr = new PlayerRecord();
pr.id = id; pr.keyhash = keyhash; pr.name = name;
if (!Admins.Contains(keyhash))
{
Admins.Add(keyhash, pr);
}
}
}
drAdmins.Close();
}
catch
{
Admins = new AdminList();
Trace.WriteLine("ERROR: Failed to load admins!");
}
}
public JsonResult DeleteAdmin(string username)
{
bool IsDeleted = false;
Users user = new Users();
user = db.Users.Where(x => x.UserName == username).FirstOrDefault();
if (user != null)
{
AdminList adminlist = new AdminList();
adminlist = db.AdminList.Where(x => x.UserID == user.ID).FirstOrDefault();
try
{
db.Entry(adminlist).State = EntityState.Deleted;
db.SaveChanges();
IsDeleted = true;
}
catch (Exception)
{
IsDeleted = false;
}
}
return(Json(IsDeleted));
}
public JsonResult AddAdmin(string username)
{
bool data = false;
try
{
Users user = new Users();
user = db.Users.Where(x => x.UserName == username).FirstOrDefault();
if (user != null)
{
AdminList adminlist = new AdminList();
adminlist = db.AdminList.Where(x => x.UserID == user.ID).FirstOrDefault();
if (adminlist == null)
{
adminlist = new AdminList();
adminlist.UserID = user.ID;
adminlist.AuthDegree = 2;
adminlist.AuthName = "Admin";
db.AdminList.Add(adminlist);
db.SaveChanges();
data = true;
}
else
{
data = false;
}
}
}
catch (Exception)
{
data = false;
}
return(Json(data));
}
public JsonResult LoadDDLCityData(DDLCityDBModel _dbModel)
{
objList = new AdminList();
List <DDLCityDBModel> _dbModelList = new List <DDLCityDBModel>();
_dbModelList = objList.LoadDDLCityData(_dbModel);
return(this.Json(_dbModelList, JsonRequestBehavior.AllowGet));
}
public JsonResult LoadSelectedAdmin(AdminDBModel _dbModel)
{
objList = new AdminList();
List <AdminDBModel> _dbModelList = new List <AdminDBModel>();
_dbModelList = objList.LoadSelectedAdmin(_dbModel);
return(this.Json(_dbModelList, JsonRequestBehavior.AllowGet));
}
public void Save()
{
MemberList = MemberList.Distinct().ToList();
AdminList = AdminList.Distinct().ToList();
var di = Directory.CreateDirectory(Path.Combine(Utilities.RootPath, "Data", "Chats"));
File.WriteAllText(Path.Combine(di.FullName, ChatID + ".json"), JsonConvert.SerializeObject(this));
}
public static void _deploy(object data, bool update)
{
if (update)
{
return;
}
AdminList.Put(ISSUER_DEFAULT_PUBLIC_KEY, 0);
}
public IActionResult Login(Users model)
{
Users user = new Users();
bool password = false;
user = db.Users.Where(x => (x.Email == model.Email || x.UserName == model.Email) && x.AccountStatus != false).FirstOrDefault();
if (user != null)
{
if (user.Password == model.Password)
{
password = true;
}
else
{
password = false;
}
// password = Crypto.VerifyHashedPassword(user.Password, model.Password);
}
if (user != null)//üye bulunduysa
{
if (user.BannedStatus == true)
{
ViewBag.Warning = "You are banned.";
ViewBag.Status = "danger";
return(View());
}
if (password != false)
{
AdminList admin = db.AdminList.Where(x => x.User.ID == user.ID).FirstOrDefault();
if (admin == null)
{
HttpContext.Session.SetString("USER", user.UserName);//üye yönetici değil ise
HttpContext.Session.SetInt32("ID", user.ID);
}
else
{
HttpContext.Session.SetString("USER", user.UserName + "(" + admin.AuthName + ")");
HttpContext.Session.SetInt32("ID", user.ID);
}
user.LastActiveDate = DateTime.Now;
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.Warning = "Wrong password.Try again...";
ViewBag.Status = "danger";
}
}
else
{
ViewBag.Warning = "Email/User name not found.";
ViewBag.Status = "danger";
}
return(View());
}
protected void BindGrid()
{
this.TypeHid.Value = "2";
DataTable lists = bll.GetUserList();
AdminList.DataSource = lists;
AdminList.DataBind();
this.Label1.Text = "记录：" + lists.Rows.Count;
}
protected void BindGrid()
{
this.TypeHid.Value = "2";
DataTable dt = UserAccess.GetAdminUserList();
AdminList.DataSource = dt;
AdminList.DataBind();
this.Label1.Text = "记录：" + dt.Rows.Count;
}
protected void PopulateControls()
{
this.TypeHid.Value = "0";
DataTable dt = UserAccess.GetAdminUserListByDate(date);
AdminList.DataSource = dt;
AdminList.DataBind();
this.Label1.Text = "记录：" + dt.Rows.Count;
}
public IActionResult ReadArticle(int?id, int?cid)
{
if (id == null)
{
return(RedirectToAction("Index", "Home"));
}
int?userID = HttpContext.Session.GetInt32("ID");
ArticleViewModel model = new ArticleViewModel();
model.article = db.Articles.FirstOrDefault(x => x.ID == id && x.ArticleStatus == true);
if (model.article == null)
{
return(RedirectToAction("Index", "Home"));
}
model.article.Comments = db.Comments.Where(x => x.ArticleID == id).ToList();
foreach (var item in model.article.Comments)
{
item.User = db.Users.FirstOrDefault(x => x.ID == item.UserID);
}
model.article.User = db.Users.FirstOrDefault(x => x.ID == model.article.UserID);
model.article.Category = db.Categories.FirstOrDefault(x => x.ID == model.article.CategoryID);
model.favouriteArticles = db.FavouriteArticles.FirstOrDefault(x => x.ArticleID == id && x.UserID == userID);
if (model != null)
{
//model.article.Text = model.article.Text.Replace(Environment.NewLine, @"<br />");
if (model.favouriteArticles == null) //fav null ise article kişinin favorilerinde değildir.
{
model.favouriteArticles = new FavouriteArticles();
model.favouriteArticles.Favourite = false;
model.favouriteArticles.Liked = false;
}
}
else
{
return(RedirectToAction("ArticleCategories", "Article"));
}
AdminList admin = new AdminList();
admin = db.AdminList.Where(x => x.UserID == userID).FirstOrDefault();
if (admin == null)
{
model.admin = false;
}
else
{
model.admin = true;
}
if (cid != null)
{
model.complaintID = cid;
}
return(View(model));
}
private void PopulateControls()
{
this.TypeHid.Value = "0";
DateTime beginDate = curDate.Date;
DateTime endDate = curDate.AddDays(1).Date;
DataTable lists = bll.GetUserListByDate(beginDate, endDate);
AdminList.DataSource = lists;
AdminList.DataBind();
this.Label1.Text = "记录：" + lists.Rows.Count;
}
public JsonResult DeleteAdmin(AdminDBModel _dbModel)
{
int _result = 0;
objList = new AdminList();
_result = objList.DeleteAdmin(_dbModel);
if (_result > 0)
{
return(Json(new { success = true }));
}
else
{
return(Json(new { success = false }));
}
}
private void Bind()
{
StudentList.DataSource = bllStudent.GetAll();
StudentList.DataBind();
if (CheckAdmin())
{
AdminList.DataSource = bllAdmin.GetNotAdmin();
AdminList.DataBind();
}
else
{
AdminPanel.Visible = false;
}
}
public IViewComponentResult Invoke()
{
int?sId = HttpContext.Session.GetInt32("ID");
ViewModels.NavbarViewModel model = new ViewModels.NavbarViewModel();
model.Categori = db.Categories.ToList();
if (sId != null)
{
AdminList adminlist = new AdminList();
adminlist = db.AdminList.Where(x => x.UserID == sId).FirstOrDefault();
if (adminlist != null)
{
model.admin = true;
}
}
return(View(model));
}
public ActionResult Login(Users model)
{
Users user = new Users();
bool password = false;;
user = db.Users.Where(x => x.Email == model.Email || x.UserName == model.Email).FirstOrDefault();
if (user != null)
{
password = Crypto.VerifyHashedPassword(user.Password, model.Password);
}
if (user != null)//üye bulunduysa
{
//user = null;
//user = db.Users.Where(x => (x.Email == model.Email || x.NickName == model.Email) && x.Password == password).FirstOrDefault();
if (password != false)
{
AdminList admin = db.AdminList.Where(x => x.Users.ID == user.ID).FirstOrDefault();
if (admin == null)
{
Session["USER"] = user.UserName;//üye yönetici değil ise
Session["ID"] = user.ID;
}
else
{
Session["USER"] = user.UserName + "(" + admin.AuthName + ")";
Session["ID"] = user.ID;
}
return(RedirectToAction("Index", "Home"));
}
else
{
ViewBag.Warning = "Hatalı şifre.Lütfen yeniden deneyiniz.";
ViewBag.Status = "danger";
}
}
else
{
ViewBag.Warning = "Böyle bir Email/Nickname bulunamadı.";
ViewBag.Status = "danger";
}
return(View());
}
public IActionResult Complaints()
{
int?sId = HttpContext.Session.GetInt32("ID");
if (sId == null)
{
return(RedirectToAction("Index", "Home"));
}
AdminList adm = new AdminList();
adm = db.AdminList.Where(x => x.UserID == sId).FirstOrDefault();
AdminViewModel model = new AdminViewModel();
if (adm != null)
{
model.Complaints = db.Complaints.ToList();
}
return(View(model));
}
//搜索按钮
protected void Button4_Click(object sender, EventArgs e)
{
string keywords = this.KeyBox.Text.Trim().Replace("%", "");
if (keywords == "")
{
Utility.Alert(this, "关键字不能为空！");
return;
}
this.TypeHid.Value = "1";
DataTable dt = UserAccess.GetAdminUserListByKeywords(keywords);
AdminList.AllowPaging = false;
AdminList.PageIndex = 0;
AdminList.DataSource = dt;
AdminList.DataBind();
this.Label1.Text = "记录：" + dt.Rows.Count;
}
public IActionResult Admins()
{
if (HttpContext.Session.Get("userName") != null && accountType().Equals("Manager"))
{
//showing user name on admin pannel
UserNameOnAdminPanel();
var admins = _Context.Users.Where(u => u.UserID != 1000000).ToList();
AdminList adminModel = new AdminList
{
AdminAll = admins
};
return(View(adminModel));
}
else
{
return(RedirectToAction("Login", "Login"));
}
}
private void Login_Button_Click(object sender, RoutedEventArgs e)
{
string inputPassword = password.Password;
string inputUsername = username.Text;
bool switcher = true;
if (string.IsNullOrEmpty(inputUsername))
{
System.Windows.MessageBox.Show("Username box is empty");
switcher = false;
}
else if (string.IsNullOrEmpty(inputPassword))
{
System.Windows.MessageBox.Show("Password box is empty");
switcher = false;
}
if (switcher)
{
if (AdminList.isOnTheList(inputUsername, inputPassword))
{
System.Windows.MessageBox.Show("You are successfully logged in as an admin!");
Admin_ControlPanel admin_ControlPanel = new Admin_ControlPanel(this.Left, this.Top);
admin_ControlPanel.Show();
Close();
}
else if (UserList.isOnTheList(inputUsername, inputPassword))
{
CurrentlyLoggedUser.InitilizeCurrentyLoggedUser(UserList.GetId(inputUsername, inputPassword));
System.Windows.MessageBox.Show("You are successfully logged in as an user!");
User_ControlPanel user_ControlPanel = new User_ControlPanel(this.Left, this.Top);
user_ControlPanel.Show();
Close();
}
else
{
System.Windows.MessageBox.Show("Account does not exist! Click REGISTER button in order to register.");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!IsPostBack)
{
Butonvisible(true);
panelVisible(false, true, false, false);
}
Users user = (Users)Session["user"];
AdminList.DataSource = (from u in db.Users where u.ID != user.ID select u).ToList();
AdminList.DataBind();
((Master)this.Master).Path = "Kullanıcılar";
((Master)this.Master).PathLink = "AdminPage.aspx";
}
catch (Exception)
{
Uyari("Bir hata oluştu", false);
pnlAlert.Visible = true;
}
}
private void LoadAdmin()
{
AdminList.Clear();
SqlDataReader sqlData = null;
if (SharedPreference.Instance.LoginAdmin.ADMIN_GRADE == "000")
{
sqlData = new AdminQuery().SelectAll();
}
else
{
sqlData = new AdminQuery().SelectAllWithoutRoot();
}
if (sqlData.HasRows)
{
while (sqlData.Read())
{
AdminDTO dto = new AdminDTO
{
ADMIN_NUM = Int32.Parse(sqlData["num"].ToString()),
ADMIN_ID = sqlData["id"].ToString(),
ADMIN_PASSWORD = sqlData["password"].ToString(),
ADMIN_IDNUMBER = sqlData["idnumber"].ToString(),
ADMIN_NAME = sqlData["name"].ToString(),
ADMIN_RANK = sqlData["rank"].ToString(),
ADMIN_AUTH = sqlData["auth"].ToString(),
ADMIN_GRADE = sqlData["grade"].ToString()
};
AdminList.Add(new AdminModel(dto));
}
sqlData.Close();
SharedPreference.Instance.DBM.SqlConn.Close();
}
else
{
sqlData.Close();
SharedPreference.Instance.DBM.SqlConn.Close();
}
}
public void DeleteAdmin()
{
var repository = new AdminList();
var newAdmin = new Admin()
{
Name = "Jimi Hendrix",
StreetAddress = "12th Ave",
City = "Minneapolis",
State = "MN",
ZipCode = "12446"
};
var newAdminId = repository.AddAdmin(newAdmin);
Assert.IsTrue(null != newAdminId, "addition fail");
var admin = repository.GetAdmin(newAdminId.Value);
Assert.IsTrue(null != admin, "get new admin failed.");
var success = repository.DeleteAdmin(newAdminId.Value);
Assert.IsTrue(success, "delete admin failed.");
}
private void ProcessMessage(ServerMessage message)
{
var logMessage = new LogMessage
{
Date = DateTime.UtcNow,
Message = message.Message
};
switch (message.Type)
{
case ServerMessageType.PlayerList:
var list = new PlayerList(message);
OnPlayerHandler(list);
break;
case ServerMessageType.BanList:
var banList = new BanList(message);
OnBanHandler(banList);
break;
case ServerMessageType.AdminList:
var adminList = new AdminList(message);
OnAdminHandler(adminList);
break;
case ServerMessageType.MissionList:
var missinlist = new MissionList(message);
OnMissionHandler(missinlist);
break;
case ServerMessageType.ChatMessage:
var chatMessage = new ChatMessage
{
Date = DateTime.UtcNow,
Message = message.Message
};
OnChatMessageHandler(chatMessage);
break;
case ServerMessageType.RconAdminLog:
OnRConAdminLog(logMessage);
break;
case ServerMessageType.PlayerLog:
OnPlayerLog(logMessage);
break;
case ServerMessageType.BanLog:
OnBanLog(logMessage);
break;
case ServerMessageType.Unknown:
//var unknownMessage = new ChatMessage
//{
// Date = DateTime.UtcNow,
// Message = message.Message
//};
//OnChatMessageHandler(unknownMessage);
break;
}
RegisterMessage(message);
}
private void ProcessMessage(ServerMessage message)
{
switch (message.Type)
{
case ServerMessage.MessageType.PlayerList:
var list = new PlayerList(message);
OnPlayerHandler(list);
break;
case ServerMessage.MessageType.BanList:
var banList = new BanList(message);
OnBanHandler(banList);
break;
case ServerMessage.MessageType.AdminList:
var adminList = new AdminList(message);
OnAdminHandler(adminList);
break;
case ServerMessage.MessageType.MissionList:
var missinlist = new MissionList(message);
OnMissionHandler(missinlist);
break;
case ServerMessage.MessageType.ChatMessage:
var chatMessage = new ChatMessage()
{
Date = DateTime.UtcNow,
Message = message.Message
};
OnChatMessageHandler(chatMessage);
break;
case ServerMessage.MessageType.RconAdminLog:
OnRConAdminLog();
OnChatMessageHandler(new ChatMessage { Date = DateTime.UtcNow, Message = message.Message });
break;
case ServerMessage.MessageType.PlayerLog:
OnPlayerLog();
OnChatMessageHandler(new ChatMessage { Date = DateTime.UtcNow, Message = message.Message });
break;
case ServerMessage.MessageType.BanLog:
OnBanLog();
OnChatMessageHandler(new ChatMessage { Date = DateTime.UtcNow, Message = message.Message });
break;
case ServerMessage.MessageType.Unknown:
var unknownMessage = new ChatMessage()
{
Date = DateTime.UtcNow,
Message = message.Message
};
OnChatMessageHandler(unknownMessage);
break;
default:
break;
}
RegisterMessage(message);
}
