public void BindFolder()
{
try
{
DataTable dtFolders = BLL_QMSDB_Folders.QMSDBFoldes_List(null, null, null, null, UDFLib.ConvertIntegerToNull(Request.QueryString["DocID"].ToString()));
ddlFolderList.DataSource = dtFolders;
ddlFolderList.DataTextField = "FOLDER_NAME";
ddlFolderList.DataValueField = "FOLDER_ID";
ddlFolderList.DataBind();
ddlFolderName.DataSource = dtFolders;
ddlFolderName.DataTextField = "FOLDER_NAME";
ddlFolderName.DataValueField = "FOLDER_ID";
ddlFolderName.DataBind();
ddlFolderName.SelectedValue = Request.QueryString["DocID"].ToString();
if (dtFolders.Rows.Count > 0)
{
BindTrvFolder(dtFolders);
GenerateUL(dtFolders);
}
}
catch (Exception ex)
{
}
}
protected void btnAccessSave_Click(object sender, EventArgs e)
{
try
{
foreach (GridViewRow gvr in dvFolderUserAccess.Rows)
{
if ((gvr.FindControl("chkAll") as CheckBox).Checked == true || (gvr.FindControl("chkView") as CheckBox).Checked == true || (gvr.FindControl("chkAdd") as CheckBox).Checked == true || (gvr.FindControl("chkEdit") as CheckBox).Checked == true || (gvr.FindControl("chkDelete") as CheckBox).Checked == true)
{
string lblDepartment = ((Label)gvr.FindControl("lblDeptId")).Text;
string lblUserId = ((Label)gvr.FindControl("lblUerId")).Text;;
string fldFloderId = ((Label)gvr.FindControl("lblFolderId")).Text;
if ((gvr.FindControl("chkAll") as CheckBox).Checked == true)
{
int i = BLL_QMSDB_Folders.QMSDBFoldes_Insert_UserAccess(UDFLib.ConvertIntegerToNull(lblDepartment), UDFLib.ConvertIntegerToNull(lblUserId), UDFLib.ConvertIntegerToNull(fldFloderId), 1, 1, 1, 1, UDFLib.ConvertIntegerToNull(Session["USERID"].ToString()));
}
else
{
int chkView = (gvr.FindControl("chkView") as CheckBox).Checked == true ? 1 : 0;
int chkAdd = (gvr.FindControl("chkAdd") as CheckBox).Checked == true ? 1 : 0;
int chkEdit = (gvr.FindControl("chkEdit") as CheckBox).Checked == true ? 1 : 0;
int chkDelete = (gvr.FindControl("chkDelete") as CheckBox).Checked == true ? 1 : 0;
int i = BLL_QMSDB_Folders.QMSDBFoldes_Insert_UserAccess(UDFLib.ConvertIntegerToNull(lblDepartment), UDFLib.ConvertIntegerToNull(lblUserId), UDFLib.ConvertIntegerToNull(fldFloderId), chkView, chkAdd, chkEdit, chkDelete, UDFLib.ConvertIntegerToNull(Session["USERID"].ToString()));
}
}
}
BindFolderToUserAccess();
}
catch (Exception ex)
{
}
}
public void BindHeader()
{
try
{
DataTable FleetDT = BLL_QMSDB_Folders.QMSDBHeaderList();
ddlHeaderTemplate.DataSource = FleetDT;
ddlHeaderTemplate.DataTextField = "HEADERNAME";
ddlHeaderTemplate.DataValueField = "HEADERID";
ddlHeaderTemplate.DataBind();
ddlHeaderTemplate.Items.Insert(0, new ListItem("- Select -", "0"));
}
catch (Exception ex)
{
}
}
protected void BindFolderToUserAccess()
{
if (TreeView1.SelectedNode != null)
{
int rowcount = ucCustomPagerItems.isCountRecord;
string NodeValue = TreeView1.SelectedNode.Value;
DataTable dt = BLL_QMSDB_Folders.QMSDBFoldes_UserAccess(UDFLib.ConvertIntegerToNull(lstDept.SelectedValue), UDFLib.ConvertIntegerToNull(lstUser.SelectedValue), UDFLib.ConvertIntegerToNull(NodeValue), ucCustomPagerItems.CurrentPageIndex, ucCustomPagerItems.PageSize, ref rowcount);
dvFolderUserAccess.DataSource = dt;
dvFolderUserAccess.DataBind();
if (ucCustomPagerItems.isCountRecord == 1)
{
ucCustomPagerItems.CountTotalRec = rowcount.ToString();
ucCustomPagerItems.BuildPager();
}
}
}
protected void BindFolderToVEsssel()
{
if (trvFolder.SelectedNode != null)
{
int rowcount = ucCustomPager1.isCountRecord;
string NodeValue = trvFolder.SelectedNode.Value;
DataTable dt = BLL_QMSDB_Folders.QMSDBFoldes_VesselAccess((DataTable)Session["sFleet"], (DataTable)Session["sVesselCode"], UDFLib.ConvertIntegerToNull(NodeValue), ucCustomPager1.CurrentPageIndex, ucCustomPager1.PageSize, ref rowcount);
gvFolderAccessVessel.DataSource = dt;
gvFolderAccessVessel.DataBind();
if (ucCustomPager1.isCountRecord == 1)
{
ucCustomPager1.CountTotalRec = rowcount.ToString();
ucCustomPager1.BuildPager();
}
}
}
protected void btnRenameFolder_Click(object sender, EventArgs e)
{
try
{
if (txtFolderName.Text.Trim() == "")
{
lblMessage.Text = "Please enter folder name.";
return;
}
int i = BLL_QMSDB_Folders.Upd_QMSDBFoldes_Rename(int.Parse(ddlFolderList.SelectedValue), txtFolderName.Text, 1, UDFLib.ConvertIntegerToNull(Session["USERID"].ToString()));
String msg = String.Format("alert('Folder name has changed');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true);
ScriptManager.RegisterStartupScript(this, this.GetType(), "reloadparent", "parent.RealoadParent();", true);
}
catch (Exception ex)
{
}
}
protected void btnVesselSave_Click(object sender, EventArgs e)
{
try
{
foreach (GridViewRow gvr in gvFolderAccessVessel.Rows)
{
if ((gvr.FindControl("chkVessel") as CheckBox).Checked == true)
{
string lblFleet = ((Label)gvr.FindControl("lblFleet")).Text;
string VesselId = ((Label)gvr.FindControl("lblVesselId")).Text;;
string fldFloderId = ((Label)gvr.FindControl("lblFolderId")).Text;
int i = BLL_QMSDB_Folders.QMSDBFoldes_Insert_Vessel(UDFLib.ConvertIntegerToNull(lblFleet), UDFLib.ConvertIntegerToNull(VesselId), UDFLib.ConvertIntegerToNull(fldFloderId), UDFLib.ConvertIntegerToNull(Session["USERID"].ToString()), 1);
}
}
BindFolderToVEsssel();
}
catch (Exception ex)
{
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtFolderName.Text.Trim() == "")
{
lblMessage.Text = "Please enter folder name.";
return;
}
int i = BLL_QMSDB_Folders.QMSDBFoldes_Insert(UDFLib.ConvertIntegerToNull(ddlFolderList.SelectedValue), txtFolderName.Text, 1, UDFLib.ConvertIntegerToNull(Session["USERID"].ToString()));
String msg = String.Format("alert('Folder has created');");
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "msg", msg, true);
ScriptManager.RegisterStartupScript(this, this.GetType(), "reloadparent", "parent.RealoadParent();", true);
}
catch (Exception ex)
{
string js = "alert('" + ex.Message.Replace("'", "") + "');";
Page.ClientScript.RegisterStartupScript(GetType(), "script", js, true);
}
}
/// <summary>
/// this is method uses for the load & bind the treeview control from database.
/// </summary>
public void LoadtreeView()
{
//DataTable dtFolders = objQMS.getFolderList(87);
//DataTable dtFiles = objQMS.getFileList(87);
DataTable dtFolders = BLL_QMSDB_Folders.QMSDBFoldes_List(null, null, null, Convert.ToInt32(Session["USERID"]), null);
DataTable dtFiles = BLL_QMSDB_Folders.QMSDBFoldes_ProcedureList(null, null, null, Convert.ToInt32(Session["USERID"]), null);
//this is for the root node
if (dtFolders.Rows.Count == 0)
{
TreeNode parentNode = new TreeNode("DOCUMENTS", "DOCUMENTS", getNodeImageURL("Parent.FDC"));
parentNode.NavigateUrl = "AddNewFile.aspx?Path=DOCUMENTS&DocID=1";
parentNode.Target = "docPreview";
parentNode.SelectAction = TreeNodeSelectAction.Select;
parentNode.Expand();
BrowseTreeView.Nodes.Add(parentNode);
}
else
{
TreeNode parentNode = new TreeNode(dtFolders.Rows[0]["FOLDER_NAME"].ToString(), dtFolders.Rows[0]["FOLDER_NAME"].ToString(), getNodeImageURL("Parent.FDC"));
parentNode.NavigateUrl = "AddNewFile.aspx?Path=DOCUMENTS&DocID=1";
parentNode.Target = "docPreview";
parentNode.SelectAction = TreeNodeSelectAction.Select;
parentNode.Expand();
BrowseTreeView.Nodes.Add(parentNode);
}
if (dtFolders.Rows.Count > 0)
{
foreach (DataRow dr in dtFolders.Rows)
{
CreateChildNode(dr["XNPATH"].ToString(), dr["FOLDER_NAME"].ToString(), 1, Convert.ToInt32(dr["FOLDER_ID"].ToString()));
}
}
if (dtFiles.Rows.Count > 0)
{
foreach (DataRow dr in dtFiles.Rows)
{
CreateChildNode(dr["XNPATH"].ToString(), dr["FOLDER_NAME"].ToString(), 0, Convert.ToInt32(dr["FOLDER_ID"].ToString()));
}
}
}
public void BindFolder()
{
try
{
DataTable dtFolders = BLL_QMSDB_Folders.QMSDBFoldes_List(null, null, null, null, 1);
//ddlFolderName.DataSource = dtFolders;
//ddlFolderName.DataTextField = "XNPATH";
//ddlFolderName.DataValueField = "FOLDER_ID";
//ddlFolderName.DataBind();
if (dtFolders.Rows.Count > 0)
{
//ddlFolderName.SelectedValue = "1";
BindTrvFolder(dtFolders);
//GenerateUL(dtFolders);
}
}
catch (Exception ex)
{
}
}