public MAN_POWERDC LoadByPrimaryKey(DBConnection Connection, int MAN_POWER_ID)
{
MAN_POWERDC objMAN_POWE = new MAN_POWERDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_MAN_POWERLoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_MAN_POWER_ID", DbType.Int32, MAN_POWER_ID);
IDataReader reader = null;
if (Connection.Transaction != null)
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand);
}
objMAN_POWE = FillObject(reader);
return(objMAN_POWE);
}
private MAN_POWERDC FillObject(IDataReader reader)
{
MAN_POWERDC objMAN_POWE = null;
if (reader != null && reader.Read())
{
objMAN_POWE = new MAN_POWERDC();
objMAN_POWE.MAN_POWER_ID = (int)reader["MAN_POWER_ID"];
objMAN_POWE.DAILY_ID = (int)reader["DAILY_ID"];
objMAN_POWE.FIRST_NAME = (String)reader["FIRST_NAME"];
objMAN_POWE.LAST_NAME = (String)reader["LAST_NAME"];
objMAN_POWE.ST_HOURS = (Decimal)reader["ST_HOURS"];
objMAN_POWE.OT_HOURS = (Decimal)reader["OT_HOURS"];
objMAN_POWE.HOURS_DIFF = (Decimal)reader["HOURS_DIFF"];
objMAN_POWE.MAN_POWER_JOB_TYPE = (int)reader["MAN_POWER_JOB_TYPE"];
objMAN_POWE.CREATED_ON = (DateTime)reader["CREATED_ON"];
objMAN_POWE.CREATED_BY = (int)reader["CREATED_BY"];
objMAN_POWE.MODIFIED_ON = (DateTime)reader["MODIFIED_ON"];
objMAN_POWE.MODIFIED_BY = (int)reader["MODIFIED_BY"];
objMAN_POWE.LOCK_COUNTER = (int)reader["LOCK_COUNTER"];
reader.Close();
reader.Dispose();
}
return(objMAN_POWE);
}
public int Insert(DBConnection objConnection, MAN_POWERDC objMAN_POWEs)
{
int insertedCount = 0;
MAN_POWERDA objMAN_POWEDA = new MAN_POWERDA();
insertedCount = objMAN_POWEDA.Insert(objConnection, objMAN_POWEs);
return(insertedCount);
}
public int Update(DBConnection objConnection, MAN_POWERDC objMAN_POWEs)
{
int updatedCount = 0;
MAN_POWERDA objMAN_POWEDA = new MAN_POWERDA();
updatedCount = objMAN_POWEDA.Update(objConnection, objMAN_POWEs);
return(updatedCount);
}
public int Update(DBConnection Connection, MAN_POWERDC objMAN_POWE)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_MAN_POWERUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_MAN_POWER_ID", DbType.Int32, objMAN_POWE.MAN_POWER_ID);
dbCommandWrapper.AddInParameter("p_DAILY_ID", DbType.Int32, objMAN_POWE.DAILY_ID);
dbCommandWrapper.AddInParameter("p_FIRST_NAME", DbType.String, objMAN_POWE.FIRST_NAME);
dbCommandWrapper.AddInParameter("p_LAST_NAME", DbType.String, objMAN_POWE.LAST_NAME);
dbCommandWrapper.AddInParameter("p_ST_HOURS", DbType.Decimal, objMAN_POWE.ST_HOURS);
dbCommandWrapper.AddInParameter("p_OT_HOURS", DbType.Decimal, objMAN_POWE.OT_HOURS);
dbCommandWrapper.AddInParameter("p_HOURS_DIFF", DbType.Decimal, objMAN_POWE.HOURS_DIFF);
dbCommandWrapper.AddInParameter("p_MAN_POWER_JOB_TYPE", DbType.Decimal, objMAN_POWE.MAN_POWER_JOB_TYPE);
dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objMAN_POWE.CREATED_ON);
dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objMAN_POWE.CREATED_BY);
dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objMAN_POWE.MODIFIED_ON);
dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objMAN_POWE.MODIFIED_BY);
dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objMAN_POWE.LOCK_COUNTER);
if (Connection.Transaction != null)
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
if (updateCount == 0)
{
objMAN_POWE.IsDirty = IsDirty = true;
}
return(updateCount);
}
private MAN_POWERDC FillObject(DataRow row)
{
MAN_POWERDC objMAN_POWE = null;
objMAN_POWE = new MAN_POWERDC();
objMAN_POWE.MAN_POWER_ID = (int)row["MAN_POWER_ID"];
objMAN_POWE.DAILY_ID = (int)row["DAILY_ID"];
objMAN_POWE.FIRST_NAME = (String)row["FIRST_NAME"];
objMAN_POWE.LAST_NAME = (String)row["LAST_NAME"];
objMAN_POWE.ST_HOURS = (Decimal)row["ST_HOURS"];
objMAN_POWE.OT_HOURS = (Decimal)row["OT_HOURS"];
objMAN_POWE.HOURS_DIFF = (Decimal)row["HOURS_DIFF"];
objMAN_POWE.MAN_POWER_JOB_TYPE = (int)row["MAN_POWER_JOB_TYPE"];
objMAN_POWE.CREATED_ON = (DateTime)row["CREATED_ON"];
objMAN_POWE.CREATED_BY = (int)row["CREATED_BY"];
objMAN_POWE.MODIFIED_ON = (DateTime)row["MODIFIED_ON"];
objMAN_POWE.MODIFIED_BY = (int)row["MODIFIED_BY"];
objMAN_POWE.LOCK_COUNTER = (int)row["LOCK_COUNTER"];
return(objMAN_POWE);
}
public MAN_POWERDC LoadByPrimaryKey(int MAN_POWER_ID)
{
DBConnection objConnection = new DBConnection();
MAN_POWERDA objMAN_POWEDA = new MAN_POWERDA();
MAN_POWERDC objMAN_POWEDC = null;
try
{
objConnection.Open(false);
objMAN_POWEDC = objMAN_POWEDA.LoadByPrimaryKey(objConnection, MAN_POWER_ID);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objMAN_POWEDC);
}
private int Delete(DBConnection Connection, MAN_POWERDC objMAN_POWE)
{
int deleteCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_MAN_POWERDelete");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_MAN_POWER_ID", DbType.Int32, objMAN_POWE.MAN_POWER_ID);
if (Connection.Transaction != null)
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(deleteCount);
}
