public LOOK_UPDC LoadByPrimaryKey(DBConnection Connection, int LOOK_UP_ID) { LOOK_UPDC objLOOK_UP = new LOOK_UPDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_LOOK_UPSLoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_LOOK_UP_ID", DbType.Int32, LOOK_UP_ID); IDataReader reader = null; if (Connection.Transaction != null) { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction); } else { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand); } objLOOK_UP = FillObject(reader); return(objLOOK_UP); }
private int Update(DBConnection Connection, LOOK_UPDC objLOOK_UP) { int updateCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_LOOK_UPSUpdate"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_LOOK_UP_ID", DbType.Int32, objLOOK_UP.LOOK_UP_ID); dbCommandWrapper.AddInParameter("p_LU_NAME", DbType.String, objLOOK_UP.LU_NAME); dbCommandWrapper.AddInParameter("p_LU_TYPE", DbType.String, objLOOK_UP.LU_TYPE); if (Connection.Transaction != null) { updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } if (updateCount == 0) { objLOOK_UP.IsDirty = IsDirty = true; } return(updateCount); }
private LOOK_UPDC FillObject(DataRow row) { LOOK_UPDC objLOOK_UP = null; objLOOK_UP = new LOOK_UPDC(); objLOOK_UP.LOOK_UP_ID = (int)row["LOOK_UP_ID"]; objLOOK_UP.LU_NAME = (String)row["LU_NAME"]; objLOOK_UP.LU_TYPE = (String)row["LU_TYPE"]; return(objLOOK_UP); }
public IHttpActionResult Get(int id) { LOOK_UPBL objLookup = new LOOK_UPBL(); LOOK_UPDC objResult = new LOOK_UPDC(); try{ objResult = objLookup.LoadByPrimaryKey(id); return(Ok(new { objResult })); } catch (Exception ex) { return(new TextResult(ex.Message, Request, ex.StackTrace)); } }
private LOOK_UPDC FillObject(IDataReader reader) { LOOK_UPDC objLOOK_UP = null; if (reader != null && reader.Read()) { objLOOK_UP = new LOOK_UPDC(); objLOOK_UP.LOOK_UP_ID = (int)reader["LOOK_UP_ID"]; objLOOK_UP.LU_NAME = (String)reader["LU_NAME"]; objLOOK_UP.LU_TYPE = (String)reader["LU_TYPE"]; reader.Close(); reader.Dispose(); } return(objLOOK_UP); }
public LOOK_UPDC LoadByPrimaryKey(int LOOK_UP_ID) { DBConnection objConnection = new DBConnection(); LOOK_UPDA objLOOK_UPDA = new LOOK_UPDA(); LOOK_UPDC objLOOK_UPDC = null; try { objConnection.Open(false); objLOOK_UPDC = objLOOK_UPDA.LoadByPrimaryKey(objConnection, LOOK_UP_ID); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objLOOK_UPDC); }
private int Delete(DBConnection Connection, LOOK_UPDC objLOOK_UP) { int deleteCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_LOOK_UPSDelete"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_LOOK_UP_ID", DbType.Int32, objLOOK_UP.LOOK_UP_ID); if (Connection.Transaction != null) { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } return(deleteCount); }