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