private static string Save(DomainModel.FieldConfigurationModeXApplicationUser data, int auditId, string sqlcmd)
{
var sql = "EXEC ";
switch (sqlcmd)
{
case "Create":
sql += "dbo.FieldConfigurationModeXApplicationUserInsert " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId);
break;
case "Update":
sql += "dbo.FieldConfigurationModeXApplicationUserUpdate " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId);
break;
default:
break;
}
sql = sql + ", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeXApplicationUserId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.ApplicationUserId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeAccessModeId);
return(sql);
}
public static DataTable GetDetails(DomainModel.FieldConfigurationModeXApplicationUser data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationModeXApplicationUserDetails " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeXApplicationUserId);
var oDT = new Framework.Components.DataAccess.DBDataTable("FieldConfigurationModeXApplicationUser.Details", sql, DataStoreKey);
return(oDT.DBTable);
}
public static void Delete(DomainModel.FieldConfigurationModeXApplicationUser data, int auditId)
{
var sql = "EXEC dbo.FieldConfigurationModeXApplicationUserDelete " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeXApplicationUserId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.ApplicationUserId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeAccessModeId);
Framework.Components.DataAccess.DBDML.RunSQL("FieldConfigurationModeXApplicationUser.Delete", sql, DataStoreKey);
}
public static DataTable SearchByFCModeAccessMode(DomainModel.FieldConfigurationModeXApplicationUser data, int auditId)
{
// formulate SQL
var sql = "EXEC dbo.FieldConfigurationModeXApplicationUserSearchByFCModeAccessModeByFCModeAccessMode " +
" " + ToSQLParameter(BaseModel.BaseDataColumns.AuditId, auditId) +
", " + ToSQLParameter(BaseModel.BaseDataColumns.ApplicationId, ApplicationId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.ApplicationUserId) +
", " + ToSQLParameter(data, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeAccessMode);
var oDT = new DataAccess.DBDataTable("FieldConfigurationModeXApplicationRole.Search", sql, DataStoreKey);
return(oDT.DBTable);
}
public static string ToSQLParameter(DomainModel.FieldConfigurationModeXApplicationUser data, string dataColumnName)
{
var returnValue = "NULL";
switch (dataColumnName)
{
case DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeXApplicationUserId:
if (data.FieldConfigurationModeXApplicationUserId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeXApplicationUserId, data.FieldConfigurationModeXApplicationUserId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeXApplicationUserId);
}
break;
case DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeId:
if (data.FieldConfigurationModeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeId, data.FieldConfigurationModeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeId);
}
break;
case DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.ApplicationUserId:
if (data.ApplicationUserId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.ApplicationUserId, data.ApplicationUserId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.ApplicationUserId);
}
break;
case DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeAccessModeId:
if (data.FieldConfigurationModeAccessModeId != null)
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NUMBER, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeAccessModeId, data.FieldConfigurationModeAccessModeId);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeAccessModeId);
}
break;
case DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationMode:
if (!string.IsNullOrEmpty(data.FieldConfigurationMode))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationMode, data.FieldConfigurationMode);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationMode);
}
break;
case DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.ApplicationUser:
if (!string.IsNullOrEmpty(data.ApplicationUser))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.ApplicationUser, data.ApplicationUser);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.ApplicationUser);
}
break;
case DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeAccessMode:
if (!string.IsNullOrEmpty(data.FieldConfigurationModeAccessMode))
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_STRING_OR_DATE, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeAccessMode, data.FieldConfigurationModeAccessMode);
}
else
{
returnValue = string.Format(SQL_TEMPLATE_PARAMETER_NULL, DomainModel.FieldConfigurationModeXApplicationUser.DataColumns.FieldConfigurationModeAccessMode);
}
break;
default:
returnValue = BaseClass.ToSQLParameter(data, dataColumnName);
break;
}
return(returnValue);
}
public static void Update(DomainModel.FieldConfigurationModeXApplicationUser data, int auditId)
{
var sql = Save(data, auditId, "Update");
Framework.Components.DataAccess.DBDML.RunSQL("FieldConfigurationModeXApplicationUser.Update", sql, DataStoreKey);
}
