public WORK_DETAILDC LoadByPrimaryKey(DBConnection Connection, int WORK_DETAIL_VALUE_ID)
{
WORK_DETAILDC objWORK_DETAIL_VALU = new WORK_DETAILDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_WORK_DETAIL_VALUELoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_WORK_DETAIL_VALUE_ID", DbType.Int32, WORK_DETAIL_VALUE_ID);
IDataReader reader = null;
if (Connection.Transaction != null)
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand);
}
objWORK_DETAIL_VALU = FillObject(reader);
return(objWORK_DETAIL_VALU);
}
public int Insert(DBConnection Connection, WORK_DETAILDC objWORK_DETAIL_VALU)
{
int insertCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_WORK_DETAIL_VALUEInsert");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddOutParameter("p_WORK_DETAIL_VALUE_ID", DbType.Int32, objWORK_DETAIL_VALU.WORK_DETAIL_VALUE_ID);
dbCommandWrapper.AddInParameter("p_WORK_DETAIL_ID", DbType.Int32, objWORK_DETAIL_VALU.WORK_DETAIL_ID);
dbCommandWrapper.AddInParameter("p_DAILY_ID", DbType.Int32, objWORK_DETAIL_VALU.DAILY_ID);
dbCommandWrapper.AddInParameter("p_PERFORMED", DbType.String, objWORK_DETAIL_VALU.PERFORMED);
dbCommandWrapper.AddInParameter("p_UNITS", DbType.Decimal, objWORK_DETAIL_VALU.UNITS);
dbCommandWrapper.AddInParameter("p_COMMENTS", DbType.String, objWORK_DETAIL_VALU.COMMENTS);
dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objWORK_DETAIL_VALU.CREATED_ON);
dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objWORK_DETAIL_VALU.CREATED_BY);
dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objWORK_DETAIL_VALU.MODIFIED_ON);
dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objWORK_DETAIL_VALU.MODIFIED_BY);
dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objWORK_DETAIL_VALU.LOCK_COUNTER);
if (Connection.Transaction != null)
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(insertCount);
}
public int Insert(DBConnection objConnection, WORK_DETAILDC objWORK_DETAIL_VALUs)
{
int insertedCount = 0;
WORK_DETAILDA objWORK_DETAIL_VALUDA = new WORK_DETAILDA();
insertedCount = objWORK_DETAIL_VALUDA.Insert(objConnection, objWORK_DETAIL_VALUs);
return(insertedCount);
}
public int Update(DBConnection objConnection, WORK_DETAILDC objWORK_DETAIL_VALUs)
{
int updatedCount = 0;
WORK_DETAILDA objWORK_DETAIL_VALUDA = new WORK_DETAILDA();
updatedCount = objWORK_DETAIL_VALUDA.Update(objConnection, objWORK_DETAIL_VALUs);
return(updatedCount);
}
private WORK_DETAILDC FillObject(DataRow row)
{
WORK_DETAILDC objWORK_DETAIL_VALU = null;
objWORK_DETAIL_VALU = new WORK_DETAILDC();
objWORK_DETAIL_VALU.WORK_DETAIL_VALUE_ID = (int)row["WORK_DETAIL_VALUE_ID"];
objWORK_DETAIL_VALU.WORK_DETAIL_ID = (int)row["WORK_DETAIL_ID"];
objWORK_DETAIL_VALU.DAILY_ID = (int)row["DAILY_ID"];
objWORK_DETAIL_VALU.PERFORMED = row["PERFORMED"] == DBNull.Value ? null : (String)row["PERFORMED"];
objWORK_DETAIL_VALU.UNITS = (Decimal)row["UNITS"];
objWORK_DETAIL_VALU.COMMENTS = row["COMMENTS"] == DBNull.Value ? null : (String)row["COMMENTS"];
objWORK_DETAIL_VALU.CREATED_ON = (DateTime)row["CREATED_ON"];
objWORK_DETAIL_VALU.CREATED_BY = (int)row["CREATED_BY"];
objWORK_DETAIL_VALU.MODIFIED_ON = (DateTime)row["MODIFIED_ON"];
objWORK_DETAIL_VALU.MODIFIED_BY = (int)row["MODIFIED_BY"];
objWORK_DETAIL_VALU.LOCK_COUNTER = (int)row["LOCK_COUNTER"];
return(objWORK_DETAIL_VALU);
}
public WORK_DETAILDC LoadByPrimaryKey(int WORK_DETAIL_VALUE_ID)
{
DBConnection objConnection = new DBConnection();
WORK_DETAILDA objWORK_DETAIL_VALUDA = new WORK_DETAILDA();
WORK_DETAILDC objWORK_DETAIL_VALUDC = null;
try
{
objConnection.Open(false);
objWORK_DETAIL_VALUDC = objWORK_DETAIL_VALUDA.LoadByPrimaryKey(objConnection, WORK_DETAIL_VALUE_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objWORK_DETAIL_VALUDC);
}
private int Delete(DBConnection Connection, WORK_DETAILDC objWORK_DETAIL_VALU)
{
int deleteCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_WORK_DETAIL_VALUEDelete");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_WORK_DETAIL_VALUE_ID", DbType.Int32, objWORK_DETAIL_VALU.WORK_DETAIL_VALUE_ID);
if (Connection.Transaction != null)
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(deleteCount);
}
private WORK_DETAILDC FillObject(IDataReader reader)
{
WORK_DETAILDC objWORK_DETAIL_VALU = null;
if (reader != null && reader.Read())
{
objWORK_DETAIL_VALU = new WORK_DETAILDC();
objWORK_DETAIL_VALU.WORK_DETAIL_VALUE_ID = (int)reader["WORK_DETAIL_VALUE_ID"];
objWORK_DETAIL_VALU.WORK_DETAIL_ID = (int)reader["WORK_DETAIL_ID"];
objWORK_DETAIL_VALU.DAILY_ID = (int)reader["DAILY_ID"];
objWORK_DETAIL_VALU.PERFORMED = reader["PERFORMED"] == DBNull.Value ? null : (String)reader["PERFORMED"];
objWORK_DETAIL_VALU.UNITS = (Decimal)reader["UNITS"];
objWORK_DETAIL_VALU.COMMENTS = reader["COMMENTS"] == DBNull.Value ? null : (String)reader["COMMENTS"];
objWORK_DETAIL_VALU.CREATED_ON = (DateTime)reader["CREATED_ON"];
objWORK_DETAIL_VALU.CREATED_BY = (int)reader["CREATED_BY"];
objWORK_DETAIL_VALU.MODIFIED_ON = (DateTime)reader["MODIFIED_ON"];
objWORK_DETAIL_VALU.MODIFIED_BY = (int)reader["MODIFIED_BY"];
objWORK_DETAIL_VALU.LOCK_COUNTER = (int)reader["LOCK_COUNTER"];
reader.Close();
reader.Dispose();
}
return(objWORK_DETAIL_VALU);
}
