public static IdType Insert(GroupRoleData data)
{
// Create and execute the command
string sql = "Insert Into " + TABLE + "("
+ "GroupId,"
+ "RoleId,"
+ "PermitDeny,"
;
sql = sql.Substring(0, sql.Length - 1) + ") values("
+ "@GroupId,"
+ "@RoleId,"
+ "@PermitDeny,"
;
sql = sql.Substring(0, sql.Length - 1) + ");select Scope_Identity() Id";
SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
cmd.Parameters.Add(new SqlParameter("@GroupId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "GroupId", DataRowVersion.Proposed, data.GroupId.DBValue));
cmd.Parameters.Add(new SqlParameter("@RoleId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "RoleId", DataRowVersion.Proposed, data.RoleId.DBValue));
cmd.Parameters.Add(new SqlParameter("@PermitDeny", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "PermitDeny", DataRowVersion.Proposed, data.PermitDeny.DBValue));
// Execute the query
SqlDataReader returnValue = cmd.ExecuteReader();
returnValue.Read();
int returnId = (int)(returnValue.GetDecimal(0));
returnValue.Close();
// Set the output paramter value(s)
return(new IdType(returnId));
}
public static void Update(GroupRoleData data)
{
// Create and execute the command
GroupRoleData oldData = Load(data.GroupRoleId);
string sql = "Update " + TABLE + " set ";
if (!oldData.GroupId.Equals(data.GroupId))
{
sql = sql + "GroupId=@GroupId,";
}
if (!oldData.RoleId.Equals(data.RoleId))
{
sql = sql + "RoleId=@RoleId,";
}
if (!oldData.PermitDeny.Equals(data.PermitDeny))
{
sql = sql + "PermitDeny=@PermitDeny,";
}
WhereClause w = new WhereClause();
w.And("GroupRoleId", data.GroupRoleId.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.ORDERDB, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.GroupRoleId.Equals(data.GroupRoleId))
{
cmd.Parameters.Add(new SqlParameter("@GroupRoleId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "GroupRoleId", DataRowVersion.Proposed, data.GroupRoleId.DBValue));
}
if (!oldData.GroupId.Equals(data.GroupId))
{
cmd.Parameters.Add(new SqlParameter("@GroupId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "GroupId", DataRowVersion.Proposed, data.GroupId.DBValue));
}
if (!oldData.RoleId.Equals(data.RoleId))
{
cmd.Parameters.Add(new SqlParameter("@RoleId", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "RoleId", DataRowVersion.Proposed, data.RoleId.DBValue));
}
if (!oldData.PermitDeny.Equals(data.PermitDeny))
{
cmd.Parameters.Add(new SqlParameter("@PermitDeny", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "PermitDeny", DataRowVersion.Proposed, data.PermitDeny.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
public static GroupRoleData Load(IdType groupRoleId)
{
WhereClause w = new WhereClause();
w.And("GroupRoleId", groupRoleId.DBValue);
SqlDataReader dataReader = GetListReader(DatabaseEnum.ORDERDB, TABLE, w, null, true);
if (!dataReader.Read())
{
dataReader.Close();
throw new FinderException("Load found no rows for GroupRole.");
}
GroupRoleData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
private static GroupRoleData GetDataObjectFromReader(SqlDataReader dataReader)
{
GroupRoleData data = new GroupRoleData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("GroupRoleId")))
{
data.GroupRoleId = IdType.UNSET;
}
else
{
data.GroupRoleId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("GroupRoleId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GroupId")))
{
data.GroupId = IdType.UNSET;
}
else
{
data.GroupId = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("GroupId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("RoleId")))
{
data.RoleId = RoleEnum.UNSET;
}
else
{
data.RoleId = RoleEnum.GetInstance(dataReader.GetInt32(dataReader.GetOrdinal("RoleId")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("PermitDeny")))
{
data.PermitDeny = PermitDenyEnum.UNSET;
}
else
{
data.PermitDeny = PermitDenyEnum.GetInstance(dataReader.GetInt32(dataReader.GetOrdinal("PermitDeny")));
}
return(data);
}
