public static IdType Insert(OrgDepartmentsData data)
{
// Create and execute the command
string sql = "Insert Into " + TABLE + "("
+ "Description,"
+ "Active,"
+ "OrgDivisionsID,"
+ "GLAccount,"
;
sql = sql.Substring(0, sql.Length - 1) + ") values("
+ "@Description,"
+ "@Active,"
+ "@OrgDivisionsID,"
+ "@GLAccount,"
;
sql = sql.Substring(0, sql.Length - 1) + ");select Scope_Identity() Id";
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
cmd.Parameters.Add(new SqlParameter("@Active", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "Active", DataRowVersion.Proposed, !data.Active.IsValid ? data.Active.DBValue : data.Active.DBValue.Equals("Y") ? 1 : 0));
cmd.Parameters.Add(new SqlParameter("@OrgDivisionsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgDivisionsID", DataRowVersion.Proposed, data.OrgDivisionsID.DBValue));
cmd.Parameters.Add(new SqlParameter("@GLAccount", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "GLAccount", DataRowVersion.Proposed, data.GLAccount.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(OrgDepartmentsData data)
{
// Create and execute the command
OrgDepartmentsData oldData = Load(data.OrgDepartmentsID);
string sql = "Update " + TABLE + " set ";
if (!oldData.Description.Equals(data.Description))
{
sql = sql + "Description=@Description,";
}
if (!oldData.Active.Equals(data.Active))
{
sql = sql + "Active=@Active,";
}
if (!oldData.OrgDivisionsID.Equals(data.OrgDivisionsID))
{
sql = sql + "OrgDivisionsID=@OrgDivisionsID,";
}
if (!oldData.GLAccount.Equals(data.GLAccount))
{
sql = sql + "GLAccount=@GLAccount,";
}
WhereClause w = new WhereClause();
w.And("OrgDepartmentsID", data.OrgDepartmentsID.DBValue);
sql = sql.Substring(0, sql.Length - 1) + w.FormatSql();
SqlCommand cmd = GetSqlCommand(DatabaseEnum.INTRANET, sql, CommandType.Text, COMMAND_TIMEOUT);
//Create the parameters and append them to the command object
if (!oldData.OrgDepartmentsID.Equals(data.OrgDepartmentsID))
{
cmd.Parameters.Add(new SqlParameter("@OrgDepartmentsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgDepartmentsID", DataRowVersion.Proposed, data.OrgDepartmentsID.DBValue));
}
if (!oldData.Description.Equals(data.Description))
{
cmd.Parameters.Add(new SqlParameter("@Description", SqlDbType.VarChar, 100, ParameterDirection.Input, false, 0, 0, "Description", DataRowVersion.Proposed, data.Description.DBValue));
}
if (!oldData.Active.Equals(data.Active))
{
cmd.Parameters.Add(new SqlParameter("@Active", SqlDbType.Bit, 0, ParameterDirection.Input, false, 0, 0, "Active", DataRowVersion.Proposed, !data.Active.IsValid ? data.Active.DBValue : data.Active.DBValue.Equals("Y") ? 1 : 0));
}
if (!oldData.OrgDivisionsID.Equals(data.OrgDivisionsID))
{
cmd.Parameters.Add(new SqlParameter("@OrgDivisionsID", SqlDbType.Int, 0, ParameterDirection.Input, false, 10, 0, "OrgDivisionsID", DataRowVersion.Proposed, data.OrgDivisionsID.DBValue));
}
if (!oldData.GLAccount.Equals(data.GLAccount))
{
cmd.Parameters.Add(new SqlParameter("@GLAccount", SqlDbType.VarChar, 20, ParameterDirection.Input, false, 0, 0, "GLAccount", DataRowVersion.Proposed, data.GLAccount.DBValue));
}
// Execute the query
if (cmd.Parameters.Count > 0)
{
cmd.ExecuteNonQuery();
}
}
private static OrgDepartmentsData GetDataObjectFromReader(SqlDataReader dataReader)
{
OrgDepartmentsData data = new OrgDepartmentsData();
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgDepartmentsID")))
{
data.OrgDepartmentsID = IdType.UNSET;
}
else
{
data.OrgDepartmentsID = new IdType(dataReader.GetInt32(dataReader.GetOrdinal("OrgDepartmentsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Description")))
{
data.Description = StringType.UNSET;
}
else
{
data.Description = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("Description")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("Active")))
{
data.Active = BooleanType.UNSET;
}
else
{
data.Active = BooleanType.GetInstance(dataReader.GetBoolean(dataReader.GetOrdinal("Active")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("OrgDivisionsID")))
{
data.OrgDivisionsID = IntegerType.UNSET;
}
else
{
data.OrgDivisionsID = new IntegerType(dataReader.GetInt32(dataReader.GetOrdinal("OrgDivisionsID")));
}
if (dataReader.IsDBNull(dataReader.GetOrdinal("GLAccount")))
{
data.GLAccount = StringType.UNSET;
}
else
{
data.GLAccount = StringType.Parse(dataReader.GetString(dataReader.GetOrdinal("GLAccount")));
}
return(data);
}
public static OrgDepartmentsData Load(IdType orgDepartmentsID)
{
WhereClause w = new WhereClause();
w.And("OrgDepartmentsID", orgDepartmentsID.DBValue);
SqlDataReader dataReader = GetListReader(DatabaseEnum.INTRANET, TABLE, w, null, true);
if (!dataReader.Read())
{
dataReader.Close();
throw new FinderException("Load found no rows for OrgDepartments.");
}
OrgDepartmentsData data = GetDataObjectFromReader(dataReader);
dataReader.Close();
return(data);
}
