private void GetMenuData() { SqlConnection conMyConnection = new SqlConnection(); //new SqlConnection(ConfigurationManager.AppSettings.Get("ConnectionString")); conMyConnection.ConnectionString = objCCWeb.ReturnConnectionString(); conMyConnection.Open(); DataTable table = new DataTable(); string sql = "Select RollNumber menu_id,MenuCaption1 menu_name,menu_Parent_Id,MenuLinkPage menu_url from MTUserMenuMaster where ModuleID <11 and moduleid not in(4,7,8) "; //"select menu_id, menu_name, menu_parent_id, menu_url from menuMaster"; SqlCommand cmd = new SqlCommand(sql, conMyConnection); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(table); DataView view = new DataView(table); view.RowFilter = "menu_parent_id is NULL"; foreach (DataRowView row in view) { MenuItem menuItem = new MenuItem(row["menu_name"].ToString(), row["menu_id"].ToString()); menuItem.NavigateUrl = row["menu_url"].ToString(); NavigationMenu.Items.Add(menuItem); AddChildItems(table, menuItem); } }
protected void btnSave_Click(object sender, EventArgs e) { string strResult = ""; int intSchoolID = 0; string[] strArray = this.hidFlag.Value.Split('^'); try { List <string> lstArray = new List <string>(); byte[] fileData = null; byte[] imageData = null; long lnLength = 0; fUploadEmblem.Attributes["filename"] = hdnSImagePath.Value; if (fUploadEmblem.PostedFile.FileName != "") { if (fUploadEmblem.HasFile) { try { Stream myStream = fUploadEmblem.PostedFile.InputStream; lnLength = myStream.Length; fileData = new byte[(int)myStream.Length]; myStream.Read(fileData, 0, (int)lnLength); myStream.Close(); } catch (Exception ex) { } } } string strEmblemStatus; if (rbtnYes.Checked == true) { strEmblemStatus = "Y"; } else { strEmblemStatus = "N"; } //if (strArray[0] == "N" || strArray[0]=="E" && strArray[3].Trim().ToUpper() != txtAddress.Text.Trim().ToUpper()) //{ // if (objCCWeb.ReturnNumericValue("SELECT COUNT(SchoolID) FROM MTClientCompany WHERE Address='" + txtAddress.Text.Trim().Replace("'", "''") + "'") > 0) // { // strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "5", lblAddress.Text); // ClientScript.RegisterStartupScript(this.GetType(), "", "<script>" + strHideID + "alert('" + strResult + "')</script>"); // //ClientScript.RegisterStartupScript(this.GetType(), "", "<script>" + strHideID + "alert('Address Already Exist')</script>"); // hidFlag.Value = "S"; // return; // } //} if (strArray[0] == "E") { lstArray.Add("UPDATE MTClientCompany SET SchoolName1=" + objCCWeb.fReplaceChar(txtInstitution1) + ",SchoolName2='" + txtInstitution2.Text.Trim().Replace("'", "''") + "',Address=" + objCCWeb.fReplaceChar(txtAddress) + ",ReportHeader=" + objCCWeb.fReplaceChar(txtReportHeader) + ",City=" + objCCWeb.fReplaceChar(txtCity) + ",State=" + objCCWeb.fReplaceChar(txtState) + ",Pincode=" + objCCWeb.fReplaceChar(txtPincode) + ",Telephone=" + objCCWeb.fReplaceChar(txtTelephone) + "," + "Fax=" + objCCWeb.fReplaceChar(txtFax) + ",Email=" + objCCWeb.fReplaceChar(txtEmail) + ",DirectorName=" + objCCWeb.fReplaceChar(txtDirector) + ",DirectorTelephone=" + objCCWeb.fReplaceChar(txtDirPhone) + ",PrincipalName=" + objCCWeb.fReplaceChar(txtPrincipal) + ",PrincipalPhone=" + objCCWeb.fReplaceChar(txtPriPhone) + ",VicePrincipalName=" + objCCWeb.fReplaceChar(txtVicePrincipal) + "," + "VicePrincipalPhone=" + objCCWeb.fReplaceChar(txtVicePriPhone) + ",AdministratorName=" + objCCWeb.fReplaceChar(txtAdministrator) + ",AdministratorPhone=" + objCCWeb.fReplaceChar(txtAdmPhone) + ",Affiliation=" + objCCWeb.fReplaceChar(txtAffiliation) + ",Medium=" + objCCWeb.fReplaceChar(txtMedium) + ",Motto=" + objCCWeb.fReplaceChar(txtMotto) + ",EstablishedOn=" + objCCWeb.fReplaceChar(txtEstablishedOn) + ",EstablishmentCode=" + objCCWeb.fReplaceChar(txtEstablishmentCode) + "," + "BankAccountNo=" + objCCWeb.fReplaceChar(txtBankACNo) + ",EmblemStatus='" + strEmblemStatus + "',UpdateUserID=" + Session["UID"].ToString() + ",UpdateDate=GETDATE(),PLPackDate=" + objCCWeb.ReturnDateorNull(txtPLPackDate.Text.Trim()) + ",PLPackdateStaff=" + objCCWeb.ReturnDateorNull(txtPLPackDateStaff.Text.Trim()) + " WHERE SchoolID=" + strArray[1] + ""); lstArray.Add("INSERT INTO UserUpdateDetails(UID,SessionID,UpdateDate,FormName,Details) VALUES(" + Session["UID"] + ",'" + Session.SessionID + "',GETDATE(),'mnuInstitutionMaster','School " + (txtInstitution1.Text.Trim().Replace("'", "''") != "" ? txtInstitution1.Text.Trim().Replace("'", "''") : txtInstitution2.Text.Trim().Replace("'", "''")) + " Information ,Is Modified')"); } else { intSchoolID = objCCWeb.ReturnNumericValue("SELECT ISNULL(MAX(SchoolID),0)+1 FROM MTClientCompany"); lstArray.Add("INSERT INTO MTClientCompany(SchoolID,SchoolName1,SchoolName2,Address,ReportHeader,City,State,Pincode,Telephone,Fax,Email,DirectorName,DirectorTelephone,PrincipalName,PrincipalPhone,VicePrincipalName,VicePrincipalPhone,AdministratorName,AdministratorPhone," + "Affiliation,Medium,Motto,EstablishedOn,EstablishmentCode,BankAccountNo,EmblemStatus,EntryUserID,EntryDate) SELECT ISNULL(MAX(SchoolID),0)+1, '" + txtInstitution1.Text.Trim().Replace("'", "''") + "','" + txtInstitution2.Text.Trim().Replace("'", "''") + "','" + txtAddress.Text.Trim().Replace("'", "''") + "','" + txtReportHeader.Text.Trim().Replace("'", "''") + "','" + txtCity.Text.Trim().Replace("'", "''") + "','" + txtState.Text.Trim().Replace("'", "''") + "','" + txtPincode.Text.Trim().Replace("'", "''") + "','" + txtTelephone.Text.Trim().Replace("'", "''") + "'," + "'" + txtFax.Text.Trim().Replace("'", "''") + "','" + txtEmail.Text.Trim().Replace("'", "''") + "','" + txtDirector.Text.Trim().Replace("'", "''") + "','" + txtDirPhone.Text.Trim().Replace("'", "''") + "','" + txtPrincipal.Text.Trim().Replace("'", "''") + "','" + txtPriPhone.Text.Trim().Replace("'", "''") + "','" + txtVicePrincipal.Text.Trim().Replace("'", "''") + "'," + "'" + txtVicePriPhone.Text.Trim().Replace("'", "''") + "','" + txtAdministrator.Text.Trim().Replace("'", "''") + "','" + txtAdmPhone.Text.Trim().Replace("'", "''") + "','" + txtAffiliation.Text.Trim().Replace("'", "''") + "','" + txtMedium.Text.Trim().Replace("'", "''") + "','" + txtMotto.Text.Trim().Replace("'", "''") + "','" + txtEstablishedOn.Text.Trim().Replace("'", "''") + "','" + txtEstablishmentCode.Text.Trim().Replace("'", "''") + "'," + "'" + txtBankACNo.Text.Trim().Replace("'", "''") + "','" + strEmblemStatus + "'," + Session["UID"].ToString() + ",GETDATE() FROM MTClientCompany"); } strResult = objCCWeb.ExecuteQueryList(lstArray); if (strArray[0] == "E") { intSchoolID = Convert.ToInt32(strArray[1]); } if (hidFlag.Value == "N^") { hidFlag.Value = "N^"; } else { hidFlag.Value = "E^"; } if (strResult == "") { if (lnLength > 0) { //SqlConnection conSImage = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings.Get("ConnectionString")); SqlConnection conSImage = new SqlConnection(objCCWeb.ReturnConnectionString()); conSImage.Open(); SqlCommand cmdSImage = new SqlCommand("UPDATE MTClientCompany SET Emblem=@img,EmblemLength=" + lnLength.ToString() + " where SchoolID=" + intSchoolID + "", conSImage); cmdSImage.CommandType = CommandType.Text; cmdSImage.Parameters.Add(new SqlParameter("@img", SqlDbType.Image)); cmdSImage.Parameters["@img"].Value = fileData; cmdSImage.ExecuteNonQuery(); conSImage.Close(); conSImage.Dispose(); } if (lnLength == 0) { if (strArray[0] == "E") { SqlDataReader rdrImage = objCCWeb.BindReader("SELECT ISNULL(Emblem,'') AS Emblem,CAST(ISNULL(EmblemLength,0) AS INT) AS EmblemLength FROM MTClientCompany WHERE SchoolID=" + intSchoolID + ""); if (rdrImage.Read()) { int intLength = (int)rdrImage["EmblemLength"]; imageData = new byte[intLength]; imageData = (byte[])rdrImage["Emblem"]; if (intLength != 0) { lnLength = intLength; } } rdrImage.Close(); rdrImage.Dispose(); } } if (strArray[0] == "N") { strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "1", ""); } else { strResult = objCCWeb.pDisplayMessage("" + Session["Type"].ToString() + "", "2", ""); } ClientScript.RegisterStartupScript(this.GetType(), "displayScriptMsg", "<script>" + strHideID + "alert('" + strResult + "')</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "displayE", "<script language=javascript>" + strHideID + "alert('" + strResult + "')</script>"); } if (fUploadEmblem.PostedFile.FileName == "") { fileData = imageData; } btnCancel_Click(sender, e); } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script language=javascript>" + strHideID + "alert('" + ex.Message + "')</script>"); } BindDDL(); btnCancel_Click(sender, e); }
protected void Authenticate(AuthenticateEventArgs e) { SqlConnection conExecute = new SqlConnection(objCCWeb.ReturnConnectionString().ToString()); try { string strUserName, strPwd; strUserName = Login1.UserName; strPwd = ((TextBox)Login1.FindControl("Password")).Text; /* Authenticating the User Through Procedure */ SqlCommand cmdExecute = new SqlCommand("sp_AuthenticateUser", conExecute); cmdExecute.CommandType = CommandType.StoredProcedure; SqlParameter param1 = new SqlParameter(); param1.ParameterName = "@varUserID"; param1.SqlDbType = SqlDbType.VarChar; param1.Size = 30; param1.Direction = ParameterDirection.Input; param1.Value = Login1.UserName.Replace("'", "''"); cmdExecute.Parameters.Add(param1); SqlParameter param2 = new SqlParameter(); param2.ParameterName = "@varUserPwd"; param2.SqlDbType = SqlDbType.VarChar; param2.Size = 60; param2.Direction = ParameterDirection.Input; param2.Value = strPwd; cmdExecute.Parameters.Add(param2); SqlParameter param3 = new SqlParameter(); param3.ParameterName = "@varUserSalt"; param3.SqlDbType = SqlDbType.VarChar; param3.Size = 10; param3.Direction = ParameterDirection.Input; param3.Value = hid.Value; cmdExecute.Parameters.Add(param3); conExecute.Open(); SqlDataReader sdrLogin = cmdExecute.ExecuteReader(); /* THIS READERS RETURNS THESE VALUES * ValidUser, * UID, * UserID, * UserName, * UserTypeID, * EmployeeIDStudentID */ //((MSCaptcha.CaptchaControl)Login1.FindControl("ccJoin")).ValidateCaptcha(((TextBox)Login1.FindControl("txtCapText")).Text); //Login1.FailureText = "Incorrect Code"; // if (!((MSCaptcha.CaptchaControl)Login1.FindControl("ccJoin")).UserValidated) // { Login1.FailureText = "Invalid User Name or Password"; if (sdrLogin.HasRows) { sdrLogin.Read(); if (sdrLogin.GetValue(sdrLogin.GetOrdinal("ValidUser")).ToString() == "1") { Session["UserID"] = sdrLogin.GetValue(sdrLogin.GetOrdinal("UserID")); Session["UID"] = sdrLogin.GetValue(sdrLogin.GetOrdinal("UID")); Session["UserName"] = sdrLogin.GetValue(sdrLogin.GetOrdinal("UserName")); Session["AcaStart"] = ((DropDownList)Login1.FindControl("ddlAcademicYear")).SelectedValue; Session["AcademicSession"] = ((DropDownList)Login1.FindControl("ddlAcademicYear")).SelectedValue + "-" + Convert.ToInt32(Convert.ToInt32(((DropDownList)Login1.FindControl("ddlAcademicYear")).SelectedValue) + 1); Session["Type"] = "1"; if (Session["SchoolID"] == null) { //if (objCCWeb.ReturnNumericValue("SELECT Count(SchoolID) FROM MTUserInstitutionMaster WHERE UID=" + Session["UID"] + "") > 1) //{ // Login1.DestinationPageUrl = "~/MTChangeSchool.aspx"; //} //else //{ if (sdrLogin.GetValue(sdrLogin.GetOrdinal("UserTypeID")).ToString() == "3" && hdnFlag.Value == "3") { Session["ParentID"] = sdrLogin.GetValue(sdrLogin.GetOrdinal("EmployeeIDStudentID")).ToString(); if (objCCWeb.ReturnNumericValue("Select count(SYD.StudentID) from Sistudentmaster SM inner join sistudentyearwisedetails SYD on SM.StudentID=SYD.StudentID where ParentID='" + Session["ParentID"] + "' AND StudentStatus='S' AND AcaStart=" + Session["AcaStart"] + " ") > 0) { Login1.DestinationPageUrl = "~/PlParentLoginForm.aspx"; // Login1.DestinationPageUrl = "~/SchoolOnline/Default.aspx"; } else { // Login1.DestinationPageUrl = "~/SchoolOnline/Default.aspx"; Login1.DestinationPageUrl = "~/PlParentLoginForm.aspx"; ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script>alert('Student does not exist in this Session');</script>"); return; } Session["SchoolID"] = objCCWeb.ReturnNumericValue("Select SchoolID from SIStudentMaster Where ParentID IN (Select employeeIDStudentID from MTUserMaster Where UID=" + Session["UID"] + ")"); Session["SchoolName"] = objCCWeb.ReturnSingleValue("SELECT ISNULL(MAX(SchoolName1),'CampusCare') FROM MTClientCompany WHERE SchoolID=" + Session["SchoolID"] + "") + " :: " + Session["AcademicSession"]; } else if (sdrLogin.GetValue(sdrLogin.GetOrdinal("UserTypeID")).ToString() == "2" && hdnFlag.Value == "2") { Session["StudentID"] = sdrLogin.GetValue(sdrLogin.GetOrdinal("EmployeeIDStudentID")).ToString(); if (objCCWeb.ReturnNumericValue("Select count(SYD.StudentID) from Sistudentmaster SM inner join sistudentyearwisedetails SYD on SM.StudentID=SYD.StudentID where SM.StudentID='" + Session["StudentID"] + "' AND StudentStatus='S' AND AcaStart=" + Session["AcaStart"] + " ") > 0) { Login1.DestinationPageUrl = "~/PlParentLoginForm.aspx"; } else { Login1.DestinationPageUrl = "~/PlParentLoginForm.aspx"; ClientScript.RegisterStartupScript(this.GetType(), "displayScript", "<script>alert('Student does not exist in this Session');</script>"); return; } Session["SchoolID"] = objCCWeb.ReturnNumericValue("Select SchoolID from SIStudentMaster Where StudentID IN (Select employeeIDStudentID from MTUserMaster Where UID=" + Session["UID"] + ")"); Session["SchoolName"] = objCCWeb.ReturnSingleValue("SELECT ISNULL(MAX(SchoolName1),'Campus Care') FROM MTClientCompany WHERE SchoolID=" + Session["SchoolID"] + "") + " :: " + Session["AcademicSession"]; } else if (sdrLogin.GetValue(sdrLogin.GetOrdinal("UserTypeID")).ToString() == "1" && hdnFlag.Value == "1") { Session["EmployeeID"] = sdrLogin.GetValue(sdrLogin.GetOrdinal("EmployeeIDStudentID")).ToString(); Login1.DestinationPageUrl = "~/EmployeeLogin.aspx"; Session["UserType"] = "1"; Session["SchoolID"] = objCCWeb.ReturnNumericValue("Select SchoolID from PRLEmployeeMaster Where PRLEmployeeID IN (Select employeeIDStudentID from MTUserMaster Where UID=" + Session["UID"] + ")"); Session["SchoolName"] = objCCWeb.ReturnSingleValue("SELECT ISNULL(MAX(SchoolName1),'Campus Care') FROM MTClientCompany WHERE SchoolID=" + Session["SchoolID"] + "") + " :: " + Session["AcademicSession"]; } else if (sdrLogin.GetValue(sdrLogin.GetOrdinal("UserTypeID")).ToString() == "4" && hdnFlag.Value == "1") { Login1.DestinationPageUrl = "~/PlManagementLogin.aspx"; Session["SchoolID"] = "1"; Session["SchoolName"] = objCCWeb.ReturnSingleValue("SELECT ISNULL(MAX(SchoolName1),'Campus Care') FROM MTClientCompany WHERE SchoolID=" + Session["SchoolID"] + "") + " :: " + Session["AcademicSession"]; } else if (sdrLogin.GetValue(sdrLogin.GetOrdinal("UserTypeID")).ToString() == "6" && hdnFlag.Value == "6") { Session["PID"] = objCCWeb.ReturnNumericValue("Select EmployeeIDStudentID from MTUserMaster Where UserID='" + Login1.UserName.Replace("'", "''") + "' AND UserTypeID=6"); string UserID = objCCWeb.ReturnSingleValue("Select Case when UserId like 'SE%' then 'SE' else 'SR' end as UserID from MTUserMaster Where UserID='" + Login1.UserName.Replace("'", "''") + "' AND UserTypeID=6"); if (UserID == "SE") { Login1.DestinationPageUrl = "~/SRStudentonlineRegistration11.aspx"; } else { Login1.DestinationPageUrl = "~/SRStudentonlineRegistration.aspx"; } Session["SchoolID"] = objCCWeb.ReturnNumericValue("Select SchoolID from MTClientCompany"); Session["AcaStart"] = objCCWeb.ReturnNumericValue("Select MAX(AcaStart)from MTAcademicsessionmaster"); Session["SchoolName"] = objCCWeb.ReturnSingleValue("SELECT ISNULL(MAX(SchoolName1),'CampusCare') FROM MTClientCompany WHERE SchoolID=" + Session["SchoolID"] + "") + ""; // :: " + Session["AcademicSession"]; } else if (sdrLogin.GetValue(sdrLogin.GetOrdinal("UserTypeID")).ToString() == "0" && hdnFlag.Value == "0") { Login1.DestinationPageUrl = "~/Default.aspx"; Session["SchoolID"] = objCCWeb.ReturnNumericValue("SELECT ISNULL(MAX(SchoolID),1) FROM MTUserInstitutionMaster WHERE UId=" + Session["UID"] + ""); Session["SchoolName"] = objCCWeb.ReturnSingleValue("SELECT ISNULL(MAX(SchoolName1),'CampusCare') FROM MTClientCompany WHERE SchoolID=" + Session["SchoolID"] + "") + ""; //:: " + Session["AcademicSession"]; } else { Session["UserLogin"] = Session.SessionID; string strUserID = objCCWeb.ReturnSingleValue("SELECT UID FROM MTUsermaster where UserID='" + strUserName + "'"); if (strUserID != "") { objCCWeb.ExecuteQuery("INSERT INTO MDUserLoginDetails(UID,IPAddress,LoginTime,SessionDetails,UserAgent,Referrer,URL,LoggedOutTime,LoginSuccessStatus) VALUES ('" + strUserID + "','" + Request.ServerVariables.Get("remote_addr").ToString() + "',GETDATE(),'" + Session.SessionID.ToString() + "','" + hidBrsr.Value.Trim().ToString() + "','" + Request.UrlReferrer.ToString() + "','" + Request.Url.ToString() + "',null,'N')");//"+Process.GetCurrentProcess().Id.ToString()+" } else { objCCWeb.ExecuteQuery("INSERT INTO MDUserLoginDetails(UID,IPAddress,LoginTime,SessionDetails,UserAgent,Referrer,URL,LoggedOutTime,LoginSuccessStatus) VALUES (0,'" + Request.ServerVariables.Get("remote_addr").ToString() + "',GETDATE(),'" + Session.SessionID.ToString() + "','" + hidBrsr.Value.Trim().ToString() + "','" + Request.UrlReferrer.ToString() + "','" + Request.Url.ToString() + "',null,'N')");//"+Process.GetCurrentProcess().Id.ToString()+" } e.Authenticated = false; Session.Clear(); hdnFlag.Value = hdnFlag.Value + "^N"; return; } //} } Session["UserLogin"] = Session.SessionID; objCCWeb.ExecuteQuery("INSERT INTO MDUserLoginDetails(UID,IPAddress,LoginTime,SessionDetails,UserAgent,Referrer,URL,LoggedOutTime,LoginSuccessStatus) VALUES (" + sdrLogin.GetValue(sdrLogin.GetOrdinal("UID")) + ",'" + Request.ServerVariables.Get("remote_addr").ToString() + "',GETDATE(),'" + Session.SessionID.ToString() + "','" + hidBrsr.Value.Trim().ToString() + "','" + Request.UrlReferrer.ToString() + "','" + Request.Url.ToString() + "',null,'Y')");//"+Process.GetCurrentProcess().Id.ToString()+" Session["LoginID"] = objCCWeb.ReturnSingleValue("SELECT MAX(LoginID) FROM MDUSerLoginDetails WHERE UID=" + Session["UID"] + " AND LoginSuccessStatus='Y' "); Session.Timeout = 30; e.Authenticated = true; } else { Session["UserLogin"] = Session.SessionID; objCCWeb.ExecuteQuery("INSERT INTO MDUserLoginDetails(UID,IPAddress,LoginTime,SessionDetails,UserAgent,Referrer,URL,LoggedOutTime,LoginSuccessStatus) VALUES (" + sdrLogin.GetValue(sdrLogin.GetOrdinal("UID")) + ",'" + Request.ServerVariables.Get("remote_addr").ToString() + "',GETDATE(),'" + Session.SessionID.ToString() + "','" + hidBrsr.Value.Trim().ToString() + "','" + Request.UrlReferrer.ToString() + "','" + Request.Url.ToString() + "',null,'N')");//"+Process.GetCurrentProcess().Id.ToString()+" e.Authenticated = false; } } else { Session["UserLogin"] = Session.SessionID; objCCWeb.ExecuteQuery("INSERT INTO MDUserLoginDetails(UID,IPAddress,LoginTime,SessionDetails,UserAgent,Referrer,URL,LoggedOutTime,LoginSuccessStatus) VALUES (0,'" + Request.ServerVariables.Get("remote_addr").ToString() + "',GETDATE(),'" + Session.SessionID.ToString() + "','" + hidBrsr.Value.Trim().ToString() + "','" + Request.UrlReferrer.ToString() + "','" + Request.Url.ToString() + "',null,'N')");//"+Process.GetCurrentProcess().Id.ToString()+" e.Authenticated = false; } //} //else //{ // Session["UserLogin"] = Session.SessionID; // string strUserID = objCCWeb.ReturnSingleValue("SELECT UID FROM MTUsermaster where UserID='" + strUserName + "'"); // if (strUserID != "") // { // objCCWeb.ExecuteQuery("INSERT INTO MDUserLoginDetails(UID,IPAddress,LoginTime,SessionDetails,UserAgent,Referrer,URL,LoggedOutTime,LoginSuccessStatus) VALUES ('" + strUserID + "','" + // Request.ServerVariables.Get("remote_addr").ToString() + "',GETDATE(),'" + Session.SessionID.ToString() + "','" + hidBrsr.Value.Trim().ToString() + "','" + Request.UrlReferrer.ToString() + "','" + Request.Url.ToString() + "',null,'N')");//"+Process.GetCurrentProcess().Id.ToString()+" // } // else // { // objCCWeb.ExecuteQuery("INSERT INTO MDUserLoginDetails(UID,IPAddress,LoginTime,SessionDetails,UserAgent,Referrer,URL,LoggedOutTime,LoginSuccessStatus) VALUES (0,'" + // Request.ServerVariables.Get("remote_addr").ToString() + "',GETDATE(),'" + Session.SessionID.ToString() + "','" + hidBrsr.Value.Trim().ToString() + "','" + Request.UrlReferrer.ToString() + "','" + Request.Url.ToString() + "',null,'N')");//"+Process.GetCurrentProcess().Id.ToString()+" // } // e.Authenticated = false; //} sdrLogin.Close(); sdrLogin.Dispose(); } catch (Exception ex) { } finally { conExecute.Close(); conExecute.Dispose(); } // Login1.FailureText = "Invalid User Name or Password Or Check Correct Login Type"; hdnFlag.Value = hdnFlag.Value + "^N"; ClientScript.RegisterStartupScript(this.GetType(), "displ", "<script language='javascript'> document.getElementById('" + txtPosition.Text.Trim() + "').click();</script>"); }
protected void Page_Load(object sender, EventArgs e) { if (Session["UID"] == null) { Response.Write("<script>window.close();window.open('Logon.aspx','_parent');</script>"); return; } if (!IsPostBack) { //SqlConnection conMyConnection = new SqlConnection(ConfigurationManager.AppSettings.Get("ConnectionString")); //conMyConnection.Open(); SqlConnection conMyConnection = new SqlConnection(); //new SqlConnection(ConfigurationManager.AppSettings.Get("ConnectionString")); conMyConnection.ConnectionString = objCCWeb.ReturnConnectionString(); conMyConnection.Open(); SqlCommand cmdMyCommand = new SqlCommand("SELECT MM.ModuleName,UM.MenuCaption,LEN(UM.MenuLevel) AS MenuLevel,UM.MenuLinkPage,UM.MenuName FROM MTUserMenuMaster UM INNER JOIN MTUserModuleMaster MM ON MM.ModuleID=UM.ModuleID INNER JOIN MTUserLimitMaster LM ON UM.MenuName = LM.MenuName AND LM.ModuleID=UM.ModuleID AND LM.VisibleOption='Y' AND LM.UID=" + Session["UID"] + " Where UM.MenuName Not in ('mnuStaffPayInfo', 'mnuStaffOtherInfo') ORDER BY MM.Priority,MM.ModuleID,RollNumber ", conMyConnection); SqlDataReader rdrMyReader = cmdMyCommand.ExecuteReader(); TreeNode objRootNode, objtreenode, objchildnode1, objchildnode2, objchildnode3; objRootNode = new TreeNode(""); objtreenode = new TreeNode(""); objchildnode1 = new TreeNode(""); objchildnode2 = new TreeNode(""); while (rdrMyReader.Read()) { int intLevel; intLevel = Convert.ToInt32(rdrMyReader.GetValue(2).ToString()); if (intLevel == 0) { objRootNode = new TreeNode(rdrMyReader.GetValue(0).ToString(), "", "", "MainForm.aspx", "MainFrame"); trvMenu.Nodes.Add(objRootNode); } if (intLevel == 1) { if (rdrMyReader.GetValue(3).ToString() != "") { objtreenode = new TreeNode(rdrMyReader.GetValue(1).ToString(), "", "", rdrMyReader.GetValue(3).ToString().Trim() + "?MenuName=" + rdrMyReader.GetValue(4).ToString().Trim(), "MainFrame"); } else { objtreenode = new TreeNode(rdrMyReader.GetValue(1).ToString()); } objRootNode.ChildNodes.Add(objtreenode); } else if (intLevel == 2) { if (rdrMyReader.GetValue(3).ToString() != "") { objchildnode1 = new TreeNode(rdrMyReader.GetValue(1).ToString(), "", "", rdrMyReader.GetValue(3).ToString().Trim() + "?MenuName=" + rdrMyReader.GetValue(4).ToString().Trim(), "MainFrame"); } else { objchildnode1 = new TreeNode(rdrMyReader.GetValue(1).ToString()); } objtreenode.ChildNodes.Add(objchildnode1); } else if (intLevel == 3) { if (rdrMyReader.GetValue(3).ToString() != "") { objchildnode2 = new TreeNode(rdrMyReader.GetValue(1).ToString(), "", "", rdrMyReader.GetValue(3).ToString().Trim() + "?MenuName=" + rdrMyReader.GetValue(4).ToString().Trim(), "MainFrame"); } else { objchildnode2 = new TreeNode(rdrMyReader.GetValue(1).ToString()); } objchildnode1.ChildNodes.Add(objchildnode2); } else if (intLevel == 4) { if (rdrMyReader.GetValue(3).ToString() != "") { objchildnode3 = new TreeNode(rdrMyReader.GetValue(1).ToString(), "", "", rdrMyReader.GetValue(3).ToString().Trim() + "?MenuName=" + rdrMyReader.GetValue(4).ToString().Trim(), "MainFrame"); } else { objchildnode3 = new TreeNode(rdrMyReader.GetValue(1).ToString()); } objchildnode2.ChildNodes.Add(objchildnode3); } if (objRootNode.ChildNodes.Count >= 1) { objRootNode.SelectAction = TreeNodeSelectAction.Expand; } if (objtreenode.ChildNodes.Count >= 1) { objtreenode.SelectAction = TreeNodeSelectAction.Expand; } if (objchildnode1.ChildNodes.Count >= 1) { objchildnode1.SelectAction = TreeNodeSelectAction.Expand; } if (objchildnode2.ChildNodes.Count >= 1) { objchildnode2.SelectAction = TreeNodeSelectAction.Expand; } } //GetMenuData(); cmdMyCommand.Dispose(); rdrMyReader.Close(); rdrMyReader.Dispose(); conMyConnection.Close(); conMyConnection.Dispose(); } }