private static string Save(DomainModel.FieldConfigurationModeXApplicationRole data, int auditId, string sqlcmd)
{
var sql = "EXEC ";
switch (sqlcmd)
{
case "Create":
sql += "dbo.FieldConfigurationModeXApplicationRoleInsert " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId);
break;
case "Update":
sql += "dbo.FieldConfigurationModeXApplicationRoleUpdate " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeXApplicationRoleId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.ApplicationRoleId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeAccessModeId);
return(sql);
}
public static int Create(DomainModel.FieldConfigurationModeXApplicationRole data, int auditId)
{
var sql = Save(data, auditId, "Create");
var FieldConfigurationModeXApplicationRoleId = DataAccess.DBDML.RunScalarSQL("FieldConfigurationModeXApplicationRole.Insert", sql, DataStoreKey);
return(Convert.ToInt32(FieldConfigurationModeXApplicationRoleId));
}
public static List <DomainModel.FieldConfigurationModeXApplicationRole> GetEntityList(DomainModel.FieldConfigurationModeXApplicationRole data, int auditId)
{
var oDT = GetDetails(data, auditId);
var dataList = new List <DomainModel.FieldConfigurationModeXApplicationRole>();
if (oDT.Rows.Count == 1)
{
var oData = new DomainModel.FieldConfigurationModeXApplicationRole();
var row = oDT.Rows[0];
oData.FieldConfigurationModeXApplicationRoleId = (int?)row[DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeXApplicationRoleId];
oData.FieldConfigurationModeId = (int?)row[DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeId];
oData.ApplicationRoleId = (int?)row[DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.ApplicationRoleId];
oData.FieldConfigurationModeAccessModeId = (int?)row[DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeAccessModeId];
oData.FieldConfigurationMode = (string)row[DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationMode];
oData.ApplicationRole = (string)row[DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.ApplicationRole];
oData.FieldConfigurationModeAccessMode = (string)row[DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeAccessMode];
dataList.Add(oData);
}
return(dataList);
}
public static DataTable GetDetails(DomainModel.FieldConfigurationModeXApplicationRole data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationModeXApplicationRoleDetails " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeXApplicationRoleId);
var oDT = new DataAccess.DBDataTable("FieldConfigurationModeXApplicationRole.Details", sql, DataStoreKey);
return(oDT.DBTable);
}
public static void Delete(DomainModel.FieldConfigurationModeXApplicationRole data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationModeXApplicationRoleDelete " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeXApplicationRoleId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeAccessModeId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.ApplicationRoleId);
DataAccess.DBDML.RunSQL("FieldConfigurationModeXApplicationRole.Delete", sql, DataStoreKey);
}
public static DataTable SearchByFCModeAccessMode(DomainModel.FieldConfigurationModeXApplicationRole data, int auditId)
{
// formulate SQL
var sql = "EXEC dbo.FieldConfigurationModeXApplicationRoleSearchByFCModeAccessModeByFCModeAccessMode " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.ApplicationRoleId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeAccessMode);
var oDT = new DataAccess.DBDataTable("FieldConfigurationModeXApplicationRole.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
public static string ToSQLParameter(DomainModel.FieldConfigurationModeXApplicationRole data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeXApplicationRoleId:
if (data.FieldConfigurationModeXApplicationRoleId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeXApplicationRoleId, data.FieldConfigurationModeXApplicationRoleId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeXApplicationRoleId);
}
break;
case DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeId:
if (data.FieldConfigurationModeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeId, data.FieldConfigurationModeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeId);
}
break;
case DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.ApplicationRoleId:
if (data.ApplicationRoleId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.ApplicationRoleId, data.ApplicationRoleId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.ApplicationRoleId);
}
break;
case DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeAccessModeId:
if (data.FieldConfigurationModeAccessModeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeAccessModeId, data.FieldConfigurationModeAccessModeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeAccessModeId);
}
break;
case DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationMode:
if (!string.IsNullOrEmpty(data.FieldConfigurationMode))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationMode, data.FieldConfigurationMode);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationMode);
}
break;
case DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.ApplicationRole:
if (!string.IsNullOrEmpty(data.ApplicationRole))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.ApplicationRole, data.ApplicationRole);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.ApplicationRole);
}
break;
case DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeAccessMode:
if (!string.IsNullOrEmpty(data.FieldConfigurationModeAccessMode))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeAccessMode, data.FieldConfigurationModeAccessMode);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationRole.DataColumns.FieldConfigurationModeAccessMode);
}
break;
default:
returnValue = StandardClass.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static void Update(DomainModel.FieldConfigurationModeXApplicationRole data, int auditId)
{
var sql = Save(data, auditId, "Update");
DataAccess.DBDML.RunSQL("FieldConfigurationModeXApplicationRole.Update", sql, DataStoreKey);
}