public ReturnClass.ReturnDataTable get_upload_details_by_id(upload_doc d) { query = @"select Name,Data,contentType from online_videos where video_id=@video_id "; MySqlParameter[] pr = new MySqlParameter[] { new MySqlParameter("video_id", d.Action_id) }; dt = da.executeSelectQuery(query); return(dt); }
public ReturnClass.ReturnBool Upload_Video(upload_doc fu) { //query = "INSERT INTO online_videos (Name,Data,contentType,path)VALUES(@Name,@Data,@contentType,@path)"; query = "INSERT INTO online_videos (Name,contentType,path,extension)VALUES(@Name,@contentType,@path,@extension)"; MySqlParameter[] pm1 = new MySqlParameter[] { new MySqlParameter("Name", fu.Document_name), // new MySqlParameter("Data", fu.Document_data), new MySqlParameter("contentType", fu.Mime_type), new MySqlParameter("path", fu.Panjiyan_category_id), new MySqlParameter("extension", fu.File_extn) }; rc = da.executeInsertQuery(query, pm1); return(rc); }