public void BindModules()
{
int?Project_ID = null;
if (ViewState["ProjectID"] != null)
{
Project_ID = UDFLib.ConvertToInteger(ViewState["ProjectID"].ToString());
}
string sortbycoloumn = (ViewState["MODULESORTBYCOLOUMN"] == null) ? null : (ViewState["MODULESORTBYCOLOUMN"].ToString());
int? sortdirection = null;
if (ViewState["MODULESORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["MODULESORTDIRECTION"].ToString());
}
DataTable dt = BLL_Infra_ShipSettings.Get_Module_Search("", Project_ID, sortbycoloumn, sortdirection);
if (dt.Rows.Count > 0)
{
if (ViewState["ModuleID"] == null)
{
ViewState["ModuleID"] = dt.Rows[0]["Module_ID"].ToString();
}
}
else
{
ViewState["ModuleID"] = null;
}
}
private void BindEmptyModule()
{
DataTable dt = BLL_Infra_ShipSettings.Get_Module_Search(null, null, null, null);
gvModule.DataSource = dt;
gvModule.DataBind();
}
public void BindProjects()
{
string sortbycoloumn = (ViewState["PROJECTSORTBYCOLOUMN"] == null) ? null : (ViewState["PROJECTSORTBYCOLOUMN"].ToString());
int? sortdirection = null;
if (ViewState["PROJECTSORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["PROJECTSORTDIRECTION"].ToString());
}
DataTable dt = BLL_Infra_ShipSettings.Get_Project_Search("", sortbycoloumn, sortdirection);
if (dt.Rows.Count > 0)
{
gvProject.DataSource = dt;
gvProject.DataBind();
if (ViewState["ProjectID"] == null)
{
ViewState["ProjectID"] = dt.Rows[0]["Project_ID"].ToString();
gvProject.SelectedIndex = 0;
}
SetProjectRowSelection();
}
else
{
gvProject.DataSource = dt;
gvProject.DataBind();
ViewState["ProjectID"] = null;
}
UpdProjectGrid.Update();
}
protected void Load_Rank_Menu()
{
if (TreeView1.SelectedNode != null)
{
TreeNode tn = TreeView1.SelectedNode.Parent;
string Project_ID = tn != null ? tn.Value : TreeView1.SelectedNode.Value;
string Module_ID = tn != null ? TreeView1.SelectedNode.Value : null;
DataTable dt = BLL_Infra_ShipSettings.Get_Rank_Menu_Acess(UDFLib.ConvertToInteger(Project_ID), UDFLib.ConvertIntegerToNull(Module_ID)
, UDFLib.ConvertIntegerToNull(DDLVessel.SelectedValue), UDFLib.ConvertToInteger(lstRankList.SelectedValue));
if (dt.Rows.Count > 0)
{
gvMenu.DataSource = dt;
gvMenu.DataBind();
btnSave.Visible = true;
btnResetMenu.Visible = true;
}
else
{
gvMenu.DataSource = dt;
gvMenu.DataBind();
btnSave.Visible = false;
btnResetMenu.Visible = false;
}
}
}
private void BindScreen_By_SrceenID()
{
if (ViewState["ScreenID"] != null)
{
try
{
DataTable dtdetails = new DataTable();
gvDetails.DataSource = null;
gvDetails.DataBind();
dtdetails = BLL_Infra_ShipSettings.Get_Exist_Dtails_ByScreenID(UDFLib.ConvertToInteger(ViewState["ScreenID"]));
if (dtdetails.Rows.Count > 0)
{
gvDetails.DataSource = dtdetails;
gvDetails.DataBind();
}
ucCustomPagerItems.Visible = false;
upDetails.Update();
}
catch (Exception)
{
throw;
}
}
else
{
gvDetails.DataSource = null;
gvDetails.DataBind();
upDetails.Update();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
int iSessionUserID = GetSessionUserID();
if (lstRankList.SelectedValue != "0")
{
foreach (GridViewRow row in gvMenu.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
BLL_Infra_ShipSettings.Ins_Upd_Rank_Menu_Acess(UDFLib.ConvertIntegerToNull(gvMenu.DataKeys[row.RowIndex].Value.ToString())
, Convert.ToInt32(DDLVessel.SelectedValue), Convert.ToInt32(lstRankList.SelectedValue)
, Convert.ToInt32((((Label)row.FindControl("lblScreenID")).Text).ToString())
, (((CheckBox)row.FindControl("chkMenu")).Checked == true) ? 1 : 0
, (((CheckBox)row.FindControl("chkView")).Checked == true) ? 1 : 0
, (((CheckBox)row.FindControl("chkAdd")).Checked == true) ? 1 : 0
, (((CheckBox)row.FindControl("chkEdit")).Checked == true) ? 1 : 0
, (((CheckBox)row.FindControl("chkDelete")).Checked == true) ? 1 : 0
, (((CheckBox)row.FindControl("chkApprove")).Checked == true) ? 1 : 0
, iSessionUserID);
}
}
}
Load_Rank_Menu();
lblMessage.Text = "Access rights has been saved.";
}
catch (Exception ex)
{
}
}
public void BindHelpFileSettings()
{
int rowcount = ucCustomPagerItems.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
DataTable dt = BLL_Infra_ShipSettings.Get_Help_File_Settings_Search(txtfilter.Text != "" ? txtfilter.Text : null
, UDFLib.ConvertIntegerToNull(ddlScreenFilter.SelectedValue), null, sortbycoloumn, sortdirection
, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
if (dt.Rows.Count > 0)
{
gvFileSettings.DataSource = dt;
gvFileSettings.DataBind();
}
else
{
gvFileSettings.DataSource = dt;
gvFileSettings.DataBind();
}
}
protected void btnModuleSave_Click(object sender, EventArgs e)
{
int retval = BLL_Infra_ShipSettings.Ins_Upd_Nav_Modules(UDFLib.ConvertIntegerToNull(ViewState["ModuleID"]), Convert.ToInt32(ViewState["ProjectID"].ToString())
, Convert.ToInt32(ddlModuleScreen.SelectedValue.ToString()), txtModule.Text, txtModuleImagePath.Text, null, Convert.ToInt32(Session["USERID"].ToString()));
BindModules();
UpdModuleGrid.Update();
}
protected void btnProjectSave_Click(object sender, EventArgs e)
{
int retval = BLL_Infra_ShipSettings.Ins_Upd_Project(UDFLib.ConvertIntegerToNull(ViewState["ProjectID"])
, txtProject.Text, Convert.ToInt32(Session["USERID"].ToString()));
BindProjects();
UpdProjectGrid.Update();
}
protected void btnScreenSave_Click(object sender, EventArgs e)
{
int retval = BLL_Infra_ShipSettings.Ins_Upd_Screens(UDFLib.ConvertIntegerToNull(ViewState["ScreenID"])
, Convert.ToInt32(ddlScreenType.SelectedValue), Convert.ToInt32(ViewState["ModuleID"].ToString())
, txtScreen.Text, txtClass.Text, txtAssembly.Text, txtImagePath.Text, Convert.ToInt32(Session["USERID"].ToString()));
BindScreen();
UpdScreenGrid.Update();
}
public void BindModuleScreen()
{
DataTable dt = BLL_Infra_ShipSettings.Get_Module_Screens();
ddlModuleScreen.DataTextField = "Class_Name";
ddlModuleScreen.DataValueField = "Screen_ID";
ddlModuleScreen.DataSource = dt;
ddlModuleScreen.DataBind();
ddlModuleScreen.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
protected void gvDetails_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int Details_ID = UDFLib.ConvertToInteger(gvDetails.DataKeys[e.RowIndex].Values[1].ToString());
ViewState["ScreenID"] = UDFLib.ConvertToInteger(gvDetails.DataKeys[e.RowIndex].Values[0].ToString());
int result = BLL_Infra_ShipSettings.Delete_RANK_SCREEN_Access_Details(Details_ID, UDFLib.ConvertToInteger(Session["UserID"].ToString()));
BindScreen_By_SrceenID();
upDetails.Update();
}
protected void ImgDefaultModule_Click(object sender, CommandEventArgs e)
{
int retval = BLL_Infra_ShipSettings.Default_Nav_Module(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Convert.ToInt32(Session["userid"].ToString())));
BindModules();
ClearModuleFields();
UpdModuleGrid.Update();
UpdModuleEntry.Update();
}
public void BindProjectTemplete()
{
DataTable dt = BLL_Infra_ShipSettings.Get_Project_Templete();
ddlProjectTemplete.DataTextField = "Class_Name";
ddlProjectTemplete.DataValueField = "Screen_ID";
ddlProjectTemplete.DataSource = dt;
ddlProjectTemplete.DataBind();
ddlProjectTemplete.Items.Insert(0, new ListItem("-SELECT-", "0"));
}
protected void ImgScreenDelete_Click(object sender, CommandEventArgs e)
{
int retval = BLL_Infra_ShipSettings.Delete_Screen(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Convert.ToInt32(Session["userid"].ToString())));
BindScreen();
ClearScreenFields();
UpdScreenGrid.Update();
UpdScreenEntry.Update();
}
private void BindEmptyScreen()
{
int rowcount = 0;
DataTable dt = BLL_Infra_ShipSettings.Get_Screen_Search(null, null, null, null, null, null, ref rowcount);
gvScreens.DataSource = dt;
gvScreens.DataBind();
ucCustomPagerItems.Visible = false;
ClearModuleFields();
ClearScreenFields();
}
public void BindScreen()
{
int rowcount = ucCustomPagerItems.isCountRecord;
int?ModuleID = null;
if (ViewState["ModuleID"] != null)
{
ModuleID = UDFLib.ConvertToInteger(ViewState["ModuleID"].ToString());
}
string sortbycoloumn = (ViewState["SCREENSORTBYCOLOUMN"] == null) ? null : (ViewState["SCREENSORTBYCOLOUMN"].ToString());
int? sortdirection = null;
if (ViewState["SCREENSORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SCREENSORTDIRECTION"].ToString());
}
DataTable dt = BLL_Infra_ShipSettings.Get_Screen_Search("", ModuleID, sortbycoloumn, sortdirection, ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
if (dt.Rows.Count > 0)
{
gvScreens.DataSource = dt;
gvScreens.DataBind();
if (ViewState["ScreenID"] == null)
{
ViewState["ScreenID"] = dt.Rows[0]["Screen_ID"].ToString();
gvScreens.SelectedIndex = 0;
BindScreen_By_SrceenID();
}
SetScreenRowSelection();
}
else
{
gvScreens.DataSource = dt;
gvScreens.DataBind();
ViewState["ScreenID"] = null;
BindScreen_By_SrceenID();
}
ucCustomPagerItems.Visible = false;
UpdScreenGrid.Update();
}
protected void BindProjectModuleTree()
{
DataSet ds = BLL_Infra_ShipSettings.Get_Project_Module_Tree(Convert.ToInt32(Session["USERID"].ToString()));
if (ds.Tables.Count > 0)
{
int meni = 0;
int child = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
TreeNode mi = new TreeNode(dr["Name"].ToString().Trim(), dr["Project_ID"].ToString());
TreeView1.Nodes.Add(mi);
DataRow[] drInners = ds.Tables[1].Select("Project_ID ='" + dr["Project_ID"].ToString() + "' ");
if (drInners.Length != 0)
{
foreach (DataRow drInner in drInners)
{
TreeNode miner;
miner = new TreeNode(drInner["Name"].ToString().Trim(), drInner["Module_ID"].ToString());
TreeView1.Nodes[meni].ChildNodes.Add(miner);
///////////////
DataRow[] drInners1 = ds.Tables[2].Select("Module_ID ='" + drInner["Module_ID"].ToString() + "' ");
if (drInners1.Length != 0)
{
foreach (DataRow drInner1 in drInners1)
{
TreeNode miner1;
miner1 = new TreeNode(drInner1["Name"].ToString().Trim(), drInner1["Screen_ID"].ToString());
miner.ChildNodes.Add(miner1);
}
miner.CollapseAll();
}
//////////////////
TreeView1.Nodes[meni].CollapseAll();
child++;
}
}
meni++;
}
}
}
private void BindProjectList(int Project_ID)
{
DataTable dt = BLL_Infra_ShipSettings.Get_Projects(Project_ID);
if (dt.Rows.Count > 0)
{
txtProject.Text = dt.Rows[0]["Project_Name"].ToString();
lblProjectCreatedBy.Text = dt.Rows[0]["CREATEDBY"].ToString();
lblProjectModifiedBy.Text = dt.Rows[0]["MODIFIEDBY"].ToString();
lblProjectDeletedBy.Text = dt.Rows[0]["DELETEDBY"].ToString();
}
UpdProjectEntry.Update();
}
private void BindModuleList(int Module_ID)
{
DataTable dt = BLL_Infra_ShipSettings.Get_Modules(Module_ID);
if (dt.Rows.Count > 0)
{
txtModule.Text = dt.Rows[0]["Module_Name"].ToString();
lblModuleCreatedBy.Text = dt.Rows[0]["CREATEDBY"].ToString();
lblModuleModifiedBy.Text = dt.Rows[0]["MODIFIEDBY"].ToString();
lblModuleDeletedBy.Text = dt.Rows[0]["DELETEDBY"].ToString();
}
UpdModuleEntry.Update();
}
protected void ImgProjectDelete_Click(object sender, CommandEventArgs e)
{
int retval = BLL_Infra_ShipSettings.Delete_Nav_Projects(Convert.ToInt32(e.CommandArgument.ToString()), Convert.ToInt32(Convert.ToInt32(Session["userid"].ToString())));
BindProjects();
BindEmptyModule();
ClearProjectFields();
ClearModuleFields();
UpdProjectGrid.Update();
UpdProjectEntry.Update();
UpdModuleGrid.Update();
UpdModuleEntry.Update();
}
protected void btnCopy_Click(object sender, EventArgs e)
{
if (TreeView1.SelectedNode != null)
{
TreeNode tn = TreeView1.SelectedNode.Parent;
string Project_ID = tn != null ? tn.Value : TreeView1.SelectedNode.Value;
string Module_ID = tn != null ? TreeView1.SelectedNode.Value : null;
BLL_Infra_ShipSettings.Copy_Rank_Menu_Acess(UDFLib.ConvertToInteger(DDLFromVessel.SelectedValue), UDFLib.ConvertToInteger(DDLFromRank.SelectedValue)
, UDFLib.ConvertToInteger(DDLVessel.SelectedValue), UDFLib.ConvertIntegerToNull(lstRankList.SelectedValue), UDFLib.ConvertToInteger(ddlAppendMode.SelectedValue)
, UDFLib.ConvertToInteger(ddlCopyMenu.SelectedValue), UDFLib.ConvertIntegerToNull(Project_ID), UDFLib.ConvertIntegerToNull(Module_ID), UDFLib.ConvertToInteger(Session["USERID"].ToString()));
Load_Rank_Menu();
lblMessage.Text = "Access rights has been copied.";
}
}
private void BindModuleList(int Module_ID)
{
DataTable dt = BLL_Infra_ShipSettings.Get_Nav_Modules(Module_ID);
if (dt.Rows.Count > 0)
{
txtModule.Text = dt.Rows[0]["Name"].ToString();
ddlModuleScreen.SelectedValue = dt.Rows[0]["Screen_ID"].ToString();
txtModuleImagePath.Text = dt.Rows[0]["Image_Path"].ToString();
lblModuleCreatedBy.Text = dt.Rows[0]["CREATEDBY"].ToString();
lblModuleModifiedBy.Text = dt.Rows[0]["MODIFIEDBY"].ToString();
lblModuleDeletedBy.Text = dt.Rows[0]["DELETEDBY"].ToString();
}
UpdModuleEntry.Update();
}
private void BindScreenList(int Screen_ID)
{
DataTable dt = BLL_Infra_ShipSettings.Get_Screens(Screen_ID);
if (dt.Rows.Count > 0)
{
txtScreen.Text = dt.Rows[0]["Screen_Name"].ToString();
txtClass.Text = dt.Rows[0]["Class_Name"].ToString();
txtAssembly.Text = dt.Rows[0]["Assembly_Name"].ToString();
txtImagePath.Text = dt.Rows[0]["Image_Path"].ToString();
ddlScreenType.SelectedValue = dt.Rows[0]["Screen_Type"].ToString();
lblScreenCreatedBy.Text = dt.Rows[0]["CREATEDBY"].ToString();
lblScreenModifiedby.Text = dt.Rows[0]["MODIFIEDBY"].ToString();
lblScreenDeletedby.Text = dt.Rows[0]["DELETEDBY"].ToString();
}
UpdScreenEntry.Update();
}
protected void btnSave_Click(object sender, EventArgs e)
{
foreach (GridViewRow gr in gvAssignScreen.Rows)
{
CheckBox chkAssingScreen = (CheckBox)gr.FindControl("chkAssingScreen");
string lblScreen_ID = ((Label)gr.FindControl("lblScreen_ID")).Text;
string lblNavModule_ID = ((Label)gr.FindControl("lblNavModule_ID")).Text;
if ((chkAssingScreen.Checked == true || lblNavModule_ID != "0") && chkAssingScreen.Enabled == true)
{
int retval = BLL_Infra_ShipSettings.Ins_Upd_Assign_Child_Screen(Convert.ToInt32(Request.QueryString["Nav_Module_ID"].ToString()), chkAssingScreen.Checked == true ? 1:0
, Convert.ToInt32(lblScreen_ID), Convert.ToInt32(Session["userid"].ToString()));
}
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
if (HiddenFlag.Value == "Add")
{
int retval = BLL_Infra_ShipSettings.INS_Help_File_Settings(UDFLib.ConvertToInteger(ddlScreen.SelectedValue), txtTopicID.Text, txtTopicDesc.Text
, txtHelpFileName.Text, UDFLib.ConvertToInteger(Session["USERID"]));
}
else
{
int retval = BLL_Infra_ShipSettings.UPD_Help_File_Settings(Convert.ToInt32(txtID.Text.Trim()), UDFLib.ConvertToInteger(ddlScreen.SelectedValue), txtTopicID.Text, txtTopicDesc.Text
, txtHelpFileName.Text, UDFLib.ConvertToInteger(Session["USERID"]));
}
BindHelpFileSettings();
string hidemodal = String.Format("hideModal('divadd')");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "hidemodal", hidemodal, true);
}
private void BindProjectList(int Project_ID)
{
DataTable dt = BLL_Infra_ShipSettings.Get_Nav_Projects(Project_ID);
if (dt.Rows.Count > 0)
{
txtProject.Text = dt.Rows[0]["Name"].ToString();
ddlProjectTemplete.SelectedValue = dt.Rows[0]["Screen_ID"].ToString();
txtProjImagePath.Text = dt.Rows[0]["Image_Path"].ToString();
lblProjectCreatedBy.Text = dt.Rows[0]["CREATEDBY"].ToString();
lblProjectModifiedBy.Text = dt.Rows[0]["MODIFIEDBY"].ToString();
lblProjectDeletedBy.Text = dt.Rows[0]["DELETEDBY"].ToString();
}
UpdProjectEntry.Update();
}
public void BindModules()
{
int?Project_ID = null;
if (ViewState["ProjectID"] != null)
{
Project_ID = Convert.ToInt32(ViewState["ProjectID"].ToString());
}
string sortbycoloumn = (ViewState["MODULESORTBYCOLOUMN"] == null) ? null : (ViewState["MODULESORTBYCOLOUMN"].ToString());
int? sortdirection = null;
if (ViewState["MODULESORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["MODULESORTDIRECTION"].ToString());
}
DataTable dt = BLL_Infra_ShipSettings.Get_Nav_Module_Search(txtSearchModule.Text, Project_ID, sortbycoloumn, sortdirection);
if (dt.Rows.Count > 0)
{
gvModule.DataSource = dt;
gvModule.DataBind();
if (ViewState["ModuleID"] == null)
{
ViewState["ModuleID"] = dt.Rows[0]["Module_ID"].ToString();
BindModuleList(Convert.ToInt32(ViewState["ModuleID"].ToString()));
gvModule.SelectedIndex = 0;
}
SetModuleRowSelection();
}
else
{
gvModule.DataSource = dt;
gvModule.DataBind();
ViewState["ModuleID"] = null;
}
UpdModuleGrid.Update();
}
protected void onUpdate(object source, CommandEventArgs e)
{
HiddenFlag.Value = "Edit";
OperationMode = "Edit File settings";
DataTable dt = new DataTable();
dt = BLL_Infra_ShipSettings.Get_Help_File_Settings_List(Convert.ToInt32(e.CommandArgument.ToString()));
txtID.Text = dt.Rows[0]["ID"].ToString();
ddlScreen.SelectedValue = dt.Rows[0]["Screen_ID"].ToString();
txtHelpFileName.Text = dt.Rows[0]["Help_File_Name"].ToString();
txtTopicID.Text = dt.Rows[0]["Topic_ID"].ToString();
txtTopicDesc.Text = dt.Rows[0]["Topic_Description"].ToString();
string AddUserTypemodal = String.Format("showModal('divadd',false);");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "AddUserTypemodal", AddUserTypemodal, true);
}
protected void ImgExpExcel_Click(object sender, EventArgs e)
{
int rowcount = ucCustomPagerItems.isCountRecord;
string sortbycoloumn = (ViewState["SORTBYCOLOUMN"] == null) ? null : (ViewState["SORTBYCOLOUMN"].ToString());
int? sortdirection = null; if (ViewState["SORTDIRECTION"] != null)
{
sortdirection = Int32.Parse(ViewState["SORTDIRECTION"].ToString());
}
DataTable dt = BLL_Infra_ShipSettings.Get_Help_File_Settings_Search(txtfilter.Text != "" ? txtfilter.Text : null
, UDFLib.ConvertIntegerToNull(ddlScreenFilter.SelectedValue), null, sortbycoloumn, sortdirection
, null, null, ref rowcount);
string[] HeaderCaptions = { "Screen", "Class", "Topic", "Topic Description", "Help File Name" };
string[] DataColumnsName = { "Screen_Name", "Class_Name", "Topic_ID", "Topic_Description", "Help_File_Name" };
GridViewExportUtil.ShowExcel(dt, HeaderCaptions, DataColumnsName, "Help_File_Settings", "Help File Settings", "");
}
