public void GetVesselAttendance(int InspectorID, int InspectionID) { dt = objInsp.Get_VesselAttendence(InspectorID, InspectionID); if (dt.Rows.Count > 0) { ViewState["Vessel_ID"] = dt.Rows[0][0].ToString(); lblShipName.Text = dt.Rows[0][1].ToString(); lblAttendendBy.Text = dt.Rows[0][7].ToString(); lblFrom.Text = Convert.ToDateTime(dt.Rows[0][2].ToString()).ToString("dd MMM yyyy"); lblPorts.Text = dt.Rows[0][5].ToString(); } }
public void GetVesselAttendance(int InspectorID, int InspectionID) { dt = objInsp.Get_VesselAttendence(InspectorID, InspectionID); if (dt.Rows.Count > 0) { lblShipName.Text = dt.Rows[0]["Vessel_Name"].ToString(); lblWLShip.Text = dt.Rows[0]["Vessel_Name"].ToString(); lblCWlShip.Text = dt.Rows[0]["Vessel_Name"].ToString(); lblAttendendBy.Text = dt.Rows[0]["AttendedBy"].ToString(); lblRank.Text = dt.Rows[0]["Rank_Name"].ToString(); lblFrom.Text = Convert.ToDateTime(dt.Rows[0]["FromDate"].ToString()).ToString("ddMMMyy"); lblWLFrom.Text = Convert.ToDateTime(dt.Rows[0]["FromDate"].ToString()).ToString("ddMMMyy"); lblCwlFrom.Text = Convert.ToDateTime(dt.Rows[0]["FromDate"].ToString()).ToString("ddMMMyy"); if (dt.Rows[0]["ToDate"].ToString() != "") { lblTo.Text = Convert.ToDateTime(dt.Rows[0]["ToDate"].ToString()).ToString("ddMMMyy"); lblWlTo.Text = Convert.ToDateTime(dt.Rows[0]["ToDate"].ToString()).ToString("ddMMMyy"); lblCWlTo.Text = Convert.ToDateTime(dt.Rows[0]["ToDate"].ToString()).ToString("ddMMMyy"); } else { lblTo.Text = ""; lblWlTo.Text = ""; lblCWlTo.Text = ""; } lblDur.Text = dt.Rows[0]["Duration"].ToString(); lblWlDur.Text = dt.Rows[0]["Duration"].ToString(); lblCwlDur.Text = dt.Rows[0]["Duration"].ToString(); lblPorts.Text = dt.Rows[0]["Port"].ToString(); lblWLPorts.Text = dt.Rows[0]["Port"].ToString(); lblCWlPorts.Text = dt.Rows[0]["Port"].ToString(); string baseUrl = Request.Url.Scheme + "://" + Request.Url.Authority + Request.ApplicationPath.TrimEnd('/') + "/"; if (dt.Rows[0]["Vessel_Image"].ToString() == "" || dt.Rows[0]["Vessel_Image"].ToString() == null) { imgVesselPhoto.ImageUrl = baseUrl + "Images/noVesselimage.png"; // + dt.Rows[0]["Vessel_Image"].ToString(); } else { imgVesselPhoto.Visible = true; imgVesselPhoto.ImageUrl = baseUrl + "Uploads/VesselImage/" + dt.Rows[0]["Vessel_Image"].ToString(); } } }