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