public static List <TestSuiteXTestCaseArchiveDataModel> GetEntityDetails(TestSuiteXTestCaseArchiveDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @" dbo.TestSuiteXTestCaseArchiveSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ReturnAuditInfo = returnAuditInfo , TestSuiteXTestCaseId = dataQuery.TestSuiteXTestCaseId , TestSuite = dataQuery.TestSuite , TestCase = dataQuery.TestCase , TestCaseStatus = dataQuery.TestCaseStatus , TestCasePriority = dataQuery.TestCasePriority }; List <TestSuiteXTestCaseArchiveDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <TestSuiteXTestCaseArchiveDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
protected override void ShowData(int testSuiteXTestCaseArchiveid) { //oDetailButtonPanel.SetId = SetId; var data = new TestSuiteXTestCaseArchiveDataModel(); data.TestSuiteXTestCaseArchiveId = testSuiteXTestCaseArchiveid; var dt = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseArchiveDataManager.GetDetails(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { var row = dt.Rows[0]; lblTestSuiteXTestCaseArchiveId.Text = Convert.ToString(row[TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseArchiveId]); lblRecordDate.Text = Convert.ToString(row[TestSuiteXTestCaseArchiveDataModel.DataColumns.RecordDate]); lblTestSuite.Text = Convert.ToString(row[TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuite]); lblTestCase.Text = Convert.ToString(row[TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCase]); lblTestCaseStatus.Text = Convert.ToString(row[TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseStatus]); lblTestCasePriority.Text = Convert.ToString(row[TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCasePriority]); lblTestSuiteXTestCaseId.Text = Convert.ToString(row[TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseId]); lblKnowledgeDate.Text = Convert.ToString(row[TestSuiteXTestCaseArchiveDataModel.DataColumns.KnowledgeDate]); oUpdateInfo.LoadText(dt.Rows[0]); oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.TestSuiteXTestCaseArchive, testSuiteXTestCaseArchiveid, "TestSuiteXTestCaseArchive"); dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "TestSuiteXTestCaseArchive"); } else { Clear(); } }
public static void Delete(TestSuiteXTestCaseArchiveDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TestSuiteXTestCaseArchiveDelete " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseArchiveId); DBDML.RunSQL("TestSuiteXTestCaseArchive.Delete", sql, DataStoreKey); }
private System.Data.DataTable GetData() { // TODO: on all export pages var data = new TestSuiteXTestCaseArchiveDataModel(); var dt = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseArchiveDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
private DataTable GetTestSuiteXTestCaseArchiveData(int TestSuiteXTestCaseId) { var data = new TestSuiteXTestCaseArchiveDataModel(); data.TestSuiteXTestCaseId = TestSuiteXTestCaseId; var dt = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseArchiveDataManager.SearchHistory(data, SessionVariables.RequestProfile); return(dt); }
public static DataTable Search(TestSuiteXTestCaseArchiveDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.TestSuiteXTestCaseArchiveSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseArchiveId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuite) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCase) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseStatus) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCasePriority) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseId); var oDT = new DBDataTable("TestSuiteXTestCaseArchive.Search", sql, DataStoreKey); return(oDT.DBTable); }
private static string CreateOrUpdate(TestSuiteXTestCaseArchiveDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.TestSuiteXTestCaseArchiveInsert "; break; case "Update": sql += "dbo.TestSuiteXTestCaseArchiveUpdate "; break; default: break; } sql = sql + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseArchiveId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseStatusId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCasePriorityId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.RecordDate) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.KnowledgeDate) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuite) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCase) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseStatus) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCasePriority) + ", " + ToSQLParameter(data, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseId); return(sql); }
public static string ToSQLParameter(TestSuiteXTestCaseArchiveDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseArchiveId: if (data.TestSuiteXTestCaseArchiveId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseArchiveId, data.TestSuiteXTestCaseArchiveId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseArchiveId); } break; case TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseId: if (data.TestSuiteXTestCaseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseId, data.TestSuiteXTestCaseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteXTestCaseId); } break; case TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteId: if (data.TestSuiteId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteId, data.TestSuiteId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuiteId); } break; case TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseId: if (data.TestCaseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseId, data.TestCaseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseId); } break; case TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseStatusId: if (data.TestCaseStatusId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseStatusId, data.TestCaseStatusId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseStatusId); } break; case TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCasePriorityId: if (data.TestCasePriorityId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCasePriorityId, data.TestCasePriorityId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCasePriorityId); } break; case TestSuiteXTestCaseArchiveDataModel.DataColumns.RecordDate: if (data.RecordDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseArchiveDataModel.DataColumns.RecordDate, data.RecordDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseArchiveDataModel.DataColumns.RecordDate); } break; case TestSuiteXTestCaseArchiveDataModel.DataColumns.KnowledgeDate: if (data.KnowledgeDate != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseArchiveDataModel.DataColumns.KnowledgeDate, data.KnowledgeDate); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseArchiveDataModel.DataColumns.KnowledgeDate); } break; case TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuite: if (!string.IsNullOrEmpty(data.TestSuite)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuite, data.TestSuite); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestSuite); } break; case TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCase: if (!string.IsNullOrEmpty(data.TestCase)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCase, data.TestCase); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCase); } break; case TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseStatus: if (!string.IsNullOrEmpty(data.TestCase)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseStatus, data.TestCaseStatus); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCaseStatus); } break; case TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCasePriority: if (!string.IsNullOrEmpty(data.TestCasePriority)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TestSuiteXTestCaseDataModel.DataColumns.TestCasePriority, data.TestCasePriority); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseArchiveDataModel.DataColumns.TestCasePriority); } break; } return(returnValue); }
public static void Update(TestSuiteXTestCaseArchiveDataModel data, RequestProfile requestProfile) { var sql = CreateOrUpdate(data, requestProfile, "Update"); DBDML.RunSQL("TestSuiteXTestCaseArchive.Update", sql, DataStoreKey); }
public static TestSuiteXTestCaseArchiveDataModel GetDetails(TestSuiteXTestCaseArchiveDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }