protected void lstUserList_SelectedIndexChanged(object sender, EventArgs e) { int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString()); DataTable dtvsl = BLL_Infra_Common.Get_User_Vessel_Assignment(Convert.ToInt32(lstUserList.SelectedValue), ddlFleet.SelectedIndex == 0 ? null : UDFLib.ConvertIntegerToNull(ddlFleet.SelectedValue), UserCompanyID); lstVessel.DataSource = dtvsl; lstVessel.DataBind(); // lstVessel.Items.Insert(0, new ListItem("-SELECT-", "-1")); lstVessel.ClearSelection(); chkSelectAll.Checked = false; foreach (DataRow dr in dtvsl.Rows) { ListItem li = lstVessel.Items.FindByValue(dr["ASSIGNED"].ToString()); if (li != null) { li.Selected = true; } } }
/// <summary> /// Added by Anjali DT:20-06-2016 JIT:9496 /// To assign one or more vessel to selected user. /// </summary> private void AssignVesseltoUser() { try { if (ValidateControls()) { int UserCompanyID = UDFLib.ConvertToInteger(Session["USERCOMPANYID"].ToString()); DataTable dtvslAllSelected = BLL_Infra_Common.Get_User_Vessel_Assignment(Convert.ToInt32(lstUserList.SelectedValue), null, UserCompanyID); if (dtvslAllSelected != null) { if (dtvslAllSelected.Rows.Count > 0) { if (ddlFleet.SelectedIndex > 0) { foreach (DataRow item in dtvslAllSelected.Rows) { if (item["FleetCode"].ToString() != ddlFleet.SelectedValue && item["ASSIGNED"].ToString() != "-1") { DataRow dr = dtvsl.NewRow(); dr["ID"] = item["Vessel_ID"].ToString(); dtvsl.Rows.Add(dr); } } } BLL_Infra_Common.Upd_User_Vessel_Assignment(Convert.ToInt32(lstUserList.SelectedValue), dtvsl, Convert.ToInt32(Session["USERID"])); string js1 = "alert('Vessel assignment is saved successfully.');"; ScriptManager.RegisterStartupScript(this, this.GetType(), "script1", js1, true); dtvsl = null; } } } } catch (Exception ex) { throw ex; } }