private static string CreateOrUpdate(TestSuiteXTestCaseDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.TestSuiteXTestCaseInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.TestSuiteXTestCaseUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestSuiteXTestCaseId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestSuiteId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestCaseId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestCasePriorityId); return(sql); }
public override int?Save(string action) { var data = new TestSuiteXTestCaseDataModel(); data.TestSuiteXTestCaseId = TestSuiteXTestCaseId; data.TestSuiteId = TestSuiteId; data.TestCaseId = TestCaseId; data.TestCasePriorityId = TestCasePriorityId; data.TestCaseStatusId = TestCaseStatusId; if (action == "Insert") { var dtTestSuiteXTestCase = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.DoesExist(data, SessionVariables.RequestProfile); if (dtTestSuiteXTestCase.Rows.Count == 0) { TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.Create(data, SessionVariables.RequestProfile); } else { throw new Exception("Record with given ID already exists."); } } else { TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.Update(data, SessionVariables.RequestProfile); } // not correct ... when doing insert, we didn't get/change the value of TestSuiteXTestCaseID ? return(TestSuiteXTestCaseId); }
public static List <TestSuiteXTestCaseDataModel> GetEntityList(TestSuiteXTestCaseDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @" dbo.TestSuiteXTestCaseSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ReturnAuditInfo = returnAuditInfo , TestSuiteXTestCaseId = dataQuery.TestSuiteXTestCaseId , TestSuiteId = dataQuery.TestSuiteId , TestCaseId = dataQuery.TestCaseId , TestCaseStatusId = dataQuery.TestCaseStatusId , TestCasePriorityId = dataQuery.TestCasePriorityId }; List <TestSuiteXTestCaseDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <TestSuiteXTestCaseDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
protected override void ShowData(int testSuiteXTestCaseId) { base.ShowData(testSuiteXTestCaseId); oDetailButtonPanel.SetId = SetId; Clear(); var dataQuery = new TestSuiteXTestCaseDataModel(); dataQuery.TestSuiteXTestCaseId = testSuiteXTestCaseId; var entityList = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.GetEntityList(dataQuery, SessionVariables.RequestProfile); if (entityList.Count == 1) { foreach (var entityItem in entityList) { lblTestSuiteXTestCaseId.Text = entityItem.TestSuiteXTestCaseId.ToString(); lblTestCaseId.Text = entityItem.TestCaseId.ToString(); lblTestSuiteId.Text = entityItem.TestSuiteId.ToString(); lblTestCaseStatusId.Text = entityItem.TestCaseStatusId.ToString(); lblTestCasePriorityId.Text = entityItem.TestCasePriorityId.ToString(); oUpdateInfo.LoadText(entityItem.UpdatedDate, entityItem.UpdatedBy, entityItem.LastAction); oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.TestSuiteXTestCase, testSuiteXTestCaseId, "TestSuiteXTestCase"); } } }
public static void Delete(TestSuiteXTestCaseDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TestSuiteXTestCaseDelete " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestSuiteXTestCaseId); DBDML.RunSQL("TestSuiteXTestCase.Delete", sql, DataStoreKey); }
protected override void Update(Dictionary <string, string> values) { var data = new TestSuiteXTestCaseDataModel(); PropertyMapper.CopyProperties(data, values); TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.Update(data, SessionVariables.RequestProfile); base.Update(values); }
private System.Data.DataTable GetData() { // TODO: on all export pages var data = new TestSuiteXTestCaseDataModel(); var dt = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override void Clear() { base.Clear(); var data = new TestSuiteXTestCaseDataModel(); TestSuiteXTestCaseId = data.TestSuiteXTestCaseId; TestSuiteId = data.TestSuiteId; TestCaseId = data.TestCaseId; TestCaseStatusId = data.TestCaseStatusId; TestCasePriorityId = data.TestCasePriorityId; }
protected override void OnInit(EventArgs e) { try { DynamicUpdatePanel.AddColumns(GetColumns()); SuperKey = ApplicationCommon.GetSuperKey(); SetId = ApplicationCommon.GetSetId(); var key = 0; var TestSuiteXTestCasedata = new TestSuiteXTestCaseDataModel(); var results = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.Search(TestSuiteXTestCasedata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var data = new SuperKeyDetailDataModel(); data.SuperKeyId = Convert.ToInt32(SuperKey); // Change System Entity Type data.SystemEntityTypeId = (int)Framework.Components.DataAccess.SystemEntity.TestSuiteXTestCase; var dt = Framework.Components.Core.SuperKeyDetailDataManager.Search(data, SessionVariables.RequestProfile); if (dt != null && dt.Rows.Count > 0) { foreach (System.Data.DataRow dr in dt.Rows) { key = Convert.ToInt32(dr[SuperKeyDetailDataModel.DataColumns.EntityKey]); TestSuiteXTestCasedata.TestSuiteXTestCaseId = key; var TestSuiteXTestCasedt = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.Search(TestSuiteXTestCasedata, SessionVariables.RequestProfile); if (TestSuiteXTestCasedt.Rows.Count == 1) { results.ImportRow(TestSuiteXTestCasedt.Rows[0]); } } } } else { key = SetId; TestSuiteXTestCasedata.TestSuiteXTestCaseId = key; var TestSuiteXTestCasedt = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.Search(TestSuiteXTestCasedata, SessionVariables.RequestProfile); if (TestSuiteXTestCasedt.Rows.Count == 1) { results.ImportRow(TestSuiteXTestCasedt.Rows[0]); } } SelectedData = new DataTable(); SelectedData = results.Copy(); base.OnInit(e); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); //throw } }
public static bool DoesExist(TestSuiteXTestCaseDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.TestSuiteXTestCaseSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestSuiteXTestCaseId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestSuiteId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestCaseId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestCasePriorityId); var oDT = new DBDataTable("TestSuiteXTestCase.DoesExist", sql, DataStoreKey); return(oDT.DBTable.Rows.Count > 0); }
public static DataTable Search(TestSuiteXTestCaseDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.TestSuiteXTestCaseSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestSuiteXTestCaseId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestSuiteId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestCaseId) + //", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusList) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusId) + ", " + ToSQLParameter(data, TestSuiteXTestCaseDataModel.DataColumns.TestCasePriorityId); var oDT = new DBDataTable("TestSuiteXTestCase.Search", sql, DataStoreKey); return(oDT.DBTable); }
override protected void btnUpdate_Click(object sender, EventArgs e) { var UpdatedData = new DataTable(); var data = new TestSuiteXTestCaseDataModel(); UpdatedData = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.Search(data, SessionVariables.RequestProfile).Clone(); for (var i = 0; i < SelectedData.Rows.Count; i++) { data.TestSuiteXTestCaseId = Convert.ToInt32(SelectedData.Rows[i][TestSuiteXTestCaseDataModel.DataColumns.TestSuiteXTestCaseId].ToString()); data.TestSuiteId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(TestSuiteXTestCaseDataModel.DataColumns.TestSuiteId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(TestSuiteXTestCaseDataModel.DataColumns.TestSuiteId).ToString()) : int.Parse(SelectedData.Rows[i][TestSuiteXTestCaseDataModel.DataColumns.TestSuiteId].ToString()); data.TestCaseId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(TestSuiteXTestCaseDataModel.DataColumns.TestCaseId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(TestSuiteXTestCaseDataModel.DataColumns.TestCaseId).ToString()) : int.Parse(SelectedData.Rows[i][TestSuiteXTestCaseDataModel.DataColumns.TestCaseId].ToString()); data.TestCaseStatusId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusId).ToString()) : int.Parse(SelectedData.Rows[i][TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusId].ToString()); data.TestCasePriorityId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(TestSuiteXTestCaseDataModel.DataColumns.TestCasePriorityId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(TestSuiteXTestCaseDataModel.DataColumns.TestCasePriorityId).ToString()) : int.Parse(SelectedData.Rows[i][TestSuiteXTestCaseDataModel.DataColumns.TestCasePriorityId].ToString()); TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.Update(data, SessionVariables.RequestProfile); data = new TestSuiteXTestCaseDataModel(); data.TestSuiteXTestCaseId = Convert.ToInt32(SelectedData.Rows[i][TestSuiteXTestCaseDataModel.DataColumns.TestSuiteXTestCaseId].ToString()); var dt = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { UpdatedData.ImportRow(dt.Rows[0]); } // if everything is done and good THEN move from thsi page. //Response.Redirect("Default.aspx?Added=" + true, false); } DynamicUpdatePanel.SetUp(GetColumns(), "TestSuiteXTestCase", UpdatedData); }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new TestSuiteXTestCaseDataModel(); data.TestSuiteXTestCaseId = int.Parse(index); TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.Delete(data, SessionVariables.RequestProfile); } DeleteAndRedirect(); } catch (Exception ex) { Response.Write(ex.Message); } }
public void LoadData(int testSuiteXTestCaseId, bool showId) { // clear UI Clear(); // set up parameters var data = new TestSuiteXTestCaseDataModel(); data.TestSuiteXTestCaseId = testSuiteXTestCaseId; // get data var items = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.GetEntityList(data, SessionVariables.RequestProfile); // should only have single match -- should log exception. if (items.Count != 1) { return; } var item = items[0]; TestSuiteXTestCaseId = item.TestSuiteXTestCaseId; TestSuiteId = item.TestSuiteId; TestCaseId = item.TestCaseId; TestCaseStatusId = item.TestCaseStatusId; TestCasePriorityId = item.TestCasePriorityId; if (!showId) { txtTestSuiteXTestCaseId.Text = item.TestSuiteXTestCaseId.ToString(); //PlaceHolderAuditHistory.Visible = true; // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup(PrimaryEntity, testSuiteXTestCaseId, PrimaryEntityKey); } else { txtTestSuiteXTestCaseId.Text = String.Empty; } oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); }
protected override DataTable GetData() { try { SuperKey = ApplicationCommon.GetSuperKey(); SetId = ApplicationCommon.GetSetId(); var selectedrows = new DataTable(); var testSuiteXTestCasedata = new TestSuiteXTestCaseDataModel(); selectedrows = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.GetDetails(testSuiteXTestCasedata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var systemEntityTypeId = (int)PrimaryEntity; var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey); foreach (var entityKey in lstEntityKeys) { testSuiteXTestCasedata.TestSuiteXTestCaseId = entityKey; var result = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.GetDetails(testSuiteXTestCasedata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } } else { testSuiteXTestCasedata.TestSuiteXTestCaseId = SetId; var result = TestCaseManagement.Components.DataAccess.TestSuiteXTestCaseDataManager.GetDetails(testSuiteXTestCasedata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } return(selectedrows); } catch (Exception ex) { Response.Write(ex.Message); } return(null); }
public static TestSuiteXTestCaseDataModel GetDetails(TestSuiteXTestCaseDataModel data, RequestProfile requestProfile) { var list = GetEntityList(data, requestProfile); return(list.FirstOrDefault()); }
public static void Update(TestSuiteXTestCaseDataModel data, RequestProfile requestProfile) { var sql = CreateOrUpdate(data, requestProfile, "Update"); DBDML.RunSQL("TestSuiteXTestCase.Update", sql, DataStoreKey); }
public static string ToSQLParameter(TestSuiteXTestCaseDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case TestSuiteXTestCaseDataModel.DataColumns.TestSuiteXTestCaseId: if (data.TestSuiteXTestCaseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseDataModel.DataColumns.TestSuiteXTestCaseId, data.TestSuiteXTestCaseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseDataModel.DataColumns.TestSuiteXTestCaseId); } break; case TestSuiteXTestCaseDataModel.DataColumns.TestSuiteId: if (data.TestSuiteId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseDataModel.DataColumns.TestSuiteId, data.TestSuiteId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseDataModel.DataColumns.TestSuiteId); } break; case TestSuiteXTestCaseDataModel.DataColumns.TestCaseId: if (data.TestCaseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseDataModel.DataColumns.TestCaseId, data.TestCaseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseDataModel.DataColumns.TestCaseId); } break; case TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusId: if (data.TestCaseStatusId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusId, data.TestCaseStatusId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusId); } break; case TestSuiteXTestCaseDataModel.DataColumns.TestCasePriorityId: if (data.TestCasePriorityId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, TestSuiteXTestCaseDataModel.DataColumns.TestCasePriorityId, data.TestCasePriorityId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseDataModel.DataColumns.TestCasePriorityId); } break; case TestSuiteXTestCaseDataModel.DataColumns.TestSuite: if (!string.IsNullOrEmpty(data.TestSuite)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TestSuiteXTestCaseDataModel.DataColumns.TestSuite, data.TestSuite); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseDataModel.DataColumns.TestSuite); } break; case TestSuiteXTestCaseDataModel.DataColumns.TestCase: if (!string.IsNullOrEmpty(data.TestCase)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TestSuiteXTestCaseDataModel.DataColumns.TestCase, data.TestCase); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseDataModel.DataColumns.TestCase); } break; case TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatus: if (!string.IsNullOrEmpty(data.TestCase)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatus, data.TestCaseStatus); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatus); } break; case TestSuiteXTestCaseDataModel.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, TestSuiteXTestCaseDataModel.DataColumns.TestCasePriority); } break; case TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusList: if (!string.IsNullOrEmpty(data.TestCaseStatusList)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusList, data.TestCaseStatusList); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, TestSuiteXTestCaseDataModel.DataColumns.TestCaseStatusList); } break; } return(returnValue); }