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