public int Insert(DBConnection Connection, MATERIALDC objMATERIAL_VALU) { int insertCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_MATERIAL_VALUEInsert"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddOutParameter("p_MATERIAL_VALUE_ID", DbType.Int32, objMATERIAL_VALU.MATERIAL_VALUE_ID); dbCommandWrapper.AddInParameter("p_MATERIAL_ID", DbType.Int32, objMATERIAL_VALU.MATERIAL_ID); dbCommandWrapper.AddInParameter("p_DAILY_ID", DbType.Int32, objMATERIAL_VALU.DAILY_ID); dbCommandWrapper.AddInParameter("p_UNITS", DbType.Decimal, objMATERIAL_VALU.UNITS); dbCommandWrapper.AddInParameter("p_COMMENTS", DbType.String, objMATERIAL_VALU.COMMENTS); dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objMATERIAL_VALU.CREATED_ON); dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objMATERIAL_VALU.CREATED_BY); dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objMATERIAL_VALU.MODIFIED_ON); dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objMATERIAL_VALU.MODIFIED_BY); dbCommandWrapper.AddInParameter("p_LOCK_COUNTER", DbType.Int32, objMATERIAL_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, MATERIALDC objMATERIAL_VALUs) { int insertedCount = 0; MATERIALDA objMATERIAL_VALUDA = new MATERIALDA(); insertedCount = objMATERIAL_VALUDA.Insert(objConnection, objMATERIAL_VALUs); return(insertedCount); }
public int Update(DBConnection objConnection, MATERIALDC objMATERIAL_VALUs) { int updatedCount = 0; MATERIALDA objMATERIAL_VALUDA = new MATERIALDA(); updatedCount = objMATERIAL_VALUDA.Update(objConnection, objMATERIAL_VALUs); return(updatedCount); }
public MATERIALDC LoadByPrimaryKey(int MATERIAL_VALUE_ID) { DBConnection objConnection = new DBConnection(); MATERIALDA objMATERIAL_VALUDA = new MATERIALDA(); MATERIALDC objMATERIAL_VALUDC = null; try { objConnection.Open(false); objMATERIAL_VALUDC = objMATERIAL_VALUDA.LoadByPrimaryKey(objConnection, MATERIAL_VALUE_ID); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objMATERIAL_VALUDC); }
private MATERIALDC FillObject(IDataReader reader) { MATERIALDC objMATERIAL_VALU = null; if (reader != null && reader.Read()) { objMATERIAL_VALU = new MATERIALDC(); objMATERIAL_VALU.MATERIAL_VALUE_ID = (int)reader["MATERIAL_VALUE_ID"]; objMATERIAL_VALU.MATERIAL_ID = (int)reader["MATERIAL_ID"]; objMATERIAL_VALU.DAILY_ID = (int)reader["DAILY_ID"]; objMATERIAL_VALU.UNITS = (Decimal)reader["UNITS"]; objMATERIAL_VALU.COMMENTS = reader["COMMENTS"] == DBNull.Value ? null : (String)reader["COMMENTS"]; objMATERIAL_VALU.CREATED_ON = (DateTime)reader["CREATED_ON"]; objMATERIAL_VALU.CREATED_BY = (int)reader["CREATED_BY"]; objMATERIAL_VALU.MODIFIED_ON = (DateTime)reader["MODIFIED_ON"]; objMATERIAL_VALU.MODIFIED_BY = (int)reader["MODIFIED_BY"]; objMATERIAL_VALU.LOCK_COUNTER = (int)reader["LOCK_COUNTER"]; reader.Close(); reader.Dispose(); } return(objMATERIAL_VALU); }
private int Delete(DBConnection Connection, MATERIALDC objMATERIAL_VALU) { int deleteCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_MATERIAL_VALUEDelete"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_MATERIAL_VALUE_ID", DbType.Int32, objMATERIAL_VALU.MATERIAL_VALUE_ID); if (Connection.Transaction != null) { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } return(deleteCount); }