public virtual DriveStatistic UpdateDriveStatistic(DriveStatistic entity)
{
if (entity.IsTransient())
{
return(entity);
}
DriveStatistic other = GetDriveStatistic(entity.DriveStatisticId);
if (entity.Equals(other))
{
return(entity);
}
string sql = @"Update DriveStatistic set [IPAddress]=@IPAddress
, [DriveSpaceAvailable]=@DriveSpaceAvailable
, [DriveTotalSpace]=@DriveTotalSpace
, [DriveName]=@DriveName
, [CreationDate]=@CreationDate
, [MachineName]=@MachineName
where DriveStatisticId=@DriveStatisticId" ;
SqlParameter[] parameterArray = new SqlParameter[] {
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("@DriveName", entity.DriveName ?? (object)DBNull.Value)
, new SqlParameter("@CreationDate", entity.CreationDate ?? (object)DBNull.Value)
, new SqlParameter("@MachineName", entity.MachineName ?? (object)DBNull.Value)
, new SqlParameter("@DriveStatisticId", entity.DriveStatisticId)
};
SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray);
return(GetDriveStatistic(entity.DriveStatisticId));
}
public virtual DriveStatistic UpdateDriveStatistic(DriveStatistic entity)
{
if (entity.IsTransient()) return entity;
DriveStatistic other = GetDriveStatistic(entity.DriveStatisticId);
if (entity.Equals(other)) return entity;
string sql=@"Update DriveStatistic set [IPAddress]=@IPAddress
, [DriveSpaceAvailable]=@DriveSpaceAvailable
, [DriveTotalSpace]=@DriveTotalSpace
, [DriveName]=@DriveName
, [CreationDate]=@CreationDate
, [MachineName]=@MachineName
where DriveStatisticId=@DriveStatisticId";
SqlParameter[] parameterArray=new SqlParameter[]{
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("@DriveName",entity.DriveName ?? (object)DBNull.Value)
, new SqlParameter("@CreationDate",entity.CreationDate ?? (object)DBNull.Value)
, new SqlParameter("@MachineName",entity.MachineName ?? (object)DBNull.Value)
, new SqlParameter("@DriveStatisticId",entity.DriveStatisticId)};
SqlHelper.ExecuteNonQuery(this.ConnectionString,CommandType.Text,sql,parameterArray);
return GetDriveStatistic(entity.DriveStatisticId);
}
