public MESSAGES_COMPANIEDC LoadByPrimaryKey(DBConnection Connection, int MESSAGE_COMPANY_ID)
{
MESSAGES_COMPANIEDC objMESSAGES_COMPANIE = new MESSAGES_COMPANIEDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_MESSAGES_COMPANIESLoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_MESSAGE_COMPANY_ID", DbType.Int32, MESSAGE_COMPANY_ID);
IDataReader reader = null;
if (Connection.Transaction != null)
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand);
}
objMESSAGES_COMPANIE = FillObject(reader);
return(objMESSAGES_COMPANIE);
}
private int Insert(DBConnection Connection, MESSAGES_COMPANIEDC objMESSAGES_COMPANIE)
{
int insertCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_MESSAGES_COMPANIESInsert");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_MESSAGE_COMPANY_ID", DbType.Int32, objMESSAGES_COMPANIE.MESSAGE_COMPANY_ID);
dbCommandWrapper.AddInParameter("p_MESSAGE_ID", DbType.Int32, objMESSAGES_COMPANIE.MESSAGE_ID);
dbCommandWrapper.AddInParameter("p_COMPANY_ID", DbType.Int32, objMESSAGES_COMPANIE.COMPANY_ID);
if (Connection.Transaction != null)
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(insertCount);
}
private MESSAGES_COMPANIEDC FillObject(DataRow row)
{
MESSAGES_COMPANIEDC objMESSAGES_COMPANIE = null;
objMESSAGES_COMPANIE = new MESSAGES_COMPANIEDC();
objMESSAGES_COMPANIE.MESSAGE_COMPANY_ID = (int)row["MESSAGE_COMPANY_ID"];
objMESSAGES_COMPANIE.MESSAGE_ID = (int)row["MESSAGE_ID"];
objMESSAGES_COMPANIE.COMPANY_ID = (int)row["COMPANY_ID"];
objMESSAGES_COMPANIE.CREATED_ON = (DateTime)row["CREATED_ON"];
objMESSAGES_COMPANIE.CREATED_BY = (int)row["CREATED_BY"];
objMESSAGES_COMPANIE.MODIFIED_ON = (DateTime)row["MODIFIED_ON"];
objMESSAGES_COMPANIE.MODIFIED_BY = (int)row["MODIFIED_BY"];
objMESSAGES_COMPANIE.LOCK_COUNTER = row["LOCK_COUNTER"] == DBNull.Value ? null : (int?)row["LOCK_COUNTER"];
return(objMESSAGES_COMPANIE);
}
private MESSAGES_COMPANIEDC FillObject(IDataReader reader)
{
MESSAGES_COMPANIEDC objMESSAGES_COMPANIE = null;
if (reader != null && reader.Read())
{
objMESSAGES_COMPANIE = new MESSAGES_COMPANIEDC();
objMESSAGES_COMPANIE.MESSAGE_COMPANY_ID = (int)reader["MESSAGE_COMPANY_ID"];
objMESSAGES_COMPANIE.MESSAGE_ID = (int)reader["MESSAGE_ID"];
objMESSAGES_COMPANIE.COMPANY_ID = (int)reader["COMPANY_ID"];
objMESSAGES_COMPANIE.CREATED_ON = (DateTime)reader["CREATED_ON"];
objMESSAGES_COMPANIE.CREATED_BY = (int)reader["CREATED_BY"];
objMESSAGES_COMPANIE.MODIFIED_ON = (DateTime)reader["MODIFIED_ON"];
objMESSAGES_COMPANIE.MODIFIED_BY = (int)reader["MODIFIED_BY"];
objMESSAGES_COMPANIE.LOCK_COUNTER = reader["LOCK_COUNTER"] == DBNull.Value ? null : (int?)reader["LOCK_COUNTER"];
reader.Close();
reader.Dispose();
}
return(objMESSAGES_COMPANIE);
}
public MESSAGES_COMPANIEDC LoadByPrimaryKey(int MESSAGE_COMPANY_ID)
{
DBConnection objConnection = new DBConnection();
MESSAGES_COMPANIEDA objMESSAGES_COMPANIEDA = new MESSAGES_COMPANIEDA();
MESSAGES_COMPANIEDC objMESSAGES_COMPANIEDC = null;
try
{
objConnection.Open(false);
objMESSAGES_COMPANIEDC = objMESSAGES_COMPANIEDA.LoadByPrimaryKey(objConnection, MESSAGE_COMPANY_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objMESSAGES_COMPANIEDC);
}
private int Update(DBConnection Connection, MESSAGES_COMPANIEDC objMESSAGES_COMPANIE)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_MESSAGES_COMPANIESUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_MESSAGE_COMPANY_ID", DbType.Int32, objMESSAGES_COMPANIE.MESSAGE_COMPANY_ID);
dbCommandWrapper.AddInParameter("p_MESSAGE_ID", DbType.Int32, objMESSAGES_COMPANIE.MESSAGE_ID);
dbCommandWrapper.AddInParameter("p_COMPANY_ID", DbType.Int32, objMESSAGES_COMPANIE.COMPANY_ID);
dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objMESSAGES_COMPANIE.CREATED_ON);
dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objMESSAGES_COMPANIE.CREATED_BY);
dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objMESSAGES_COMPANIE.MODIFIED_ON);
dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objMESSAGES_COMPANIE.MODIFIED_BY);
dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objMESSAGES_COMPANIE.LOCK_COUNTER);
if (Connection.Transaction != null)
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
if (updateCount == 0)
{
objMESSAGES_COMPANIE.IsDirty = IsDirty = true;
}
return(updateCount);
}
