}//editUserToolStripMenuItem_Click //----------------------------------------------------------------------------------------- private void btnCancel_Click(object sender, EventArgs e) { currentoperation = DataBaseOperation.none; grbUserInfor.Visible = false; Load_List_of_Users(); clear_form(); }//btnCancel_Click
public IActionResult UserManage(string mode, string from, string uid, string msg) { ViewData["where"] = ControllerName; if (ValidateSession()) { if (!CurrentUser.UserGroup.IsAdmin) { LW.E("Someone trying access illegal page!, Page: UserManage, user:"******", possible referer:" + Request.Headers["Referer"]); return(NotFound()); } ViewData["mode"] = mode; if (mode == "edit") { ViewData["from"] = from; string targetId = uid; string message = (string)PublicTools.DecodeObject(Encoding.UTF8.GetString(Convert.FromBase64String(msg ?? ""))); ViewData["registerMsg"] = message; return(DataBaseOperation.QuerySingleData(new DBQuery().WhereEqualTo("objectId", uid), out UserObject _user) == DBQueryStatus.ONE_RESULT ? View(_user) : NotFoundError(ServerAction.INTERNAL_ERROR, XConfig.Messages["NoUserFoundByGivenID"])); } else if (mode == "query") { return(View()); } else { throw new NotSupportedException("mode not supported!"); } } else { return(LoginFailed($"/Manage/UserManage?mode={mode}&from={from}&uid={uid}&msg={msg}")); } }
public JsonResult Get(string ClassID, string TeacherID) { if (!ValidateSession()) { return(SessionError); } if (!(CurrentUser.ClassList.Contains(ClassID) && CurrentUser.ObjectId == TeacherID)) { return(UserGroupError); } DBQuery StudentQuery = new DBQuery(); StudentQuery.WhereEqualTo("ClassID", ClassID); Dictionary <string, string> dict = new Dictionary <string, string>(); switch (DataBaseOperation.QueryMultipleData(StudentQuery, out List <StudentObject> StudentList)) { case DBQueryStatus.INTERNAL_ERROR: return(InternalError); default: dict.Add("count", StudentList.Count.ToString()); for (int i = 0; i < StudentList.Count; i++) { dict.Add("num_" + i.ToString(), StudentList[i].ToString()); } dict.Add("ErrCode", "0"); dict.Add("ErrMessage", "null"); return(Json(dict)); } }
} //Load_List_of_Load_List_of_Users //----------------------------------------------------------------------------------------- private void addNewUserToolStripMenuItem_Click(object sender, EventArgs e) { clear_form(); grbUserInfor.Visible = true; currentoperation = DataBaseOperation.Create; Load_List_of_Users(); }//addNewUserToolStripMenuItem_Click
public void Save() { int id = ID; string name = Name; DataBaseOperation.Save(this); }
public static bool ChangePassWord(UserObject NowUser, string OriPasswrd, string NewPasswrd) { if (OriPasswrd.SHA256Encrypt() != CurrentUser.Password) { LW.E("ChangePassword Request Failed, Reason: Original Password Incorrect...."); return(false); } else { NowUser.Password = NewPasswrd.SHA256Encrypt(); if (DataBaseOperation.UpdateData(ref NowUser, new DBQuery() .WhereEqualTo("objectId", CurrentUser.ObjectId) .WhereEqualTo("Password", OriPasswrd.SHA256Encrypt()) .WhereEqualTo("Username", CurrentUser.UserName)) == DBQueryStatus.ONE_RESULT) { LW.I("Change Password Success!"); return(true); } else { LW.I("Change Password Failed!"); return(false); } } }
private static bool SendMessage(InternalMessage message) { string MessageString = message.DataObject as string; if (DataBaseOperation.QueryMultiple(new DBQuery().Limit(5000), out List <UserObject> _usr) <= 0) { L.E("No Users Found???"); return(false); } WeChatSentMessage wxMsg = new WeChatSentMessage(WeChatSMsg.text, null, "来自管理员 " + message.User.RealName + "的消息:\r\n" + MessageString, null, null); switch (message.Identifier) { case "all": wxMsg.toUser = (from _ in _usr select _.UserName).ToArray(); break; case "bteachers": wxMsg.toUser = (from _ in _usr where _.UserGroup.IsBusManager select _.UserName).ToArray(); break; case "cteachers": wxMsg.toUser = (from _ in _usr where _.UserGroup.IsClassTeacher select _.UserName).ToArray(); break; case "parents": wxMsg.toUser = (from _ in _usr where _.UserGroup.IsParent select _.UserName).ToArray(); break; default: L.E("Unknown SendMessage Identifier " + message.Identifier); return(true); } WeChatMessageSystem.AddToSendList(wxMsg); return(true); }
public IActionResult SignStudent(string signmode) { ViewData["where"] = ControllerName; ViewData["SignMode"] = signmode; if (ValidateSession()) { ViewData["cUser"] = CurrentUser.ToString(); if (Request.Cookies["SignMode"] == signmode) { DataBaseOperation.QuerySingle(new DBQuery().WhereEqualTo("TeacherObjectID", CurrentUser.ObjectId), out SchoolBusObject busObject); if (busObject == null) { busObject = new SchoolBusObject() { ObjectId = "0000000000", BusName = "未找到班车", TeacherID = CurrentUser.ObjectId }; } ViewData["cBus"] = busObject.ObjectId; ViewData["mode"] = signmode; return(View()); } else { return(RequestIllegal(ServerAction.BusManage_SignStudents, XConfig.Messages["TokenTimeout"])); } } else { return(LoginFailed("/" + ControllerName + "/SignStudent?signmode=" + signmode)); } }
public override IActionResult Index() { ViewData["where"] = HomeController.ControllerName; if (ValidateSession()) { if (CurrentUser.UserGroup.IsClassTeacher && CurrentUser.ClassList.Count > 0) { switch (DataBaseOperation.QuerySingleData(new DBQuery().WhereEqualTo("objectId", CurrentUser.ClassList[0]), out ClassObject myClass)) { case DBQueryStatus.INTERNAL_ERROR: return(DatabaseError(ServerAction.MyClass_Index, XConfig.Messages.InternalDataBaseError)); case DBQueryStatus.NO_RESULTS: return(NotFoundError(ServerAction.MyClass_Index, XConfig.Messages["ClassNotFound"])); case DBQueryStatus.ONE_RESULT: ViewData["ClassName"] = string.Join(" ", myClass.CDepartment, myClass.CGrade, myClass.CNumber); ViewData["ClassID"] = myClass.ObjectId; ViewData["cUser"] = CurrentUser.ToString(); return(View()); default: return(DatabaseError(ServerAction.MyClass_Index, XConfig.Messages["MultipleClassIDsFound"])); } } else { return(RequestIllegal(ServerAction.MyClass_Index, XConfig.Messages["NotClassTeacher"], ResponceCode.Default)); } } else { return(LoginFailed("/ClassManager/Index/")); } }
public void Init(int index) { DataSet dataSet = DataBaseOperation.Query(index); Sex = Convert.ToBoolean(dataSet.Tables[0].Rows[0][0]); Hobby = dataSet.Tables[0].Rows[0][1].ToString(); }
}//frmContactList //----------------------------------------------------------------------------------------- private void frmContactList_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'contactListDataDataSet.tbl_Contact' table. You can move, or remove it, as needed. this.tbl_ContactTableAdapter.Fill(this.contactListDataDataSet.tbl_Contact); _currentOperation = DataBaseOperation.Read; this.Text = Properties.Resources.EnglishProgramTitle; }//frmContactList_Load
public IActionResult DirectGoHome() { ViewData["where"] = ControllerName; if (ValidateSession()) { if (!CurrentUser.UserGroup.IsParent) { return(PermissionDenied(ServerAction.MyChild_MarkAsArrived, XConfig.Messages["NotParent"], ResponceCode.PermisstionDenied)); } if (DataBaseOperation.QueryMultiple(new DBQuery() .WhereEqualTo("DirectGoHome", 0) .WhereValueContainedInArray("ObjectId", CurrentUser.ChildList.ToArray()), out List <StudentObject> ToBeSignedStudents) == DBQueryStatus.INTERNAL_ERROR) { return(DatabaseError(ServerAction.MyChild_MarkAsArrived, XConfig.Messages.InternalDataBaseError)); } ViewData["ChildCount"] = ToBeSignedStudents.Count; return(View(ToBeSignedStudents)); } else { return(LoginFailed("/" + ControllerName + "/DirectGoHomeSign")); } }
public JsonResult Get(string UserID) { if (ValidateSession()) { if (string.IsNullOrEmpty(UserID)) { return(RequestIllegal); } else { switch (DataBaseOperation.QuerySingleData(new DBQuery().WhereEqualTo("objectId", UserID), out UserObject user)) { case DBQueryStatus.INTERNAL_ERROR: case DBQueryStatus.MORE_RESULTS: return(InternalError); case DBQueryStatus.NO_RESULTS: return(SpecialisedInfo($"未知用户({UserID})")); default: return(SpecialisedInfo($"{user.RealName}({user.ObjectId})")); } } } else { return(SessionError); } }
public JsonResult GET(string BusID, string TeacherID, string ReportType, string Content) { if (!ValidateSession()) { return(SessionError); } if (TeacherID != CurrentUser.ObjectId) { return(RequestIllegal); } if (DataBaseOperation.QuerySingle(new DBQuery().WhereIDIs(BusID).WhereEqualTo("TeacherObjectID", TeacherID), out SchoolBusObject bus) != DBQueryStatus.ONE_RESULT) { return(RequestIllegal); } BusReport busReport = new BusReport { BusID = BusID, TeacherID = TeacherID, ReportType = (BusReportTypeE)Convert.ToInt32(ReportType), OtherData = Content }; if (DataBaseOperation.CreateData(ref busReport) != DBQueryStatus.ONE_RESULT) { return(DataBaseError); } InternalMessage message_TP = new InternalMessage(InternalMessageTypes.Bus_Status_Report, CurrentUser, busReport, BusID); MessagingSystem.AddMessageProcesses(message_TP); return(Json(new { Report = busReport })); }
public static bool Login(string xUserName, string xPassword, out UserObject user) { xUserName = xUserName.ToLower(); string HashedPs = xPassword.SHA256Encrypt(); DBQuery UserNameQuery = new DBQuery(); UserNameQuery.WhereEqualTo("Username", xUserName); UserNameQuery.WhereEqualTo("Password", HashedPs); switch (DataBaseOperation.QuerySingleData(UserNameQuery, out user)) { case DBQueryStatus.INTERNAL_ERROR: LW.E("Internal DataBase Error"); break; case DBQueryStatus.NO_RESULTS: LW.E("No User Found"); break; case DBQueryStatus.ONE_RESULT: LW.E("User Found"); return(true); case DBQueryStatus.MORE_RESULTS: LW.E("WTF Exception...."); break; default: break; } return(false); }
public JsonResult Get(string parentId) { if (!ValidateSession()) { return(SessionError); } if (!(CurrentUser.ObjectId == parentId && CurrentUser.UserGroup.IsParent)) { return(UserGroupError); } Dictionary <string, string> dict = new Dictionary <string, string>(); switch (DataBaseOperation.QueryMultipleData(new DBQuery().WhereValueContainedInArray("objectId", CurrentUser.ChildList.ToArray()), out List <StudentObject> StudentList)) { case DBQueryStatus.INTERNAL_ERROR: return(InternalError); default: dict.Add("count", StudentList.Count.ToString()); for (int i = 0; i < StudentList.Count; i++) { dict.Add("num_" + i.ToString(), StudentList[i].ToString()); } dict.Add("ErrCode", "0"); dict.Add("ErrMessage", "null"); return(Json(dict)); } }
private static bool Upload(DataGridViewRow row) { SchoolBusObject busObject = new SchoolBusObject(); if (row.Cells[0].Value == null && row.Cells[1].Value == null) { return(false); } if (row.Cells[0].Value == "" && row.Cells[1].Value == "") { return(false); } busObject.BusName = (string)row.Cells[1].Value; busObject.TeacherID = (string)row.Cells[3].Value ?? ""; busObject.LSChecked = (bool)row.Cells[4].Value; busObject.AHChecked = (bool)row.Cells[5].Value; busObject.CSChecked = (bool)row.Cells[6].Value; if (row.Cells[0].Value == null || row.Cells[0].Value.ToString() == "") { return(DataBaseOperation.CreateData(ref busObject) == DBQueryStatus.ONE_RESULT); } else { busObject.ObjectId = row.Cells[0].Value.ToString(); return(DataBaseOperation.UpdateData(ref busObject) == 0); } }
public void Save() { bool sex = Sex; string hobby = Hobby; DataBaseOperation.Save(this); }
} //btnSave_Click //----------------------------------------------------------------------------------------- private void btnDelete_Click(object sender, EventArgs e) { _currentOperation = DataBaseOperation.Delete; string strTitle = Properties.Resources.EnglishProgramTitle; string strMessage = ""; if (txtFirstName.Text.Length == 0) { strMessage = "Please select a contact first"; MessageBox.Show(strMessage, strTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning); }//if nothing is selected else { strMessage = "Are you sure that you want to remove the following record?"; strMessage += "\n" + txtFirstName.Text + " " + txtLastname.Text; DialogResult res = MessageBox.Show(strMessage, strTitle, MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (res == DialogResult.Yes) { int r = tbl_ContactTableAdapter.DeleteContact(int.Parse(txtContactID.Text)); if (r > 0) { tbl_ContactTableAdapter.Fill(contactListDataDataSet.tbl_Contact); clear_entry(); strMessage = "One record is removed"; MessageBox.Show(strMessage, strTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); }//if removed else { strMessage = "It was not possible to remove record, please try again"; MessageBox.Show(strMessage, strTitle, MessageBoxButtons.OK, MessageBoxIcon.Error); } //else if delete was uncompleted } //if Yes is clicked } //else if record is loaded } //btnDelete_Click
public JsonResult Get(string UserID) { if (!ValidateSession()) { return(SessionError); } if (string.IsNullOrEmpty(UserID)) { return(RequestIllegal); } string uName = ""; switch (DataBaseOperation.QuerySingle(new DBQuery().WhereIDIs(UserID), out UserObject user)) { case DBQueryStatus.INTERNAL_ERROR: case DBQueryStatus.MORE_RESULTS: return(InternalError); case DBQueryStatus.NO_RESULTS: uName = $"未知用户({UserID})"; break; default: uName = $"{user.RealName}({user.ObjectId})"; break; } return(Json(new { Name = uName })); }
public JsonResult Get(string BusID, string TeacherID, string Session) { if (!ValidateSession()) { return(SessionError); } if (!(CurrentUser.ObjectId == TeacherID)) { return(UserGroupError); } //user.UserGroup.BusID == BusID && DBQuery BusQuery = new DBQuery(); BusQuery.WhereIDIs(BusID); BusQuery.WhereEqualTo("TeacherObjectID", TeacherID); if (DataBaseOperation.QueryMultiple(BusQuery, out List <SchoolBusObject> BusList) != DBQueryStatus.ONE_RESULT) { return(InternalError); } string[] weekType = XConfig.ServerConfig.IsBigWeek() ? new string[] { "0", "1", "2" } : new string[] { "0", "2" }; switch (DataBaseOperation.QueryMultiple(new DBQuery().WhereEqualTo("BusID", BusList[0].ObjectId).WhereValueContainedInArray("WeekType", weekType), out List <StudentObject> StudentList)) { case DBQueryStatus.INTERNAL_ERROR: return(DataBaseError); case DBQueryStatus.INJECTION_DETECTED: return(RequestIllegal); default: return(Json(new { StudentList.Count, StudentList })); } }
public void Init(int index) { DataSet dataSet = DataBaseOperation.Query(index); ID = Convert.ToInt32(dataSet.Tables[0].Rows[0][0]); Name = dataSet.Tables[0].Rows[0][1].ToString(); }
}//UserManagement //----------------------------------------------------------------------------------------- private void UserManagement_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'factory_DataBaseDataSet_UserType.tbl_UserType' table. You can move, or remove it, as needed. this.tbl_UserTypeTableAdapter.Fill(this.factory_DataBaseDataSet_UserType.tbl_UserType); Load_List_of_Users(); currentoperation = DataBaseOperation.none; clear_form(); }//UserManagement_Load
}//btnCancel_Click //----------------------------------------------------------------------------------------- private void btnNewContact_Click(object sender, EventArgs e) { clear_entry(); grbEditData.Enabled = true; _currentOperation = DataBaseOperation.Create; btnNewContact.Enabled = false; btnEdit.Enabled = false; btnDelete.Enabled = false; }//btnNewContact_Click
}//check_existanse private void RemoveProductToolStripMenuItem_Click(object sender, EventArgs e) { btnSave.Visible = false; btnDelete.Visible = true; Load_List_of_Product(); currentoperation = DataBaseOperation.Delete; grbEntery.Visible = true; grbListItems.Visible = true; }//RemoveProductToolStripMenuItem_Click
/// <summary> /// Change the user data /// </summary> /// <param name="UserID">User name</param> /// <param name="Column">Column to be changed</param> /// <param name="Content">RAW value</param> /// <param name="STAMP">Time Stamp and hash</param> /// <param name="Ticket">Random string</param> /// <returns></returns> public JsonResult Get(string UserID, string Column, string Content, string STAMP) { object Equals2Obj = Content; if (int.TryParse((string)Equals2Obj, out int EqInt)) { Equals2Obj = EqInt; } else if (((string)Equals2Obj).ToLower() == "true") { Equals2Obj = true; } else if (((string)Equals2Obj).ToLower() == "false") { Equals2Obj = false; } string[] SessionVerify = STAMP.Split("_v3_"); if (SessionVerify.Length != 2) { return(RequestIllegal); } if (ValidateSession() && SessionVerify[0] == (CurrentUser.ObjectId + Content + SessionVerify[1]).SHA256Encrypt()) { //user.objectId = SessionUser.objectId; //user.UserGroup = SessionUser.UserGroup; switch (Column.ToLower()) { case "realname": CurrentUser.RealName = (string)Equals2Obj; break; case "password": CurrentUser.Password = (string)Equals2Obj; break; default: break; } var _tempUser = CurrentUser; if (DataBaseOperation.UpdateData(ref _tempUser) == 0) { UpdateUser(_tempUser); var result = new { ErrCode = 0, ErrMessage = "null", updated_At = DateTime.Now.ToNormalString(), user = CurrentUser }; return(Json(result)); } else { return(InternalError); } } else { return(RequestIllegal); } }
static void Main(string[] args) { LW.InitLog(); LW.SetLogLevel(LogLevel.Dbg); DataBaseOperation.InitialiseClient(); LW.D(DataBaseOperation.QuerySingleData(new DBQuery().WhereEqualTo("realname", "刘浩宇"), out UserObject me)); LW.D(me); ClassObject co = new ClassObject() { CDepartment = "学部", CGrade = "1年级", CNumber = "5班", TeacherID = me.ObjectId }; LW.D(DataBaseOperation.CreateData(ref co)); me.ClassList.Add(co.ObjectId); LW.D(co); SchoolBusObject bo = new SchoolBusObject() { BusName = "校车方向1", TeacherID = me.ObjectId }; LW.D(DataBaseOperation.CreateData(ref bo)); LW.D(bo); for (int cn = 1; cn < 40; cn++) { StudentObject stu = new StudentObject() { BusID = bo.ObjectId, ClassID = co.ObjectId, Sex = "M", StudentName = "学生-" + cn.ToString("000"), AHChecked = false, CSChecked = false, LSChecked = false }; LW.D(DataBaseOperation.CreateData(ref stu)); LW.D(stu); if (cn < 21) { me.ChildList.Add(stu.ObjectId); } } me.HeadImagePath = "liuhaoyu.gif"; LW.D(DataBaseOperation.UpdateData(ref me)); LW.D(me); }
public JsonResult Get(string BusID, string Column, string Content, string STAMP, string SALT) { if (Cryptography.SHA256Encrypt(BusID + ";;" + SALT + Column + ";" + Content + ";;" + SALT) != STAMP) { return(RequestIllegal); } DBQuery query = new DBQuery(); query.WhereEqualTo("objectId", BusID); switch (DataBaseOperation.QueryMultipleData(query, out List <SchoolBusObject> BusList)) { case DBQueryStatus.INTERNAL_ERROR: return(InternalError); case DBQueryStatus.NO_RESULTS: return(DataBaseError); default: { object Equals2Obj = Content; if (int.TryParse((string)Equals2Obj, out int EqInt)) { Equals2Obj = EqInt; } else if (((string)Equals2Obj).ToLower() == "true") { Equals2Obj = true; } else if (((string)Equals2Obj).ToLower() == "false") { Equals2Obj = false; } DBQuery query2 = new DBQuery(); query2.WhereEqualTo("BusID", BusList[0].ObjectId); query2.WhereEqualTo(Column, Equals2Obj); switch (DataBaseOperation.QueryMultipleData(query2, out List <StudentObject> StudentList)) { case DBQueryStatus.INTERNAL_ERROR: return(InternalError); case DBQueryStatus.NO_RESULTS: return(DataBaseError); default: Dictionary <string, string> dict = new Dictionary <string, string> { { "count", StudentList.Count.ToString() } }; for (int i = 0; i < StudentList.Count; i++) { dict.Add("num_" + i.ToString(), StudentList[i].ToString()); } dict.Add("ErrCode", "0"); dict.Add("ErrMsg", "null"); return(Json(dict)); } } } }
} //Load_List_of_Product //--------------------------------------------------------------------- private void EditProductToolStripMenuItem_Click(object sender, EventArgs e) { this.tbl_ColorTableAdapter.Fill(factory_DataBaseDataSet.tbl_Color); Load_List_of_Product(); currentoperation = DataBaseOperation.Update; grbEntery.Visible = true; grbListItems.Visible = true; btnSave.Visible = true; btnDelete.Visible = false; }//EditProductToolStripMenuItem_Click
}//clear_entery //--------------------------------------------------------------------- private void btnCancel_Click(object sender, EventArgs e) { clear_entery(); grbEntery.Visible = false; grbListItems.Visible = false; openToolStripMenuItem.Checked = false; btnSave.Visible = true; btnDelete.Visible = false; currentoperation = DataBaseOperation.none; }//btnCancel_Click