public static List <FunctionalityOwnerDataModel> GetEntityDetails(FunctionalityOwnerDataModel dataQuery, RequestProfile requestedProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.FunctionalityOwnerSearch "; var parameters = new { AuditId = requestedProfile.AuditId , ApplicationId = dataQuery.ApplicationId , FunctionalityId = dataQuery.FunctionalityId , FunctionalityOwnerId = dataQuery.FunctionalityOwnerId , DeveloperRoleId = dataQuery.DeveloperRoleId , Developer = dataQuery.Developer , FeatureOwnerStatusId = dataQuery.FeatureOwnerStatusId , ReturnAuditInfo = returnAuditInfo }; List <FunctionalityOwnerDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <FunctionalityOwnerDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
private static string Save(FunctionalityOwnerDataModel data, RequestProfile requestedProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.FunctionalityOwnerInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestedProfile.AuditId) + ", " + ToSQLParameter(FunctionalityOwnerDataModel.DataColumns.ApplicationId, requestedProfile.ApplicationId); break; case "Update": sql += "dbo.FunctionalityOwnerUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestedProfile.AuditId) + ", " + ToSQLParameter(data, FunctionalityOwnerDataModel.DataColumns.ApplicationId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, FunctionalityOwnerDataModel.DataColumns.FunctionalityOwnerId) + ", " + ToSQLParameter(data, FunctionalityOwnerDataModel.DataColumns.FunctionalityId) + ", " + ToSQLParameter(data, FunctionalityOwnerDataModel.DataColumns.DeveloperRoleId) + ", " + ToSQLParameter(data, FunctionalityOwnerDataModel.DataColumns.Developer) + ", " + ToSQLParameter(data, FunctionalityOwnerDataModel.DataColumns.FeatureOwnerStatusId); return(sql); }
public override int?Save(string action) { var data = new FunctionalityOwnerDataModel(); data.FunctionalityOwnerId = FunctionalityOwnerId; data.DeveloperRoleId = DeveloperRoleId; data.FunctionalityId = FunctionalityId; data.FeatureOwnerStatusId = FeatureOwnerStatusId; data.Developer = Developer; data.ApplicationId = ApplicationId; if (action == "Insert") { var dtEntityOwner = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityOwnerDataManager.DoesExist(data, SessionVariables.RequestProfile); if (dtEntityOwner.Rows.Count == 0) { TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityOwnerDataManager.Create(data, SessionVariables.RequestProfile); } else { throw new Exception("Record with given ID already exists."); } } else { TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityOwnerDataManager.Update(data, SessionVariables.RequestProfile); } return(data.FunctionalityOwnerId); }
protected override void ShowData(int functionalityOwnerId) { oDetailButtonPanel.SetId = SetId; var data = new FunctionalityOwnerDataModel(); data.FunctionalityOwnerId = functionalityOwnerId; var items = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityOwnerDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); if (items.Count == 1) { var item = items[0]; lblFunctionalityOwnerId.Text = Convert.ToString(item.FunctionalityOwnerId); lblFunctionalityId.Text = Convert.ToString(item.Functionality); lblDevelperRoleId.Text = Convert.ToString(item.DeveloperRole); lblDeveloper.Text = Convert.ToString(item.Developer); lblFeatureOwnerStatusId.Text = Convert.ToString(item.FeatureOwnerStatus); oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); oHistoryList.Setup(PrimaryEntity, functionalityOwnerId, "FunctionalityOwner"); } else { Clear(); } }
protected override DataTable UpdateData() { var UpdatedData = new DataTable(); var data = new FunctionalityOwnerDataModel(); UpdatedData = FunctionalityOwnerDataManager.Search(data, SessionVariables.RequestProfile).Clone(); for (var i = 0; i < SelectedData.Rows.Count; i++) { data.FunctionalityOwnerId = Convert.ToInt32(SelectedData.Rows[i][FunctionalityOwnerDataModel.DataColumns.FunctionalityOwnerId].ToString()); data.FunctionalityId = Convert.ToInt32(SelectedData.Rows[i][FunctionalityOwnerDataModel.DataColumns.FunctionalityId].ToString()); data.FeatureOwnerStatusId = Convert.ToInt32(SelectedData.Rows[i][FunctionalityOwnerDataModel.DataColumns.FeatureOwnerStatusId].ToString()); data.Developer = !string.IsNullOrEmpty(CheckAndGetRepeaterTextBoxValue(FunctionalityOwnerDataModel.DataColumns.Developer)) ? CheckAndGetRepeaterTextBoxValue(FunctionalityOwnerDataModel.DataColumns.Developer) : SelectedData.Rows[i][FunctionalityOwnerDataModel.DataColumns.Developer].ToString(); data.ApplicationId = Convert.ToInt32(SelectedData.Rows[i][BaseDataModel.BaseDataColumns.ApplicationId].ToString()); data.FeatureOwnerStatusId = Convert.ToInt32(SelectedData.Rows[i][FunctionalityOwnerDataModel.DataColumns.FeatureOwnerStatusId].ToString()); FunctionalityOwnerDataManager.Update(data, SessionVariables.RequestProfile); data = new FunctionalityOwnerDataModel(); data.FunctionalityOwnerId = Convert.ToInt32(SelectedData.Rows[i][FunctionalityOwnerDataModel.DataColumns.FunctionalityOwnerId].ToString()); var dt = FunctionalityOwnerDataManager.Search(data, SessionVariables.RequestProfile); if (dt.Rows.Count == 1) { UpdatedData.ImportRow(dt.Rows[0]); } } return(UpdatedData); }
private DataTable GetData() { var data = new FunctionalityOwnerDataModel(); var dt = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityOwnerDataManager.Search(data, SessionVariables.RequestProfile); return(dt); }
public static DataTable Search(FunctionalityOwnerDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 0); var table = list.ToDataTable(); return(table); }
protected override DataTable GetEntityData(int?entityKey) { var FunctionalityOwnerdata = new FunctionalityOwnerDataModel(); FunctionalityOwnerdata.FunctionalityOwnerId = entityKey; var results = FunctionalityOwnerDataManager.Search(FunctionalityOwnerdata, SessionVariables.RequestProfile); return(results); }
protected override void Update(Dictionary <string, string> values) { var data = new FunctionalityOwnerDataModel(); // copies properties from values dictionary object to data object PropertyMapper.CopyProperties(data, values); TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityOwnerDataManager.Update(data, SessionVariables.RequestProfile); base.Update(values); }
public static bool DoesExist(FunctionalityOwnerDataModel data, RequestProfile requestProfile) { var doesExistRequest = new FunctionalityOwnerDataModel(); doesExistRequest.Name = data.Name; doesExistRequest.FunctionalityId = data.FunctionalityId; doesExistRequest.Developer = data.Developer; doesExistRequest.ApplicationId = data.ApplicationId; var list = GetEntityDetails(doesExistRequest, requestProfile, 0); return(list.Count > 0); }
protected override void Clear() { base.Clear(); var data = new FunctionalityOwnerDataModel(); FunctionalityOwnerId = data.FunctionalityOwnerId; FunctionalityId = data.FunctionalityId; DeveloperRoleId = data.DeveloperRoleId; Developer = data.Developer; FeatureOwnerStatusId = data.FeatureOwnerStatusId; ApplicationId = data.ApplicationId; }
public static void Delete(FunctionalityOwnerDataModel dataQuery, RequestProfile requestedProfile) { const string sql = @"dbo.FunctionalityOwnerDelete "; var parameters = new { AuditId = requestedProfile.AuditId , FunctionalityOwnerId = dataQuery.FunctionalityOwnerId }; using (var dataAccess = new DataAccessBase(DataStoreKey)) { dataAccess.Connection.Execute(sql, parameters, commandType: CommandType.StoredProcedure); } }
public void LoadData(int functionalityOwnerId, bool showId) { // clear UI Clear(); // set up parameters var data = new FunctionalityOwnerDataModel(); data.FunctionalityOwnerId = functionalityOwnerId; // get data var items = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityOwnerDataManager.GetEntityDetails(data, SessionVariables.RequestProfile); // should only have single match -- should log exception. if (items.Count != 1) { return; } var item = items[0]; txtDeveloper.Text = item.Developer.ToString(); txtFunctionality.Text = item.Functionality.ToString(); txtDeveloperRole.Text = item.DeveloperRole.ToString(); txtFeatureOwnerStatus.Text = item.FeatureOwnerStatus.ToString(); drpFunctionalityList.SelectedValue = item.FunctionalityId.ToString(); drpDeveloperRoleList.SelectedValue = item.DeveloperRoleId.ToString(); drpFeatureOwnerStatusList.SelectedValue = item.FeatureOwnerStatusId.ToString(); if (!showId) { txtFunctionalityOwnerId.Text = item.FunctionalityOwnerId.ToString(); //PlaceHolderAuditHistory.Visible = true; // only show Audit History in case of Update page, not for Clone. oHistoryList.Setup(PrimaryEntity, functionalityOwnerId, PrimaryEntityKey); } else { txtFunctionalityOwnerId.Text = String.Empty; } oUpdateInfo.LoadText(item.UpdatedDate, item.UpdatedBy, item.LastAction); }
protected void btnDelete_Click(object sender, EventArgs e) { try { string[] deleteIndexList = DeleteIds.Split(','); foreach (string index in deleteIndexList) { var data = new FunctionalityOwnerDataModel(); data.FunctionalityOwnerId = int.Parse(index); TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityOwnerDataManager.Delete(data, SessionVariables.RequestProfile); } Framework.Components.Audit.AuditHistoryDataManager.DeleteDataBySystemEntity(DeleteIds, (int)Framework.Components.DataAccess.SystemEntity.FunctionalityOwner, SessionVariables.RequestProfile); Response.Redirect(Page.GetRouteUrl("FunctionalityOwnerEntityRoute", new { Action = "Default", SetId = true }), false); } catch (Exception ex) { Response.Write(ex.Message); } }
protected override DataTable GetData() { try { SuperKey = ApplicationCommon.GetSuperKey(); SetId = ApplicationCommon.GetSetId(); var selectedrows = new DataTable(); var FunctionalityOwnerdata = new FunctionalityOwnerDataModel(); selectedrows = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityOwnerDataManager.GetDetails(FunctionalityOwnerdata, SessionVariables.RequestProfile).Clone(); if (!string.IsNullOrEmpty(SuperKey)) { var systemEntityTypeId = (int)PrimaryEntity; var lstEntityKeys = ApplicationCommon.GetSuperKeyDetails(systemEntityTypeId, SuperKey); foreach (var entityKey in lstEntityKeys) { FunctionalityOwnerdata.FunctionalityOwnerId = entityKey; var result = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityOwnerDataManager.GetDetails(FunctionalityOwnerdata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } } else { FunctionalityOwnerdata.FunctionalityOwnerId = SetId; var result = TaskTimeTracker.Components.Module.ApplicationDevelopment.FunctionalityOwnerDataManager.GetDetails(FunctionalityOwnerdata, SessionVariables.RequestProfile); selectedrows.ImportRow(result.Rows[0]); } return(selectedrows); } catch (Exception ex) { Response.Write(ex.Message); } return(null); }
public static string ToSQLParameter(FunctionalityOwnerDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case FunctionalityOwnerDataModel.DataColumns.FunctionalityOwnerId: if (data.FunctionalityOwnerId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityOwnerDataModel.DataColumns.FunctionalityOwnerId, data.FunctionalityOwnerId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityOwnerDataModel.DataColumns.FunctionalityOwnerId); } break; case FunctionalityOwnerDataModel.DataColumns.FunctionalityId: if (data.FunctionalityId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityOwnerDataModel.DataColumns.FunctionalityId, data.FunctionalityId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityOwnerDataModel.DataColumns.FunctionalityId); } break; case FunctionalityOwnerDataModel.DataColumns.DeveloperRoleId: if (data.DeveloperRoleId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityOwnerDataModel.DataColumns.DeveloperRoleId, data.DeveloperRoleId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityOwnerDataModel.DataColumns.DeveloperRoleId); } break; case FunctionalityOwnerDataModel.DataColumns.Developer: if (data.Developer != null && !string.IsNullOrEmpty(data.Developer)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityOwnerDataModel.DataColumns.Developer, data.Developer); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityOwnerDataModel.DataColumns.Developer); } break; case FunctionalityOwnerDataModel.DataColumns.FeatureOwnerStatusId: if (data.FeatureOwnerStatusId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityOwnerDataModel.DataColumns.FeatureOwnerStatusId, data.FeatureOwnerStatusId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityOwnerDataModel.DataColumns.FeatureOwnerStatusId); } break; case FunctionalityOwnerDataModel.DataColumns.Functionality: if (data.Functionality != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityOwnerDataModel.DataColumns.Functionality, data.Functionality); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityOwnerDataModel.DataColumns.Functionality); } break; case FunctionalityOwnerDataModel.DataColumns.DeveloperRole: if (data.DeveloperRole != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityOwnerDataModel.DataColumns.DeveloperRole, data.DeveloperRole); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityOwnerDataModel.DataColumns.DeveloperRole); } break; case FunctionalityOwnerDataModel.DataColumns.FeatureOwnerStatus: if (data.FeatureOwnerStatus != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityOwnerDataModel.DataColumns.FeatureOwnerStatus, data.FeatureOwnerStatus); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityOwnerDataModel.DataColumns.FeatureOwnerStatus); } break; case FunctionalityOwnerDataModel.DataColumns.ApplicationId: if (data.ApplicationId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, FunctionalityOwnerDataModel.DataColumns.ApplicationId, data.ApplicationId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityOwnerDataModel.DataColumns.ApplicationId); } break; case FunctionalityOwnerDataModel.DataColumns.Application: if (!string.IsNullOrEmpty(data.Application)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, FunctionalityOwnerDataModel.DataColumns.Application, data.Application.Trim()); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, FunctionalityOwnerDataModel.DataColumns.Application); } break; default: returnValue = StandardDataManager.ToSQLParameter(data, dataColumnName); break; } return(returnValue); }
public static FunctionalityOwnerDataModel GetDetails(FunctionalityOwnerDataModel data, RequestProfile requestedProfile) { var list = GetEntityDetails(data, requestedProfile); return(list.FirstOrDefault()); }
public static void Update(FunctionalityOwnerDataModel data, RequestProfile requestedProfile) { var sql = Save(data, requestedProfile, "Update"); DBDML.RunSQL("FunctionalityOwner.Update", sql, DataStoreKey); }