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();
}
}
