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); }