private static string Save(ApplicationModeXRunTimeFeatureDataModel data, RequestProfile requestProfile, string action) { var sql = "EXEC "; switch (action) { case "Create": sql += "dbo.ApplicationModeXRunTimeFeatureInsert " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId); break; case "Update": sql += "dbo.ApplicationModeXRunTimeFeatureUpdate " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId); break; default: break; } sql = sql + ", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeXRunTimeFeatureId) + ", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeatureId) + ", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeId); return(sql); }
public static void Delete(ApplicationModeXRunTimeFeatureDataModel data, RequestProfile requestProfile) { var sql = "EXEC dbo.ApplicationModeXRunTimeFeatureDelete " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeXRunTimeFeatureId); DBDML.RunSQL("ApplicationModeXRunTimeFeature.Delete", sql, DataStoreKey); }
public static DataTable Search(ApplicationModeXRunTimeFeatureDataModel data, RequestProfile requestProfile) { // formulate SQL var sql = "EXEC dbo.ApplicationModeXRunTimeFeatureSearch " + " " + ToSQLParameter(BaseDataModel.BaseDataColumns.AuditId, requestProfile.AuditId) + ", " + ToSQLParameter(BaseDataModel.BaseDataColumns.ApplicationId, requestProfile.ApplicationId) + ", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeXRunTimeFeatureId) + ", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeId) + ", " + ToSQLParameter(data, ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeatureId); var oDT = new DBDataTable("ApplicationModeXRunTimeFeature.Search", sql, DataStoreKey); return(oDT.DBTable); }
private DataTable GetRunTimeFeatureData(int applicationModeId) { var data = new ApplicationModeXRunTimeFeatureDataModel(); data.ApplicationModeId = applicationModeId; var dt = TaskTimeTracker.Components.BusinessLayer.Feature.ApplicationModeXRunTimeFeatureDataManager.Search(data, SessionVariables.RequestProfile); var runTimeFeaturedt = TaskTimeTracker.Components.BusinessLayer.Feature.RunTimeFeatureDataManager.GetList(SessionVariables.RequestProfile); var resultdt = runTimeFeaturedt.Clone(); var runTimeIdColumn = RunTimeFeatureDataModel.DataColumns.RunTimeFeatureId; foreach (DataRow row in dt.Rows) { var rows = runTimeFeaturedt.Select(runTimeIdColumn + " = " + row[runTimeIdColumn]); resultdt.ImportRow(rows[0]); } return(resultdt); }
public static void Update(ApplicationModeXRunTimeFeatureDataModel data, RequestProfile requestProfile) { var sql = Save(data, requestProfile, "Update"); DBDML.RunSQL("ApplicationModeXRunTimeFeature.Update", sql, DataStoreKey); }
public static string ToSQLParameter(ApplicationModeXRunTimeFeatureDataModel data, string dataColumnName) { var returnValue = "NULL"; switch (dataColumnName) { case ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeXRunTimeFeatureId: if (data.ApplicationModeXRunTimeFeatureId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeXRunTimeFeatureId, data.ApplicationModeXRunTimeFeatureId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeXRunTimeFeatureId); } break; case ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeId: if (data.ApplicationModeId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeId, data.ApplicationModeId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationModeId); } break; case ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeatureId: if (data.RunTimeFeatureId != null) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeatureId, data.RunTimeFeatureId); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeatureId); } break; case ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationMode: if (!string.IsNullOrEmpty(data.ApplicationMode)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationMode, data.ApplicationMode); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationModeXRunTimeFeatureDataModel.DataColumns.ApplicationMode); } break; case ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeature: if (!string.IsNullOrEmpty(data.RunTimeFeature)) { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeature, data.RunTimeFeature); } else { returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, ApplicationModeXRunTimeFeatureDataModel.DataColumns.RunTimeFeature); } break; } return(returnValue); }
public static List <ApplicationModeXRunTimeFeatureDataModel> GetEntityDetails(ApplicationModeXRunTimeFeatureDataModel dataQuery, RequestProfile requestProfile, int returnAuditInfo = BaseDataManager.ReturnAuditInfoOnDetails) { const string sql = @"dbo.ApplicationModeXRunTimeFeatureSearch "; var parameters = new { AuditId = requestProfile.AuditId , ApplicationId = requestProfile.ApplicationId , ReturnAuditInfo = returnAuditInfo , ApplicationModeXRunTimeFeatureId = dataQuery.ApplicationModeXRunTimeFeatureId , ApplicationModeId = dataQuery.ApplicationModeId , RunTimeFeatureId = dataQuery.RunTimeFeatureId }; List <ApplicationModeXRunTimeFeatureDataModel> result; using (var dataAccess = new DataAccessBase(DataStoreKey)) { result = dataAccess.Connection.Query <ApplicationModeXRunTimeFeatureDataModel>(sql, parameters, commandType: CommandType.StoredProcedure).ToList(); } return(result); }
public static ApplicationModeXRunTimeFeatureDataModel GetDetails(ApplicationModeXRunTimeFeatureDataModel data, RequestProfile requestProfile) { var list = GetEntityDetails(data, requestProfile, 1); return(list.FirstOrDefault()); }