protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string Vessel_ID = GetQueryString("vid"); string Worklist_ID = GetQueryString("wlid"); string WL_Office_ID = GetQueryString("wl_off_id"); if (Vessel_ID != "" && Worklist_ID != "" && WL_Office_ID != "") { DataTable dt = objBLL.Get_Worklist_Attachments(UDFLib.ConvertToInteger(Vessel_ID), UDFLib.ConvertToInteger(Worklist_ID), UDFLib.ConvertToInteger(WL_Office_ID), UDFLib.ConvertToInteger(Session["UserID"])); string FilePath = ""; string FileName = ""; if (dt.Rows.Count == 1) { FilePath = dt.Rows[0]["Attach_Path"].ToString(); FileName = dt.Rows[0]["Attach_Name"].ToString(); Response.Redirect("~/Uploads/Technical/" + FilePath); } else if (dt.Rows.Count > 1) { foreach (DataRow dr in dt.Rows) { FilePath = dr["Attach_Path"].ToString(); FileName = dr["Attach_Name"].ToString(); HyperLink lnk = new HyperLink(); lnk.Text = FileName + "<br>"; lnk.NavigateUrl = "../../Uploads/Technical/" + FilePath; lnk.Target = "_blank"; Panel1.Controls.Add(lnk); } } } } }
protected void Load_Attachments() { BLL_Tec_Worklist objBLL = new BLL_Tec_Worklist(); string Vessel_ID = GetQueryString("vid"); string Worklist_ID = GetQueryString("wlid"); string WL_Office_ID = GetQueryString("wl_off_id"); string AttID = GetQueryString("AttID"); if (!IsPostBack) { if (Vessel_ID != "" && Worklist_ID != "" && WL_Office_ID != "") { DataTable dt = objBLL.Get_Worklist_Attachments(UDFLib.ConvertToInteger(Vessel_ID), UDFLib.ConvertToInteger(Worklist_ID), UDFLib.ConvertToInteger(WL_Office_ID), UDFLib.ConvertToInteger(Session["UserID"])); GenerateRSS(dt); } } }
private void Load_Attachments(int VESSEL_ID, int WORKLIST_ID, int WL_OFFICE_ID, int UserID) { try { DataTable dt = objBLL.Get_Worklist_Attachments(VESSEL_ID, WORKLIST_ID, WL_OFFICE_ID, UserID); DataView dvImage = dt.DefaultView; dvImage.RowFilter = "Is_Image='1' "; ListView1.DataSource = dvImage; ListView1.DataBind(); ListView2.DataSource = dvImage; ListView2.DataBind(); hidenTotalrecords.Value = dvImage.Count.ToString(); HCurrentIndex.Value = "0"; if (dvImage.Count == 0) { tdg.Visible = false; } else { tdg.Visible = true; } dt.DefaultView.RowFilter = "Is_Image='0' ";//AND Is_Audio='1' gvAttachments.DataSource = dt.DefaultView; gvAttachments.DataBind(); //Bind Popup } catch (Exception ex) { UDFLib.WriteExceptionLog(ex); } }
protected void Page_Load(object sender, EventArgs e) { string Vessel_ID = GetQueryString("vid"); string Worklist_ID = GetQueryString("wlid"); string WL_Office_ID = GetQueryString("wl_off_id"); string AttID = GetQueryString("AttID"); if (!IsPostBack) { if (Vessel_ID != "" && Worklist_ID != "" && WL_Office_ID != "") { DataTable dt = objBLL.Get_Worklist_Attachments(UDFLib.ConvertToInteger(Vessel_ID), UDFLib.ConvertToInteger(Worklist_ID), UDFLib.ConvertToInteger(WL_Office_ID), UDFLib.ConvertToInteger(Session["UserID"])); lblJob.Text = "Job Code: " + Worklist_ID + " / " + dt.Rows[0]["Vessel_Short_Name"].ToString(); DataView dvImage = dt.DefaultView; dvImage.RowFilter = "Is_Image='1' "; ListView2.DataSource = dvImage; ListView2.DataBind(); hidenTotalrecords.Value = dvImage.Count.ToString(); HCurrentIndex.Value = "0"; dt.DefaultView.RowFilter = "Is_Image='0' "; rpt1.DataSource = dt.DefaultView; rpt1.DataBind(); } //if (Vessel_ID != "" && Worklist_ID != "" && WL_Office_ID != "") //{ // DataTable dt = objBLL.Get_Worklist_Attachments(UDFLib.ConvertToInteger(Vessel_ID), UDFLib.ConvertToInteger(Worklist_ID), UDFLib.ConvertToInteger(WL_Office_ID), UDFLib.ConvertToInteger(Session["UserID"])); // string FilePath = ""; // string FileName = ""; // rpt1.DataSource = dt; // rpt1.DataBind(); // if (dt.Rows.Count > 0) // { // lblJob.Text = "Job Code: " + Worklist_ID + "/" + dt.Rows[0]["Vessel_Short_Name"].ToString(); // Session["WL_Attach_Title"] = "Job Code: " + Worklist_ID + "/" + dt.Rows[0]["Vessel_Short_Name"].ToString() + " - Attachments"; // if (AttID != "") // { // DataRow[] dr = dt.Select("attachment_id=" + AttID); // if (dr.Length > 0) // { // FileName = dr[0]["Attach_Name"].ToString(); // FilePath = "../../Uploads/Technical/" + Path.GetFileName( dr[0]["Attach_Path"].ToString()); // if (System.IO.File.Exists(Server.MapPath(FilePath)) == true) // { // Random r = new Random(); // string ver = r.Next().ToString(); // frmContract.Attributes.Add("src", FilePath + "?ver=" + ver); // } // } // } // else // { // FileName = dt.Rows[0]["Attach_Name"].ToString(); // FilePath = "../../Uploads/Technical/" + Path.GetFileName(dt.Rows[0]["Attach_Path"].ToString()); // if (System.IO.File.Exists(Server.MapPath(FilePath)) == true) // { // Random r = new Random(); // string ver = r.Next().ToString(); // frmContract.Attributes.Add("src", FilePath + "?ver=" + ver); // } // } // } //} } // this.Title = Session["WL_Attach_Title"].ToString(); }