protected void btnDelete_Click1(object sender, EventArgs e)
{
try
{
string del_list = hdfCheck.Value;
string[] sp_list = del_list.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
List <tblQuiz> arrDe = new List <tblQuiz>();
for (int i = 0; i < sp_list.Length; i++)
{
tblQuiz _quiz = (from p in sql.tblQuizs where p.ID == Convert.ToInt32(sp_list[i]) select p).FirstOrDefault();
_quiz.Status = -1;
//try
//{
// DataTable db = news.GetNewsByID(sp_list[i]);
// bool kt = File.Exists(Server.MapPath("~/Images/news/") + db.Rows[0]["IMAGE"]);
// if (kt)
// File.Delete(Server.MapPath("~/Images/news/") + db.Rows[0]["IMAGE"]);
//}
//catch (Exception)
//{
// throw;
//}
//news.tblNewsDelete(int.Parse(sp_list[i]));
}
sql.SubmitChanges();
Response.Redirect(Request.RawUrl);
}
catch (Exception ex)
{
divMessage.InnerHtml = O2S_Message.Error("Cảnh Báo", "Phát hiện lỗi! " + ex.Message);
}
}
public int AddQuiz(QuizModel quizModel)
{
try
{
using (var context = new MCQ_Quiz_DBEntities())
{
tblQuiz _tblQuiz = new tblQuiz();
// _tblQuiz.QuizId = quizModel.QuizId;
_tblQuiz.Title = quizModel.Title;
_tblQuiz.Summary = quizModel.Summary;
_tblQuiz.Type = quizModel.Type;
_tblQuiz.Subject = quizModel.Subject;
_tblQuiz.CreatedON = quizModel.CreatedON;
_tblQuiz.CreatedBy = quizModel.CreatedBy;
_tblQuiz.IsActive = quizModel.IsActive;
context.tblQuizs.Add(_tblQuiz);
context.SaveChanges();
return(_tblQuiz.QuizId);
}
}
catch (Exception ex)
{
return(-1);
}
}
public DataModel.Quiz Add(DataModel.Quiz obj)
{
try
{
var existing = context.tblQuizs.Where(x => x.Name == obj.Name).FirstOrDefault();
if (obj.ID != 0)
{
return(Update(obj));
}
tblQuiz quiz = new tblQuiz();
quiz.Name = obj.Name;
quiz.Description = obj.Description;
quiz.AllowReAttempt = obj.AllowReAttempt;
quiz.Hours = obj.Hours;
quiz.Minutes = obj.Minutes;
quiz.ReAttemptDuration = obj.ReAttemptDuration;
quiz.Timer = obj.Time;
quiz.PassMarks = obj.PassMarks;
quiz.QuizUrl = obj.QuizUrl;
quiz.CreatedBy = obj.CreatedBy;
quiz.CreatedAt = DateTime.Now;
quiz.Type = obj.Type;
quiz.UpdatedAt = DateTime.Now;
quiz.IsActive = obj.IsActive;
quiz.QuizNotes = obj.QuizNotes;
quiz.RequiresLogin = obj.RequiresLogin;
if (existing != null)
{
obj.ErrorMessage = "Quiz with same name already exists";
return(obj);
}
context.tblQuizs.Add(quiz);
context.SaveChanges();
//Assuming the database is generating your Id's for you
obj.ID = quiz.ID;
obj.Success = true;
obj.ErrorMessage = "Quiz saved successfully.";
return(obj);
}
catch (DbEntityValidationException ex)
{
foreach (var validationErrors in ex.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
Trace.TraceInformation("Property: {0} Error: {1}",
validationError.PropertyName,
validationError.ErrorMessage);
}
}
throw;
}
}
public bool action_update_status(int ID)
{
if (Session["username"] != null && !string.IsNullOrEmpty(Session["username"].ToString()))
{
tblQuiz _quiz = (from p in sql.tblQuizs where p.ID == ID select p).FirstOrDefault();
_quiz.Status = _quiz.Status == 0 ? 1 : 0;
sql.SubmitChanges();
return(true);
}
return(false);
}
public int Delete(bool IsDeleted)
{
tblQuiz quiz = new tblQuiz();
quiz.IsActive = IsDeleted;
context.Entry(quiz).State = EntityState.Modified;
int result = context.SaveChanges();
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
_quiz = (from p in sql.tblQuizs where p.ID == Convert.ToInt32(Request.QueryString["ID"]) && p.Status == 1 select p).FirstOrDefault();
if (_quiz == null)
{
Response.Redirect("~/thu-vien/ct61.htm", true);
}
DateTime _dateS = DateTime.Now;
totalSec = (_dateS.AddMinutes(Convert.ToInt32(_quiz.Min)) - _dateS).TotalSeconds;
this.Title = "Ask14.vn " + _quiz.Title;
}
public void SaveQuiz(tblQuiz Quiz)
{
if (Quiz.QuizId == 0)
{
db.tblQuizs.Add(Quiz);
}
else
{
db.Entry(Quiz).State = EntityState.Modified;
}
db.SaveChanges();
}
public List <accccc> GetDichVu()
{
int from = 1;
int to = 3;
int ID = 61;
List <dynamic> arr = new List <dynamic>();
arr.AddRange((from p in sql.tblNews where p.STATUS == 1 && (p.CATEGORYID.IndexOf(ID + ";") > -1 || p.CATEGORYID.Replace(";", "").Equals(ID.ToString()))select new { id = p.ID, time = p.CREATED_DATE, type = 0 }).OrderByDescending(d => d.time).Take(to));
arr.AddRange((from p in sql.tblQuizs where p.Status == 1 select new { id = p.ID, time = p.CreateDate, type = 1 }).OrderByDescending(d => d.time).Take(to));
arr = arr.OrderByDescending(d => d.time).ToList();
List <accccc> arrRe = new List <accccc>();
to = to > arr.Count ? arr.Count : to;
for (int i = from - 1; i < to; i++)
{
dynamic nData = arr[i];
accccc _data = new accccc();
int nId = Convert.ToInt32(nData.id);
if (nData.type == 0)
{
tblNew _new = (from p in sql.tblNews where p.ID == nId select p).FirstOrDefault();
_data.ID = _new.ID;
_data.CATEGORYNAME = "0";
_data.TITLE = _new.TITLE;
_data.IMAGE = _new.IMAGE;
_data.SUMMARY = _new.SUMMARY;
_data.CREATED_DATE = _new.CREATED_DATE;
_data.RowNumber = to - (to - i);
_data.RecordsTotal = to + 1;
arrRe.Add(_data);
}
else
{
tblQuiz _quiz = (from p in sql.tblQuizs where p.ID == nId select p).FirstOrDefault();
_data.ID = _quiz.ID;
_data.CATEGORYNAME = "quiz";
_data.TITLE = _quiz.Title;
_data.IMAGE = _quiz.Img;
_data.SUMMARY = _quiz.Des;
_data.CREATED_DATE = _quiz.CreateDate;
_data.RowNumber = to - (to - i);
_data.RecordsTotal = to + 1;
arrRe.Add(_data);
}
}
return(arrRe);
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null || String.IsNullOrEmpty(Session["username"].ToString()))
{
Response.Redirect("Login.aspx", true);
}
else
{
int ID = string.IsNullOrEmpty(Request.QueryString["ID"]) ? -1 : Convert.ToInt32(Request.QueryString["ID"]);
if (ID > 0)
{
tblQuiz _quiz = (from p in sql.tblQuizs where p.ID == ID && p.Status != -1 select p).FirstOrDefault();
if (_quiz == null)
{
Response.Redirect("Quiz.aspx", true);
}
dynamic struc_load_obj = new ExpandoObject();
struc_load_obj.setting_title = _quiz.Title;
struc_load_obj.setting_min = _quiz.Min;
struc_load_obj.setting_des = _quiz.Des;
struc_load_obj.setting_status = _quiz.Status;
strucdata = _quiz.Question;
try
{
struc_load_obj.setting_img = "data:image/png;base64," + Convert.ToBase64String(new WebClient().DownloadData(Lib.urlhome + "/images/news/" + _quiz.Img));
}
catch (Exception)
{
struc_load_obj.setting_img = "";
}
struc_load = JsonConvert.SerializeObject(struc_load_obj);
this.Title = "Chỉnh sửa " + _quiz.Title;
}
else
{
this.Title = "Thêm mới bài trắc nghiệm";
}
}
}
public DataModel.Quiz Update(DataModel.Quiz obj)
{
tblQuiz quiz = context.tblQuizs.Where(q => q.ID == obj.ID).FirstOrDefault();
quiz.Name = obj.Name;
quiz.Description = obj.Description;
quiz.AllowReAttempt = obj.AllowReAttempt;
quiz.Hours = obj.Hours;
quiz.Minutes = obj.Minutes;
quiz.ReAttemptDuration = obj.ReAttemptDuration;
quiz.Timer = obj.Time;
quiz.PassMarks = obj.PassMarks;
quiz.QuizUrl = obj.QuizUrl;
quiz.CreatedBy = obj.CreatedBy;
quiz.CreatedAt = DateTime.Now;
quiz.Type = obj.Type;
quiz.UpdatedAt = DateTime.Now;
quiz.IsActive = obj.IsActive;
quiz.QuizNotes = obj.QuizNotes;
quiz.RequiresLogin = obj.RequiresLogin;
context.Entry(quiz).State = EntityState.Modified;
int result = context.SaveChanges();
if (result > 0)
{
obj.Success = true;
obj.ErrorMessage = "Quiz updated successfully";
}
else
{
obj.Success = false;
obj.ErrorMessage = "An error occured while updating quiz.";
}
return(obj);
}
public object[] saveQuiz(string data)
{
if (Session["username"] != null && !string.IsNullOrEmpty(Session["username"].ToString()))
{
dynamic obj_all = JsonConvert.DeserializeObject <ExpandoObject>(data);
if (obj_all.id == -1)
{
dynamic ac = obj_all.setting;
string acv = ac.setting_title;
tblQuiz _quiz = new tblQuiz();
_quiz.Title = obj_all.setting.setting_title + "";
_quiz.Des = obj_all.setting.setting_des + "";
_quiz.Min = Convert.ToInt32(obj_all.setting.setting_min);
_quiz.Status = Convert.ToInt32(obj_all.setting.setting_status);
_quiz.CreateDate = DateTime.Now;
_quiz.Question = JsonConvert.SerializeObject(obj_all.questions);
sql.tblQuizs.InsertOnSubmit(_quiz);
sql.SubmitChanges();
if (_quiz.ID != null && _quiz.ID > 0)
{
string fileName = _quiz.ID + "-quiz-avarta.jpg";
Lib.ResizeByWidth(new MemoryStream(Convert.FromBase64String(Regex.Replace((string)obj_all.setting.setting_img, "data:image/.*?;base64,", ""))), 800).Save(Server.MapPath("~/images/news/") + fileName, ImageFormat.Png);
_quiz.Img = fileName;
sql.SubmitChanges();
return(new object[] { true, _quiz.ID });
}
else
{
return(new object[] { false, "Tạo bài trắc nghiệm thất bại" });
}
}
else
{
int _id = Convert.ToInt32(obj_all.id);
tblQuiz _quiz = (from p in sql.tblQuizs where p.ID == _id select p).FirstOrDefault();
if (_quiz == null)
{
return new object[] { false, "Không tìm thấy bài trắc nghiệm cần cập nhật" }
}
;
else
{
_quiz.Title = obj_all.setting.setting_title + "";
_quiz.Des = obj_all.setting.setting_des + "";
_quiz.Min = Convert.ToInt32(obj_all.setting.setting_min);
_quiz.Status = Convert.ToInt32(obj_all.setting.setting_status);
_quiz.Question = JsonConvert.SerializeObject(obj_all.questions);
string fileName = _quiz.ID + "-quiz-avarta.jpg";
Lib.ResizeByWidth(new MemoryStream(Convert.FromBase64String(Regex.Replace((string)obj_all.setting.setting_img, "data:image/.*?;base64,", ""))), 800).Save(Server.MapPath("~/images/news/") + fileName, ImageFormat.Png);
_quiz.Img = fileName;
sql.SubmitChanges();
return(new object[] { false, "Cập nhật thành công" });
}
}
}
else
{
return(new object[] { false, "Đăng nhập để sử dụng" });
}
}