private int Update(DBConnection Connection, PERMIT_ATTACHMENTDC objPERMIT_ATTACHMENT) { int updateCount = 0; StringBuilder sql = new StringBuilder(); sql.Append("proc_PERMIT_ATTACHMENTSUpdate"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_PERMIT_ID", DbType.Int32, objPERMIT_ATTACHMENT.PERMIT_ID); dbCommandWrapper.AddInParameter("p_ATTACHMENT_ID", DbType.Int32, objPERMIT_ATTACHMENT.ATTACHMENT_ID); if (Connection.Transaction != null) { updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand, Connection.Transaction); } else { updateCount = Connection.dataBase.ExecuteNonQuery(dbCommandWrapper.DBCommand); } if (updateCount == 0) { objPERMIT_ATTACHMENT.IsDirty = IsDirty = true; } return(updateCount); }
public PERMIT_ATTACHMENTDC LoadByPrimaryKey(DBConnection Connection, int PERMIT_ID, int ATTACHMENT_ID) { PERMIT_ATTACHMENTDC objPERMIT_ATTACHMENT = new PERMIT_ATTACHMENTDC(); StringBuilder sql = new StringBuilder(); sql.Append("proc_PERMIT_ATTACHMENTSLoadByPrimaryKey"); DBCommandWarpper dbCommandWrapper = new DBCommandWarpper(Connection.dataBase.GetStoredProcCommand(sql.ToString()), Connection); dbCommandWrapper.AddInParameter("p_PERMIT_ID", DbType.Int32, PERMIT_ID); dbCommandWrapper.AddInParameter("p_ATTACHMENT_ID", DbType.Int32, ATTACHMENT_ID); IDataReader reader = null; if (Connection.Transaction != null) { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand, Connection.Transaction); } else { reader = Connection.dataBase.ExecuteReader(dbCommandWrapper.DBCommand); } objPERMIT_ATTACHMENT = FillObject(reader); return(objPERMIT_ATTACHMENT); }
private PERMIT_ATTACHMENTDC FillObject(DataRow row) { PERMIT_ATTACHMENTDC objPERMIT_ATTACHMENT = null; objPERMIT_ATTACHMENT = new PERMIT_ATTACHMENTDC(); objPERMIT_ATTACHMENT.PERMIT_ID = (int)row["PERMIT_ID"]; objPERMIT_ATTACHMENT.ATTACHMENT_ID = (int)row["ATTACHMENT_ID"]; return(objPERMIT_ATTACHMENT); }
private PERMIT_ATTACHMENTDC FillObject(IDataReader reader) { PERMIT_ATTACHMENTDC objPERMIT_ATTACHMENT = null; if (reader != null && reader.Read()) { objPERMIT_ATTACHMENT = new PERMIT_ATTACHMENTDC(); objPERMIT_ATTACHMENT.PERMIT_ID = (int)reader["PERMIT_ID"]; objPERMIT_ATTACHMENT.ATTACHMENT_ID = (int)reader["ATTACHMENT_ID"]; reader.Close(); reader.Dispose(); } return(objPERMIT_ATTACHMENT); }
public PERMIT_ATTACHMENTDC LoadByPrimaryKey(int PERMIT_ID, int ATTACHMENT_ID) { DBConnection objConnection = new DBConnection(); PERMIT_ATTACHMENTDA objPERMIT_ATTACHMENTDA = new PERMIT_ATTACHMENTDA(); PERMIT_ATTACHMENTDC objPERMIT_ATTACHMENTDC = null; try { objConnection.Open(false); objPERMIT_ATTACHMENTDC = objPERMIT_ATTACHMENTDA.LoadByPrimaryKey(objConnection, PERMIT_ID, ATTACHMENT_ID); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objPERMIT_ATTACHMENTDC); }