/// <summary>
/// check if user with same email already there.
/// </summary>
/// <param name="email"></param>
/// <returns></returns>
public static bool checkUserByEmail(string email)
{
using (SVDB_Entities db = new SVDB_Entities())
{
tblUser user = db.tblUsers.Where(x => x.email == email).FirstOrDefault();
if (user != null) return true; else return false;
}
}
public static tblUser getUserById(int id)
{
using(SVDB_Entities db = new SVDB_Entities())
{
tblUser user = db.tblUsers.Where(x => x.userId == id).FirstOrDefault();
return user;
}
}
public static tblUser _checkUser(tblUser user)
{
SVDB_Entities db = new SVDB_Entities();
tblUser _user = db.tblUsers.Where(x => x.email == user.email && x.password == user.password).FirstOrDefault();
if (_user != null) return _user;
else return _user;
}
/// <summary>
/// add user to database coming from register.
/// </summary>
/// <param name="user"></param>
public static string _addUser(tblUser user)
{
using(SVDB_Entities db = new SVDB_Entities())
{
user.createOn = DateTime.Now;
user.ipaddress = "127.0.0.1";
db.tblUsers.Add(user);
db.SaveChanges();
return "User Created!";
}
}
public ActionResult Discussion(int page)
{
var _pagedData = new PagedData<tblQuestion>();
using (var db = new SVDB_Entities())
{
_pagedData.Data = db.tblQuestions.OrderBy(x => x.questionId).Skip(PageSize * (page -1)).Take(PageSize).ToList();
_pagedData.NumberOfPages = Convert.ToInt32(Math.Ceiling((double)db.tblQuestions.Count() / PageSize));
_pagedData.CurrentPage = page;
}
ViewBag._pagedData = _pagedData;
return PartialView(_pagedData);
}
public JsonResult submitQuestion(tblQuestion question)
{
if(!question.questionImage.Contains("undefined") && question.questionImage != null)
{
var regex = new Regex(@"data:(?<mime>[\w/\-\.]+);(?<encoding>\w+),(?<data>.*),(?<height>[0-9]+)px,(?<width>[0-9]+)px", RegexOptions.Compiled);
var match = regex.Match(question.questionImage);
var mime = match.Groups["mime"].Value;
var encoding = match.Groups["encoding"].Value;
string data = match.Groups["data"].Value;
var height = Convert.ToInt32(match.Groups["height"].Value);
var width = Convert.ToInt32(match.Groups["width"].Value);
Image img = SuccessVidya.BAL.Utility.Base64ToImage(data);
Image resizedImage = img.GetThumbnailImage(width, height, null, IntPtr.Zero);
question.questionImage = Guid.NewGuid().ToString();
//resizedImage.Save("~/QuestionImages/asd1.jpeg", System.Drawing.Imaging.ImageFormat.Jpeg);
resizedImage.Save(Server.MapPath("~/QuestionImages/" + question.questionImage + ".jpeg"), System.Drawing.Imaging.ImageFormat.Jpeg);
int index = question.questionText.IndexOf(data);
//without image will go to DB
question.questionText = (index < 0)
? question.questionText
: question.questionText.Remove(index, data.Length);
}
question.createOn = DateTime.Now;
question.Years = 2013;
question.userID = 2;
question.secionID = 11;
question.Examid = 1;
question.correctAnswer = "A";
using (SVDB_Entities db = new SVDB_Entities())
{
if (ModelState.IsValid)
{
db.tblQuestions.Add(question);
db.SaveChanges();
}
}
return Json(new { Answer = "question submitted", ErrorMessage = "" });
//return RedirectToAction("Index","Home");
}
public ActionResult Index()
{
var _pagedData = new PagedData<tblQuestion>();
List<mstSection> sectionList = SectionManagement.getSections();
ViewBag.sectionList = sectionList;
ViewBag.subSectionList = SectionManagement.getSubsections(1);
using(SVDB_Entities db = new SVDB_Entities())
{
_pagedData.Data = db.tblQuestions.OrderBy(x => x.questionId).Take(PageSize).ToList();
_pagedData.NumberOfPages = Convert.ToInt32(Math.Ceiling((double)db.tblQuestions.Count() / PageSize));
ViewBag._pagedData = _pagedData;
}
return View();
}
