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