public ActionResult EditSubCourses([Bind(Include = "SubCourseID,CourseID,SubCourseTitle,SubCourseDescription,CashOrFree,VideoName")] SubCourse subCourse, HttpPostedFile VideoUp) { if (ModelState.IsValid) { if (VideoUp != null) { System.IO.File.Delete(Server.MapPath("/Videos/" + subCourse.VideoName)); subCourse.VideoName = Guid.NewGuid().ToString() + Path.GetExtension(VideoUp.FileName); VideoUp.SaveAs(Server.MapPath("/Videos/" + subCourse.VideoName)); } _subCoursesRepository.UpdateSubCourses(subCourse); _subCoursesRepository.save(); return(new JsonResult { Data = "فایل با موفیت آپلود شد" }); } else { return(new JsonResult { Data = "bad" }); } }
public bool UpdateSubCourses(SubCourse item) { try { _db.Entry(item).State = System.Data.Entity.EntityState.Modified; return(true); } catch (Exception) { return(false); } }
public bool InsertSubCourses(SubCourse item) { try { _db.SubCourse.Add(item); return(true); } catch (Exception) { return(false); } }
public List <SubCourse> GetDDL_SubCourseByCourse(int CourseID) { try { List <SubCourse> li = new List <SubCourse>(); using (SqlConnection con = new SqlConnection(ConnectionStringDheya)) { SqlCommand cmd = new SqlCommand("SP_InstituteSearch", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Type", "DDL_SubCourseByCourse"); cmd.Parameters.AddWithValue("@State", ""); cmd.Parameters.AddWithValue("@Subco_id", ""); cmd.Parameters.AddWithValue("@Co_id", CourseID); cmd.Parameters.AddWithValue("@Ca_id", ""); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { SubCourse obj = new SubCourse(); obj.Subco_id = Convert.ToInt32(dr["subco_id"]); obj.Subco_name = dr["subco_name"].ToString(); li.Add(obj); } con.Close(); return(li); } else { return(null); } } } catch (Exception ex) { Log.Error(ex); return(null); } }