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);
}
