public int EditCourse(tblCourse obj)
{
int status = 0;
try
{
string returnPath = string.Empty;
if (!string.IsNullOrEmpty(obj.ContentModuleURL) && obj.ZipFile == null)
{
returnPath = obj.ContentModuleURL;
}
else
{
returnPath = UploadFile(obj.ZipFile, Convert.ToString(obj.ContentModuleId), obj.ContentModuleType);
}
db.parameters.Clear();
db.AddParameter("@ContentModuleId", SqlDbType.Int, obj.ContentModuleId);
db.AddParameter("@ContentModuleName", SqlDbType.Text, obj.ContentModuleName);
db.AddParameter("@ContentModuleDescription", SqlDbType.NText, obj.ContentModuleDescription);
db.AddParameter("@ContentModuleType", SqlDbType.Text, obj.ContentModuleType);
db.AddParameter("@ContentModuleURL", SqlDbType.Text, returnPath);
db.AddParameter("@MasteryScore", SqlDbType.Int, obj.MasteryScore);
db.AddParameter("@Duration", SqlDbType.Int, obj.Duration);
db.AddParameter("@createdBy", SqlDbType.Int, obj.createdBy);
db.AddParameter("@tenantId", SqlDbType.Int, obj.tenantId);
status = db.ExecuteQuery("sp_CourseUpdate");
}
catch (Exception ex)
{
newException.AddException(ex);
//throw ex;
status = -2;
}
return(status);
}
public ActionResult DeleteConfirmed(int id)
{
tblCourse tblCourse = _courseRepository.GetCourseById(id);
_courseRepository.MyRemove(tblCourse);
_courseRepository.MySave();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(Guid id)
{
tblCourse tblCourse = _unitOfWork.Courses.Get(id);
_unitOfWork.Courses.Remove(tblCourse);
_unitOfWork.Complete();
return(RedirectToAction("Index"));
}
public ActionResult Edit(tblCourse tblCourse)
{
if (ModelState.IsValid)
{
_unitOfWork.Courses.Update(tblCourse);
_unitOfWork.Complete();
return(RedirectToAction("Index"));
}
return(View(tblCourse));
}
public ActionResult Create(tblCourse tblCourse)
{
if (ModelState.IsValid)
{
tblCourse.id = Guid.NewGuid();
_unitOfWork.Courses.Add(tblCourse);
_unitOfWork.Complete();
return(RedirectToAction("Index"));
}
return(View(tblCourse));
}
protected void Button1_Click(object sender, EventArgs e)
{
using (var obj = new ELearningDataContext())
{
var aa = new tblCourse();
aa.CourseName = txtCourseName.Text;
obj.tblCourses.InsertOnSubmit(aa);
obj.SubmitChanges();
}
BindGrid();
lblAdd.Text = "Category Added";
emptyfield();
}
public ActionResult Edit([Bind(Include = "Id,CourseName,CourseCode")] CourseViewModel courseViewModel)
{
if (ModelState.IsValid)
{
tblCourse tc = new tblCourse();
tc.Id = courseViewModel.Id;
tc.CourseName = courseViewModel.CourseName;
tc.CourseCode = courseViewModel.CourseCode;
_courseRepository.MySave();
return(RedirectToAction("Index"));
}
return(View(courseViewModel));
}
public ActionResult AddCourse()
{
try
{
tblCourse objEditData = new tblCourse();
return(View("AddNewCourse", objEditData));
}
catch (Exception ex)
{
newException.AddException(ex);
return(View("AddNewCourse"));
}
}
// GET: Courses/Delete/5
public ActionResult Delete(Guid id)
{
if (id == Guid.Empty)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblCourse tblCourse = _unitOfWork.Courses.Get(id);
if (tblCourse == null)
{
return(HttpNotFound());
}
return(View(tblCourse));
}
// GET: School/Course/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tblCourse tblCourse = _courseRepository.GetCourseById(id);
if (tblCourse == null)
{
return(HttpNotFound());
}
return(View(tblCourse));
}
public int DeleteCourse(tblCourse obj)
{
try
{
db = new DataRepository();
db.parameters.Clear();
db.AddParameter("@ContentModuleId", SqlDbType.Int, obj.ContentModuleId);
db.AddParameter("@IsActive", SqlDbType.Bit, obj.IsActive);
return(db.ExecuteQuery("sp_CourseActivateDeactivate"));
}
catch (Exception ex)
{
newException.AddException(ex);
throw ex;
}
}
public bool Delete(CourseEntity course)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblCourse Course = entity.tblCourses.Where(x => x.ID == course.ID).FirstOrDefault();
entity.tblCourses.Remove(Course);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public CourseEntity GetSingle(int ID)
{
try
{
TIMSDBEntities entity = new TIMSDBEntities();
tblCourse Course = entity.tblCourses.Where(x => x.ID == ID).FirstOrDefault();
CourseEntity course = new CourseEntity();
course.ID = Course.ID;
course.Title = Course.Title;
course.Description = Course.Description;
return(course);
}
catch (Exception ex)
{
return(null);
}
}
public int AddCourse(tblCourse obj)
{
int status = 0;
int ContentModuleId = 0;
try
{
FileInfo f1 = new FileInfo(obj.ZipFile.FileName);
db.parameters.Clear();
var path = ConfigurationManager.AppSettings["DestinationPath"].ToString();
if (obj.ContentModuleType == "Other")
{
path = f1.Extension;
}
db.AddParameter("@ContentModuleName", SqlDbType.Text, obj.ContentModuleName);
db.AddParameter("@ContentModuleDescription", SqlDbType.NText, obj.ContentModuleDescription);
db.AddParameter("@ContentModuleType", SqlDbType.Text, obj.ContentModuleType);
db.AddParameter("@ContentModuleURL", SqlDbType.Text, path);
db.AddParameter("@MasteryScore", SqlDbType.Int, obj.MasteryScore);
db.AddParameter("@Duration", SqlDbType.Int, obj.Duration);
db.AddParameter("@createdBy", SqlDbType.Int, obj.createdBy);
db.AddParameter("@tenantId", SqlDbType.Int, obj.tenantId);
db.AddParameter("@ContentModuleId", SqlDbType.Int, ParameterDirection.Output);
status = db.ExecuteQuery("sp_CourseAdd");
if (Convert.ToInt32(db.parameters[8].Value) > 0)
{
ContentModuleId = Convert.ToInt32(db.parameters[8].Value);
string returnPath = UploadFile(obj.ZipFile, Convert.ToString(ContentModuleId), obj.ContentModuleType);
}
if (ContentModuleId > 0)
{
status = ContentModuleId;
}
}
catch (Exception ex)
{
newException.AddException(ex);
//throw ex;
status = -2;
}
return(status);
}
public ActionResult Upload(tblCourse tb)
{
HttpPostedFileBase fup = Request.Files["VideoPath"];
if (fup != null)
{
//string fileName =Convert.ToString( LoginController.UserID )+ fup.FileName;
tb.VideoPath = fup.FileName;
tb.UserId = LoginController.UserID;
fup.SaveAs(Path.Combine(Server.MapPath("~/Videos/" + fup.FileName)));
}
_db.tblCourses.Add(tb);
if (_db.SaveChanges() > 0)
{
return(RedirectToAction("Index", "User"));
}
return(View());
}
public bool Save(CourseEntity course)
{
try
{
tblCourse Course = new tblCourse();
Course.ID = course.ID;
Course.Title = course.Title;
Course.Description = course.Description;
TIMSDBEntities entity = new TIMSDBEntities();
entity.tblCourses.Add(Course);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public ActionResult AddCourse(tblCourse objCourse, HttpPostedFileBase file)
{
try
{
if (ModelState.IsValid)
{
int rows = 0;
TblUser sessionUser = (TblUser)Session["UserSession"];
objCourse.createdBy = sessionUser.UserId;
objCourse.tenantId = sessionUser.TenantId;
newException.AddDummyException(":- " + objCourse.tenantId);
objCourse.ZipFile = file;
if (objCourse.ContentModuleId > 0)
{
rows = cc.EditCourse(objCourse);
}
else
{
rows = cc.AddCourse(objCourse);
}
if (rows != 0)
{
TempData["CourseMessage"] = "Course Saved Successfully";
return(View("AddNewCourse", objCourse));
//return RedirectToAction("Index");
}
else
{
return(View("AddNewCourse", objCourse));
}
}
return(View("AddNewCourse", objCourse));
}
catch (Exception ex)
{
newException.AddException(ex);
return(View("AddNewCourse"));
}
}
public bool Update(CourseEntity course)
{
try
{
tblCourse newCourse = new tblCourse();
newCourse.ID = course.ID;
newCourse.Title = course.Title;
newCourse.Description = course.Description;
TIMSDBEntities entity = new TIMSDBEntities();
tblCourse oldCourse = entity.tblCourses.Where(x => x.ID == course.ID).FirstOrDefault();
entity.Entry(oldCourse).CurrentValues.SetValues(newCourse);
entity.SaveChanges();
return(true);
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult InsertCourse(Course course)
{
PenOCDataContext db = new PenOCDataContext();
tblCourse courseRecord = new tblCourse
{
strName = course.name,
intEvent = course.eventId,
intLength = course.length,
intClimb = course.climb,
intControls = course.controls,
intTechnical = course.difficultyId,
intListOrder = course.listOrder
};
db.tblCourses.InsertOnSubmit(courseRecord);
db.SubmitChanges();
course.id = courseRecord.idCourse;
return Ok(course);
}
public ActionResult DeleteConfirmCourse(int id)
{
try
{
Response response = new Response();
List <tblCourse> objCourseList = cc.GetCourseById(id);
tblCourse objCourse = objCourseList[0];
if (ModelState.IsValid)
{
if (objCourse.IsActive == true)
{
objCourse.IsActive = false;
}
else
{
objCourse.IsActive = true;
}
int rows = cc.DeleteCourse(objCourse);
if (rows != 0)
{
response.StatusCode = 1;
//return RedirectToAction("Index");
}
else
{
response.StatusCode = 0;
//return View(objCourse);
}
}
//return View(objTenant);
return(Json(response.StatusCode, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
newException.AddException(ex);
return(View());
}
}
public tblCourse MyRemove(tblCourse obj)
{
throw new NotImplementedException();
}
public tblCourse MyAdd(tblCourse obj)
{
_db.tblCourses.Add(obj);
return(obj);
}
public tblCourse MyRemove(tblCourse obj)
{
_db.tblCourses.Remove(obj);
return(obj);
}
