protected void btnExport_Click(object sender, ImageClickEventArgs e)
{
try
{
DataTable dt = BLL_LMS_Training.GET_VESSEL_VIDEOS(null);
dt.DefaultView.RowFilter = "FileName IS NOT NULL";
DataView dv = dt.DefaultView;
List <String> lFileList = new List <string>();
foreach (DataRow item in dv.ToTable().Rows)
{
lFileList.Add(item["FileName"].ToString());
}
if (lFileList.Count > 0)
{
string lDownlodFileName = BLL_LMS_Training.RAR(Server.MapPath("~/Uploads/VesselVideos"), lFileList);
ResponseHelper.Redirect("~/Uploads/VesselVideos/" + lDownlodFileName, "blank", "");
}
}
catch (Exception)
{
string js1 = "alert('Videos Not Found.');";
ScriptManager.RegisterStartupScript(this, this.GetType(), "showModalJS", js1, true);
return;
}
//string[] HeaderCaptions = { "Module Name", "Original File Name", "New File Name" };
//string[] DataColumnsName = { "text", "OriginalFileName", "FileName", };
//GridViewExportUtil.ShowExcel(dv.ToTable(), HeaderCaptions, DataColumnsName, "Vessel_Videos_File_List", "Rename your local files with file names as given below", "");
}
public string Get_Function_Tree_Videos(string id)
{
DataTable dt = BLL_LMS_Training.GET_VESSEL_VIDEOS(null);
return(ConvertDataTabletoJson(dt));
}