protected void Get_JoiningType()
{
DataTable dt = objBLL.Get_JoiningType_List(null);
ddlJoinType.DataSource = dt;
ddlJoinType.DataBind();
ddlJoinType.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
protected void btnsave_Click(object sender, EventArgs e)
{
string msg;
int flag = 0;
DataTable dtJoining = new DataTable();
dtJoining = objBLL.Get_JoiningType_List(null);
dtJoining.DefaultView.RowFilter = HiddenFlag.Value != "Add" ? "Joining_Type= '" + txtJoiningType.Text.Trim() + "' AND ID<> '" + txtJoiningTypeID.Text.Trim() + "'" : "Joining_Type= '" + txtJoiningType.Text.Trim() + "'";
if (dtJoining.DefaultView.Count > 0)
{
msg = String.Format("alert('Joining Type already exists!')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true);
flag = 1;
string hidemodal = String.Format("showModal('divadd')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true);
}
if (flag != 1)
{
dtJoining.DefaultView.RowFilter = HiddenFlag.Value != "Add" ? "JCode= '" + txtJoiningCode.Text.Trim() + "' AND ID<> '" + txtJoiningTypeID.Text.Trim() + "'" : "JCode= '" + txtJoiningCode.Text.Trim() + "'";
if (dtJoining.DefaultView.Count > 0)
{
msg = String.Format("alert('Joining code already exists!')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true);
flag = 1;
string hidemodal = String.Format("showModal('divadd')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true);
}
else
{
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("JCode", typeof(Int32)));
DataRow dr;
if (chkPBillConsidered.Checked == true)
{
foreach (GridViewRow row in GVOffPBill.Rows)
{
if ((row.Cells[1].FindControl("chkPbillAssigned") as CheckBox).Checked == true)
{
dr = dt.NewRow();
dr["JCode"] = GVOffPBill.DataKeys[row.RowIndex].Value;
dt.Rows.Add(dr);
}
}
}
if (HiddenFlag.Value == "Add")
{
int retval = objBLL.InsertJoiningType(txtJoiningType.Text, txtJoiningCode.Text, chkSeniorityConsidered.Checked, chkVessselPBill_Considered.Checked, chkServiceConsidered.Checked, chkPBillConsidered.Checked, dt, Convert.ToInt32(Session["USERID"]), chkOperatorExp.Checked, chkWatchKeeping.Checked);
}
else
{
int retval = objBLL.EditJoiningType(Convert.ToInt32(txtJoiningTypeID.Text.Trim()), txtJoiningType.Text, txtJoiningCode.Text, chkSeniorityConsidered.Checked, chkVessselPBill_Considered.Checked, chkServiceConsidered.Checked, chkPBillConsidered.Checked, dt, Convert.ToInt32(Session["USERID"]), chkOperatorExp.Checked, chkWatchKeeping.Checked);
}
BindJoiningType();
string hidemodal = String.Format("hideModal('divadd')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, 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();
}
