protected void BindCPdDetails()
{
DataTable dt = objCP.GET_Charter_Party_Details(UDFLib.ConvertIntegerToNull(CPID));
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lblOwner.Text = dr["Owner"].ToString();
ltCharterer.Text = "TO :" + dr["Charterer"].ToString();
VesselName = dr["Vessel_Name"].ToString();
ltVesselCharterer.Text = dr["Vessel_Name"].ToString() + "/" + dr["ChartererShort"].ToString();
DateTime dtCPDate = Convert.ToDateTime(dr["CP_Date"]);
ltCPdate.Text = dtCPDate.ToString("dd-MMM-yyyy");
Bank_Account_ID = dr["Bank_Account_ID"].ToString();
}
}
protected void BindAttachment()
{
int? ID = UDFLib.ConvertIntegerToNull(Session["CPID"]);
DataTable dt1 = objCP.GET_Charter_Party_Details(UDFLib.ConvertIntegerToNull(Session["CPID"]));
if (dt1.Rows[0]["Charter_Id"] != null)
{
Charter_ID = dt1.Rows[0]["Charter_Id"].ToString();
}
Session["Charter_ID"] = Charter_ID;
DataTable dt = new DataTable();
dt = objCP.GET_CharterFiles(Charter_ID);
gvAttachment.DataSource = dt;
gvAttachment.DataBind();
//Repeater1.DataSource = dt;
//Repeater1.DataBind();
}
protected void BindCPDetails()
{
clearControl();
if (Session["CPID"] != null)
{
CPID = Convert.ToInt32(Session["CPID"]);
}
try
{
if (CPID != 0)
{
btnAddDeliveryBunker.Visible = true;
btnAddRedeliveryBunker.Visible = true;
DataTable dt = oCP.GET_Charter_Party_Details(UDFLib.ConvertIntegerToNull(CPID));
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
lblCRNo.Text = dr["Charter_Id"].ToString();
if (dr["Vessel_Opening_Port_ID"] != null)
{
ddlPort.SelectedValue = dr["Vessel_Opening_Port_ID"].ToString();
}
txtDeliveryPort.Text = dr["Delivery_Port"].ToString();
if (dr["Delivery_Date_Zone"] != null)
{
ddlDeliveryLTGMT.SelectedValue = dr["Delivery_Date_Zone"].ToString();
}
txtRedeliveryPort.Text = dr["Redelivery_Port"].ToString();
if (dr["ReDelivery_Date_Zone"] != null)
{
ddlReDeliveryLTGMT.SelectedValue = dr["ReDelivery_Date_Zone"].ToString();
}
if (dr["Vessel_Opening_Date"] != null)
{
DateTime dtOpening = Convert.ToDateTime(dr["Vessel_Opening_Date"]);
dtOP.Text = dtOpening.ToString("dd-MMM-yyyy");
string Hour = dtOpening.Hour.ToString().Trim();
string Min = dtOpening.Minute.ToString().Trim();
if (Hour.Length == 1)
{
Hour = "0" + Hour;
}
if (Min.Length == 1)
{
Min = "0" + Min;
}
ddlOpeningHours.SelectedValue = Hour;
ddlOpeningMins.SelectedValue = Min;
}
DateTime dtCPDate = Convert.ToDateTime(dr["CP_Date"]);
dtCP.Text = dtCPDate.ToString("dd-MMM-yyyy");
ddlStatus.SelectedValue = dr["CP_Status_ID"].ToString();
ddlCPType.SelectedValue = dr["CP_Type_ID"].ToString();
ddlVessel.SelectedValue = dr["Vessel_Id"].ToString();
if (dr["Charterer_Code"] != null)
{
ddlCharterer.SelectedValue = dr["Charterer_Code"].ToString();
}
if (dr["Vessel_Opening_Port_ID"] != null)
{
ddlPort.SelectedValue = dr["Vessel_Opening_Port_ID"].ToString();
}
if (dr["OWNER_Code"] != null)
{
ddlOwner.SelectedValue = dr["OWNER_Code"].ToString();
}
if (dr["Broker_Code"] != null)
{
ddlBroker.SelectedValue = dr["Broker_Code"].ToString();
}
if (dr["Broker2_Code"] != null)
{
ddlBroker2.SelectedValue = dr["Broker2_Code"].ToString();
}
if (dr["Broker3_Code"] != null)
{
ddlBroker3.SelectedValue = dr["Broker3_Code"].ToString();
}
if (dr["Bank_Account_ID"] != null)
{
ddlOwnerBank.SelectedValue = dr["Bank_Account_ID"].ToString();
}
if (dr["Hire_Type_ID"] != null)
{
ddlHireType.SelectedValue = dr["Hire_Type_ID"].ToString();
}
// txtLaycan.Text = dr["LayCan"].ToString();
txtGMTTimeZone.Text = dr["LayCan_Time_Zone"].ToString();
txtRedeliveryDays.Text = dr["Redelivery_Notice_Days"].ToString();
if (dr["LayCan_Start"] != null && dr["LayCan_Start"].ToString() != "")
{
DateTime dtLCStart = Convert.ToDateTime(dr["LayCan_Start"]);
string LCHour = dtLCStart.Hour.ToString().Trim();
string LCMin = dtLCStart.Minute.ToString().Trim();
if (LCHour.Length == 1)
{
LCHour = "0" + LCHour;
}
if (LCMin.Length == 1)
{
LCMin = "0" + LCMin;
}
dtLayCanStart.Text = dtLCStart.ToString("dd-MMM-yyyy");
ddlLayCanStartHours.SelectedValue = LCHour;
ddlLayCanStartMins.SelectedValue = LCMin;
}
if (dr["LayCan_End"] != null && dr["LayCan_End"].ToString() != "")
{
DateTime dtLCEnd = Convert.ToDateTime(dr["LayCan_End"]);
string LCHour = dtLCEnd.Hour.ToString().Trim();
string LCMin = dtLCEnd.Minute.ToString().Trim();
if (LCHour.Length == 1)
{
LCHour = "0" + LCHour;
}
if (LCMin.Length == 1)
{
LCMin = "0" + LCMin;
}
dtLayCanEnd.Text = dtLCEnd.ToString("dd-MMM-yyyy");
ddlLayCanEndHours.SelectedValue = LCHour;
ddlLayCanEndMins.SelectedValue = LCMin;
}
if (dr["Delivery_Date"] != null && dr["Delivery_Date"].ToString() != "")
{
DateTime dtDelivery = Convert.ToDateTime(dr["Delivery_Date"]);
string Hour = dtDelivery.Hour.ToString().Trim();
string Min = dtDelivery.Minute.ToString().Trim();
if (Hour.Length == 1)
{
Hour = "0" + Hour;
}
if (Min.Length == 1)
{
Min = "0" + Min;
}
dtdelivery.Text = dtDelivery.ToString("dd-MMM-yyyy");
ddlDeliveryPortHour.SelectedValue = Hour;
ddlDeliveryPortMin.SelectedValue = Min;
}
if (dr["Redelivery_Date"] != null && dr["Redelivery_Date"].ToString() != "")
{
DateTime dtReDelivery = Convert.ToDateTime(dr["Redelivery_Date"]);
dtRedelivery.Text = dtReDelivery.ToString("dd-MMM-yyyy");
string Hour = dtReDelivery.Hour.ToString().Trim();
string Min = dtReDelivery.Minute.ToString().Trim();
if (Hour.Length == 1)
{
Hour = "0" + Hour;
}
if (Min.Length == 1)
{
Min = "0" + Min;
}
ddlRedeliveryHour.SelectedValue = Hour;
ddlRedeliveryMin.SelectedValue = Min;
}
txtHireTerms.Text = dr["Hire_Terms"].ToString();
txtCommisionTerms.Text = dr["Commission_Terms"].ToString();
txtCurrentHireRate.Text = dr["Hire_Rate"].ToString();
txtAddressCommision.Text = dr["Address_Comm"].ToString();
txtBrokCommision.Text = dr["Brokerage_Comm"].ToString();
txtBrokCommision2.Text = dr["Brokerage2_Comm"].ToString();
txtBrokCommision3.Text = dr["Brokerage3_Comm"].ToString();
txtBillingCycle.Text = dr["Billing_Period"].ToString();
txtSpreadBy.Text = dr["Billing_Cycle_Value"].ToString();
if (dr["Billing_Cycle_Type"] != null)
{
ddlSpreadByInterval.SelectedItem.Text = dr["Billing_Cycle_Type"].ToString();
}
if (dr["Brokerage_Comm_Payment"] != null)
{
ddlBrokPayment.SelectedValue = dr["Brokerage_Comm_Payment"].ToString();
}
if (dr["Brokerage2_Comm_Payment"] != null)
{
ddlBrokPayment2.SelectedValue = dr["Brokerage2_Comm_Payment"].ToString();
}
if (dr["Brokerage3_Comm_Payment"] != null)
{
ddlBrokPayment3.SelectedValue = dr["Brokerage3_Comm_Payment"].ToString();
}
}
BindBunkerDetail();
ReBindBunkerDetail();
}
else
{
lblCRNo.Text = "[Not Created.]";
lblCRNo.ForeColor = System.Drawing.Color.Red;
}
}
catch { }
}
protected void BindInvDetails()
{
try
{
CPID = Convert.ToInt32(Session["CPID"]);
if (CPID != null)
{
DataTable dtCP = objCP.GET_Charter_Party_Details(UDFLib.ConvertIntegerToNull(CPID));
if (dtCP.Rows.Count > 0)
{
DataRow dr = dtCP.Rows[0];
if (dr["Bank_Account_ID"] != null)
{
ddlBank.SelectedValue = dr["Bank_Account_ID"].ToString();
}
txtAddressCommision.Text = dr["Address_Comm"].ToString();
}
if (ViewState["InvID"] != null && ViewState["InvID"].ToString() != "0")
{
CPID = Convert.ToInt32(Session["CPID"]);
//Inv_ID = Convert.ToInt32(ViewState["InvID"]);
DataTable dt = objHI.Get_Hire_InvDetail(UDFLib.ConvertIntegerToNull(ViewState["InvID"]));
if (dt.Rows.Count > 0)
{
DataRow dr = dt.Rows[0];
txtDate.Text = dr["Hire_Invoice_Date"].ToString();
txtDueDate.Text = dr["Due_Date"].ToString();
if (dr["Hire_Invoice_Status"] != null)
{
string Status = dr["Hire_Invoice_Status"].ToString();
string StatusText = ddlStatus.Items.FindByText(Status).Text;
string strStatus = dr["strStatus"].ToString();
ddlStatus.SelectedValue = ddlStatus.Items.FindByText(Status).Value;
if (StatusText == "APPROVED")
{
if (strStatus != "Matched")
{
btnUnapprove.Visible = true;
}
btnApprove.Visible = false;
}
if (StatusText == "PLANNED")
{
btnUnapprove.Visible = false;
btnApprove.Visible = true;
}
}
if (dr["Bank_Account_ID"] != null && dr["Bank_Account_ID"].ToString() != "0")
{
ddlBank.SelectedValue = dr["Bank_Account_ID"].ToString();
}
if (dr["Period_From"] != null)
{
DateTime dtOpening = Convert.ToDateTime(dr["Period_From"]);
string Hour = dtOpening.Hour.ToString().Trim();
string Min = dtOpening.Minute.ToString().Trim();
if (Hour.Length == 1)
{
Hour = "0" + Hour;
}
if (Min.Length == 1)
{
Min = "0" + Min;
}
dtBillingStart.Text = dtOpening.ToString("dd-MMM-yyyy");
ddlBillingStartHours.SelectedValue = Hour;
ddlBillingStartMins.SelectedValue = Min;
}
if (dr["Period_To"] != null)
{
DateTime dtOpening = Convert.ToDateTime(dr["Period_To"]);
string Hour = dtOpening.Hour.ToString().Trim();
string Min = dtOpening.Minute.ToString().Trim();
if (Hour.Length == 1)
{
Hour = "0" + Hour;
}
if (Min.Length == 1)
{
Min = "0" + Min;
}
dtBillingEnd.Text = dtOpening.ToString("dd-MMM-yyyy");
ddlBillingEndHours.SelectedValue = Hour;
ddlBillingEndMins.SelectedValue = Min;
}
if (dr["Coverage"] != null)
{
ltCoverageOfdays.Text = " Coverage of " + dr["Coverage"].ToString() + " days.";
}
txtReference.Text = dr["InvoiceRef"].ToString();
txtInvAmount.Text = dr["Billed_Amount"].ToString();
txtAddressCommision.Text = dr["Address_Comm"].ToString();
txtReceivedamount.Text = dr["Received_Amount"].ToString();
txtRcvDate.Text = dr["Received_Date"].ToString();
txtInvRemarks.Text = dr["invoice_Remarks"].ToString();
if (dr["DUE"].ToString() == "NOT DUE")
{
ltOutstandingamt.Text = "NOT DUE";
}
else
{
ltOutstandingamt.Text = dr["DUE"].ToString() + " US$";
}
}
if (txtInvAmount.Text == "")
{
btnApprove.Visible = false;
}
}
else
{
txtDate.Text = DateTime.Now.ToString("dd-MMM-yyyy");
}
}
}
catch (Exception ex)
{
string err = ex.ToString();
}
}
