private static string Save(UseCasePackageXUseCaseDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.UseCasePackageXUseCaseInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.UseCasePackageXUseCaseUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageXUseCaseId) + ", " + ToSQLParameter(data, UseCasePackageXUseCaseDataModel.DataColumns.UseCaseId) + ", " + ToSQLParameter(data, UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageId); return(sql); }
private System.Data.DataTable GetData() { var data = new UseCasePackageXUseCaseDataModel(); var dt = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
protected override void ShowData(int useCasePackageXUseCaseId) { oDetailButtonPanel.SetId = SetId; var data = new UseCasePackageXUseCaseDataModel(); data.UseCasePackageXUseCaseId = useCasePackageXUseCaseId; var dt = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.GetDetails(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { var row = dt.Rows[0]; lblUseCasePackageXUseCaseId.Text = Convert.ToString(row[UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageXUseCaseId]); lblUseCasePackage.Text = Convert.ToString(row[UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackage]); lblUseCase.Text = Convert.ToString(row[UseCasePackageXUseCaseDataModel.DataColumns.UseCase]); oUpdateInfo.LoadText(dt.Rows[0]); oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.UseCasePackageXUseCase, useCasePackageXUseCaseId, "UseCasePackageXUseCase"); dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "UseCasePackageXUseCase"); } else { Clear(); } }
protected override DataTable UpdateData() { var UpdatedData = new DataTable(); var data = new UseCasePackageXUseCaseDataModel(); UpdatedData = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.Search(data, SessionVariables.RequestProfile).Clone(); for (var i = 0; i < SelectedData.Rows.Count; i++) { data.UseCasePackageXUseCaseId = Convert.ToInt32(SelectedData.Rows[i][UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageXUseCaseId].ToString()); data.UseCasePackageId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageId).ToString()) : int.Parse(SelectedData.Rows[i][UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageId].ToString()); data.UseCaseId = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(UseCasePackageXUseCaseDataModel.DataColumns.UseCaseId)) ? int.Parse(CheckAndGetRepeaterTextBoxValue(UseCasePackageXUseCaseDataModel.DataColumns.UseCaseId).ToString()) : int.Parse(SelectedData.Rows[i][UseCasePackageXUseCaseDataModel.DataColumns.UseCaseId].ToString()); TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.Update(data, SessionVariables.RequestProfile); data = new UseCasePackageXUseCaseDataModel(); data.UseCasePackageXUseCaseId = Convert.ToInt32(SelectedData.Rows[i][UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageXUseCaseId].ToString()); var dt = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { UpdatedData.ImportRow(dt.Rows[0]); } } return(UpdatedData); }
public static void Delete(UseCasePackageXUseCaseDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.UseCasePackageXUseCaseDelete " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageXUseCaseId); Framework.Components.DataAccess.DBDML.RunSQL("UseCasePackageXUseCase.Delete", sql, DataStoreKey); }
protected override DataTable GetEntityData(int?entityKey) { var useCasePackageXUseCasedata = new UseCasePackageXUseCaseDataModel(); useCasePackageXUseCasedata.UseCasePackageXUseCaseId = entityKey; var results = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.Search(useCasePackageXUseCasedata, SessionVariables.RequestProfile); return(results); }
protected override void Update(Dictionary <string, string> values) { var data = new UseCasePackageXUseCaseDataModel(); data.UseCasePackageXUseCaseId = int.Parse(values[UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageXUseCaseId].ToString()); data.UseCasePackageId = int.Parse(values[UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageId].ToString()); data.UseCaseId = int.Parse(values[UseCasePackageXUseCaseDataModel.DataColumns.UseCaseId].ToString()); TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.Update(data, SessionVariables.RequestProfile); base.Update(values); }
public static DataTable Search(UseCasePackageXUseCaseDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.UseCasePackageXUseCaseSearch " + " " + BaseDataManager.SetCommonParametersForSearch(requestProfile.AuditId, requestProfile.ApplicationId, requestProfile.ApplicationModeId) + ", " + ToSQLParameter(data, UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageId) + ", " + ToSQLParameter(data, UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageXUseCaseId) + ", " + ToSQLParameter(data, UseCasePackageXUseCaseDataModel.DataColumns.UseCaseId); var oDT = new Framework.Components.DataAccess.DBDataTable("UseCasePackageXUseCase.Search", sql, DataStoreKey); return(oDT.DBTable); }
public override int?Save(string action) { var data = new UseCasePackageXUseCaseDataModel(); data.UseCasePackageXUseCaseId = UseCasePackageXUseCaseId; data.UseCaseId = UseCaseId; data.UseCasePackageId = UseCasePackageId; if (action == "Insert") { TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.Create(data, SessionVariables.RequestProfile); } else { TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.Update(data, SessionVariables.RequestProfile); } return(UseCasePackageXUseCaseId); }
protected void btnDelete_Click(object sender, EventArgs e) { try { var deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new UseCasePackageXUseCaseDataModel(); data.UseCasePackageXUseCaseId = int.Parse(index); TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.Delete(data, SessionVariables.RequestProfile); } Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.UseCasePackageXUseCase, SessionVariables.RequestProfile); Response.Redirect(Page.GetRouteUrl("UseCasePackageXUseCaseEntityRoute", new { Action = "Default", SetId = true }), false); } catch (Exception ex) { Response.Write(ex.Message); } }
public void LoadData(int useCasePackageXUseCaseId, bool showId) { var data = new UseCasePackageXUseCaseDataModel(); data.UseCasePackageXUseCaseId = useCasePackageXUseCaseId; var oUseCasePackageXUseCaseTable = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.GetDetails(data, SessionVariables.RequestProfile); if (oUseCasePackageXUseCaseTable.Rows.Count == 1) { var row = oUseCasePackageXUseCaseTable.Rows[0]; if (!showId) { txtUseCasePackageXUseCaseId.Text = Convert.ToString(row[UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageXUseCaseId]); dynAuditHistory.Visible = true; oHistoryList.Setup((int)Framework.Components.DataAccess.SystemEntity.UseCasePackageXUseCase, useCasePackageXUseCaseId, "UseCasePackageXUseCase"); dynAuditHistory.Visible = PerferenceUtility.GetUserPreferenceByKeyAsBoolean(ApplicationCommon.HistoryGridVisibilityKey, "UseCasePackageXUseCase"); } else { txtUseCasePackageXUseCaseId.Text = String.Empty; } txtUseCasePackageId.Text = Convert.ToString(row[UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageId]); txtUseCaseId.Text = Convert.ToString(row[UseCasePackageXUseCaseDataModel.DataColumns.UseCaseId]); drpUseCaseList.SelectedValue = Convert.ToString(row[UseCasePackageXUseCaseDataModel.DataColumns.UseCaseId]); drpUseCasePackageList.SelectedValue = Convert.ToString(row[UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageId]); oUpdateInfo.LoadText(oUseCasePackageXUseCaseTable.Rows[0]); } else { txtUseCasePackageXUseCaseId.Text = String.Empty; txtUseCaseId.Text = String.Empty; txtUseCasePackageId.Text = String.Empty; } }
protected override DataTable GetData() { try { SuperKey = ApplicationCommon.GetSuperKey(); SetId = ApplicationCommon.GetSetId(); var selectedrows = new DataTable(); var useCasePackageXUseCasedata = new UseCasePackageXUseCaseDataModel(); selectedrows = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.GetDetails(useCasePackageXUseCasedata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var systemEntityTypeId = (int)PrimaryEntity; var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey); foreach (var entityKey in lstEntityKeys) { useCasePackageXUseCasedata.UseCasePackageXUseCaseId = entityKey; var result = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.GetDetails(useCasePackageXUseCasedata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } } else if (SetId != 0) { useCasePackageXUseCasedata.UseCasePackageXUseCaseId = SetId; var result = TaskTimeTracker.Components.BusinessLayer.RequirementAnalysis.UseCasePackageXUseCaseDataManager.GetDetails(useCasePackageXUseCasedata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } return(selectedrows); } catch (Exception ex) { Response.Write(ex.Message); } return(null); }
public static List <UseCasePackageXUseCaseDataModel> GetEntityDetails(UseCasePackageXUseCaseDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.UseCasePackageXUseCaseSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ReturnAuditInfo = returnAuditInfo , UseCasePackageId = dataQuery.UseCasePackageId , UseCasePackageXUseCaseId = dataQuery.UseCasePackageXUseCaseId , UseCaseId = dataQuery.UseCaseId }; List <UseCasePackageXUseCaseDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <UseCasePackageXUseCaseDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static void Update(UseCasePackageXUseCaseDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); Framework.Components.DataAccess.DBDML.RunSQL("UseCasePackageXUseCase.Update", sql, DataStoreKey); }
public static string ToSQLParameter(UseCasePackageXUseCaseDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageXUseCaseId: if (data.UseCasePackageXUseCaseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageXUseCaseId, data.UseCasePackageXUseCaseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageXUseCaseId); } break; case UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageId: if (data.UseCasePackageId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageId, data.UseCasePackageId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackageId); } break; case UseCasePackageXUseCaseDataModel.DataColumns.UseCaseId: if (data.UseCaseId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, UseCasePackageXUseCaseDataModel.DataColumns.UseCaseId, data.UseCaseId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCasePackageXUseCaseDataModel.DataColumns.UseCaseId); } break; case UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackage: if (!string.IsNullOrEmpty(data.UseCasePackage)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackage, data.UseCasePackage); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCasePackageXUseCaseDataModel.DataColumns.UseCasePackage); } break; case UseCasePackageXUseCaseDataModel.DataColumns.UseCase: if (!string.IsNullOrEmpty(data.UseCase)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, UseCasePackageXUseCaseDataModel.DataColumns.UseCase, data.UseCase); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, UseCasePackageXUseCaseDataModel.DataColumns.UseCase); } break; } return(returnValue); }
public static UseCasePackageXUseCaseDataModel GetDetails(UseCasePackageXUseCaseDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }