public ActionResult InsertInteres(string id_user, string interes, int id_producto, string name)
{
using (DBEnt db = new DBEnt())
{
DateTime aDate = DateTime.Now;
var interestr = interes;
interestr = interestr.Replace("%", "");
var intereDeci = Convert.ToDecimal(interestr);
var interx = new ProductoFinancieroInteres()
{
id_productofinanciero = id_producto,
interes = intereDeci
};
db.ProductoFinancieroInteres.Add(interx);
db.SaveChanges();
}
var action = "Insert";
var comments = "Interes para Producto Financiero " + name + " ingresado por el usuario : ";
InsertInBitacora(id_user, action, comments + id_user);
return(RedirectToAction("Details", "ProductoFinanciero", new { id = id_producto }));
}
public ActionResult AddMcq(McqViewModel collection)
{
//return Json(collection, JsonRequestBehavior.AllowGet);
Mcq mcq = new Mcq()
{
ExamId = collection.ExamId,
SubjectId = collection.SubjectId,
ChapterId = collection.ChapterId,
Question = collection.Question.ToString(),
OptionA = collection.OptionA.ToString(),
OptionB = collection.OptionB.ToString(),
OptionC = collection.OptionC.ToString(),
OptionD = collection.OptionD.ToString(),
CorrectOption = collection.CorrectOption.ToString(),
UpVotes = 5,
DownVotes = 0,
Status = "approve",
EntryDate = DateTime.Now,
};
DBEnt db = new DBEnt();
db.Submissions.Add(new Submission()
{
UserID = User.Identity.GetUserId(), McqId = mcq.Id
});
db.Mcqs.Add(mcq);
db.SaveChanges();
Alerts.addMcq = true;
return(RedirectToAction("allMcq", "Admin"));
}
public ActionResult addSubject(SubjectViewModel collection)
{
if (!subjectExist(collection.Name))
{
DBEnt db = new DBEnt();
string filename = Path.GetFileNameWithoutExtension(collection.Image.FileName);
string ext = Path.GetExtension(collection.Image.FileName);
filename = filename + DateTime.Now.Millisecond.ToString();
filename = filename + ext;
string filetodb = "/Image/" + filename;
filename = Path.Combine(Server.MapPath("~/Image/"), filename);
collection.Image.SaveAs(filename);
collection.Cover = filetodb;
db.Subjects.Add(new Subject()
{
Name = collection.Name, Cover = collection.Cover
});
db.SaveChanges();
Alerts.addSubject = true;
return(RedirectToAction("addSubject", "Admin"));
}
else
{
Alerts.alreadyExist = true;
return(RedirectToAction("addSubject", "Admin"));
}
}
public ActionResult pendingMcq()
{
DBEnt db = new DBEnt();
var mcqs = db.Mcqs.Where(x => x.Status != "approve").ToList <Mcq>();
List <McqViewModel> mcq = new List <McqViewModel>();
foreach (Mcq i in mcqs)
{
McqViewModel obj = new McqViewModel()
{
Id = i.Id,
Question = i.Question,
OptionA = i.OptionA,
OptionB = i.OptionB,
OptionC = i.OptionC,
OptionD = i.OptionD,
CorrectOption = i.CorrectOption,
Exam = getExamType(i.ExamId),
ChapterId = Convert.ToInt32(i.ChapterId),
SubjectId = Convert.ToInt32(i.SubjectId),
Upvotes = Convert.ToInt32(i.UpVotes),
Downvotes = Convert.ToInt32(i.DownVotes),
Status = i.Status,
Subject = mcqSubject(i.Id),
Chapter = mcqChapter(i.Id)
};
mcq.Add(obj);
}
return(View(mcq));
}
public ActionResult takeSubjectExam(long?id)
{
DBEnt db = new DBEnt();
var subject = db.Subjects.Where(x => x.Id == id).FirstOrDefault();
return(Json(subject, JsonRequestBehavior.AllowGet));
}
public ActionResult deleteUser(string id)
{
DBEnt db = new DBEnt();
var user = db.AspNetUsers.Where(x => x.Id == id).FirstOrDefault();
List <AspNetRole> roles = user.AspNetRoles.ToList();
try
{
if (roles.FirstOrDefault().Name == "Admin")
{
return(Content("Admin cannot be deleted!"));
}
if (roles.FirstOrDefault().Name != "Admin")
{
db.Entry(user).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
Alerts.deleteUser = true;
return(RedirectToAction("allUsers", "Admin"));
}
}
catch
{
db.Entry(user).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
Alerts.deleteUser = true;
return(RedirectToAction("allUsers", "Admin"));
}
return(Content("Error........"));
}
//Open Source Submission
public ActionResult addOpenSpurceMcq(McqViewModel collection)
{
Mcq mcq = new Mcq()
{
ExamId = collection.ExamId,
SubjectId = collection.SubjectId,
ChapterId = collection.ChapterId,
Question = collection.Question,
OptionA = collection.OptionA,
OptionB = collection.OptionB,
OptionC = collection.OptionC,
OptionD = collection.OptionD,
CorrectOption = collection.CorrectOption,
UpVotes = 5,
DownVotes = 0,
Status = "pending",
EntryDate = DateTime.Now,
};
string userId = User.Identity.GetUserId().ToString();
DBEnt db = new DBEnt();
db.Mcqs.Add(mcq);
db.Submissions.Add(new Submission()
{
UserID = User.Identity.GetUserId(), McqId = mcq.Id
});
db.SaveChanges();
Alerts.openSubmit = true;
return(RedirectToAction("Index", "Front"));
}
public ActionResult takeProperExam(long?id)
{
DBEnt db = new DBEnt();
var exam = db.Exams.Where(x => x.Id == id).FirstOrDefault();
return(Json(exam, JsonRequestBehavior.AllowGet));
}
public string getExamType(long?id)
{
DBEnt db = new DBEnt();
var obj = db.Exams.Where(x => x.Id == id).First();
return(obj.Name);
}
public ActionResult startSubjectExam(long?id)
{
DBEnt db = new DBEnt();
List <Mcq> subjectMcq = db.Mcqs.Where(x => x.ChapterId == id).ToList <Mcq>();
List <McqViewModel> m = new List <McqViewModel>();
foreach (Mcq i in subjectMcq)
{
McqViewModel obj = new McqViewModel()
{
Id = i.Id,
Question = i.Question,
OptionA = i.OptionA,
OptionB = i.OptionB,
OptionC = i.OptionC,
OptionD = i.OptionD,
CorrectOption = i.CorrectOption,
Exam = getExamType(i.ExamId),
Subject = mcqSubject(i.Id),
Chapter = mcqChapter(i.Id)
};
m.Add(obj);
}
ViewData["mcq"] = m;
return(View());
}
public ActionResult mcqApi()
{
DBEnt db = new DBEnt();
var mcqs = db.Mcqs.ToList <Mcq>();
List <McqViewModel> m = new List <McqViewModel>();
foreach (Mcq i in mcqs)
{
McqViewModel obj = new McqViewModel()
{
Id = i.Id,
Question = i.Question,
OptionA = i.OptionA,
OptionB = i.OptionB,
OptionC = i.OptionC,
OptionD = i.OptionD,
CorrectOption = i.CorrectOption,
Exam = getExamType(i.ExamId),
Subject = mcqSubject(i.Id),
Chapter = mcqChapter(i.Id)
};
m.Add(obj);
}
return(Json(m, JsonRequestBehavior.AllowGet));
}
public ActionResult editMcq(long id)
{
DBEnt db = new DBEnt();
var mcq = db.Mcqs.Where(x => x.Id == id).FirstOrDefault();
ViewData["mcq"] = mcq;
return(View());
}
public ActionResult subjectExam(long?id)
{
DBEnt db = new DBEnt();
List <Chapter> chapters = db.Chapters.Where(x => x.SubjectId == id).OrderBy(x => x.ChapterNo).ToList <Chapter>();
ViewData["chapters"] = chapters;
return(View());
}
public ActionResult editExam(long?id)
{
DBEnt db = new DBEnt();
var exam = db.Exams.Where(x => x.Id == id).FirstOrDefault();
ViewData["exam"] = exam;
return(View());
}
public string mcqChapter(long id)
{
DBEnt db = new DBEnt();
var mcq = db.Mcqs.Where(x => x.Id == id).First();
var chap = db.Chapters.Where(x => x.Id == mcq.ChapterId).First();
return(chap.ChapterNo.ToString());
}
public string mcqSubject(long id)
{
DBEnt db = new DBEnt();
var mcq = db.Mcqs.Where(x => x.Id == id).First();
var subject = db.Subjects.Where(x => x.Id == mcq.SubjectId).First();
return(subject.Name);
}
public ActionResult editChapter(long?id)
{
DBEnt db = new DBEnt();
var chapter = db.Chapters.Where(x => x.Id == id).FirstOrDefault();
ViewData["chapter"] = chapter;
return(View());
}
public ActionResult editSubject(long?id)
{
DBEnt db = new DBEnt();
var subject = db.Subjects.Where(x => x.Id == id).FirstOrDefault();
ViewData["subject"] = subject;
return(View());
}
public ActionResult addChapter()
{
DBEnt db = new DBEnt();
var chapters = db.Chapters.ToList <Chapter>();
ViewData["chapters"] = chapters;
return(View(new ChapterViewModel()));
}
public ActionResult addSubject()
{
DBEnt db = new DBEnt();
List <Subject> subjects = db.Subjects.ToList <Subject>();
ViewData["subjects"] = subjects;
return(View(new SubjectViewModel()));
}
public JsonResult JsonBeneficio(int id)
{
using (DBEnt db = new DBEnt())
{
var credito = db.HomeBeneficios.ToList <HomeBeneficios>().Where(u => u.id.Equals(id)).FirstOrDefault();
return(Json(credito, JsonRequestBehavior.AllowGet));
}
}
public JsonResult JSONINFO(int id)
{
using (DBEnt db = new DBEnt())
{
var credito = db.HomeProductosFinancieros.ToList <HomeProductosFinancieros>().Where(u => u.id.Equals(id)).FirstOrDefault();
return(Json(credito, JsonRequestBehavior.AllowGet));
}
}
public JsonResult JSONInteres(int id)
{
using (DBEnt db = new DBEnt())
{
var credito = db.ProductoFinancieroInteres.ToList <ProductoFinancieroInteres>().Where(u => u.id_productofinanciero.Equals(id));
return(Json(credito, JsonRequestBehavior.AllowGet));
}
}
public JsonResult JSONInfoUser(string id)
{
using (DBEnt db = new DBEnt())
{
var user = db.AspNetUsers.ToList <AspNetUsers>().Where(u => u.Id.Equals(id)).FirstOrDefault();
return(Json(user, JsonRequestBehavior.AllowGet));
}
}
public ActionResult disapproveMcq(int?id)
{
DBEnt db = new DBEnt();
var mcq = db.Mcqs.Where(x => x.Id == id).First();
mcq.Status = "pending";
db.SaveChanges();
Alerts.disapprove = true;
return(RedirectToAction("allMcq", "Admin"));
}
public ActionResult deleteMessage(int?id)
{
DBEnt db = new DBEnt();
var message = db.Messages.Where(x => x.Id == id).First();
db.Entry(message).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
Alerts.deleteMessage = true;
return(RedirectToAction("viewMessagaes", "Admin"));
}
public ActionResult addExam()
{
DBEnt db = new DBEnt();
var exams = db.Exams.OrderBy(x => x.Name).ToList <Exam>();
var subjects = db.Subjects.OrderBy(x => x.Name).ToList();
ViewData["subjects"] = subjects;
ViewData["exams"] = exams;
return(View(new ExamViewModel()));
}
public ActionResult addExam(ExamViewModel collection)
{
List <ExamSubject> sublist = new List <ExamSubject>();
foreach (long i in collection.Subjects)
{
ExamSubject obj = new ExamSubject()
{
SubjectId = i,
};
if (!sublist.Contains(obj))
{
sublist.Add(obj);
}
}
if (!examExist(collection.Name))
{
DBEnt db = new DBEnt();
string filename = Path.GetFileNameWithoutExtension(collection.Image.FileName);
string ext = Path.GetExtension(collection.Image.FileName);
filename = filename + DateTime.Now.Millisecond.ToString();
filename = filename + ext;
string filetodb = "/Image/" + filename;
filename = Path.Combine(Server.MapPath("~/Image/"), filename);
collection.Image.SaveAs(filename);
collection.Cover = filetodb;
Exam exm = new Exam()
{
Name = collection.Name, Cover = collection.Cover, MarkPerMcq = collection.MarkPerMcq, NegativeMark = collection.NegativeMark, TimeInMinutes = collection.TimeInMinutes
};
db.Exams.Add(exm);
db.SaveChanges();
foreach (ExamSubject i in sublist)
{
i.ExamId = exm.Id;
db.ExamSubjects.Add(i);
}
db.SaveChanges();
Alerts.addExam = true;
return(RedirectToAction("addExam", "Admin"));
}
else
{
Alerts.alreadyExist = true;
return(RedirectToAction("addExam", "Admin"));
}
}
// GET: Front
public ActionResult Index()
{
DBEnt db = new DBEnt();
List <Exam> exams = db.Exams.ToList();
List <Subject> subjects = db.Subjects.ToList();
ViewData["subjects"] = subjects;
ViewData["exams"] = exams;
return(View());
}
public ActionResult editChapter(long?id, ChapterViewModel collection)
{
DBEnt db = new DBEnt();
var chap = db.Chapters.Where(x => x.Id == id).FirstOrDefault();
chap.Name = collection.Name;
chap.ChapterNo = collection.ChapterNo;
db.SaveChanges();
Alerts.chapterupdated = true;
return(RedirectToAction("addChapter", "Admin"));
}