public JsonResult UpdateBackImagePostion(string CategoryName, string BCimgTOP, string BCimgLeft) { try { using (IwillDbEntities Dbc = new IwillDbEntities()) { //DP image upload on server var data = Dbc.CourseCategories.Where(i => i.CreatedBy == Helper.User.UID && i.CCName.ToLower() == CategoryName.ToLower().Trim()).FirstOrDefault(); if (data != null) { data.BackImgTop = Convert.ToInt32(BCimgTOP); data.BackImgLeft = Convert.ToInt32(BCimgLeft); Dbc.SaveChanges(); } else { return(Json("Error: invalid Pic Name found", JsonRequestBehavior.AllowGet)); } } return(Json("updated", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json("Error: on update<br> " + ex.Message, JsonRequestBehavior.AllowGet)); } }
public JsonResult CreateCategory(string CCName, string BackImage, string BackLeft, string BackTop, string IsEditPic) //ModelCourseCategory ModCorsCat) { try { using (IwillDbEntities Dbc = new IwillDbEntities()) { if (IsEditPic == "false") { var data = new CourseCategory(); var TempLocation = Server.MapPath("~/Images/Temp/" + BackImage); var DestLocation = Server.MapPath("~/Images/UserImages/" + BackImage); System.IO.File.Copy(TempLocation, DestLocation); System.IO.File.Delete(TempLocation); data.CCName = CCName; data.CImagePath = BackImage; data.BackImgLeft = Convert.ToInt32(BackLeft); data.BackImgTop = Convert.ToInt32(BackTop); data.CreatedOn = DateTime.Now; data.CreatedBy = Helper.User.UID; data.IsActive = true; Dbc.CourseCategories.Add(data); Dbc.SaveChanges(); TempData["success"] = "Course Category Back Image has been Created"; return(Json("saved", JsonRequestBehavior.AllowGet)); } else { var TempLocation = Server.MapPath("~/Images/Temp/" + BackImage); var DestLocation = Server.MapPath("~/Images/UserImages/" + BackImage); System.IO.File.Copy(TempLocation, DestLocation); System.IO.File.Delete(TempLocation); var data = Dbc.CourseCategories.Where(i => i.CCName.ToLower() == CCName.ToLower().Trim() && i.CreatedBy == Helper.User.UID).FirstOrDefault(); if (data != null) { data.CImagePath = BackImage; data.BackImgLeft = Convert.ToInt32(BackLeft); data.BackImgTop = Convert.ToInt32(BackTop); data.CreatedOn = DateTime.Now; Dbc.SaveChanges(); //TempData["success"] = "Course Category Back Image has been updated"; return(Json("updated", JsonRequestBehavior.AllowGet)); } else { throw new Exception("data not found to update course category"); } } } //return Json("Error: not deleted", JsonRequestBehavior.AllowGet); } catch (Exception ex) { return(Json("Error: on save<br> " + ex.Message, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetCourseCategory(string CategoryName) { try { using (IwillDbEntities Dbc = new IwillDbEntities()) { ModelCourseCategory data = Dbc.CourseCategories.Where(i => i.CCName.ToLower().Trim().Replace(" ", "") == CategoryName.ToLower().Trim().Replace(" ", "")). Select(s => new ModelCourseCategory() { BackImage = s.CImagePath, CCName = s.CCName, BackLeft = s.BackImgLeft, BackTop = s.BackImgTop }).FirstOrDefault(); if (data != null) { return(Json(data, JsonRequestBehavior.AllowGet)); } else { return(Json("nothing", JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { return(Json("Error: on save<br> " + ex.Message, JsonRequestBehavior.AllowGet)); } }
public ActionResult ViewUsersGivenRegQuestions(string UserID) { try { if (Request["UserID"] == null) { throw new Exception(); } Int64 UID; Int64.TryParse(Request["UserID"], out UID); using (IwillDbEntities Dbc = new IwillDbEntities()) { //var data = Dbc.UserGivenQuesAns.Where(i => i.FkUserID == UID).GroupBy(g=>g.FkUQID).GroupBy(g=>g.Question).Select(s => s.FirstOrDefault().FkUQID).ToList(); var data = Dbc.spGetRegUserQuestion(UID).ToList(); ViewBag.UserRegQues = data; return(View(data)); } } catch (Exception ex) { ViewData["Error"] = "Error: to View User Given Regestration Question " + ex.Message; return(View()); } }
public JsonResult UpdateUserRegesterQuestionOption(ModelUserQuestionDetail GetUserQuesOption) { try { using (IwillDbEntities data = new IwillDbEntities()) { var UserQuestionOption = data.UserQuestionDetails.Where(i => i.UQDID == GetUserQuesOption.UQDID).FirstOrDefault(); if (UserQuestionOption == null) { return(Json("No Record Found", JsonRequestBehavior.AllowGet)); } UserQuestionOption.QuesOptionName = GetUserQuesOption.QuesOptionName; int r = data.SaveChanges(); if (r >= 0) { TempData["success"] = "Question option has Successfully updated"; TempData["UQDID"] = GetUserQuesOption.UQDID; return(Json("Record Updated Successfully", JsonRequestBehavior.AllowGet)); } else { //ViewData["Error"]= "Error: on updating the question"; return(Json("error on inserting", JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { ViewData["Error"] = "Error: " + ex.Message; return(Json("Error", JsonRequestBehavior.AllowGet)); } }
public JsonResult ActivateQuestionDetailOption(string id) { try { if (string.IsNullOrEmpty(id)) { throw new Exception("Question ID Requried"); } Int64 UQDID = Convert.ToInt64(id); using (IwillDbEntities data = new IwillDbEntities()) { var UserQuestOption = data.UserQuestionDetails.Where(i => i.UQDID == UQDID).FirstOrDefault(); if (UserQuestOption == null) { return(Json("No Record Found", JsonRequestBehavior.AllowGet)); } Int64 QID = Convert.ToInt64(UserQuestOption.FkQID); var Ques = DBC.UserQuestions.Where(i => i.UQID == QID).FirstOrDefault(); if (Ques == null) { return(Json("No Question Detail Found", JsonRequestBehavior.AllowGet)); } if (Ques.FkUQType == 1 && UserQuestOption.IsRight == true) { return(Json("Cannot Activated MCQz option, because its value is true", JsonRequestBehavior.AllowGet)); } UserQuestOption.IsActive = true; int r = data.SaveChanges(); if (r >= 0) { TempData["success"] = "Question Option has Successfully Activated"; TempData["UQDID"] = id; return(Json("Question Option has Successfully Activated", JsonRequestBehavior.AllowGet)); } else { //ViewData["Error"]= "Error: on updating the question"; return(Json("error on Activating option", JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { ViewData["Error"] = "Error: " + ex.Message; return(Json("Error", JsonRequestBehavior.AllowGet)); } }
public JsonResult CreateAndAssignCourse(List <int> values) { try { using (IwillDbEntities Dbc = new IwillDbEntities()) { } return(Json("Error: not deleted", JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json("Error: on save<br> " + ex.Message, JsonRequestBehavior.AllowGet)); } }
public JsonResult DeactivateQuestion(string id) { try { if (string.IsNullOrEmpty(id)) { throw new Exception("Question ID Requried"); } //if (string.IsNullOrEmpty(UQID)) // throw new Exception("Activation can not be empty"); Int64 QID = Convert.ToInt64(id); //bool IsActivated = Convert.ToBoolean(IsActivate); using (IwillDbEntities data = new IwillDbEntities()) { var UserQuestion = data.UserQuestions.Where(i => i.UQID == QID).FirstOrDefault(); if (UserQuestion == null) { return(Json("No Record Found", JsonRequestBehavior.AllowGet)); } UserQuestion.IsActive = false; int r = data.SaveChanges(); TempData["UQID"] = id; if (r >= 0) { TempData["success"] = "Question has Successfully Deactivated"; TempData["UQID"] = id; return(Json("Record Deactivated Successfully", JsonRequestBehavior.AllowGet)); } else { //ViewData["Error"]= "Error: on updating the question"; return(Json("error on Deactivating", JsonRequestBehavior.AllowGet)); } } } catch (Exception ex) { ViewData["Error"] = "Error: " + ex.Message; return(Json("Error", JsonRequestBehavior.AllowGet)); } }
public JsonResult GetCategories()//ModelCourseCategory ModCorsCat) { try { using (IwillDbEntities Dbc = new IwillDbEntities()) { List <string> data = Dbc.CourseCategories.Select(s => s.CCName).ToList(); return(Json(data, JsonRequestBehavior.AllowGet)); } //return Json("saved", JsonRequestBehavior.AllowGet); //return Json("Error: not deleted", JsonRequestBehavior.AllowGet); } catch (Exception ex) { return(Json("Error: on save<br> " + ex.Message, JsonRequestBehavior.AllowGet)); } }
public JsonResult RemoveBackgroundPic(string CategoryName, string FileName, string IsBackPicEdit) { try { using (IwillDbEntities Dbc = new IwillDbEntities()) { if (IsBackPicEdit == "true") { var BackPic = Dbc.CourseCategories.Where(i => i.CreatedBy == Helper.User.UID && i.CCName.ToLower() == CategoryName.ToLower().Trim()).FirstOrDefault(); var OldPicLocation = Server.MapPath("~/Images/UserImages/" + BackPic.CImagePath); System.IO.File.Delete(OldPicLocation); BackPic.CImagePath = null; BackPic.BackImgLeft = null; BackPic.BackImgTop = null; } else { var fullPath = Server.MapPath("~/Images/Temp/" + FileName); if (System.IO.File.Exists(fullPath)) { System.IO.File.Delete(fullPath); var tempPic = Dbc.TempPics.Where(i => i.TempPicName == FileName).FirstOrDefault(); Dbc.TempPics.Remove(tempPic); } else { return(Json("Error: not deleted", JsonRequestBehavior.AllowGet)); } } Dbc.SaveChanges(); return(Json("deleted", JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { return(Json("Error: on delete<br> " + ex.Message, JsonRequestBehavior.AllowGet)); } }
public JsonResult CourseCategoryFileUpload() { var path = ""; try { string CurrentUserIP = Request.UserHostAddress; // CheckUserPicUploadCount(UserIP); using (IwillDbEntities Dbc = new IwillDbEntities()) { var count = Dbc.TempPics.Where(i => i.UserIP == CurrentUserIP && EntityFunctions.TruncateTime(i.CreatedOn.Value) == EntityFunctions.TruncateTime(DateTime.Now) && i.CreatedBy == Helper.User.UID).ToList().Count; if (count > 10) { return(Json("Create Category, image upload limit exceeded", JsonRequestBehavior.AllowGet)); } } string fileName = ""; string Ext = ""; string PicPath = ""; if (Request.Files.Count == 0) { return(Json("nofiles", JsonRequestBehavior.AllowGet)); } for (int i = 0; i < Request.Files.Count; i++) { var file = Request.Files[i]; fileName = Path.GetFileName(file.FileName); Ext = Path.GetExtension(file.FileName); //fileName = "UserImg_" + Guid.NewGuid().ToString().Trim() + Ext; fileName = Guid.NewGuid().ToString().Trim() + Ext; var fileLocation = Server.MapPath("~/Images/Temp/"); FileInfo fileDiresctory = new FileInfo(fileLocation); if (!fileDiresctory.Exists) { fileDiresctory.Directory.Create(); } path = Path.Combine(fileLocation, fileName); if (!System.IO.File.Exists(path)) { string aa = System.Web.HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]; file.SaveAs(path); using (IwillDbEntities Dbc = new IwillDbEntities()) { var tempPic = new TempPic() { TempPicName = fileName, CreatedOn = DateTime.Now, CreatedBy = Helper.User.UID, UserIP = Request.UserHostAddress }; Dbc.TempPics.Add(tempPic); Dbc.SaveChanges(); } } else { return(Json("file already exists", JsonRequestBehavior.AllowGet)); } } return(Json("saved^" + fileName, JsonRequestBehavior.AllowGet)); //return Json("saved^", JsonRequestBehavior.AllowGet); } catch (Exception ex) { return(Json("notsaved " + path, JsonRequestBehavior.AllowGet)); } }