private int Update(DBConnection Connection, PERMIT_TYPEDC objPERMITS_LOOK_UP)
{
int updateCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_PERMITS_LOOK_UPUpdate");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_PERMIT_TYPE_ID", DbType.String, objPERMITS_LOOK_UP.PERMIT_TYPE_ID);
dbCommandWrapper.AddInParameter("p_DESCRIPTION", DbType.String, objPERMITS_LOOK_UP.DESCRIPTION);
dbCommandWrapper.AddInParameter("p_PERMIT_CATEGORY", DbType.Int32, objPERMITS_LOOK_UP.PERMIT_CATEGORY);
dbCommandWrapper.AddInParameter("p_FEE", DbType.String, objPERMITS_LOOK_UP.FEE);
dbCommandWrapper.AddInParameter("p_DURATION", DbType.String, objPERMITS_LOOK_UP.DURATION);
if (Connection.Transaction != null)
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
if (updateCount == 0)
{
objPERMITS_LOOK_UP.IsDirty = IsDirty = true;
}
return(updateCount);
}
public PERMIT_TYPEDC LoadByPrimaryKey(DBConnection Connection, string PERMIT_TYPE_ID)
{
PERMIT_TYPEDC obj = new PERMIT_TYPEDC();
StringBuilder sql = new StringBuilder();
sql.Append("proc_PERMIT_TYPESLoadByPrimaryKey");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("@p_PERMIT_TYPE_ID", DbType.String, PERMIT_TYPE_ID);
DataSet ds = new DataSet();
if (Connection.Transaction != null)
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
ds = Connection.dataBase.ExecuteDataSet(dbCommandWrapper.DBCommand);
}
obj = (Utility.ConvertToObject <PERMIT_TYPEDC>(ds.Tables[0]));
return(obj);
}
public IHttpActionResult Get(string id)
{
PERMIT_TYPEBL objLookup = new PERMIT_TYPEBL();
PERMIT_TYPEDC objResult = new PERMIT_TYPEDC();
try{
objResult = objLookup.LoadByPrimaryKey(id);
return(Ok(new { objResult }));
}
catch (Exception ex)
{
return(new TextResult(ex.Message, Request, ex.StackTrace));
}
}
public PERMIT_TYPEDC LoadByPrimaryKey(string PERMIT_NUMBER)
{
DBConnection objConnection = new DBConnection();
PERMITSTYPEDA objPERMITS_LOOK_UPDA = new PERMITSTYPEDA();
PERMIT_TYPEDC objPERMITS_LOOK_UPDC = null;
try
{
objConnection.Open(false);
objPERMITS_LOOK_UPDC = objPERMITS_LOOK_UPDA.LoadByPrimaryKey(objConnection, PERMIT_NUMBER);
}
catch (Exception ex)
{
throw ex;
}
finally
{
objConnection.Close();
}
return(objPERMITS_LOOK_UPDC);
}
private int Delete(DBConnection Connection, PERMIT_TYPEDC objPERMITS_LOOK_UP)
{
int deleteCount = 0;
StringBuilder sql = new StringBuilder();
sql.Append("proc_PERMITS_LOOK_UPDelete");
DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection);
dbCommandWrapper.AddInParameter("p_PERMIT_NUMBER", DbType.String, objPERMITS_LOOK_UP.PERMIT_TYPE_ID);
if (Connection.Transaction != null)
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction);
}
else
{
deleteCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand);
}
return(deleteCount);
}
