}//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
