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));
}
}