protected void VesselSelectionChange()
{
int VesselFlag = 0;
int VesselId = int.Parse(ddlVessel.SelectedValue);
DataTable dt1 = objVessel.GetVesselDetails_ByID(VesselId);
if (dt1.Rows.Count > 0)
{
VesselFlag = int.Parse(dt1.Rows[0]["L_Vessel_Flag"].ToString());
}
DataTable dtContract = objBLLInfra.Get_CrewContractList(Staff_Nationality, VesselFlag);
ddlContract.DataSource = dtContract;
ddlContract.DataTextField = "Contract_Name";
ddlContract.DataValueField = "ContractId";
ddlContract.DataBind();
ddlContract.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
protected void btnAddVslTo_Click(object sender, EventArgs e)
{
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
txtSelectedIDsTo.Text = "";
string To = "";
foreach (ListItem li in lstVessel.Items)
{
if (li.Selected)
{
DataTable dt = objVsl.GetVesselDetails_ByID(int.Parse(li.Value));
if (dt.Rows.Count > 0)
{
if (To.Length > 0 && dt.Rows[0]["Vessel_email"].ToString() != "")
{
To += ";";
}
To += dt.Rows[0]["Vessel_email"].ToString();
}
}
}
if (((Button)sender).CommandArgument == "TO")
{
txtTo.Text += ";" + To;
}
else
{
txtCC.Text += ";" + To;
}
if (IsPostBack)
{
ucEmailAttachment1.Register_JS_Attach();
}
UpdatePanel1.Update();
objVsl = null;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
DataTable dtItem = BLL_PURC_Common.GET_ItemDetails_ByItemRefCode(Request.QueryString["item_ref_code"]);
BLL_Infra_VesselLib objVSL = new BLL_Infra_VesselLib();
DataTable dtVsl = objVSL.GetVesselDetails_ByID(Convert.ToInt32(Request.QueryString["vessel_code"]));
lblcataloguename.Text = dtItem.Rows[0]["system_description"].ToString();
lblsubcataloguename.Text = dtItem.Rows[0]["subsystem_description"].ToString();
lblItemRefCode.Text = dtItem.Rows[0]["short_description"].ToString();
lblLongDesc.Text = Convert.ToString(dtItem.Rows[0]["Long_Description"]);
lblvesselname.Text = dtVsl.Rows[0]["vessel_name"].ToString();
gvItemHistory.DataSource = BLL_PURC_Common.GET_Item_History(Request.QueryString["vessel_code"], Request.QueryString["item_ref_code"]);
gvItemHistory.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
}
public void ViewVesselDetails(int Key)
{
try
{
DataTable dtVessel = objBLL.GetVesselDetails_ByID(Key);
lblShipName.Text = dtVessel.Rows[0]["Vessel_Name"].ToString();
txtExName.Text = dtVessel.Rows[0]["Vessel_Ex_Name1"].ToString();
txtVeseelCode.Text = dtVessel.Rows[0]["Vessel_Code"].ToString();
txtAccCode.Text = dtVessel.Rows[0]["BANK_ACCOUNT_ID"].ToString();
txtVesselOwner.Text = dtVessel.Rows[0]["Vessel_Owner"].ToString();
txtOperator.Text = dtVessel.Rows[0]["Vessel_Operator"].ToString();
DDLFlag.SelectedItem.Text = dtVessel.Rows[0]["Vessel_Flag"].ToString();
txtCallSign.Text = dtVessel.Rows[0]["Vessel_Call_sign"].ToString();
txtIMO.Text = dtVessel.Rows[0]["Vessel_IMO_No"].ToString();
txtOffcialNo.Text = dtVessel.Rows[0]["Vessel_Official_No"].ToString();
DDLClass.SelectedItem.Text = dtVessel.Rows[0]["Vessel_Class"].ToString();
txtClassNo.Text = dtVessel.Rows[0]["Vessel_Class_No"].ToString();
txtServSpeed.Text = dtVessel.Rows[0]["Vessel_Serv_Speed"].ToString();
DDLVesselType.SelectedItem.Text = dtVessel.Rows[0]["Vessel_Type"].ToString();
DDLTankSize.SelectedItem.Text = dtVessel.Rows[0]["Vessel_Size"].ToString();
if (dtVessel.Rows[0]["Vessel_Keel_laid_Date"].ToString() != "")
{
txtKeellaiddt.Text = dtVessel.Rows[0]["Vessel_Keel_laid_Date"].ToString().ToString(iFormatProvider);
}
if (dtVessel.Rows[0]["Vessel_Delvry_Date"].ToString() != "")
{
txtDlvrydt.Text = dtVessel.Rows[0]["Vessel_Delvry_Date"].ToString().ToString(iFormatProvider);
}
txtyard.Text = dtVessel.Rows[0]["Vessel_Yard"].ToString();
txtHullNo.Text = dtVessel.Rows[0]["Vessel_Hull_No"].ToString();
DDLHullType.SelectedItem.Text = dtVessel.Rows[0]["Vessel_Hull_Type"].ToString();
txtLength.Text = dtVessel.Rows[0]["Vessel_Length_OA"].ToString();
txtBpLength.Text = dtVessel.Rows[0]["Vessel_Length_BP"].ToString();
txtDepth.Text = dtVessel.Rows[0]["Vessel_Depth"].ToString();
txtBreadth.Text = dtVessel.Rows[0]["Vessel_Breadth"].ToString();
txtMastTopfrmKeel.Text = dtVessel.Rows[0]["Vessel_Mast_Top_Keel"].ToString();
txtMMSI.Text = dtVessel.Rows[0]["Vessel_MMSI_No"].ToString();
txtCargoTkCap.Text = dtVessel.Rows[0]["Vessel_Cargo_Tk_Cap"].ToString();
txtSloptkCap.Text = dtVessel.Rows[0]["vessel_Slop_Tk_Cap"].ToString();
txtBallastTkCap.Text = dtVessel.Rows[0]["Vessel_Ballast_Tk_Cap"].ToString();
txtDw_Trop.Text = dtVessel.Rows[0]["Dwt_Tropical"].ToString();
txtDw_Summ.Text = dtVessel.Rows[0]["Dwt_Summer"].ToString();
txt_Dw_wint.Text = dtVessel.Rows[0]["Dwt_winter"].ToString();
txtDw_Ballast.Text = dtVessel.Rows[0]["Dwt_Ballast"].ToString();
txtDisp_Trop.Text = dtVessel.Rows[0]["Disp_Tropical"].ToString();
txtDisp_summ.Text = dtVessel.Rows[0]["Disp_Summer"].ToString();
txtDisp_Winter.Text = dtVessel.Rows[0]["Disp_Winter"].ToString();
txtDisp_Ballast.Text = dtVessel.Rows[0]["Disp_Ballasr"].ToString();
txtdrft_trop.Text = dtVessel.Rows[0]["Draft_Tropical"].ToString();
txtdrft_summ.Text = dtVessel.Rows[0]["Draft_Summer"].ToString();
txtdrft_wint.Text = dtVessel.Rows[0]["Draft_winter"].ToString();
txtdrft_Ballast.Text = dtVessel.Rows[0]["Draft_Ballast"].ToString();
txgrttInter.Text = dtVessel.Rows[0]["Grt_International"].ToString();
txtGrtSuez.Text = dtVessel.Rows[0]["Grt_Suez"].ToString();
txtGrtpanama.Text = dtVessel.Rows[0]["Grt_Panama"].ToString();
txtNrtInter.Text = dtVessel.Rows[0]["NRT_International"].ToString();
txtNrtSuez.Text = dtVessel.Rows[0]["NRT_Suez"].ToString();
txtNrtPanama.Text = dtVessel.Rows[0]["NRT_Panama"].ToString();
txtLwtInter.Text = dtVessel.Rows[0]["LWT_International"].ToString();
txtLwtSuez.Text = dtVessel.Rows[0]["LWT_Suez"].ToString();
txtLwtPanama.Text = dtVessel.Rows[0]["LWT_Panama"].ToString();
txtME.Text = dtVessel.Rows[0]["Vessel_MainEngine"].ToString();
txtAuxBoil.Text = dtVessel.Rows[0]["Vessel_Aux_Boiler"].ToString();
txtAuxKw.Text = dtVessel.Rows[0]["Vessel_ABLR_Cap"].ToString();
txtMCR.Text = dtVessel.Rows[0]["Vessel_ME_MCR"].ToString();
txtNCR.Text = dtVessel.Rows[0]["Vessel_ME_NCR"].ToString();
txtCopCap.Text = dtVessel.Rows[0]["Vessel_Cops_Cap"].ToString();
txtAunEng.Text = dtVessel.Rows[0]["Aux_Engine"].ToString();
DDLDeckMech.SelectedItem.Text = dtVessel.Rows[0]["Vessel_Deck_Mache"].ToString();
txtAuxKw.Text = dtVessel.Rows[0]["Vessel_AE_KW"].ToString();
txtturbEng.Text = dtVessel.Rows[0]["Vessel_Turb_Genrt"].ToString();
txtturbengKw.Text = dtVessel.Rows[0]["Vessel_TG_KW"].ToString();
if (dtVessel.Rows[0]["Dry_dock_Last"].ToString() != "")
{
txtDrtLast.Text = (DateTime.Parse(dtVessel.Rows[0]["Dry_dock_Last"].ToString())).ToShortDateString();;
}
if (dtVessel.Rows[0]["Dry_dock_Next"].ToString() != "")
{
txtDryNext.Text = (DateTime.Parse(dtVessel.Rows[0]["Dry_dock_Next"].ToString())).ToShortDateString();;
}
if (dtVessel.Rows[0]["Dry_dock_Latest"].ToString() != "")
{
txtDryLatest.Text = (DateTime.Parse(dtVessel.Rows[0]["Dry_dock_Latest"].ToString())).ToShortDateString();
}
if (dtVessel.Rows[0]["Spl_Svry_Last"].ToString() != "")
{
txtSplLast.Text = (DateTime.Parse(dtVessel.Rows[0]["Spl_Svry_Last"].ToString())).ToShortDateString();;
}
if (dtVessel.Rows[0]["Spl_Svry_Next"].ToString() != "")
{
txtSplNext.Text = (DateTime.Parse(dtVessel.Rows[0]["Spl_Svry_Next"].ToString())).ToShortDateString();;
}
if (dtVessel.Rows[0]["Spl_Svry_Latest"].ToString() != "")
{
txtSplLatest.Text = (DateTime.Parse(dtVessel.Rows[0]["Spl_Svry_Latest"].ToString())).ToShortDateString();;
}
if (dtVessel.Rows[0]["Tailshft_Svry_Last"].ToString() != "")
{
txtTailLast.Text = (DateTime.Parse(dtVessel.Rows[0]["Tailshft_Svry_Last"].ToString())).ToShortDateString();;
}
if (dtVessel.Rows[0]["Tailshft_Svry_Next"].ToString() != "")
{
txtTailNext.Text = (DateTime.Parse(dtVessel.Rows[0]["Tailshft_Svry_Next"].ToString())).ToShortDateString();;
}
if (dtVessel.Rows[0]["Tailshft_Svry_Latest"].ToString() != "")
{
txtTailLatest.Text = (DateTime.Parse(dtVessel.Rows[0]["Tailshft_Svry_Latest"].ToString())).ToShortDateString();;
}
ShipImg.ImageUrl = "ShipImage/" + dtVessel.Rows[0]["Vessel_Image"].ToString();
Session["Shipimage"] = dtVessel.Rows[0]["Vessel_Image"].ToString();
TankImg.ImageUrl = "shipLayout/" + dtVessel.Rows[0]["Vessel_Tank_Image"].ToString();
Session["TankImg"] = dtVessel.Rows[0]["Vessel_Tank_Image"].ToString();
txtemail.Text = dtVessel.Rows[0]["Vessel_email"].ToString();
}
catch (Exception ex)
{
//string js = ex.Message;
//ScriptManager.RegisterStartupScript(this, this.GetType(), "error", js, true);
}
}
protected void onUpdate(object source, CommandEventArgs e)
{
lblMessage1.Text = "";
HiddenFlag.Value = "Edit";
OperationMode = "Edit Vessel";
DataTable dt = new DataTable();
dt = objBLL.GetVesselDetails_ByID(Convert.ToInt32(e.CommandArgument.ToString()));
ddlVesselManager.SelectedValue = dt.Rows[0]["Vessel_Manager"].ToString() != "" ? dt.Rows[0]["Vessel_Manager"].ToString() : "0";
Load_FleetList_AddVessel();
Load_VesselList();
ddlFleet_AddVessel.SelectedValue = dt.Rows[0]["FleetCode"].ToString() != "" ? dt.Rows[0]["FleetCode"].ToString() : "0";
ddlvessel_AddType.SelectedValue = dt.Rows[0]["Vessel_type"].ToString() != "" ? dt.Rows[0]["Vessel_type"].ToString() : "0";
txtVesselID.Text = dt.Rows[0]["Vessel_ID"].ToString();
txtVessel.Text = dt.Rows[0]["Vessel_Name"].ToString();
txtVesselShortName.Text = dt.Rows[0]["Vessel_Short_Name"].ToString();
txtEmailID.Text = dt.Rows[0]["Vessel_email"].ToString();
dtTakeoverDate.Text = dt.Rows[0]["Takeover_Date"].ToString();
dtHandoverDate.Text = dt.Rows[0]["Handover_Date"].ToString();
txtMinimumCTM.Text = dt.Rows[0]["Min_CTM"].ToString();
txtCallSign.Text = dt.Rows[0]["Vessel_Call_sign"].ToString();
txtImoNo.Text = dt.Rows[0]["Vessel_IMO_No"].ToString();
ddlVesselFlage_AddVessel.SelectedValue = dt.Rows[0]["L_Vessel_Flag"].ToString() != "" ? dt.Rows[0]["L_Vessel_Flag"].ToString() : "0";
if (dt.Rows[0]["ODM_ENABLED"].ToString() == "-1")
{
chkSyncEnable.Checked = true;
}
else
{
chkSyncEnable.Checked = false;
}
lnkAttachment.Text = dt.Rows[0]["ME_Power_Curve"].ToString();
//lnkAttachment.NavigateUrl = @"\" + System.Configuration.ConfigurationManager.AppSettings["APP_NAME"].ToString() + @"\Uploads\MEPowerCurve\" + lnkAttachment.Text;
lnkAttachment.NavigateUrl = @"~\Uploads\MEPowerCurve\" + lnkAttachment.Text; //Added By JIT_1776_Pranali_17072015
lnkVslImage.Text = dt.Rows[0]["Vessel_Image"].ToString();
lnkVslImage.NavigateUrl = @"~\Uploads\VesselImage\" + lnkVslImage.Text;//Added By JIT_1776_Pranali_17072015
//lnkVslImage.NavigateUrl = @"\" + System.Configuration.ConfigurationManager.AppSettings["APP_NAME"].ToString() + @"\Uploads\VesselImage\" + lnkVslImage.Text;
if (lnkAttachment.Text != "")
{
lnkAttachment.Visible = true;
ImgTempAttDelete.Visible = true;
}
else
{
lnkAttachment.Visible = false;
ImgTempAttDelete.Visible = false;
}
if (lnkVslImage.Text != "")
{
lnkVslImage.Visible = true;
ImgVslImgDelete.Visible = true;
}
else
{
lnkVslImage.Visible = false;
ImgVslImgDelete.Visible = false;
}
chkIsVessel.Checked = Convert.ToBoolean(dt.Rows[0]["ISVESSEL"]);
string InfoDiv = "Get_Record_Information_Details('LIB_VESSELS','Vessel_ID=" + txtVesselID.Text + "')";
ScriptManager.RegisterStartupScript(this, this.GetType(), "InfoDiv", InfoDiv, true);
string AddNewVessel = String.Format("showModal('dvAddNewVessel',false);");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AddNewVessel", AddNewVessel, true);
}
protected void Page_Load(object sender, EventArgs e)
{
// show office portage only if office portage bill has been considered for any joining type//
string arg = Request.QueryString["arg"].ToString();
string[] arr;
if (arg != null && arg.Length > 0)
{
arr = arg.Split('~');
ViewState["Vessel_ID"] = UDFLib.ConvertToInteger(arr[0]);
ViewState["PBDt"] = DateTime.Parse(arr[1]);
ViewState["Vessel_Name"] = arr[2];
}
if (UDFLib.ConvertToInteger(ViewState["Vessel_ID"]) > 0)
{
BLL_Crew_Admin objAdm = new BLL_Crew_Admin();
DataTable dtJtype = objAdm.Get_JoiningType_List(null);
BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib();
DataTable dtVsl = objVsl.GetVesselDetails_ByID(Convert.ToInt32(ViewState["Vessel_ID"]));
if (dtJtype.Rows.Count > 0 && dtVsl.Rows.Count > 0)
{
// for office vessel only
if (dtJtype.Select("OfficePortageBillConsidered=1").Length > 0 && UDFLib.ConvertToInteger(dtVsl.Rows[0]["ISVESSEL"]) == 0)
{
btnGeneratePortageBill.Visible = true;
btnFinalizePortageBill.Visible = true;
DataTable dtOPPbill = BLL_PB_PortageBill.Get_Open_PortageBill();
if (dtOPPbill.Rows.Count > 0 && Convert.ToString(dtOPPbill.Rows[0]["GENERATE_PB"]).Trim().Length > 1)
{
ViewState["Open_PB_Month"] = Convert.ToDateTime(dtOPPbill.Rows[0]["PB_GEN_DATE"]).Month;
ViewState["Open_PB_Year"] = Convert.ToDateTime(dtOPPbill.Rows[0]["PB_GEN_DATE"]).Year;
}
// if open pbill is same as requested then generate pbill //
if (int.Parse(ViewState["Open_PB_Month"].ToString()) == DateTime.Parse(ViewState["PBDt"].ToString()).Month&& int.Parse(ViewState["Open_PB_Year"].ToString()) == DateTime.Parse(ViewState["PBDt"].ToString()).Year)
{
BLL_PB_PortageBill.Upd_Generate_PortageBill(ViewState["Open_PB_Month"].ToString(), ViewState["Open_PB_Year"].ToString(), Convert.ToInt32(ViewState["Vessel_ID"]), Convert.ToInt32(Session["USERID"]), null);
}
else
{
btnGeneratePortageBill.Visible = false;
btnFinalizePortageBill.Visible = false;
}
}
else
{
btnGeneratePortageBill.Visible = false;
btnFinalizePortageBill.Visible = false;
}
}
Load_PortageBill();
}
UserAccessValidation();
}
public void ViewVesselDetails(int Key)
{
DataTable dtVessel = objBLL.GetVesselDetails_ByID(Key);
FormView1.DataSource = dtVessel;
FormView1.DataBind();
FormView3.DataSource = dtVessel;
FormView3.DataBind();
FormView4.DataSource = dtVessel;
FormView4.DataBind();
FormView5.DataSource = dtVessel;
FormView5.DataBind();
FormView6.DataSource = dtVessel;
FormView6.DataBind();
FormView7.DataSource = dtVessel;
FormView7.DataBind();
ShipImg.ImageUrl = "~/Vessel/ShipImage/" + dtVessel.Rows[0]["Vessel_Image"].ToString();
TankImg.ImageUrl = "~/Vessel/shipLayout/" + dtVessel.Rows[0]["Vessel_Tank_Image"].ToString();
lblShipName.Text = dtVessel.Rows[0]["Vessel_Short_Name"].ToString();
DataSet ds = objBLL.GetInmarsatValues_ForVesselID(Key);
DataTable dt1 = ds.Tables[0];
DataTable dt2 = ds.Tables[0];
dt1 = RemoveDuplicateRows(dt1, "terminal");
dt2 = RemoveDuplicateRows(dt2, "channel");
// GridView1.DataSource = ds.Tables["Dtl_IID_INMARSAT"].DefaultView;
// GridView1.DataBind();
//DataTable SourceDt = new DataTable();
for (int i = 0; i < dt1.Rows.Count + 1; i++)
{
TableRow tr = new TableRow();
for (int j = 0; j < 5; j++)
{
TableCell tc = new TableCell();
Label lbl = new Label();
tc.Text = "";
tc.BorderWidth = 1;
tr.Cells.Add(tc);
if (j == 0 && i > 0)
{
tc.Text = "<b>Inmarsat-</b>" + dt1.Rows[i - 1]["terminal"].ToString();
}
}
tr.BorderStyle = BorderStyle.Solid;
Table1.Rows.Add(tr);
if (i >= 1)
{
switch (ds.Tables[0].Rows[i - 1]["Channel"].ToString())
{
case "Telex":
{
Table1.Rows[i].Cells[1].Text = ds.Tables[0].Rows[i - 1]["Phone"].ToString();
break;
}
case "Telephone":
{
Table1.Rows[i].Cells[2].Text = ds.Tables[0].Rows[i - 1]["Phone"].ToString();
break;
}
case "Fax":
{
Table1.Rows[i].Cells[3].Text = ds.Tables[0].Rows[i - 1]["Phone"].ToString();
break;
}
case "Data":
{
Table1.Rows[i].Cells[4].Text = ds.Tables[0].Rows[i - 1]["Phone"].ToString();
break;
}
}
}
}
Table1.Rows[0].Cells[0].Text = "";
Table1.Rows[0].Cells[1].Text = "<b>Telex</b>";
Table1.Rows[0].Cells[2].Text = "<b>Telephone</b>";
Table1.Rows[0].Cells[3].Text = "<b>Fax</b>";
Table1.Rows[0].Cells[4].Text = "<b>Data</b>";
//GridView1.DataSource = dt2;
//GridView1.DataBind();
}
