public virtual PerformanceStatistic UpdatePerformanceStatistic(PerformanceStatistic entity) { if (entity.IsTransient()) { return(entity); } PerformanceStatistic other = GetPerformanceStatistic(entity.PerformanceStatisticId); if (entity.Equals(other)) { return(entity); } string sql = @"Update PerformanceStatistic set [CPU]=@CPU , [Memory]=@Memory , [CreationDate]=@CreationDate , [MachineName]=@MachineName , [IPAddress]=@IPAddress , [DriveSpaceAvailable]=@DriveSpaceAvailable , [DriveTotalSpace]=@DriveTotalSpace where PerformanceStatisticID=@PerformanceStatisticID" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@CPU", entity.Cpu ?? (object)DBNull.Value) , new SqlParameter("@Memory", entity.Memory ?? (object)DBNull.Value) , new SqlParameter("@CreationDate", entity.CreationDate ?? (object)DBNull.Value) , new SqlParameter("@MachineName", entity.MachineName ?? (object)DBNull.Value) , new SqlParameter("@IPAddress", entity.IpAddress ?? (object)DBNull.Value) , new SqlParameter("@DriveSpaceAvailable", entity.DriveSpaceAvailable ?? (object)DBNull.Value) , new SqlParameter("@DriveTotalSpace", entity.DriveTotalSpace ?? (object)DBNull.Value) , new SqlParameter("@PerformanceStatisticID", entity.PerformanceStatisticId) }; SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray); return(GetPerformanceStatistic(entity.PerformanceStatisticId)); }
public override PerformanceStatistic InsertPerformanceStatistic(PerformanceStatistic entity) { PerformanceStatistic other = new PerformanceStatistic(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into PerformanceStatistic ( [CPU],[Memory],[CreationDate],[MachineName],[IPAddress],[DriveSpaceAvailable],[DriveTotalSpace] ) Values ( @CPU, @Memory, getutcdate(), @MachineName, @IPAddress, @DriveSpaceAvailable, @DriveTotalSpace ); Select scope_identity()"; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@CPU", entity.Cpu ?? (object)DBNull.Value) , new SqlParameter("@Memory", entity.Memory ?? (object)DBNull.Value) , new SqlParameter("@MachineName", entity.MachineName ?? (object)DBNull.Value) , new SqlParameter("@IPAddress", entity.IpAddress ?? (object)DBNull.Value) , new SqlParameter("@DriveSpaceAvailable", entity.DriveSpaceAvailable ?? (object)DBNull.Value) , new SqlParameter("@DriveTotalSpace", entity.DriveTotalSpace ?? (object)DBNull.Value) }; 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(GetPerformanceStatistic(Convert.ToInt32(identity))); } return(entity); }
public override PerformanceStatistic InsertPerformanceStatistic(PerformanceStatistic entity) { PerformanceStatistic other = new PerformanceStatistic(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into PerformanceStatistic ( [CPU],[Memory],[CreationDate],[MachineName],[IPAddress],[DriveSpaceAvailable],[DriveTotalSpace] ) Values ( @CPU, @Memory, getutcdate(), @MachineName, @IPAddress, @DriveSpaceAvailable, @DriveTotalSpace ); Select scope_identity()"; SqlParameter[] parameterArray = new SqlParameter[]{ new SqlParameter("@CPU",entity.Cpu ?? (object)DBNull.Value) , new SqlParameter("@Memory",entity.Memory ?? (object)DBNull.Value) , new SqlParameter("@MachineName",entity.MachineName ?? (object)DBNull.Value) , new SqlParameter("@IPAddress",entity.IpAddress ?? (object)DBNull.Value) , new SqlParameter("@DriveSpaceAvailable",entity.DriveSpaceAvailable ?? (object)DBNull.Value) , new SqlParameter("@DriveTotalSpace",entity.DriveTotalSpace ?? (object)DBNull.Value)}; 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 GetPerformanceStatistic(Convert.ToInt32(identity)); } return entity; }
public virtual PerformanceStatistic UpdatePerformanceStatistic(PerformanceStatistic entity) { if (entity.IsTransient()) return entity; PerformanceStatistic other = GetPerformanceStatistic(entity.PerformanceStatisticId); if (entity.Equals(other)) return entity; string sql=@"Update PerformanceStatistic set [CPU]=@CPU , [Memory]=@Memory , [CreationDate]=@CreationDate , [MachineName]=@MachineName , [IPAddress]=@IPAddress , [DriveSpaceAvailable]=@DriveSpaceAvailable , [DriveTotalSpace]=@DriveTotalSpace where PerformanceStatisticID=@PerformanceStatisticID"; SqlParameter[] parameterArray=new SqlParameter[]{ new SqlParameter("@CPU",entity.Cpu ?? (object)DBNull.Value) , new SqlParameter("@Memory",entity.Memory ?? (object)DBNull.Value) , new SqlParameter("@CreationDate",entity.CreationDate ?? (object)DBNull.Value) , new SqlParameter("@MachineName",entity.MachineName ?? (object)DBNull.Value) , new SqlParameter("@IPAddress",entity.IpAddress ?? (object)DBNull.Value) , new SqlParameter("@DriveSpaceAvailable",entity.DriveSpaceAvailable ?? (object)DBNull.Value) , new SqlParameter("@DriveTotalSpace",entity.DriveTotalSpace ?? (object)DBNull.Value) , new SqlParameter("@PerformanceStatisticID",entity.PerformanceStatisticId)}; SqlHelper.ExecuteNonQuery(this.ConnectionString,CommandType.Text,sql,parameterArray); return GetPerformanceStatistic(entity.PerformanceStatisticId); }