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