public string getPageTitle(string PgName)
{
PageConn pagecon = new PageConn();
con = pagecon.dynconn;
string str = "Select PageTitle from PageMaster where PageName='" + ClsEncDesc.EncDyn(PgName) + "'";
SqlCommand cmd = new SqlCommand(str, PageConn.busclient());
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
string pgTitle;
if (dt.Rows.Count > 0)
{
pgTitle = ClsEncDesc.DecDyn(dt.Rows[0]["PageTitle"].ToString());
}
else
{
pgTitle = "Iwebshop Version1.1";
}
return(pgTitle);
}
protected void Timekeepingfillpageaccesscheck()
{
try
{
DataTable drt = selectbusdy("SELECT distinct " + PageConn.busdatabase + ".dbo.RoleMenuAccessRightTbl.MenuId,PageMaster.PageName FROM MainMenuMaster inner join " + PageConn.busdatabase + ".dbo.RoleMenuAccessRightTbl on " + PageConn.busdatabase + ".dbo.RoleMenuAccessRightTbl.MenuId=MainMenuMaster.MainMenuId inner join PageMaster on PageMaster.MainMenuId=" + PageConn.busdatabase + ".dbo.RoleMenuAccessRightTbl.MenuId inner join pageplaneaccesstbl on pageplaneaccesstbl.Pageid=PageMaster.PageId INNER JOIN " + PageConn.busdatabase + ".dbo.User_Role ON " + PageConn.busdatabase + ".dbo.RoleMenuAccessRightTbl.RoleId = " + PageConn.busdatabase + ".dbo.User_Role.Role_id INNER JOIN " + PageConn.busdatabase + ".dbo.User_master ON " + PageConn.busdatabase + ".dbo.User_Role.User_id = " + PageConn.busdatabase + ".dbo.User_master.UserID where pageplaneaccesstbl.Priceplanid='" + ClsEncDesc.EncDyn(Session["PriceId"].ToString()) + "' and PageMaster.PageName='timekeepingafterlogin.aspx' and PageMaster.VersionInfoMasterId='" + ClsEncDesc.EncDyn(Session["verId"].ToString()) + "' and " + PageConn.busdatabase + ".dbo.User_master.UserID ='" + Session["userid"] + "'");
if (drt.Rows.Count <= 0)
{
drt = selectbusdy("SELECT PageMaster.PageName FROM PageMaster inner join " + PageConn.busdatabase + ".dbo.RolePageAccessRightTbl on " + PageConn.busdatabase + ".dbo.RolePageAccessRightTbl.PageId=PageMaster.PageId inner join pageplaneaccesstbl on pageplaneaccesstbl.Pageid=PageMaster.PageId INNER JOIN " + PageConn.busdatabase + ".dbo.User_Role ON " + PageConn.busdatabase + ".dbo.RolePageAccessRightTbl.RoleId = " + PageConn.busdatabase + ".dbo.User_Role.Role_id INNER JOIN " + PageConn.busdatabase + ".dbo.User_master ON " + PageConn.busdatabase + ".dbo.User_Role.User_id = " + PageConn.busdatabase + ".dbo.User_master.UserID where pageplaneaccesstbl.Priceplanid='" + Session["PriceId"] + "' and PageMaster.PageName='timekeepingafterlogin.aspx' and PageMaster.VersionInfoMasterId='" + ClsEncDesc.EncDyn(Session["verId"].ToString()) + "' and " + PageConn.busdatabase + ".dbo.User_master.UserID ='" + Session["userid"] + "'");
if (drt.Rows.Count <= 0)
{
drt = selectbusdy("SELECT distinct PageMaster.PageName FROM MainMenuMaster inner join SubMenuMaster on SubMenuMaster.MainMenuId=MainMenuMaster.MainMenuId inner join " + PageConn.busdatabase + ".dbo.RoleSubMenuAccessRightTbl on " + PageConn.busdatabase + ".dbo.RoleSubMenuAccessRightTbl.SubMenuId=SubMenuMaster.SubMenuId inner join PageMaster on PageMaster.SubMenuId=" + PageConn.busdatabase + ".dbo.RoleSubMenuAccessRightTbl.SubMenuId inner join pageplaneaccesstbl on pageplaneaccesstbl.Pageid=PageMaster.PageId INNER JOIN " + PageConn.busdatabase + ".dbo.User_Role ON " + PageConn.busdatabase + ".dbo.RoleSubMenuAccessRightTbl.RoleId = " + PageConn.busdatabase + ".dbo.User_Role.Role_id INNER JOIN " + PageConn.busdatabase + ".dbo.User_master ON " + PageConn.busdatabase + ".dbo.User_Role.User_id = " + PageConn.busdatabase + ".dbo.User_master.UserID where pageplaneaccesstbl.Priceplanid='" + ClsEncDesc.EncDyn(Session["PriceId"].ToString()) + "' and PageMaster.PageName='timekeepingafterlogin.aspx' and PageMaster.VersionInfoMasterId='" + ClsEncDesc.EncDyn(Session["verId"].ToString()) + "' and " + PageConn.busdatabase + ".dbo.User_master.UserID ='" + Session["userid"] + "'");
if (drt.Rows.Count <= 0)
{
Button6.Visible = false;
}
else
{
Button6.Visible = true;
}
}
else
{
Button6.Visible = true;
}
}
else
{
Button6.Visible = true;
}
}
catch (Exception ex)
{
}
}
protected void LoadPdf(int Docid)
{
DataTable dt = new DataTable();
dt = clsDocument.SelectDoucmentMasterByID(Docid);
if (dt.Rows.Count > 0)
{
string docname = dt.Rows[0]["DocumentName"].ToString();
ViewState["decname"] = docname.ToString();
string filepath = Server.MapPath("~//Account//" + Session["comid"] + "//UploadedDocuments//" + docname);
string strft = "Select FileStorage.* from FileStorage Where B='" + ClsEncDesc.EncDyn(Session["comid"].ToString()) + "' and H='" + ClsEncDesc.EncDyn("True") + "'";
SqlCommand cmdft = new SqlCommand(strft, con);
SqlDataAdapter adpft = new SqlDataAdapter(cmdft);
DataTable dtft = new DataTable();
adpft.Fill(dtft);
if (dtft.Rows.Count > 0)
{
FileInfo filec = new FileInfo(filepath);
if (!filec.Exists)
{
datatransftp(docname, filepath);
System.Threading.Thread.Sleep(1000);
FileInfo filecup = new FileInfo(filepath);
if (filecup.Exists)
{
string filepathu = Server.MapPath("~//Account//pdftoimage.exe");
System.Diagnostics.ProcessStartInfo pti = new System.Diagnostics.ProcessStartInfo(filepathu);
pti.UseShellExecute = false;
pti.Arguments = filepathu + " -i UploadedDocuments//" + docname + " " + "-o" + " " + "DocumentImage//";//+ " " + "-r" + "VNKSURDLWQOVHPGH";
pti.RedirectStandardOutput = true;
pti.RedirectStandardInput = true;
pti.RedirectStandardError = true;
pti.WorkingDirectory = Server.MapPath("~//Account//" + Session["comid"] + "//");
System.Diagnostics.Process ps = Process.Start(pti);
System.Threading.Thread.Sleep(1000);
}
}
}
int length = docname.Length;
string docnameIn = docname.Substring(0, length - 4);
ViewState["path"] = filepath.ToString();
DataTable dt1 = new DataTable();
DataColumn dcom = new DataColumn();
dcom.ColumnName = "image";
dcom.DataType = System.Type.GetType("System.String");
dt1.Columns.Add(dcom);
string Location = Server.MapPath("~//Account//" + Session["comid"] + "//DocumentImage//");
System.IO.DirectoryInfo dir = new System.IO.DirectoryInfo(Location);
foreach (System.IO.FileInfo f in dir.GetFiles(docnameIn.ToString() + "*.*"))
{
DataRow drow = dt1.NewRow();
drow["image"] = "~/Account/" + Session["comid"] + "/DocumentImage/" + f.Name.ToString();
dt1.Rows.Add(drow);
}
DataList1.DataSource = dt1;
DataList1.DataBind();
DataTable dtfill = (DataTable)Session["grdcopy"];
GridView2.DataSource = dtfill;
GridView2.DataBind();
}
}
