public List <DropdownDataForDetailAnalysis> GetDropdownDataForDetailAnalysis_Portfolio() { try { string AppUrl = HttpContext.Request.Headers["appurl"]; string SchemaName = ""; string _SpUserId = HttpContext.Request.Headers["LoggedInUserSPUserId"]; if (!string.IsNullOrEmpty(AppUrl)) { SchemaName = new clsUatClient(_context).GetClientSchema(AppUrl); } else { return(null); } List <DropdownDataForDetailAnalysis> detailedAnalysisResult = new List <DropdownDataForDetailAnalysis>(); using (var cmd = _context.Database.GetDbConnection().CreateCommand()) { cmd.CommandText = "UAT.spDetailAnalysisDropDown_Portfolio"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@SPUserId", SqlDbType.Int) { Value = _SpUserId }); cmd.Parameters.Add(new SqlParameter("@SchemaName", SqlDbType.VarChar, 500) { Value = SchemaName }); cmd.Parameters.Add(new SqlParameter("@Ret_Parameter", SqlDbType.VarChar, 500) { Direction = ParameterDirection.Output }); if (cmd.Connection.State != ConnectionState.Open) { cmd.Connection.Open(); } var retObject = new List <dynamic>(); TesterList lst = new TesterList(); using (var dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { var dataRow = new ExpandoObject() as IDictionary <string, object>; List <clsTestterList> oTester = new List <clsTestterList>(); #region ' XMl Parsing ' #region Project Lead Conversion string _versionLeadName = string.Empty; if (dataReader["projectLead"] != null) { using (XmlReader reader = XmlReader.Create(new StringReader("<users>" + dataReader["projectLead"] + "</users>"))) { XmlDocument xml = new XmlDocument(); xml.Load(reader); XmlNodeList TesterList = xml.GetElementsByTagName("user"); foreach (XmlNode node in TesterList) { if (node["userName"] != null) { _versionLeadName = node["userName"].InnerText; } break; } } } #endregion #region Test Manager Conversion string _testManagerName = string.Empty; if (dataReader["testManagerDetails"] != null) { using (XmlReader reader = XmlReader.Create(new StringReader("<users>" + dataReader["testManagerDetails"] + "</users>"))) { XmlDocument xml = new XmlDocument(); xml.Load(reader); XmlNodeList xmlNodeList = xml.GetElementsByTagName("user"); foreach (XmlNode node in xmlNodeList) { if (node["userName"] != null) { _testManagerName = node["userName"].InnerText; } break; } } } #endregion #region Tester Conversion string _testerSPID = string.Empty, _testerName = string.Empty; if (dataReader["rowTesterDetails"] != null) { using (XmlReader reader = XmlReader.Create(new StringReader("<users>" + dataReader["rowTesterDetails"] + "</users>"))) { XmlDocument xml = new XmlDocument(); xml.Load(reader); XmlNodeList xmlNodeList = xml.GetElementsByTagName("user"); foreach (XmlNode node in xmlNodeList) { if (node["spUserId"] != null) { _testerSPID = node["spUserId"].InnerText; } if (node["userName"] != null) { _testerName = node["userName"].InnerText; } break; } } } #endregion #region Tester Conversion New string _tSPID = string.Empty, _tName = string.Empty; string _tRoleID = string.Empty, _tRoleName = string.Empty; if (dataReader["TesterDetailsRowNew"] != null) { using (XmlReader reader = XmlReader.Create(new StringReader("<users>" + dataReader["TesterDetailsRowNew"] + "</users>"))) { XmlDocument xml = new XmlDocument(); xml.Load(reader); XmlNodeList xmlNodeList = xml.GetElementsByTagName("user"); foreach (XmlNode node in xmlNodeList) { XmlElement companyElement = (XmlElement)node; if (node["TUserId"] != null) { _tSPID = node["TUserId"].InnerText; } if (node["TUserName"] != null) { _tName = node["TUserName"].InnerText; } if (node["TRoleId"] != null) { _tRoleID = node["TRoleId"].InnerText; } if (node["TRoleName"] != null) { _tRoleName = node["TRoleName"].InnerText; } oTester.Add(new clsTestterList { testerId = (companyElement.GetElementsByTagName("TUserId") != null) ? Convert.ToString(companyElement.GetElementsByTagName("TUserId")[0].InnerText) : "", testerName = (companyElement.GetElementsByTagName("TUserName") != null) ? Convert.ToString(companyElement.GetElementsByTagName("TUserName")[0].InnerText) : "", roleId = (companyElement.GetElementsByTagName("TRoleId") != null) ? Convert.ToString(companyElement.GetElementsByTagName("TRoleId")[0].InnerText) : "", roleName = (companyElement.GetElementsByTagName("TRoleName") != null) ? Convert.ToString(companyElement.GetElementsByTagName("TRoleName")[0].InnerText) : "" }); } } } #endregion #endregion int projectId = dataReader.GetOrdinal("projectId"); int testPassId = dataReader.GetOrdinal("testPassId"); int testPassName = dataReader.GetOrdinal("testPassName"); int tpEndDate = dataReader.GetOrdinal("tpEndDate"); int roleId = dataReader.GetOrdinal("roleId"); int roleName = dataReader.GetOrdinal("roleName"); int projectName = dataReader.GetOrdinal("projectName"); int projectVersion = dataReader.GetOrdinal("projectVersion"); detailedAnalysisResult.Add(new DropdownDataForDetailAnalysis() { projectId = (dataReader.IsDBNull(projectId)) == true ? "" : Convert.ToString(dataReader["projectId"]), projectName = (dataReader.IsDBNull(projectName)) == true ? "" : Convert.ToString(dataReader["projectName"]), projectVersion = (dataReader.IsDBNull(projectVersion)) == true ? "" : Convert.ToString(dataReader["projectVersion"]), versionLead = _versionLeadName, testpassId = (dataReader.IsDBNull(testPassId)) == true ? "" : Convert.ToString(dataReader["testPassId"]), testpassName = (dataReader.IsDBNull(testPassName)) == true ? "" : Convert.ToString(dataReader["testPassName"]), testManager = _testManagerName, tpEndDate = (dataReader.IsDBNull(tpEndDate)) == true ? "" : Convert.ToString(dataReader["tpEndDate"]), testerId = _testerSPID, testerName = _testerName, lstTesterList = oTester, roleId = (dataReader.IsDBNull(roleId)) == true ? "" : Convert.ToString(dataReader["roleId"]), roleName = (dataReader.IsDBNull(roleName)) == true ? "" : Convert.ToString(dataReader["roleName"]), }); } return(detailedAnalysisResult); } } } catch (Exception ex) { return(null); } }
public JsonResult GetDropdownDataForDetailAnalysis() { try { string AppUrl = HttpContext.Request.Headers["appurl"]; string SchemaName = ""; string _SpUserId = HttpContext.Request.Headers["LoggedInUserSPUserId"]; if (!string.IsNullOrEmpty(AppUrl)) { SchemaName = new clsUatClient(_context).GetClientSchema(AppUrl); } else { return(Json("Invalid Url")); } using (var cmd = _context.Database.GetDbConnection().CreateCommand()) { cmd.CommandText = "UAT.spDetailAnalysisDropDown"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@SPUserId", SqlDbType.Int) { Value = _SpUserId }); cmd.Parameters.Add(new SqlParameter("@SchemaName", SqlDbType.VarChar, 500) { Value = SchemaName }); cmd.Parameters.Add(new SqlParameter("@Ret_Parameter", SqlDbType.VarChar, 500) { Direction = ParameterDirection.Output }); if (cmd.Connection.State != ConnectionState.Open) { cmd.Connection.Open(); } var retObject = new List <dynamic>(); TesterList lst = new TesterList(); using (var dataReader = cmd.ExecuteReader()) { while (dataReader.Read()) { var dataRow = new ExpandoObject() as IDictionary <string, object>; for (var iFiled = 0; iFiled < dataReader.FieldCount; iFiled++) { var Name = dataReader.GetName(iFiled); var Value = dataReader.IsDBNull(iFiled) ? null : dataReader[iFiled]; List <clsTestterList> oTester = new List <clsTestterList>(); string valueCheck = Convert.ToString(Value); if (!string.IsNullOrEmpty(valueCheck)) { #region ' XMl Parsing ' if (valueCheck.Contains('<')) { if (Convert.ToString(Name) == "TesterDetailsRowNew") { Name = "lstTesterList"; using (XmlReader reader = XmlReader.Create(new StringReader("<users>" + Value + "</users>"))) { XmlDocument xml = new XmlDocument(); xml.Load(reader); XmlNodeList companyList = xml.GetElementsByTagName("user"); foreach (XmlNode node in companyList) { XmlElement companyElement = (XmlElement)node; oTester.Add(new clsTestterList { testerId = (companyElement.GetElementsByTagName("TUserId") != null) ? Convert.ToString(companyElement.GetElementsByTagName("TUserId")[0].InnerText) : "", testerName = (companyElement.GetElementsByTagName("TUserName") != null) ? Convert.ToString(companyElement.GetElementsByTagName("TUserName")[0].InnerText) : "", roleId = (companyElement.GetElementsByTagName("TRoleId") != null) ? Convert.ToString(companyElement.GetElementsByTagName("TRoleId")[0].InnerText) : "", roleName = (companyElement.GetElementsByTagName("TRoleName") != null) ? Convert.ToString(companyElement.GetElementsByTagName("TRoleName")[0].InnerText) : "" }); } } lst.lstTesterList = oTester; } } #endregion } dataRow.Add(Name, Name == "lstTesterList" ? lst.lstTesterList : Value); } retObject.Add((ExpandoObject)dataRow); } } return(Json(retObject)); } } catch (Exception ex) { return(Json(ex.Message)); } }
private void DataListBind() { string type = GetMemberType(); int year = GetYear(); string name = GetName(); DAL.DMember list = new DAL.DMember(); if (type.Equals("")) { ManagerList.DataSource = list.GetMemberByManyInfo("", "主管", name, year); ManagerList.DataBind(); AndroiderList.DataSource = list.GetMemberByManyInfo(type + "%Android", "", name, year); AndroiderList.DataBind(); ASPNETerList.DataSource = list.GetMemberByManyInfo(type + "%.NET", "", name, year); ASPNETerList.DataBind(); PHPerList.DataSource = list.GetMemberByManyInfo(type + "%PHP", "", name, year); PHPerList.DataBind(); JavaerList.DataSource = list.GetMemberByManyInfo(type + "%JAVA", "", name, year); JavaerList.DataBind(); PSerList.DataSource = list.GetMemberByManyInfo(type + "%美工", "", name, year); PSerList.DataBind(); UIerList.DataSource = list.GetMemberByManyInfo(type + "%UI", "", name, year); UIerList.DataBind(); TesterList.DataSource = list.GetMemberByManyInfo("测试", "", name, year); TesterList.DataBind(); } if (type.Contains("主管")) { ManagerList.DataSource = list.GetMemberByManyInfo("", "主管", name, year); ManagerList.DataBind(); AndroiderList.DataSource = null; AndroiderList.DataBind(); ASPNETerList.DataSource = null; ASPNETerList.DataBind(); PHPerList.DataSource = null; PHPerList.DataBind(); JavaerList.DataSource = null; JavaerList.DataBind(); PSerList.DataSource = null; PSerList.DataBind(); UIerList.DataSource = null; UIerList.DataBind(); TesterList.DataSource = null; TesterList.DataBind(); } if (type.Contains("开发")) { ManagerList.DataSource = null; ManagerList.DataBind(); AndroiderList.DataSource = list.GetMemberByManyInfo(type + "%Android", "", name, year); AndroiderList.DataBind(); ASPNETerList.DataSource = list.GetMemberByManyInfo(type + "%.NET", "", name, year); ASPNETerList.DataBind(); PHPerList.DataSource = list.GetMemberByManyInfo(type + "%PHP", "", name, year); PHPerList.DataBind(); JavaerList.DataSource = list.GetMemberByManyInfo(type + "%JAVA", "", name, year); JavaerList.DataBind(); PSerList.DataSource = null; PSerList.DataBind(); UIerList.DataSource = null; UIerList.DataBind(); TesterList.DataSource = null; TesterList.DataBind(); } if (type.Contains("特效")) { ManagerList.DataSource = null; ManagerList.DataBind(); AndroiderList.DataSource = null; AndroiderList.DataBind(); ASPNETerList.DataSource = null; ASPNETerList.DataBind(); PHPerList.DataSource = null; PHPerList.DataBind(); JavaerList.DataSource = null; JavaerList.DataBind(); PSerList.DataSource = list.GetMemberByManyInfo(type + "%美工", "", name, year); PSerList.DataBind(); UIerList.DataSource = list.GetMemberByManyInfo(type + "%UI", "", name, year); UIerList.DataBind(); TesterList.DataSource = list.GetMemberByManyInfo("测试", "", name, year); TesterList.DataBind(); } if (type.Contains("测试")) { ManagerList.DataSource = null; ManagerList.DataBind(); AndroiderList.DataSource = null; AndroiderList.DataBind(); ASPNETerList.DataSource = null; ASPNETerList.DataBind(); PHPerList.DataSource = null; PHPerList.DataBind(); JavaerList.DataSource = null; JavaerList.DataBind(); PSerList.DataSource = null; PSerList.DataBind(); UIerList.DataSource = null; UIerList.DataBind(); TesterList.DataSource = list.GetMemberByManyInfo("测试", "", name, year); TesterList.DataBind(); } }