/// <summary> /// upload file create from user /// </summary> public void uploadFile_User() { try { ds = SqlHelper.ExecuteDataset(ConnStr, CommandType.StoredProcedure, storegetsys); int n = ds.Tables[0].Rows.Count; if (n < 1) { ds.Clear(); //Console.WriteLine("! chua co file Video dong bo from Itemmovie to Storage -" + DateTime.Now + " !"); Ultils.AddToLogFile("! chua co file Video dong bo from Itemmovie to Storage -" + DateTime.Now + " !"); Thread.Sleep(2000); return; } for (int i = 0; i < n; i++) { ID = Convert.ToInt64(ds.Tables[0].Rows[i]["ID"]); idVideo = Convert.ToInt64(ds.Tables[0].Rows[i]["Itemcode"]); type = ds.Tables[0].Rows[i]["type"].ToString(); ItemFile = ds.Tables[0].Rows[i]["ItemFile"].ToString(); FolderName = ds.Tables[0].Rows[i]["FolderName"].ToString(); //Console.WriteLine("! Dang dong bo file Video " + FolderName + "/" + ItemFile + "--- idmoviegroup" + idVideo + "--" + DateTime.Now + " !"); Ultils.AddToLogFile("! Dang dong bo file Video " + FolderName + "/" + ItemFile + "--- idmoviegroup" + idVideo + "--" + DateTime.Now + " !"); try { if (type == "1") { file_path = FolderMP4 + FolderName + "/" + ItemFile; s3DirectoryName = s3DirectoryName + "/" + FolderName; // upload file storage if (sendMyFileToS3(file_path, myBucketName, s3DirectoryName, s3FileName)) { status = true; } } if (status == true) { SqlParameter[] param = { new SqlParameter("@id", ID), new SqlParameter("@idvideo", idVideo), new SqlParameter("@status", 1) }; ds = SqlHelper.ExecuteDataset(ConnStr, CommandType.StoredProcedure, storeupdatesys_success, param); //Console.WriteLine("! Upload phim:" + FolderName + "/" + ItemFile + "--- idmoviegroup" + idVideo + "--" + " to storage success- " + DateTime.Now + " !"); Ultils.AddToLogFile("! Upload phim:" + FolderName + "/" + ItemFile + "--- idmoviegroup" + idVideo + "--" + " to storage success- " + DateTime.Now + " !"); } else { SqlParameter[] param = { new SqlParameter("@id", ID), new SqlParameter("@idvideo", idVideo), new SqlParameter("@status", 2) }; ds = SqlHelper.ExecuteDataset(ConnStr, CommandType.StoredProcedure, storeupdatesys_fail, param); //Console.WriteLine("! Upload phim:" + FolderName + "/" + ItemFile + "--- idmoviegroup" + idVideo + "--" + " to storage fail -" + DateTime.Now + " !"); Ultils.AddToLogFile("! Upload phim:" + FolderName + "/" + ItemFile + "--- idmoviegroup" + idVideo + "--" + " to storage fail -" + DateTime.Now + " !"); } } catch (Exception ex) { SqlParameter[] param = { new SqlParameter("@id", ID), new SqlParameter("@idvideo", idVideo), new SqlParameter("@status", 2) }; ds = SqlHelper.ExecuteDataset(ConnStr, CommandType.StoredProcedure, storeupdatesys_fail, param); //Console.WriteLine("! Upload phim:" + FolderName + "/" + ItemFile + "--- idmoviegroup" + idVideo + "--" + " to storage fail " + DateTime.Now + " !"); Ultils.AddToLogFile("! Upload phim:" + FolderName + "/" + ItemFile + "--- idmoviegroup" + idVideo + "--" + " to storage fail " + DateTime.Now + " !"); } } } catch (Exception ex) { } }
public void DowloadFile() { try { string host = "10.60.135.32"; string user = "******"; string pass = "******"; string path_host = "/media2/phimonbox/mp4/";//20171020/a6110324-17f6-460d-9927-8b72e769b06a_3.mp4 string path_local = @"E:\fileMP4.mp4"; DataSet ds = null; string store_sync_to_cdn = "PHIM_sync_to_cdn"; ds = SqlHelper.ExecuteDataset(ConnStr, CommandType.StoredProcedure, store_sync_to_cdn); int n = ds.Tables[0].Rows.Count; if (n < 1) { ds.Clear(); Console.WriteLine("! chua co file Video dong bo from Itemmovie to Storage -" + DateTime.Now + " !"); //Ultils.AddToLogFile("! chua co file Video dong bo from Itemmovie to Storage -" + DateTime.Now + " !"); Thread.Sleep(2000); return; } for (int i = 0; i < n; i++) { string ID = ds.Tables[0].Rows[i]["ID"].ToString(); string FileName = ds.Tables[0].Rows[i]["FileName"].ToString(); string Folder = ds.Tables[0].Rows[i]["Folder"].ToString(); string id_group = ds.Tables[0].Rows[i]["id_group"].ToString(); FileName = FileName + ".mp4"; string path_host1 = path_host + Folder + "/" + FileName; path_local = @"E:\onkeeng\mp4\" + Folder + "/" + FileName; if (!Directory.Exists(@"E:\onkeeng\mp4\" + Folder)) { Directory.CreateDirectory(@"E:\onkeeng\mp4\" + Folder); } if (FTPDownload(host, user, pass, path_host1, path_local)) { SqlParameter[] param = { new SqlParameter("@itemfile", FileName), new SqlParameter("@idvideo", id_group), }; ds = SqlHelper.ExecuteDataset(ConnStr, CommandType.StoredProcedure, "INSERT_SYNC_TO_CDN", param); Console.WriteLine("upload success " + ds.Tables[0].Rows[0][0].ToString()); } else { SqlParameter[] param = { new SqlParameter("@idvideo", id_group), new SqlParameter("@status", 3), }; ds = SqlHelper.ExecuteDataset(ConnStr, CommandType.StoredProcedure, "UPDATE_SYNC_TO_CDN", param); } } } catch (Exception ex) { } }