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