public ActionResult Update(Publication publication)
{
List <MySqlParameter> parameters = new List <MySqlParameter>();
string TimeOfViewParam = "@tov";
if (publication.TimeOfView > 0)
{
parameters.Add(new MySqlParameter("@tov", publication.TimeOfView));
}
else
{
TimeOfViewParam = "default";
}
if (publication.ExpiryDate < DateTime.Now.Date)
{
ViewBag.Status = false;
ViewBag.StatusMessage = "Please input Expiry Date.";
return(View());
}
parameters.Add(new MySqlParameter("@expdate", publication.ExpiryDate));
bool rlt = Mysqldb.Update($"update publications set TimeOfView={TimeOfViewParam}, ExpiryDate=@expdate where ID={publication.ID}", parameters);
if (rlt)
{
ViewBag.Status = true;
ViewBag.StatusMessage = "Publication Updated Successfully.";
TempData["ID"] = publication.ID;
PublicationsOnChange(publication.GetHashCode());
}
return(View(publication));
}
public ActionResult Index()
{
List <Publication> publications = new List <Publication>();
bool rlt = false;
if (Session["UserItem"] != null)
{
rlt = true;
}
DataSet ds = Mysqldb.Select($"select * from publications where ExpiryDate>='{DateTime.Now.Date:yyyy-MM-dd}' order by ExpiryDate");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
Publication pub = new Publication();
pub.ID = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"].ToString());
pub.TimeOfView = Convert.ToInt32(ds.Tables[0].Rows[i]["TimeOfView"].ToString());
pub.ExpiryDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["ExpiryDate"].ToString());
pub.ImageData = (byte[])ds.Tables[0].Rows[i]["Image"];
publications.Add(pub);
}
ViewBag.auth = rlt;
return(View(publications));
}
public ActionResult Index(User user)
{
if (user.Email == null || user.Pwd == null)
{
return(View());
}
string email = user.Email;
string pwd = user.Pwd;
DataSet ds = Mysqldb.Select("select * from users where Email='" + email + "'");
if (ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
int dbid = (int)ds.Tables[0].Rows[0][0];
string dbpwd = ds.Tables[0].Rows[0][3].ToString();
string dbusrname = ds.Tables[0].Rows[0][1].ToString();
if (dbpwd == pwd)
{
user.ID = dbid;
user.Username = dbusrname;
Session.Timeout = 30;
Session["UserItem"] = user;
return(RedirectToAction("Index", "Management"));
}
}
}
return(View());
}
private bool PublicationsOnChange(int ObjectHashCode)
{
using (SHA256 sha256 = SHA256.Create())
{
string hashedcode = Cryption.Encrypt(sha256, Convert.ToBase64String(BitConverter.GetBytes(ObjectHashCode)));
return(Mysqldb.Update($"update tables_onchange set Value='{hashedcode}' where TableName='publications'"));
}
}
public ActionResult Delete(int id)
{
Mysqldb.Delete($"delete from publications where ID={id}");
Publication pub = new Publication
{
ID = id
};
PublicationsOnChange(pub.GetHashCode());
return(RedirectToAction("Index", "Management"));
}
public static List <Publication> GetPublications()
{
// This method gets only continues publications
List <Publication> rlt = new List <Publication>();
//This Get publications with sql query.
DataSet ds = Mysqldb.Select($"select * from publications where ExpiryDate>='{DateTime.Now.Date:yyyy-MM-dd}'");
//This Loop on dataset table rows.
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
//This Get image bytes.
byte[] imgbyte = (byte[])ds.Tables[0].Rows[i]["Image"];
//This create instance MemoryStream with give image bytes.
using (MemoryStream ms = new MemoryStream(imgbyte))
{
//This create new instance of BitmapImage and initialize image bytes.
var imageSource = new BitmapImage
{
CreateOptions = BitmapCreateOptions.PreservePixelFormat
};
imageSource.BeginInit();
imageSource.StreamSource = ms;
imageSource.CacheOption = BitmapCacheOption.OnLoad;
imageSource.EndInit();
//This create new instance of publication and set properties.
Publication pub = new Publication
{
ID = Convert.ToInt32(ds.Tables[0].Rows[i]["ID"]),
Image = imageSource,
TimeOfView = Convert.ToInt32(ds.Tables[0].Rows[i]["TimeOfView"]),
ExpiryDate = Convert.ToDateTime(ds.Tables[0].Rows[i]["ExpiryDate"])
};
// Add to list to return
rlt.Add(pub);
}
}
// Get Publications On Change Hashcode.
PublicationBase.PublicationOnChange =
Mysqldb.Select("select * from tables_onchange where TableName='publications'").Tables[0].Rows[0]["Value"].ToString();
return(rlt);
}
public ActionResult Create(Publication publication)
{
if (publication.Image != null)
{
using (Stream istream = publication.Image.InputStream)
{
using (MemoryStream ms = new MemoryStream())
{
publication.Image.InputStream.CopyTo(ms);
byte[] image = ms.ToArray();
var Parameters = new List <MySqlParameter>();
string TimeOfViewParam = "default";
if (publication.TimeOfView > 0)
{
TimeOfViewParam = "@tov";
Parameters.Add(new MySqlParameter("@tov", publication.TimeOfView));
}
if (publication.ExpiryDate < DateTime.Now.Date)
{
ViewBag.Status = false;
ViewBag.StatusMessage = "Please input Expiry Date.";
return(View());
}
Parameters.AddRange(new MySqlParameter[]
{
new MySqlParameter("@expdate", publication.ExpiryDate.Date.ToString("yyyy-MM-dd")),
new MySqlParameter("@image", image)
});
if (Mysqldb.Insert($"insert into publications(TimeOfView,ExpiryDate,Image) values({TimeOfViewParam},@expdate,@image)", Parameters))
{
ViewBag.Status = true;
ViewBag.StatusMessage = "Publication Added Successfully.";
PublicationsOnChange(publication.GetHashCode());
}
}
}
}
else
{
ViewBag.Status = false;
ViewBag.StatusMessage = "Publication adding failed.";
}
return(View());
}
protected void login_Click(object sender, EventArgs e)
{
string sn = userid.Text.Trim();
string name = username.Text.Trim();
string pwd = password.Text.Trim();
string sql = null;
useridValidator.Validate();
usernameRequiredFieldValidator3.Validate();
passwordCustomValidator.Validate();
if (useridValidator.IsValid && usernameRequiredFieldValidator3.IsValid && passwordCustomValidator.IsValid)
{
try
{
sql = "select * from user where sn = @sn and name = @name and password = @pwd";
Mysqldb mysqldb = new Mysqldb();
MySqlConnection connection = mysqldb.getConnection();
MySqlCommand cmd = mysqldb.getCommand(connection);
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@sn", sn);
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@pwd", pwd);
MySqlDataReader reader = mysqldb.ExceSql_getDataReader(cmd, connection);
if (reader.HasRows)
{
//code here if the login is valid
mysqldb.Close();
// 将学生姓名、学号存储在 session 中
Session["sn"] = sn;
Session["username"] = name;
Response.Redirect("Default.aspx");
}
else
{
login_result.Text = "<a class='error'>学号、姓名、密码错误或者不存在</a>";
}
}
catch (Exception error)
{
//login_result.Text = "<a class='error'>服务器繁忙，请稍后重试</a>";
login_result.Text = error.ToString();
Console.WriteLine("An error occurred when connection trys to connect: '{0}'", error);
}
}
}
protected void signup_Click(object sender, EventArgs e)
{
string sql = null;
string userid = userid_sign.Text.Trim();
string email = email_sign.Text.Trim();
string username = username_sign.Text.Trim();
string pwd = password_sign.Text.Trim();
userid_signCustomValidator2.Validate();
username_signRequiredFieldValidator1.Validate();
email_signValidator1.Validate();
passwordValidator.Validate();
PasswordCompareValidator.Validate();
if (userid_signCustomValidator2.IsValid && username_signRequiredFieldValidator1.IsValid && email_signValidator1.IsValid && passwordValidator.IsValid && PasswordCompareValidator.IsValid)
{
try
{
sql = "insert into user (sn, name, password, email) values (@userid, @username, @pwd, @email)";
Mysqldb mysqldb = new Mysqldb();
MySqlConnection connection = mysqldb.getConnection();
MySqlCommand cmd = mysqldb.getCommand(connection);
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@userid", userid);
cmd.Parameters.AddWithValue("@username", username);
cmd.Parameters.AddWithValue("@pwd", pwd);
cmd.Parameters.AddWithValue("@email", email);
if (mysqldb.ExceSql(cmd, connection))
{
//成功插入，注册成功，重新登陆
mysqldb.Close();
this.RegisterStartupScript("hello", "<script>alert('注册成功，请登录!')</script>");
}
else
{
login_result.Text = "<a class='error'>注册失败，请稍后重试</a>";
}
}
catch (Exception error)
{
//login_result.Text = "<a class='error'>服务器繁忙，请稍后重试</a>";
login_result.Text = error.ToString();
Console.WriteLine("An error occurred when connection trys to connect: '{0}'", error);
}
}
}
public void GetHistory()
{
string userId = Session["sn"].ToString();
string sql = "select id, examId, score, datetime from exam_record where userId = @userId";
Mysqldb mysqldb = new Mysqldb();
MySqlConnection connection = mysqldb.getConnection();
MySqlCommand cmd = mysqldb.getCommand(connection);
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@userId", userId);
MySqlDataAdapter da = new MySqlDataAdapter();
connection.Open();
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "history");
GridView_Exam_History.DataSource = ds;
GridView_Exam_History.DataBind();
connection.Close();
}
public ActionResult Update(int id = 0)
{
Publication pub = new Publication();
TempData["ID"] = id;
if (id > 0)
{
DataSet ds = Mysqldb.Select($"select * from publications where ID={id}");
if (ds.Tables.Count > 0)
{
pub.ID = Convert.ToInt32(ds.Tables[0].Rows[0]["ID"].ToString());
pub.TimeOfView = Convert.ToInt32(ds.Tables[0].Rows[0]["TimeOfView"].ToString());
pub.ExpiryDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["ExpiryDate"].ToString());
PublicationsOnChange(pub.GetHashCode());
}
return(View(pub));
}
return(View());
}
//This method check on change status.
public static string OnChange()
{
string rlt = null;
//Get publications table hashcode.
DataSet ds = Mysqldb.Select("select * from tables_onchange where TableName='publications'");
if (ds.Tables[0].Rows.Count > 0)
{
if (PublicationBase.PublicationOnChange == null)
{
PublicationBase.PublicationOnChange = ds.Tables[0].Rows[0]["Value"].ToString();
}
else
{
string poc = ds.Tables[0].Rows[0]["Value"].ToString();
if (poc != PublicationBase.PublicationOnChange)
{
rlt = poc;
}
}
}
return(rlt);
}
public MainWindow()
{
InitializeComponent();
// Initialize mysql database connection.
Mysqldb.Open();
// Get publications list.
publications = PublicationServices.GetPublications();
// Check publications count bigger than 0.
if (publications.Count > 0)
{
//Check first publication expiry date is expired or not.
if (publications[0].ExpiryDate < DateTime.Now.Date)
{
//Remove first publication from list
publications.RemoveAt(0);
}
//Set first index publication to image view.
SlaytShow.Dispatcher.Invoke(() => { SlaytShow.Source = publications[0].Image; });
//Set animation slider.
InitProgressAnimation(publications[0].TimeOfView);
pubIndx++;
}
else
{
// Set default image when no publications stored in db.
SlaytShow.Source = GetDefaultImage();
InitProgressAnimation(DefaultTimeOfView);
SlaytShowProgress.Visibility = Visibility.Hidden;
SlaytShow.Margin = new Thickness(0, 0, 0, 0);
}
}
protected void Submit1_Click(object sender, EventArgs e)
{
if (count_total == 15)
{
Mysqldb mysqldb = new Mysqldb();
MySqlConnection connection = mysqldb.getConnection();
MySqlCommand cmd = mysqldb.getCommand(connection);
ArrayList questions_one_chosed = null;
ArrayList questions_more_chosed = null;
ArrayList questions_judge_chosed = null;
ConnectMongo();
int score_total = 0;
string userid = Session["sn"].ToString();
Hashtable Question_Save = (Hashtable)Session["Question_Save"];
ArrayList question_one = (ArrayList)Question_Save["questions_one"];
ArrayList question_more = (ArrayList)Question_Save["questions_more"];
ArrayList question_judge = (ArrayList)Question_Save["questions_judge"];
Hashtable hashtable_question_one = Exam_Drector.Get_Score(DataList_Questoin_One, question_one, "questions_one");
Hashtable hashtable_question_more = Exam_Drector.Get_Score(DataList_Questoin_More, question_more, "questions_more");
Hashtable hashtable_question_judge = Exam_Drector.Get_Score(DataList_Questoin_Judge, question_judge, "questions_judge");
score_total = Convert.ToInt32(hashtable_question_one["questions_one_score"]) + Convert.ToInt32(hashtable_question_more["questions_more_score"]) + Convert.ToInt32(hashtable_question_judge["questions_judge_score"]);
Session["hashtable_question_one"] = hashtable_question_one;
Session["hashtable_question_more"] = hashtable_question_more;
Session["hashtable_question_judge"] = hashtable_question_judge;
Session["score_total"] = score_total;
count_total = 0; // 对进度条清0
// 存储这次考试记录
DateTime datetime = DateTime.Now;
string exam_id = userid.ToString() + "_" + datetime.ToString();
string sql = "insert into exam_record (userId, examId, score, datetime) VALUES (@userid, @exam_id, @score_total, @datetime)";
cmd.CommandText = sql;
cmd.Parameters.AddWithValue("@userid", userid);
cmd.Parameters.AddWithValue("@exam_id", exam_id);
cmd.Parameters.AddWithValue("@score_total", score_total.ToString());
cmd.Parameters.AddWithValue("@datetime", datetime.ToString());
if (mysqldb.ExceSql(cmd, connection))
{
//成功插入
mysqldb.Close();
}
else
{
Response.Write("mysql 插入失败");
}
mysqldb.ExceSql(cmd, connection);
// 将这次考试的试题信息，以及答题信息存储到 mongodb 中
var document = new BsonDocument
{
{ "examId", exam_id },
};
// 用户题目 选择
question_one = ArraylistToObject(question_one);
question_more = ArraylistToObject(question_more);
question_judge = ArraylistToObject(question_judge);
questions_one_chosed = (ArrayList)hashtable_question_one["questions_one_chosed"];
questions_more_chosed = (ArrayList)hashtable_question_more["questions_more_chosed"];
questions_judge_chosed = (ArrayList)hashtable_question_judge["questions_judge_chosed"];
var question_one_save = new List <ArrayList> {
question_one
};
var question_more_save = new List <ArrayList> {
question_more
};
var question_judge_save = new List <ArrayList> {
question_judge
};
var question_one_chosed_save = new List <ArrayList> {
questions_one_chosed
};
var question_more_chosed_save = new List <ArrayList> {
questions_more_chosed
};
var question_judge_chosed_save = new List <ArrayList> {
questions_judge_chosed
};
document.Add("question_one", new BsonArray(question_one_save));
document.Add("question_more", new BsonArray(question_more_save));
document.Add("question_judge", new BsonArray(question_judge_save));
document.Add("questions_one_chosed", new BsonArray(question_one_chosed_save));
document.Add("questions_more_chosed", new BsonArray(question_more_chosed_save));
document.Add("questions_judge_chosed", new BsonArray(question_judge_chosed_save));
//document.Add("question_chosed", new BsonArray(question_chosed));
mongodb.GetCollection("exam");
mongodb.Insert(document);
Response.Redirect("~/Result.aspx");
}
else
{
#pragma warning disable CS0618 // 类型或成员已过时
this.RegisterStartupScript("hello", "<script>alert('还有题目未完成哦!')</script>");
#pragma warning restore CS0618 // 类型或成员已过时
}
}
