//added for get the session info by sessionId (20141017 by SK)
public List <SessionDataForRecovery> getSessionsDataBySessionId(Int64 sessionid)
{
List <SessionDataForRecovery> sdList = new List <SessionDataForRecovery>();
object[] arg = new Object[1] {
sessionid
};
StoredProcedureGrab storedprocedure = new StoredProcedureGrab(serverName, dbName, userName, passWord, "sp_get_sessions_data_by_S_id", arg);
spData = storedprocedure.GetReader();
if (!spData.getErrorStatus())
{
foreach (DataRow row in spData.getDataTable().Rows)
{
var tempsd = new SessionDataForRecovery();
tempsd.setSessionDataForRecovery((Int64)row[0], (int)row[1], (int)row[2], (int)row[3], String.Format("{0:M/d/yyyy HH:mm:ss}", row[4]), String.Format("{0:M/d/yyyy HH:mm:ss}", row[5]));
sdList.Add(tempsd);
}
}
else
{
var tempsd = new SessionDataForRecovery();
tempsd.setErrorDataForRecovery(spData.getErrorDetails());
sdList.Add(tempsd);
}
return(sdList);
}
public List <TestletItemData> getTestletItemData(string testletname)
{
List <TestletItemData> tltItemList = new List <TestletItemData>();
object[] arg = new Object[1] {
testletname
};
StoredProcedureGrab storedprocedure = new StoredProcedureGrab(serverName, dbName, userName, passWord, "sp_ws_get_testlet_items", arg);
spData = storedprocedure.GetReader();
if (!spData.getErrorStatus())
{
foreach (DataRow row in spData.getDataTable().Rows)
{
//int len = row.ItemArray.Length;
object[] data = row.ItemArray;
var tmp = new TestletItemData();
//tempud.setUserData((Int64)row[0], (string)row[1], (string)row[2], (int)(row[3] ?? 0), (string)(row[4] ?? ""));//String.Format("{0:M/d/yyyy HH:mm:ss}", row[4]));
tmp.setTestletItemData(data);//String.Format("{0:M/d/yyyy HH:mm:ss}", row[4]));
tltItemList.Add(tmp);
}
}
else
{
var tmp = new TestletItemData();
tmp.setErrorData(spData.getErrorDetails());
tltItemList.Add(tmp);
}
return(tltItemList);
}
public List <SessionData> getSessionsDataByDate(int thisYear, int thisMonth, int thisDay)
{
List <SessionData> sdList = new List <SessionData>();
object[] arg = new Object[3] {
thisYear, thisMonth, thisDay
};
StoredProcedureGrab storedprocedure = new StoredProcedureGrab(serverName, dbName, userName, passWord, "sp_get_sessions_data_by_date", arg);
spData = storedprocedure.GetReader();
if (!spData.getErrorStatus())
{
foreach (DataRow row in spData.getDataTable().Rows)
{
var tempsd = new SessionData();
tempsd.setSessionData((Int64)row[0], (int)row[1], (string)row[2], (string)row[3], String.Format("{0:M/d/yyyy HH:mm:ss}", row[4]), String.Format("{0:M/d/yyyy HH:mm:ss}", row[5]));
sdList.Add(tempsd);
}
}
else
{
var tempsd = new SessionData();
tempsd.setErrorData(spData.getErrorDetails());
sdList.Add(tempsd);
}
return(sdList);
}
public List <ProfileData> getProfileDataById(int profileid)
{
List <ProfileData> prfdList = new List <ProfileData>();
Object[] arg = new Object[1] {
profileid
};
StoredProcedureGrab storedprocedure = new StoredProcedureGrab(serverName, dbName, userName, passWord, "sp_get_profile_data_by_id", arg);
spData = storedprocedure.GetReader();
if (!spData.getErrorStatus())
{
var tempPrfData = new ProfileData();
var row = spData.getDataTable().Rows[0];
tempPrfData.setProfileData((int)row[0], (int)row[1], (string)row[2], (string)row[3], (string)row[4],
(string)row[5], String.Format("{0:M/d/yyyy HH:mm:ss}", row[6]), (string)row[7], (string)row[8], (string)row[9], "");
prfdList.Add(tempPrfData);
}
else
{
var tempPrfData = new ProfileData();
tempPrfData.setErrorData(spData.getErrorDetails());
prfdList.Add(tempPrfData);
}
return(prfdList);
}
public List <TestGroupData> getTestGroupsDataBySession(int sessionId)
{
List <TestGroupData> tgdList = new List <TestGroupData>();
object[] arg = new Object[1] {
sessionId
};
StoredProcedureGrab storedprocedure = new StoredProcedureGrab(serverName, dbName, userName, passWord, "sp_get_test_groups_data_by_session", arg);
spData = storedprocedure.GetReader();
if (!spData.getErrorStatus())
{
//gd.setGenericData(spData.getTheOnlyValue());
foreach (DataRow row in spData.getDataTable().Rows)
{
var temptgd = new TestGroupData();
temptgd.setTestGroupData((int)row[0], (Int64)row[1], (string)row[2], (string)row[3], (string)row[4], (string)row[5],
(string)row[6], (string)row[7], (int)row[8], String.Format("{0:M/d/yyyy HH:mm:ss}", row[9]), (int)row[10]);
tgdList.Add(temptgd);
}
}
else
{
var temptgd = new TestGroupData();
temptgd.setErrorData(spData.getErrorDetails());
tgdList.Add(temptgd);
}
return(tgdList);
}
//sp_ws_insert_survey_item adding user_wpl
public List <SurveyItemData> getAllSurveyItems(string osvDate1, string osvDate2)
{
List <SurveyItemData> svItemList = new List <SurveyItemData>();
//DateTime osvDate1T = new DateTime(int.Parse(osvDate1.Split('-')[0]), int.Parse(osvDate1.Split('-')[1]), int.Parse(osvDate1.Split('-')[2]));
//DateTime osvDate2T = new DateTime(int.Parse(osvDate2.Split('-')[0]), int.Parse(osvDate2.Split('-')[1]), int.Parse(osvDate2.Split('-')[2]));
//DateTime osvDate1T = new DateTime(2013, 1, 1);
//DateTime osvDate2T = new DateTime(2016,1,1);
osvDate1 = String.IsNullOrEmpty(osvDate1) ? "2006-01-01" : osvDate1;
osvDate2 = String.IsNullOrEmpty(osvDate2) ? (DateTime.Now.ToString("yyyy-M-d")) + " 23:59:59" : osvDate2; //to include today (DateTime.Now.ToString("yyyy-M-d"))
object[] arg = new Object[2] {
osvDate1, osvDate2
};
StoredProcedureGrab storedprocedure = new StoredProcedureGrab(serverName, dbName, userName, passWord, "sp_ws_get_all_survey_items", arg);
spData = storedprocedure.GetReader();
if (!spData.getErrorStatus())
{
foreach (DataRow row in spData.getDataTable().Rows)
{
var tempsvItem = new SurveyItemData();
tempsvItem.setSurvyItemData(
(Int64)row[0],
(int)row[1],
(string)row[2],
String.Format("{0:M/d/yyyy HH:mm:ss}", row[3]),
(string)row[4],
(int)row[5],
(int)row[6], (int)row[7], (int)row[8], (int)row[9],
(int)row[10], (int)row[11], (int)row[12], (int)row[13], (int)row[14], (int)row[15], (int)row[16], (int)row[17], (int)row[18], (int)row[19], (int)row[20], (int)row[21], (int)row[22], (string)row[23], (int)row[24], (int)row[25], (int)row[26]);
svItemList.Add(tempsvItem);
}
}
else
{
var tempsvItem = new SurveyItemData();
tempsvItem.setErrorData(spData.getErrorDetails());
svItemList.Add(tempsvItem);
}
return(svItemList);
}
public List <ProfileData> getProfilesByUserId(int userid)
{
List <ProfileData> prfdList = new List <ProfileData>();
Object[] arg = new Object[1] {
userid
};
StoredProcedureGrab storedprocedure = new StoredProcedureGrab(serverName, dbName, userName, passWord, "sp_get_profiles_by_user_id", arg);
spData = storedprocedure.GetReader();
if (!spData.getErrorStatus())
{
foreach (DataRow row in spData.getDataTable().Rows)
{
var tempPrfData = new ProfileData();
tempPrfData.setProfileData((int)row[0], //int prfid
0, //int prfouid
(string)row[1], //string prflng
(string)row[2], //string prfmod
"", //string prfwpl
"", //string prfcpl
String.Format("{0:M/d/yyyy HH:mm:ss}", row[3]), //string prfdate
"", //string prftimestring
"", //string prflink
"", //string prfdbnm
(string)row[4]);
prfdList.Add(tempPrfData);
}
}
else
{
var tempPrfData = new ProfileData();
tempPrfData.setErrorData(spData.getErrorDetails());
prfdList.Add(tempPrfData);
}
return(prfdList);
}
public List <ItemTrackerData> getItemTrackerDataByTestGroup(int testGroupId)
{
List <ItemTrackerData> tgdList = new List <ItemTrackerData>();
object[] arg = new Object[1] {
testGroupId
};
StoredProcedureGrab storedprocedure = new StoredProcedureGrab(serverName, dbName, userName, passWord, "sp_get_item_tracker_data_by_test_group", arg);
spData = storedprocedure.GetReader();
if (!spData.getErrorStatus())
{
//gd.setGenericData(spData.getTheOnlyValue());
foreach (DataRow row in spData.getDataTable().Rows)
{
var tempitd = new ItemTrackerData();
string imtp;
if (row[10] != null)
{
imtp = row[10].ToString();
}
else
{
imtp = String.Empty;
}
tempitd.setItemTrackerData((Int64)row[0], (string)row[1], (int)row[2], (string)row[3], (string)row[4], (string)row[5],
(double)row[6], (double)row[7], (double)row[8], (byte)row[9], imtp);
tgdList.Add(tempitd);
}
}
else
{
var tempitd = new ItemTrackerData();
tempitd.setErrorData(spData.getErrorDetails());
tgdList.Add(tempitd);
}
return(tgdList);
}
//sp_ws_insert_test_recovery_item
//sp_ws_get_test_recovery_item
public List <RecoveryTestItemData> getTestRecoveryItemData(int ouId)
{
List <RecoveryTestItemData> rtItemList = new List <RecoveryTestItemData>();
object[] arg = new Object[1] {
ouId
};
StoredProcedureGrab storedprocedure = new StoredProcedureGrab(serverName, dbName, userName, passWord, "sp_ws_get_test_recovery_item", arg);
spData = storedprocedure.GetReader();
if (!spData.getErrorStatus())
{
foreach (DataRow row in spData.getDataTable().Rows)
{
var temprtItem = new RecoveryTestItemData();
temprtItem.setRecoveryTestItemData(
(Int64)row[0],
(int)row[1],
(int)row[2],
(int)row[3],
(Int64)row[4],
String.Format("{0:M/d/yyyy HH:mm:ss}", row[5]),
(string)row[6],
(string)row[7]);
rtItemList.Add(temprtItem);
}
}
else
{
var temprtItem = new RecoveryTestItemData();
temprtItem.setErrorData(spData.getErrorDetails());
rtItemList.Add(temprtItem);
}
return(rtItemList);
} //sp_ws_get_test_recovery_item
public List <String> getTestletsNames()
{
List <String> tltList = new List <String>();
object[] arg = new Object[] { };
StoredProcedureGrab storedprocedure = new StoredProcedureGrab(serverName, dbName, userName, passWord, "sp_ws_getTestletsNames", arg);
spData = storedprocedure.GetReader();
if (!spData.getErrorStatus())
{
foreach (DataRow row in spData.getDataTable().Rows)
{
tltList.Add((string)row[0]);
}
}
else
{
tltList.Add("error");
}
return(tltList);
}
