protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["UData"] != null)
{
DataSet MyRecDataSet = (DataSet)Session["UData"];
if ((Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["SystemAdmin"]) == true) || (Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["ApprovPermission"]) == true))
{/// Log Data Start
String Users = "Governorate";
if (Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["ApprovPermission"]) == true)
{
Users = "Internal Audit";
}
else if (Convert.ToBoolean(MyRecDataSet.Tables[0].Rows[0]["SystemAdmin"]) == true)
{
Users = "System Administrator";
}
Obj.ExecuteProcedureStringID("NewLogTable", Convert.ToInt32(MyRecDataSet.Tables[0].Rows[0]["EmpID"]), "View Sections Notes and Recommendations Charts by " + Users + "Permission");
/// Log Data End
DropYear.Items.Clear();
DropYear.DataSource = Obj.GetDataSet("GetPlans");
DropYear.DataTextField = "YearName";
DropYear.DataValueField = "ID";
DropYear.DataBind();
ListItem aa = new ListItem("جميع السنوات", "0");
DropYear.Items.Insert(0, aa);
DropYear.SelectedItem.Value = "0";
Admins.DataSource = Obj.GetDataSet("GetSectionsDashboard");
Admins.DataTextField = "SectionName";
Admins.DataValueField = "SectionID";
Admins.DataBind();
ListItem aaSection = new ListItem
{
Text = "اختر الإدارة العليا",
Value = ""
};
Admins.Items.Insert(0, aaSection);
}
else
{
Response.Redirect("NoPermissions.aspx");
}
}
}
}
public ActionResult DeleteAdmins(int adminid, int p)
{
Admins admin = adminsService.GetByID(adminid);
admin.Isenable = 0;
adminsService.SaveChanges();
return(RedirectToAction("Admins", new { p = p }));
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
RouteConfig.RegisterRoutes(RouteTable.Routes);
DataAccessLayer dal = new DataAccessLayer();
dal.Database.CreateIfNotExists();
List <string> basic = new List <string> {
"Wifi", "Laptop_Friendly_Workspace", "Cable_TV", "Washer", "Air_Conditioning", "TV", "Heating"
};
List <string> family = new List <string> {
"Crib", "High_Chair", "Travel_Crib", "Room-darkening_Shades", "Window_Guards"
};
List <string> facility = new List <string> {
"Elevator", "Paid_Parking_Off_Premices", "Single_Level_Home_(No_Stairs)", "Free_Street_Parking"
};
List <string> dining = new List <string> {
"Kitchen", "Coffee_Maker", "Cooking_Basics(Pots,_Pans,_Salt_Pepper", "Dishes_and_Silverware", "Microwave", "Refrigerator"
};
if (dal.availableamenitiesdb.ToList().Count == 0)
{
foreach (string str in basic)
{
dal.availableamenitiesdb.Add(new Models.AvailableAmenities {
type = 1, name = str.Replace('_', ' ')
});
}
foreach (string str in family)
{
dal.availableamenitiesdb.Add(new Models.AvailableAmenities {
type = 2, name = str.Replace('_', ' ')
});
}
foreach (string str in facility)
{
dal.availableamenitiesdb.Add(new Models.AvailableAmenities {
type = 3, name = str.Replace('_', ' ')
});
}
foreach (string str in dining)
{
dal.availableamenitiesdb.Add(new Models.AvailableAmenities {
type = 4, name = str.Replace('_', ' ')
});
}
dal.SaveChanges();
}
Admins admini = new Admins("~/App_Data/admini.txt");
HttpContext.Current.Application["admini"] = admini;
}
//登录
private void btnLogin_Click(object sender, RoutedEventArgs e)
{
if (txtLogId.Text.Trim().Length == 0)
{
MessageBox.Show("请输入登录账号！", "登录提示");
txtLogId.Focus();
return;
}
if (DataValidate.IsInteger(txtLogId.Text.Trim()) == false)
{
MessageBox.Show("请输入正确账号！(纯数字格式)", "登录提示");
txtLogId.Focus();
return;
}
if (txtLogPwd.Password.Trim().Length == 0)
{
MessageBox.Show("请输入登录密码！", "登录提示");
txtLogPwd.Focus();
return;
}
//输入的账号密码
Admins admin = new Admins()
{
Loginld = Convert.ToInt32(txtLogId.Text.Trim()),
//LoginPwd = txtLogPwd.Password
};
//和后台交互查询，判断登录信息是否正确
try
{
Admins mainuse = new AdminManager().GetAdmins(admin);
if (mainuse == null)
{
MessageBox.Show("用户账号不存在！", "提示信息");
txtLogId.Focus();
}
else
{
if (mainuse.LoginPwd == txtLogPwd.Password)
{
//保存登录信息
App.CurrentAdmin = mainuse;
this.DialogResult = true;
this.Close();
}
else
{
MessageBox.Show("用户密码错误！", "提示信息");
txtLogPwd.Focus();
}
}
}
catch (Exception ex)
{
MessageBox.Show("服务器连接异常，登录失败！请检查您的网络！");
}
}
public ActionResult Index()
{
string user_id = User.Identity.GetUserId();
Admins admin = db.Admins.Where(b => b.AspNetUserId == user_id).First();
var doctors = db.Doctors.Where(a => a.AdminId == admin.Id);
return(View(doctors));
}
public async Task <IActionResult> PutAdmins([FromBody] JObject json)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
dynamic data = json;
int id = data.id;
string name = data.name;
string pass = data.password;
string email = data.email;
int level = data.level;
bool active = data.active;
Admins admins = new Admins();
admins.level = level;
admins.name = name;
admins.email = email;
admins.active = active;
if (pass.Length > 0)
{
var new_pass = bf.Encrypt_CBC(pass);
admins.password = new_pass;
}
else
{
var old_pass = _context.Admins.FirstOrDefault(p => p.email == admins.email).password;
admins.password = old_pass;
}
var create_at = _context.Admins.FirstOrDefault(p => p.email == admins.email).date_create;
admins.date_create = create_at;
_context.Entry(admins).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!AdminsExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult EditAdmins(int adminid, int p, ICollection <AdminLims> AdminLims, int isenable = 0, string password = null)
{
Admins admin = adminsService.GetByID(adminid);
if (ModelState.IsValid)
{
admin.Isenable = Convert.ToByte(isenable);
if (password != null && password != "")
{
admin.Password = password;
}
if (AdminLims != null)
{
AdminLims = AdminLims.Where(a => a.LimID != 0).ToList();
foreach (AdminLims adminlim in admin.AdminLims.ToArray())
{
if (!AdminLims.ToList().Exists(a => a.LimID == adminlim.LimID))
{
admin.AdminLims.Remove(adminlim);
adminlimsService.Delete(adminlim.AdminLimID);
}
}
foreach (AdminLims al in AdminLims)
{
if (admin.AdminLims.ToList().Exists(a => a.LimID == al.LimID))
{
AdminLims cd = admin.AdminLims.Where(a => a.LimID == al.LimID).FirstOrDefault();
cd.IsAdd = al.IsAdd;
cd.IsUpdate = al.IsUpdate;
cd.IsDelete = al.IsDelete;
}
else
{
al.AdminLimID = Guid.NewGuid();
al.AdminID = admin.AdminID;
admin.AdminLims.Add(al);
}
}
}
adminsService.Update(admin);
adminsService.SaveChanges();
return(RedirectToAction("Admins", new { p = p }));
}
else
{
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists, see your system administrator.");
ViewBag.pageNumber = p;
ViewBag.Lims = limsService.Get().Where(a => a.ParentID == null).OrderBy(a => a.Sort);
return(View(admin));
}
}
protected override void Page_Show()
{
if (YRequest.GetQueryString("action") == "logout")
{
HttpCookie admincookie = currentcontext.Request.Cookies["cmsntadmin"];
if (admincookie != null)
{
admincookie.Expires = DateTime.Now.AddYears(-1);
currentcontext.Response.AppendCookie(admincookie);
}
ShowMsg("注销管理状态", "管理员登录注销成功,跳转到前台首页.", "", "index.aspx");
}
UserInfo userinfo = GetUserInfo();
if (userinfo == null)
{
ShowError("后台登陆", "发生错误,请先登录前台,然后再访问此页.", "", "login.aspx");
}
IsAdminLogined();
if (admininfo != null)
{
string action = YRequest.GetString("action") == string.Empty ? "default" : YRequest.GetString("action");
int id = YRequest.GetInt("id", 0);
url = string.Format("frame.aspx?action={0}&id={1}", action, id);
}
else
{
url = "";
if (ispost)
{
//todo adminlogin
string name = YRequest.GetFormString("loginname");
string password = YRequest.GetFormString("password");
string path = YRequest.GetFormString("path");
admininfo = Admins.GetAdminInfo(name, Natsuhime.Common.Utils.MD5(password));
if (admininfo != null && admininfo.Uid == userinfo.Uid)
{
HttpCookie admincookie = new HttpCookie("cmsntadmin");
admincookie.Values["adminid"] = admininfo.Adminid.ToString();
admincookie.Values["password"] = admininfo.Password;
admincookie.Values["path"] = path;
admincookie.Expires = DateTime.Now.AddMinutes(20d);
currentcontext.Response.AppendCookie(admincookie);
ShowMsg("后台登陆", "登录成功!开始跳转到后台首页", "", "admincp.aspx");
}
else
{
ShowError("后台登陆", "登录失败,用户名或密码错误!", "", "");
}
}
}
}
public ActionResult Edit([Bind(Include = "id_Admi,correo,pwd,usuario,nombre,ap_pat,ap_mat,puesto,rol")] Admins admins)
{
if (ModelState.IsValid)
{
db.Entry(admins).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(admins));
}
private static void RemoveAdmin(string username)
{
Admin admin = Admins.FirstOrDefault(x => x.UserName == username);
if (admin == null)
{
throw new Exception("There is no such admin");
}
Admins.Remove(admin);
}
//删除
public static int DeleteAdminsByName(string _name)
{
using (HullShellContainer hs = new HullShellContainer())
{
Admins adm = hs.AdminsSet.Where(a => a.UserName == _name).FirstOrDefault();
hs.DeleteObject(adm);
return(hs.SaveChanges());
}
}
public string GetPasswordD(int id, string login)
{
var flag = Admins.FirstOrDefault(a => a.Title == Operators.FirstOrDefault(c => c.OperatorID == id).UserStatus).Flag;
var key = Admins.FirstOrDefault(a => a.Title == Operators.FirstOrDefault(c => c.OperatorID == id).UserStatus).Key;
var sol = Admins.FirstOrDefault(a => a.Title == Operators.FirstOrDefault(c => c.OperatorID == id).UserStatus).Sol;
var p = Passwords.FirstOrDefault(i => i.Flag == flag && i.AccountID == Accounts.FirstOrDefault(a => a.Login == login).AccountID).Passwords;
string d = Encryption.Decrypt(p, key, sol);
return(d);
}
private void Init()
{
if (db == null)
{
var optionsBuilder = new DbContextOptionsBuilder <cap01devContext>();
optionsBuilder = optionsBuilder.UseNpgsql(Configuration["DatabaseConnectionString"]);
db = new cap01devContext(optionsBuilder.Options);
}
Admins.Clear(db);
}
public ActionResult Edit(Admins admins)
{
if (ModelState.IsValid)
{
context.Entry(admins).State = EntityState.Modified;
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(admins));
}
public ActionResult Edit([Bind(Include = "Id,ClinicName,AspNetUserId,Password,Login")] Admins admins)
{
if (ModelState.IsValid)
{
db.Entry(admins).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(admins));
}
public void test_update_time_changing_if_chaged_comment()
{
// TEST: testing update date and time changing, when comment has been changed
Admins item = new Admins();
DateTime updateDateTime = item.UpdateDate;
Thread.Sleep(50);
item.SetComment("Value");
Assert.AreNotEqual(updateDateTime, item.UpdateDate);
}
public static int DeleteAdminsById(int Id)
{
using (HullShellContainer hs = new HullShellContainer())
{
Admins adm = hs.AdminsSet.Where(a => a.Id == Id).FirstOrDefault();
hs.DeleteObject(adm);
return(hs.SaveChanges());
}
}
public void update_not_exists_admin()
{
Init();
// TEST: add new Admins without email to db
Admins.AddOrUpdate(item_with_valid_data);
//Assert.ThrowsException<KeyNotFoundException>(() =>
//{
//});
}
public void test_update_time_changing_if_disabled()
{
// TEST: testing update date and time changing, when IsActive has been changed
Admins item = new Admins();
DateTime updateDateTime = item.UpdateDate;
Thread.Sleep(50);
item.Disable();
Assert.AreNotEqual(updateDateTime, item.UpdateDate);
}
public ActionResult Guncelle(Admins c2)
{
var admin = db.Admins.Find(c2.AdminId);
admin.UserName = c2.UserName;
admin.Password = c2.Password;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void test_update_time_changing_if_chaged_password_hash()
{
// TEST: testing update date and time changing, when PasswordHash has been changed
Admins item = new Admins();
DateTime updateDateTime = item.UpdateDate;
Thread.Sleep(50);
item.Password = "******";
Assert.AreNotEqual(updateDateTime, item.UpdateDate);
}
public Admin GetAdminById(Guid userId)
{
return(Admins
.Include(u => u.Role)
.Include(u => u.Licensees)
.Include(u => u.AllowedBrands)
.Include(u => u.BrandFilterSelections)
.Include(u => u.Currencies)
.SingleOrDefault(u => u.Id == userId));
}
public ActionResult Edit(int Id)
{
Admins admins = context.Admins.Find(Id);
if (admins == null)
{
return(HttpNotFound());
}
return(View(admins));
}
// GET: Admin/Admins/Update/5
public ActionResult Update(int id)
{
Admins admins = db.Admins.Find(id);
if (admins == null)
{
return(HttpNotFound());
}
return(View(admins));
}
public ActionResult Validate([FromBody] Admins admin)
{
/* var _admin = db.Admins.Where(s => s.Email == admin.Email);
* if(_admin.Any()){
*
* if(_admin.Where(s => s.Password == admin.Password).Any()){
*
* return Json(new { status = true, message = "Login Successfull!"});
* }
* else
* {
* return Json(new { status = true, message = "Invalid Password!"});
* }
* }
* else
* {
* return Json(new { status = false, message = "Invalid Email!"});
* }*/
var _admin = db.Admins.Where(s => s.Email == admin.Email).FirstOrDefault();
if (_admin != null)
{
if (_admin.Password == admin.Password)
{
HttpContext.Session.SetString("email", _admin.Email);
HttpContext.Session.SetInt32("id", _admin.Id);
HttpContext.Session.SetInt32("role_id", (int)_admin.RolesId);
HttpContext.Session.SetString("name", _admin.FullName);
int roleId = (int)HttpContext.Session.GetInt32("role_id");
List <Menus> menus = db.LinkRolesMenus.Where(s => s.RolesId == roleId).Select(s => s.Menus).ToList();
DataSet ds = new DataSet();
ds = ToDataSet(menus);
DataTable table = ds.Tables[0];
DataRow[] parentMenus = table.Select("ParentId = 0");
var sb = new StringBuilder();
string menuString = GenerateUL(parentMenus, table, sb);
HttpContext.Session.SetString("menuString", menuString);
HttpContext.Session.SetString("menus", JsonConvert.SerializeObject(menus));
return(Json(new { status = true, message = "Login Successfull!" }));
}
else
{
return(Json(new { status = true, message = "Invalid Password!" }));
}
}
else
{
return(Json(new { status = false, message = "Invalid Email!" }));
}
}
public JsonResult delete([FromBody] string content)
{
try
{
Logger.Trace("AdminsController.delete IN");
HttpRequest Request = ControllerContext.HttpContext.Request;
if (!Request.ContentType.Contains("application/json"))
{
return(new JsonResult(ResponseData.CONFLICT_409("Wrong content type. Content type must be 'application/json'"))
{
StatusCode = (int)System.Net.HttpStatusCode.Conflict
});
}
if (Request.Body.Length > 1000)
{
return(new JsonResult(ResponseData.CONFLICT_409("Big content. The data length must be less than 1000"))
{
StatusCode = (int)System.Net.HttpStatusCode.Conflict
});
}
RequestData requestData = RequestData.Deserialize(Request.Body);
string Email = requestData.GetValue("email") as string;
Logger.Debug($"AdminsController.delete Email = {Email}");
Admins.Delete(Email, db);
Logger.Debug("AdminsController.delete deleted");
return(new JsonResult(ResponseData.OK_200())
{
StatusCode = (int)System.Net.HttpStatusCode.OK
});
}
catch (ValidationException ex)
{
Logger.Error(ex, "Error in Admins.delete: ValidateError");
return(new JsonResult(ResponseData.CONFLICT_409(ex.Message))
{
StatusCode = (int)System.Net.HttpStatusCode.Conflict
});
}
catch (Exception ex)
{
Logger.Error(ex, "Error in Admins.delete");
return(new JsonResult(ResponseData.INTERNAL_SERVER_ERROR_500())
{
StatusCode = (int)System.Net.HttpStatusCode.InternalServerError
});
}
finally
{
Logger.Trace("AdminsController.delete OUT");
}
}
public async Task <IActionResult> Create([Bind("AdminUsername,AdminEmail,AdminPassword")] Admins admins)
{
if (ModelState.IsValid)
{
_context.Add(admins);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(admins));
}
public static void RemoveLevels(Player player)
{
if (player.Data.LevelAdmin > 0)
{
Admins.Remove(player);
}
if (player.Data.LevelVip > 0)
{
Vips.Remove(player);
}
}
protected void Sector_SelectedIndexChanged(object sender, EventArgs e)
{
if (Sector.SelectedValue != "")
{
Admins.DataSource = Obj.GetDataSetByID("GetAdministrations", Convert.ToInt32(Sector.SelectedValue)); // Bind the Admins (Administrations) DropdownList
Admins.DataTextField = "AdmName"; // Set the text in the dropdown list
Admins.DataValueField = "AdmID"; // Set the value in the dropdown list
Admins.DataBind();
Admins.Items.Insert(0, "");
}
}
public ActionResult Create(Admins admins)
{
if (ModelState.IsValid)
{
context.Admins.Add(admins);
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(admins));
}
/// <summary>
/// 添加一条记录
/// </summary>
public int Add(Admins entity, IDbTransaction tran)
{
string sql = @"insert into [Admins]
([logName], [logPwd], [userName], [role], [editRole], [checkRole])
values
(@logName, @logPwd, @userName, @role, @editRole, @checkRole)";
object param = new
{
logName = entity.LogName,
logPwd = entity.LogPwd,
userName = entity.UserName,
role = entity.Role,
editRole = entity.EditRole,
checkRole = entity.CheckRole
};
int count = tran.Connection.Execute(sql, param, tran);
return count;
}
public void Can_Save_Valid_Changes()
{
// Arrange - create mock repository
Mock<IUsersRepository> mock = new Mock<IUsersRepository>();
// Arrange - create the controller
ProfileController target = new ProfileController(mock.Object);
// Arrange - create a Admin
Admins user = new Admins { Login = "******" };
// Act - try to save the product
ActionResult result = target.Edit(user);
// Assert - check that the repository was called
mock.Verify(m => m.EditUser(user));
// Assert - check the method result type
Assert.IsInstanceOfType(typeof(RedirectToRouteResult), result);
}
/// <summary>
/// 添加一条记录
/// </summary>
public ResultSet Add(Admins entity)
{
Func<Admins, ResultStatus> validate = (_entity) =>
{
return new ResultStatus();
};
Func<Admins, ResultStatus> op = (_entity) =>
{
int ret = new AdminsDal().Add(entity);
if (ret > 0)
return new ResultStatus();
else
return new ResultStatus()
{
Success = false,
Code = StatusCollection.AddFailed.Code,
Description = StatusCollection.AddFailed.Description
};
};
return HandleBusiness(entity, op, validate);
}
/// <summary>
/// 添加一条记录
/// </summary>
public int Add(Admins entity)
{
string sql = @"insert into [Admins]
([logName], [logPwd], [userName], [role], [editRole], [checkRole])
values
(@logName, @logPwd, @userName, @role, @editRole, @checkRole)";
object param = new
{
logName = entity.LogName,
logPwd = entity.LogPwd,
userName = entity.UserName,
role = entity.Role,
editRole = entity.EditRole,
checkRole = entity.CheckRole
};
using (IDbConnection conn = OpenConnection())
{
int count = conn.Execute(sql, param);
return count;
}
}
// Range: -1 Access: 0 Flags: ( 0, 4, 255 )
public static void load_admins( ) {
dynamic C = null;
ByTable rank_names = null;
AdminRank R = null;
ByTable Lines = null;
dynamic line = null;
ByTable List = null;
string ckey = null;
string rank = null;
Admins D = null;
DBQuery query = null;
string ckey2 = null;
string rank2 = null;
Admins D2 = null;
GlobalVars.admin_datums.Cut();
C = null;
foreach (dynamic _a in GlobalVars.admins ) {
C = _a;
if ( !Lang13.Bool( ((dynamic)typeof(Client)).IsInstanceOfType( C ) ) ) {
continue;
}
((dynamic)C).remove_admin_verbs();
C.holder = null;
};
GlobalVars.admins.Cut();
GlobalFuncs.load_admin_ranks();
rank_names = new ByTable();
R = null;
foreach (dynamic _b in GlobalVars.admin_ranks ) {
if ( !( _b is AdminRank ) ) {
continue;
}
R = _b;
rank_names[R.name] = R;
};
if ( GlobalVars.config.admin_legacy_system ) {
Lines = GlobalFuncs.file2list( "config/admins.txt" );
line = null;
foreach (dynamic _c in Lines ) {
line = _c;
if ( !Lang13.Bool( line.Length ) ) {
continue;
}
if ( String13.find_exact_case( line, "#", 1, 2 ) != 0 ) {
continue;
}
List = GlobalFuncs.text2list( line, "=" );
if ( !( List.len != 0 ) ) {
continue;
}
ckey = String13.ckey( List[1] );
if ( !Lang13.Bool( ckey ) ) {
continue;
}
rank = "";
if ( List.len >= 2 ) {
rank = String13.ckey_preserve_case( List[2] );
}
D = new Admins( rank_names[rank], ckey );
if ( !( D != null ) ) {
continue;
}
D.associate( GlobalVars.directory[ckey] );
};
} else {
GlobalFuncs.establish_db_connection();
if ( !GlobalVars.dbcon.IsConnected() ) {
((dynamic)Game13.log).write( "Failed to connect to database in load_admins(). Reverting to legacy system." );
((dynamic)GlobalVars.diary).write( "Failed to connect to database in load_admins(). Reverting to legacy system." );
GlobalVars.config.admin_legacy_system = true;
GlobalFuncs.load_admins();
return;
}
query = GlobalVars.dbcon.NewQuery( "SELECT ckey, rank FROM " + GlobalFuncs.format_table_name( "admin" ) );
query.Execute();
while (query.NextRow()) {
ckey2 = String13.ckey( query.item[1] );
rank2 = String13.ckey_preserve_case( query.item[2] );
if ( rank_names[rank2] == null ) {
GlobalFuncs.warning( "" + ( "Admin rank (" + rank2 + ") does not exist." ) + " in " + "code/modules/admin/admin_ranks.dm" + " at line " + 183 + " src: " + Task13.source + " usr: "******"." );
continue;
}
D2 = new Admins( rank_names[rank2], ckey2 );
if ( !( D2 != null ) ) {
continue;
}
D2.associate( GlobalVars.directory[ckey2] );
}
}
return;
}
