public LABORDC LoadByPrimaryKey(DBConnection Connection, int LABOR_VALUE_ID) { LABORDC objLABOR_VALU = new LABORDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_LABOR_VALUELoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_LABOR_VALUE_ID", DbType.Int32, LABOR_VALUE_ID); IDataReader reader = null; if (Connection.Transaction != null) { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction); } else { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand); } objLABOR_VALU = FillObject(reader); return(objLABOR_VALU); }
public int Insert(DBConnection Connection, LABORDC objLABOR_VALU) { int insertCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_LABOR_VALUEInsert"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddOutParameter("p_LABOR_VALUE_ID", DbType.Int32, objLABOR_VALU.LABOR_VALUE_ID); dbCommandWrapper.AddInParameter("p_LABOR_ID", DbType.Int32, objLABOR_VALU.LABOR_ID); dbCommandWrapper.AddInParameter("p_DAILY_ID", DbType.Int32, objLABOR_VALU.DAILY_ID); dbCommandWrapper.AddInParameter("p_HOURS", DbType.Decimal, objLABOR_VALU.HOURS); dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objLABOR_VALU.CREATED_ON); dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objLABOR_VALU.CREATED_BY); dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objLABOR_VALU.MODIFIED_ON); dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objLABOR_VALU.MODIFIED_BY); dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objLABOR_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, LABORDC objLABOR_VALUs) { int insertedCount = 0; LABORDA objLABOR_VALUDA = new LABORDA(); insertedCount = objLABOR_VALUDA.Insert(objConnection, objLABOR_VALUs); return(insertedCount); }
public int Update(DBConnection objConnection, LABORDC objLABOR_VALUs) { int updatedCount = 0; LABORDA objLABOR_VALUDA = new LABORDA(); updatedCount = objLABOR_VALUDA.Update(objConnection, objLABOR_VALUs); return(updatedCount); }
private LABORDC FillObject(DataRow row) { LABORDC objLABOR_VALU = null; objLABOR_VALU = new LABORDC(); objLABOR_VALU.LABOR_VALUE_ID = (int)row["LABOR_VALUE_ID"]; objLABOR_VALU.LABOR_ID = (int)row["LABOR_ID"]; objLABOR_VALU.DAILY_ID = (int)row["DAILY_ID"]; objLABOR_VALU.HOURS = (Decimal)row["HOURS"]; objLABOR_VALU.CREATED_ON = (DateTime)row["CREATED_ON"]; objLABOR_VALU.CREATED_BY = (int)row["CREATED_BY"]; objLABOR_VALU.MODIFIED_ON = (DateTime)row["MODIFIED_ON"]; objLABOR_VALU.MODIFIED_BY = (int)row["MODIFIED_BY"]; objLABOR_VALU.LOCK_COUNTER = (int)row["LOCK_COUNTER"]; return(objLABOR_VALU); }
public LABORDC LoadByPrimaryKey(int LABOR_VALUE_ID) { DBConnection objConnection = new DBConnection(); LABORDA objLABOR_VALUDA = new LABORDA(); LABORDC objLABOR_VALUDC = null; try { objConnection.Open(false); objLABOR_VALUDC = objLABOR_VALUDA.LoadByPrimaryKey(objConnection, LABOR_VALUE_ID); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objLABOR_VALUDC); }
private LABORDC FillObject(IDataReader reader) { LABORDC objLABOR_VALU = null; if (reader != null && reader.Read()) { objLABOR_VALU = new LABORDC(); objLABOR_VALU.LABOR_VALUE_ID = (int)reader["LABOR_VALUE_ID"]; objLABOR_VALU.LABOR_ID = (int)reader["LABOR_ID"]; objLABOR_VALU.DAILY_ID = (int)reader["DAILY_ID"]; objLABOR_VALU.HOURS = (Decimal)reader["HOURS"]; objLABOR_VALU.CREATED_ON = (DateTime)reader["CREATED_ON"]; objLABOR_VALU.CREATED_BY = (int)reader["CREATED_BY"]; objLABOR_VALU.MODIFIED_ON = (DateTime)reader["MODIFIED_ON"]; objLABOR_VALU.MODIFIED_BY = (int)reader["MODIFIED_BY"]; objLABOR_VALU.LOCK_COUNTER = (int)reader["LOCK_COUNTER"]; reader.Close(); reader.Dispose(); } return(objLABOR_VALU); }
private int Delete(DBConnection Connection, LABORDC objLABOR_VALU) { int deleteCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_LABOR_VALUEDelete"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_LABOR_VALUE_ID", DbType.Int32, objLABOR_VALU.LABOR_VALUE_ID); if (Connection.Transaction != null) { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } return(deleteCount); }