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