public virtual ClickTrack InsertClickTrack(ClickTrack entity) { ClickTrack other = new ClickTrack(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into ClickTrack ( [Name] ,[CreatedOn] ) Values ( @Name , @CreatedOn ); Select scope_identity()" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@ClickTrackID", entity.ClickTrackId) , new SqlParameter("@Name", entity.Name) , new SqlParameter("@CreatedOn", entity.CreatedOn) }; var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray); if (identity == DBNull.Value) { throw new DataException("Identity column was null as a result of the insert operation."); } return(GetClickTrack(Convert.ToInt32(identity))); } return(entity); }
public virtual ClickTrack ClickTrackFromDataRow(DataRow dr) { if (dr == null) { return(null); } ClickTrack entity = new ClickTrack(); entity.ClickTrackId = (System.Int32)dr["ClickTrackID"]; entity.Name = dr["Name"].ToString(); entity.CreatedOn = (System.DateTime)dr["CreatedOn"]; return(entity); }
public virtual ClickTrack UpdateClickTrack(ClickTrack entity) { if (entity.IsTransient()) { return(entity); } ClickTrack other = GetClickTrack(entity.ClickTrackId); if (entity.Equals(other)) { return(entity); } string sql = @"Update ClickTrack set [Name]=@Name , [CreatedOn]=@CreatedOn where ClickTrackID=@ClickTrackID" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@ClickTrackID", entity.ClickTrackId) , new SqlParameter("@Name", entity.Name) , new SqlParameter("@CreatedOn", entity.CreatedOn) }; SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray); return(GetClickTrack(entity.ClickTrackId)); }
public Filters(ClickTrack clickTrack) { ClickTrack = clickTrack; }
public ClickTrack InsertClickTrack(ClickTrack entity) { return(_iClickTrackRepository.InsertClickTrack(entity)); }
public ClickTrack UpdateClickTrack(ClickTrack entity) { return(_iClickTrackRepository.UpdateClickTrack(entity)); }
public virtual ClickTrack DeleteClickTrack(ClickTrack entity) { this.DeleteClickTrack(entity.ClickTrackId); return(entity); }