protected void btnsave_Click(object sender, EventArgs e) { int?AutoRefreshFlage = null; if (chkAutoRefresh_Add.Checked) { AutoRefreshFlage = 1; } if (HiddenFlag.Value == "Add") { int retval = BLL_Infra_DashBoard.Insert_DashBoardSnippet(txtSnippetID.Text, txtSnippetName.Text, txtSnippetFunctionName.Text , UDFLib.ConvertIntegerToNull(ddlDepartment_Add.SelectedValue), ddlDepartmentColor.SelectedValue, AutoRefreshFlage, Convert.ToInt32(Session["USERID"])); } else { int retval = BLL_Infra_DashBoard.Edit_DashBoardSnippet(Convert.ToInt32(txtID.Text.Trim()), txtSnippetID.Text, txtSnippetName.Text, txtSnippetFunctionName.Text , UDFLib.ConvertIntegerToNull(ddlDepartment_Add.SelectedValue), ddlDepartmentColor.SelectedValue, AutoRefreshFlage, Convert.ToInt32(Session["USERID"])); } BindDashBoardSnippet(); string hidemodal = String.Format("hideModal('divadd')"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true); }
protected void Page_Load(object sender, EventArgs e) { dtMonths = BLL_Infra_DashBoard.Get_Portcalls_Month(Convert.ToInt32(Session["userid"])); ChrtPortCallsMonth.DataSource = dtMonths; ChrtPortCallsMonth.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { DataSet ds = BLL_Infra_DashBoard.Get_Decklog_Anomalies(Convert.ToInt32(Session["USERID"])); gvDecklogAnomalies.DataSource = ds; ViewState["rowcnt"] = ds.Tables[0].Rows.Count - 1; gvDecklogAnomalies.DataBind(); }
protected void lstUserList_SelectedIndexChanged(object sender, EventArgs e) { try { gvSnippets.DataSource = BLL_Infra_DashBoard.Get_Snippet_Access(Convert.ToInt32(lstUserList.SelectedValue), null); gvSnippets.DataBind(); } catch (Exception ex) { lblmsg.Text = ex.Message; } }
protected void Page_Load(object sender, EventArgs e) { if (hdfissaveClicked.Value == "1") { TreeView1.Visible = false; } if (!IsPostBack) { DataTable dtmenu = BLL_Infra_DashBoard.Get_User_Menu_List(Convert.ToInt32(Session["userid"].ToString())); GenerateUL(dtmenu); } }
protected void btnSaveFavourite_Click(object s, EventArgs e) { dtMenu.Columns.Add("menu_code"); dtMenu.Columns.Add("is_favourite"); dtMenu.PrimaryKey = new DataColumn[] { dtMenu.Columns["menu_code"] }; Traverse(TreeView1.Nodes); BLL_Infra_DashBoard.UPD_User_Menu_Favourite(Convert.ToInt32(Session["userid"].ToString()), dtMenu); string msgmodal = String.Format("parent.asyncGet_MyShortsCuts_Menu();parent.CloseWindow('POP__Menu');"); ScriptManager.RegisterClientScriptBlock(Page, Page.GetType(), "Apprmodala", msgmodal, true); }
protected void onUpdate(object source, CommandEventArgs e) { HiddenFlag.Value = "Edit"; OperationMode = "Edit Snippet"; DataTable dt = new DataTable(); dt = BLL_Infra_DashBoard.List_DashBoardSnippet(Convert.ToInt32(e.CommandArgument.ToString())); txtID.Text = dt.Rows[0]["ID"].ToString(); txtSnippetID.Text = dt.Rows[0]["Snippet_ID"].ToString(); txtSnippetName.Text = dt.Rows[0]["Snippet_Name"].ToString(); txtSnippetFunctionName.Text = dt.Rows[0]["Snippet_Function_Name"].ToString(); if (ddlDepartment_Add.Items.FindByValue(dt.Rows[0]["Department_ID"].ToString()) != null) { ddlDepartment_Add.SelectedValue = dt.Rows[0]["Department_ID"].ToString() != "" ? dt.Rows[0]["Department_ID"].ToString() : "0"; } else { ddlDepartment_Add.SelectedValue = "0"; } //ddlDepartment_Add.SelectedValue = dt.Rows[0]["Department_ID"].ToString() != "" ? dt.Rows[0]["Department_ID"].ToString() : "0"; ddlDepartmentColor.SelectedValue = dt.Rows[0]["Department_Color"].ToString() != "" ? dt.Rows[0]["Department_Color"].ToString() : "0"; chkAutoRefresh_Add.Checked = dt.Rows[0]["Auto_Refresh"].ToString() == "1" ? true : false; string InfoDiv = "Get_Record_Information_Details('INF_LIB_Dash_Board_Snippet','ID=" + txtID.Text + "')"; ScriptManager.RegisterStartupScript(this, this.GetType(), "InfoDiv", InfoDiv, true); string AddOfficeDeptmodal = String.Format("showModal('divadd',false);"); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AddOfficeDeptmodal", AddOfficeDeptmodal, true); }
protected void btnSaveSnippets_Click(object s, EventArgs e) { try { DataTable dtsnippets = new DataTable(); dtsnippets.Columns.Add("Snippet_ID"); dtsnippets.Columns.Add("Access"); foreach (GridViewRow rw in gvSnippets.Rows) { DataRow dr = dtsnippets.NewRow(); dr["Snippet_ID"] = ((CheckBox)rw.FindControl("chksnippet")).ToolTip; dr["Access"] = ((CheckBox)rw.FindControl("chksnippet")).Checked == true ? 1 : 0; dtsnippets.Rows.Add(dr); } BLL_Infra_DashBoard.UPD_Snippet_Access(Convert.ToInt32(lstUserList.SelectedValue), dtsnippets, Convert.ToInt32(Session["userid"].ToString())); lblmsg.Text = "Saved Successfully"; } catch (Exception ex) { lblmsg.Text = ex.Message; } }
protected void CheckAccessRightsAndLoadSnippets() { try { StringBuilder sbMyActionLabels = new StringBuilder(); int?DepID = UDFLib.ConvertIntegerToNull((Request.QueryString["DepID"] == null ? "0" : Request.QueryString["DepID"].ToString())); DataTable dtSnippetAccess = BLL_Infra_DashBoard.Get_Snippet_Access_OnDashboard(Convert.ToInt32(Session["userid"]), DepID); if (DepID != null) { DataRow[] drValue = dtSnippetAccess.Select("Department_ID = " + DepID.ToString()); if (drValue.Length > 0) { string avalue = drValue[0]["VALUE"].ToString(); lblDashBoard.Text = avalue + " Dashboard"; } } //if (DepID != null) // lblDashBoard.Text = dtSnippetAccess.Rows[0]["VALUE"] + " Dashboard"; StringBuilder jsFunctions = new StringBuilder(); StringBuilder jsFunctions_Auto_Refresh = new StringBuilder(); int counter = 0; if (dtSnippetAccess.Rows.Count > 0) { foreach (DataRow dr in dtSnippetAccess.Rows) { try { WebPart wp = _manager.WebParts[Convert.ToString(dr["snippet_id"])]; if (wp != null) { //WebPartVerbCollection vcl = wp.Zone.WebParts[0].Verbs; if (Convert.ToString(dr["Active_Status"]) != "1" && !wp.IsClosed) { _manager.CloseWebPart(wp); } else if (Convert.ToString(dr["access"]) != "0") { int i = 0; foreach (System.Web.UI.WebControls.WebParts.GenericWebPart cl in wp.Parent.Controls) { i++; if (cl.ChildControl.ID == Convert.ToString(dr["snippet_id"])) { if (Convert.ToString(dr["formyaction"]) == "1") { if (sbMyActionLabels.Length > 0) { sbMyActionLabels.Append(","); } sbMyActionLabels.Append(Convert.ToString(dr["snippet_id"])); } ((Label)cl.ChildControl).CssClass = Convert.ToString(dr["department_color"]); } } if (Convert.ToString(dr["Snippet_Function_Name"]).Length > 1) { if (Convert.ToInt32(dr["Auto_Refresh"]) == 1) { if (Convert.ToInt32(dr["IsCountSpecific"]) == 1) { if (counter == 0) { hdnFromDays0.Value = Convert.ToString(dr["FromDay"]); hdnToDays7.Value = Convert.ToString(dr["ToDay"]); counter = counter + 1; } else if (counter == 1) { hdnFromDays8.Value = Convert.ToString(dr["FromDay"]); hdnToDays30.Value = Convert.ToString(dr["ToDay"]); counter = counter + 1; } else if (counter == 2) { hdnFromDays31.Value = Convert.ToString(dr["FromDay"]); hdnToDays90.Value = Convert.ToString(dr["ToDay"]); counter = counter + 1; } // jsFunctions_Auto_Refresh.Append(" setTimeout(" + Convert.ToString(dr["Snippet_Function_Name"]) + "(" + hdnFromDays0.Value.ToString() + "," + hdnToDays7.Value.ToString() + ")" + ",200); "); // jsFunctions_Auto_Refresh.Append(" setTimeout(" + Convert.ToString(dr["Snippet_Function_Name"]) + "(" + Convert.ToString(dr["FromDay"]) + "," + Convert.ToString(dr["ToDay"]) + ")" + ",200); "); jsFunctions_Auto_Refresh.Append(" setTimeout(" + Convert.ToString(dr["Snippet_Function_Name"]) + ",200); "); } else { jsFunctions_Auto_Refresh.Append(" setTimeout(" + Convert.ToString(dr["Snippet_Function_Name"]) + ",200); "); } } else { if (Convert.ToInt32(dr["IsCountSpecific"]) == 1) { if (counter == 0) { hdnFromDays31.Value = Convert.ToString(dr["FromDay"]); hdnToDays90.Value = Convert.ToString(dr["ToDay"]); counter = counter + 1; } else if (counter == 1) { hdnFromDays8.Value = Convert.ToString(dr["FromDay"]); hdnToDays30.Value = Convert.ToString(dr["ToDay"]); counter = counter + 1; } else if (counter == 2) { hdnFromDays0.Value = Convert.ToString(dr["FromDay"]); hdnToDays7.Value = Convert.ToString(dr["ToDay"]); counter = counter + 1; } jsFunctions_Auto_Refresh.Append(" setTimeout(" + Convert.ToString(dr["Snippet_Function_Name"]) + ",200); "); } else { jsFunctions.Append(" setTimeout(" + Convert.ToString(dr["Snippet_Function_Name"]) + ",200); "); } } } } else if (Convert.ToString(dr["access"]) == "0" && !wp.IsClosed) { _manager.CloseWebPart(wp); //hide the web part based on user rights } } } catch (Exception ex) { lblErrorMessage.Text += ex.Message + ex.StackTrace; } } if (jsFunctions.Length > 0) { String msgretv = " try { " + jsFunctions.ToString() + " } catch(ex){alert(ex._message);} "; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Load_DashBoard", msgretv, true); } if (jsFunctions_Auto_Refresh.Length > 1) { jsFunctions_Auto_Refresh.Insert(0, " function Refresh_Functions(){ "); jsFunctions_Auto_Refresh.Append(" setTimeout('Refresh_Functions()',300000); } "); jsFunctions_Auto_Refresh.Append("setTimeout(Refresh_Functions,200);"); String msgFunc = jsFunctions_Auto_Refresh.ToString(); ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Load_DashBoard_Refresh_", msgFunc, true); } if (sbMyActionLabels.Length > 0) { string slbl = "var ForMyActionLabels='" + sbMyActionLabels.ToString() + "';"; ScriptManager.RegisterStartupScript(Page, Page.GetType(), "Load_MyActions", slbl, true); } } } catch (Exception ex) { lblErrorMessage.Text += ex.Message + ex.StackTrace; } }
protected void onDelete(object source, CommandEventArgs e) { int retval = BLL_Infra_DashBoard.Delete_DashBoardSnippet(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Session["USERID"])); BindDashBoardSnippet(); }
protected void Requisition_Count() { BLL_Infra_VesselLib objVsl = new BLL_Infra_VesselLib(); BLL_PURC_Purchase objTechService = new BLL_PURC_Purchase(); BLL_Infra_UserCredentials objUserFlt = new BLL_Infra_UserCredentials(); DataTable dtEmptyTable = new DataTable(); DataTable FleetDT = objVsl.GetFleetList(Convert.ToInt32(Session["USERCOMPANYID"].ToString())); DataTable DeptDt = objTechService.GetDeptType(); dtEmptyTable.Columns.Add("Message"); DataRow drEmpty = dtEmptyTable.NewRow(); drEmpty[0] = "No record found !"; dtEmptyTable.Rows.Add(drEmpty); DataTable dtUserFleet = objUserFlt.Get_Fleet_By_UserID(Convert.ToInt32(Session["USERID"].ToString())); if (dtUserFleet.Rows.Count > 0) { Table tbl_Reqsn_Count = new Table(); tbl_Reqsn_Count.CssClass = "tbl-css-dash"; tbl_Reqsn_Count.CellPadding = 0; tbl_Reqsn_Count.CellSpacing = 1; foreach (DataRow drflt in FleetDT.Rows) { // get the fleets based on vessels assigned to loged in user DataRow[] drUserFleet = dtUserFleet.Select("fleetcode='" + drflt["code"].ToString() + "'"); if (drUserFleet.Length > 0) { TableRow tr_Reqsn_Count_HD_Fleet = new TableRow(); TableCell cl_Reqsn_Count_HD_Fleet = new TableCell(); TableRow tr_Reqsn_Count_HD_FormType = new TableRow(); Label lblHD = new Label(); TableRow tr_Reqsn_Count = new TableRow(); tr_Reqsn_Count.CssClass = "td-css-dash"; cl_Reqsn_Count_HD_Fleet.CssClass = "cell-HD-css"; lblHD.Text = drflt["Name"].ToString(); cl_Reqsn_Count_HD_Fleet.Controls.Add(lblHD); tr_Reqsn_Count_HD_Fleet.Controls.Add(cl_Reqsn_Count_HD_Fleet); tbl_Reqsn_Count.Controls.Add(tr_Reqsn_Count_HD_Fleet); foreach (DataRow drDep in DeptDt.Rows) { if (drDep["Short_Code"].ToString() != "ALL") { DataTable dtReqsnCount = BLL_Infra_DashBoard.Get_Rreqsn_Count(drDep["Short_Code"].ToString(), UDFLib.ConvertToInteger(drflt["code"].ToString()), Session["USERID"].ToString()).Tables[0]; TableCell cl_Reqsn_Count = new TableCell(); TableCell cl_Reqsn_Count_HD_FormType = new TableCell(); cl_Reqsn_Count_HD_FormType.Text = drDep["Description"].ToString(); cl_Reqsn_Count.CssClass = "td-css-dash"; cl_Reqsn_Count_HD_FormType.CssClass = "cell-HD-css"; GridView gvReqsnCount = new GridView(); gvReqsnCount.ID = "gvReqsnCount" + drflt["code"].ToString() + drDep["Short_Code"].ToString(); if (dtReqsnCount.Rows.Count > 0) { gvReqsnCount.DataSource = dtReqsnCount; } else { gvReqsnCount.DataSource = dtEmptyTable; } gvReqsnCount.DataBind(); gvReqsnCount.EmptyDataText = "No record found !"; gvReqsnCount.AutoGenerateColumns = true; gvReqsnCount.RowStyle.CssClass = "RowStyle-css-dash"; gvReqsnCount.AlternatingRowStyle.CssClass = "AlternatingRowStyle-css-dash"; gvReqsnCount.HeaderStyle.CssClass = "HeaderStyle-css-dash"; tr_Reqsn_Count_HD_FormType.Controls.Add(cl_Reqsn_Count_HD_FormType); cl_Reqsn_Count.Controls.Add(gvReqsnCount); tr_Reqsn_Count.Controls.Add(cl_Reqsn_Count); } } tbl_Reqsn_Count.Controls.Add(tr_Reqsn_Count_HD_FormType); tbl_Reqsn_Count.Controls.Add(tr_Reqsn_Count); } } phReqsnCount.Controls.Add(tbl_Reqsn_Count); } }
protected void Page_Load(object sender, EventArgs e) { gvEvaluationSchedules.DataSource = BLL_Infra_DashBoard.Get_Evaluation_Schedules(Convert.ToInt32(Session["userid"].ToString())); gvEvaluationSchedules.DataBind(); }