/// <summary> /// @author : TrungMT /// @CreateDate:04/03/2008 /// @Description: Retrieves all with clip code /// </summary> public static DataSet Retrieve(int clipId) { ConnectionFactory Connection = InternalGlobal.MakeConnectionFactory(); PrClip Clip = new PrClip(Connection); try { Connection.Open(); return Clip.Search(clipId); } catch (Exception exp) { throw exp; } finally { Connection.Close(); } }
public BClip(int clipId) { PrClip Clip = new PrClip(Connection); try { Open(); DataRow dr = Clip.Search(clipId).Tables[0].Rows[0]; LoadDetails(dr); } catch (Exception exp) { throw exp; } finally { Close(); } }
/// <summary> /// @author : TrungMT /// @CreateDate:04/03/2008 /// @Description: Retrieves all Clip denpend on param /// </summary> public DataSet Retrieves(Clip pClip) { PrClip Clip = new PrClip(Connection); try { Open(); return Clip.Search(pClip); } catch (Exception exp) { throw exp; } finally { Close(); } }
/// <summary> /// @author : TrungMT /// @CreateDate:04/03/2008 /// @Description: Update 1 Clip with Clip_id /// </summary> public int Update(Clip pClip) { PrClip Clip = new PrClip(Connection); int intRowAffected = 0; try { Open(); intRowAffected = Clip.Update(pClip); if (pClip.AutoSetUploadDate) pClip.UploadDate = Qtc.Libs.Util.DBUtil.getDBSystemTime(Connection); Commit(); } catch (Exception exp) { Rollback(); throw exp; } finally { Close(); } return intRowAffected; }
/// <summary> /// @author : TrungMT /// @CreateDate:04/03/2008 /// @Description: Delete 1 Clip with Clip_id /// </summary> public int Delete(Clip pClip) { PrClip Clip = new PrClip(Connection); int intRowAffected = 0; try { Open(); intRowAffected = Clip.Delete(pClip); Commit(); } catch (Exception exp) { Rollback(); throw exp; } finally { Close(); } return intRowAffected; }