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