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