public USERS_RMAGDC LoadByPrimaryKey(DBConnection Connection, int USER_RMAG_ID) { USERS_RMAGDC objUSERS_RMAG = new USERS_RMAGDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_USERS_RMAGSLoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_USER_RMAG_ID", DbType.Int32, USER_RMAG_ID); IDataReader reader = null; if (Connection.Transaction != null) { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction); } else { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand); } objUSERS_RMAG = FillObject(reader); return(objUSERS_RMAG); }
private int Insert(DBConnection Connection, USERS_RMAGDC objUSERS_RMAG) { int insertCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_USERS_RMAGSInsert"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_USER_RMAG_ID", DbType.Int32, objUSERS_RMAG.USER_RMAG_ID); dbCommandWrapper.AddInParameter("p_USER_ID", DbType.Int32, objUSERS_RMAG.USER_ID); dbCommandWrapper.AddInParameter("p_RMAG_ID", DbType.Int32, objUSERS_RMAG.RMAG_ID); dbCommandWrapper.AddInParameter("p_CREATED_ON", DbType.DateTime, objUSERS_RMAG.CREATED_ON); dbCommandWrapper.AddInParameter("p_CREATED_BY", DbType.Int32, objUSERS_RMAG.CREATED_BY); dbCommandWrapper.AddInParameter("p_MODIFIED_ON", DbType.DateTime, objUSERS_RMAG.MODIFIED_ON); dbCommandWrapper.AddInParameter("p_MODIFIED_BY", DbType.Int32, objUSERS_RMAG.MODIFIED_BY); if (Connection.Transaction != null) { insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { insertCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } return(insertCount); }
public IHttpActionResult Get(int id) { USERS_RMAGBL objUsers_Rmag = new USERS_RMAGBL(); USERS_RMAGDC objResult = new USERS_RMAGDC(); try{ objResult = objUsers_Rmag.LoadByPrimaryKey(id); return(Ok(new { objResult })); } catch (Exception ex) { return(new TextResult(ex.Message, Request)); } }
private USERS_RMAGDC FillObject(DataRow row) { USERS_RMAGDC objUSERS_RMAG = null; objUSERS_RMAG = new USERS_RMAGDC(); objUSERS_RMAG.USER_RMAG_ID = (int)row["USER_RMAG_ID"]; objUSERS_RMAG.USER_ID = (int)row["USER_ID"]; objUSERS_RMAG.RMAG_ID = (int)row["RMAG_ID"]; objUSERS_RMAG.CREATED_ON = (DateTime)row["CREATED_ON"]; objUSERS_RMAG.CREATED_BY = (int)row["CREATED_BY"]; objUSERS_RMAG.MODIFIED_ON = (DateTime)row["MODIFIED_ON"]; objUSERS_RMAG.MODIFIED_BY = (int)row["MODIFIED_BY"]; return(objUSERS_RMAG); }
private USERS_RMAGDC FillObject(IDataReader reader) { USERS_RMAGDC objUSERS_RMAG = null; if (reader != null && reader.Read()) { objUSERS_RMAG = new USERS_RMAGDC(); objUSERS_RMAG.USER_RMAG_ID = (int)reader["USER_RMAG_ID"]; objUSERS_RMAG.USER_ID = (int)reader["USER_ID"]; objUSERS_RMAG.RMAG_ID = (int)reader["RMAG_ID"]; objUSERS_RMAG.CREATED_ON = (DateTime)reader["CREATED_ON"]; objUSERS_RMAG.CREATED_BY = (int)reader["CREATED_BY"]; objUSERS_RMAG.MODIFIED_ON = (DateTime)reader["MODIFIED_ON"]; objUSERS_RMAG.MODIFIED_BY = (int)reader["MODIFIED_BY"]; reader.Close(); reader.Dispose(); } return(objUSERS_RMAG); }
public USERS_RMAGDC LoadByPrimaryKey(int USER_RMAG_ID) { DBConnection objConnection = new DBConnection(); USERS_RMAGDA objUSERS_RMAGDA = new USERS_RMAGDA(); USERS_RMAGDC objUSERS_RMAGDC = null; try { objConnection.Open(false); objUSERS_RMAGDC = objUSERS_RMAGDA.LoadByPrimaryKey(objConnection, USER_RMAG_ID); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objUSERS_RMAGDC); }
private int Delete(DBConnection Connection, USERS_RMAGDC objUSERS_RMAG) { int deleteCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_USERS_RMAGSDelete"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_USER_RMAG_ID", DbType.Int32, objUSERS_RMAG.USER_RMAG_ID); if (Connection.Transaction != null) { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } return(deleteCount); }