static private void LoadPacerFileFormatField(PacerFileFormatField objPacerFileFormatField, IDataReader _reader)
{
if (_reader.IsDBNull(0) != true)
{
objPacerFileFormatField.ID = _reader.GetInt32(0);
}
if (_reader.IsDBNull(1) != true)
{
objPacerFileFormatField.PacerFileFormatID = _reader.GetInt32(1);
}
if (_reader.IsDBNull(2) != true)
{
objPacerFileFormatField.PacerFieldID = _reader.GetInt32(2);
}
if (_reader.IsDBNull(3) != true)
{
objPacerFileFormatField.FieldOrder = _reader.GetInt32(3);
}
if (_reader.IsDBNull(4) != true)
{
objPacerFileFormatField.PacerFileVersion = _reader.GetString(4);
}
if (_reader.IsDBNull(5) != true)
{
objPacerFileFormatField.PacerFieldName = _reader.GetString(5);
}
}
static private void Update(PacerFileFormatField objPacerFileFormatField, Database db, DbTransaction trans)
{
//Database db = DatabaseFactory.CreateDatabase("BRGCaseMail");
System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_PacerFileFormatFieldUpdate");
db.AddInParameter(dbCommand, "ID", DbType.Int32, objPacerFileFormatField.ID);
if (objPacerFileFormatField.PacerFileFormatID > 0)
{
db.AddInParameter(dbCommand, "PacerFileFormatID", DbType.Int32, objPacerFileFormatField.PacerFileFormatID);
}
else
{
db.AddInParameter(dbCommand, "PacerFileFormatID", DbType.Int32, Convert.DBNull);
}
if (objPacerFileFormatField.PacerFieldID > 0)
{
db.AddInParameter(dbCommand, "PacerFieldID", DbType.Int32, objPacerFileFormatField.PacerFieldID);
}
else
{
db.AddInParameter(dbCommand, "PacerFieldID", DbType.Int32, Convert.DBNull);
}
db.AddInParameter(dbCommand, "FieldOrder", DbType.Int32, objPacerFileFormatField.FieldOrder);
db.AddInParameter(dbCommand, "PacerFileVersion", DbType.String, objPacerFileFormatField.PacerFileVersion);
db.AddInParameter(dbCommand, "PacerFieldName", DbType.String, objPacerFileFormatField.PacerFieldName);
db.ExecuteNonQuery(dbCommand, trans);
}
static public void Save(PacerFileFormatField objPacerFileFormatField, Database db, DbTransaction trans, bool CommitTrans)
{
try
{
if (objPacerFileFormatField.IsModified == true)
{
if (objPacerFileFormatField.ID == 0)
{
Insert(objPacerFileFormatField, db, trans);
}
else
{
Update(objPacerFileFormatField, db, trans);
}
}
if (CommitTrans == true)
{
trans.Commit();
}
}
catch (Exception e)
{
if (CommitTrans == true)
{
//we were hoping to commit the transaction which means we're at the end so
//Roll back the transaction. Otherwise just rethrow the error and let the next
//higher level catch it and rollback
trans.Rollback();
}
//and then rethrow the error
throw (e);
}
}
static private void Insert(PacerFileFormatField objPacerFileFormatField)
{
Database db = DatabaseFactory.CreateDatabase("BRGCaseMail");
System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_PacerFileFormatFieldInsert");
db.AddOutParameter(dbCommand, "ID", DbType.Int32, 4);
if (objPacerFileFormatField.PacerFileFormatID > 0)
{
db.AddInParameter(dbCommand, "PacerFileFormatID", DbType.Int32, objPacerFileFormatField.PacerFileFormatID);
}
else
{
db.AddInParameter(dbCommand, "PacerFileFormatID", DbType.Int32, Convert.DBNull);
}
if (objPacerFileFormatField.PacerFieldID > 0)
{
db.AddInParameter(dbCommand, "PacerFieldID", DbType.Int32, objPacerFileFormatField.PacerFieldID);
}
else
{
db.AddInParameter(dbCommand, "PacerFieldID", DbType.Int32, Convert.DBNull);
}
db.AddInParameter(dbCommand, "FieldOrder", DbType.Int32, objPacerFileFormatField.FieldOrder);
db.AddInParameter(dbCommand, "PacerFileVersion", DbType.String, objPacerFileFormatField.PacerFileVersion);
db.AddInParameter(dbCommand, "PacerFieldName", DbType.String, objPacerFileFormatField.PacerFieldName);
db.ExecuteNonQuery(dbCommand);
objPacerFileFormatField.ID = Int32.Parse(db.GetParameterValue(dbCommand, "ID").ToString());
}
static public void Delete(PacerFileFormatField objPacerFileFormatField)
{
Database db = DatabaseFactory.CreateDatabase("BRGCaseMail");
System.Data.Common.DbCommand dbCommand = db.GetStoredProcCommand("p_PacerFileFormatFieldDelete");
db.AddInParameter(dbCommand, "ID", DbType.Int32, objPacerFileFormatField.ID);
db.ExecuteNonQuery(dbCommand);
}
public PacerFileFormatField Copy()
{
PacerFileFormatField _pacerFileFormatField = new PacerFileFormatField();
_pacerFileFormatField.ID = _iD;
_pacerFileFormatField.PacerFileFormatID = _pacerFileFormatID;
_pacerFileFormatField.PacerFieldID = _pacerFieldID;
_pacerFileFormatField.FieldOrder = _fieldOrder;
_pacerFileFormatField.PacerFileVersion = _pacerFileVersion;
_pacerFileFormatField.PacerFieldName = _pacerFieldName;
return(_pacerFileFormatField);
}
static public void Save(PacerFileFormatField objPacerFileFormatField)
{
if (objPacerFileFormatField.IsModified == true)
{
if (objPacerFileFormatField.ID == 0)
{
Insert(objPacerFileFormatField);
}
else
{
Update(objPacerFileFormatField);
}
}
}
static public List <PacerFileFormatField> GetForPacerFileFormat(int PacerFileFormatID)
{
List <PacerFileFormatField> objPacerFileFormatFields = new List <PacerFileFormatField>();
Database db = DatabaseFactory.CreateDatabase("BRGCaseMail");
using (IDataReader reader = db.ExecuteReader(CommandType.Text, _selectViewSQL + " Where PacerFileFormatID = " + PacerFileFormatID + " order by FieldOrder asc"))
{
while (reader.Read())
{
PacerFileFormatField objPacerFileFormatField = new PacerFileFormatField();
LoadPacerFileFormatField(objPacerFileFormatField, reader);
objPacerFileFormatField.IsModified = false;
objPacerFileFormatFields.Add(objPacerFileFormatField);
}
// always call Close when done reading.
reader.Close();
return(objPacerFileFormatFields);
}
}
static public PacerFileFormatField GetByID(int ID)
{
PacerFileFormatField objPacerFileFormatField = new PacerFileFormatField();
string query = _selectViewSQL + " where ID = " + ID;
Database db = DatabaseFactory.CreateDatabase("BRGCaseMail");
using (IDataReader reader = db.ExecuteReader(CommandType.Text, query))
{
if (reader.Read())
{
LoadPacerFileFormatField(objPacerFileFormatField, reader);
// always call Close when done reading.
reader.Close();
objPacerFileFormatField.IsModified = false;
return(objPacerFileFormatField);
}
else
{
return(null);
}
}
}