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 DataTransfer <GetOutput> Get(string _id)
{
DataTransfer <GetOutput> tranfer = new DataTransfer <GetOutput>();
System.Int32 drivestatisticid = 0;
if (!string.IsNullOrEmpty(_id) && System.Int32.TryParse(_id, out drivestatisticid))
{
DriveStatistic drivestatistic = _iDriveStatisticRepository.GetDriveStatistic(drivestatisticid);
if (drivestatistic != null)
{
tranfer.IsSuccess = true;
GetOutput output = new GetOutput();
output.CopyFrom(drivestatistic);
tranfer.Data = output;
}
else
{
tranfer.IsSuccess = false;
tranfer.Errors = new string[1];
tranfer.Errors[0] = "Error: No record found.";
}
}
else
{
tranfer.IsSuccess = false;
tranfer.Errors = new string[1];
tranfer.Errors[0] = "Error: Invalid request.";
}
return(tranfer);
}
public virtual DriveStatistic DriveStatisticFromDataRow(DataRow dr)
{
if(dr==null) return null;
DriveStatistic entity=new DriveStatistic();
if (dr.Table.Columns.Contains("DriveStatisticId"))
{
entity.DriveStatisticId = (System.Int32)dr["DriveStatisticId"];
}
if (dr.Table.Columns.Contains("IPAddress"))
{
entity.IpAddress = dr["IPAddress"].ToString();
}
if (dr.Table.Columns.Contains("DriveSpaceAvailable"))
{
entity.DriveSpaceAvailable = dr["DriveSpaceAvailable"]==DBNull.Value?(System.Double?)null:(System.Double?)dr["DriveSpaceAvailable"];
}
if (dr.Table.Columns.Contains("DriveTotalSpace"))
{
entity.DriveTotalSpace = dr["DriveTotalSpace"]==DBNull.Value?(System.Double?)null:(System.Double?)dr["DriveTotalSpace"];
}
if (dr.Table.Columns.Contains("DriveName"))
{
entity.DriveName = dr["DriveName"].ToString();
}
if (dr.Table.Columns.Contains("CreationDate"))
{
entity.CreationDate = dr["CreationDate"]==DBNull.Value?(System.DateTime?)null:(System.DateTime?)dr["CreationDate"];
}
if (dr.Table.Columns.Contains("MachineName"))
{
entity.MachineName = dr["MachineName"].ToString();
}
return entity;
}
public PerformanceStatistic GetPCPerformance()
{
PerformanceStatistic stats = new PerformanceStatistic();
PerformanceCounter cpuCounter;
PerformanceCounter ramCounter;
cpuCounter = new PerformanceCounter();
cpuCounter.CategoryName = "Processor";
cpuCounter.CounterName = "% Processor Time";
cpuCounter.InstanceName = "_Total";
ramCounter = new PerformanceCounter("Memory", "Available MBytes");
Int64 phav = PerformanceInfo.GetPhysicalAvailableMemoryInMiB();
Int64 tot = PerformanceInfo.GetTotalMemoryInMiB();
stats.Memory = Math.Round((double)(100 - (((decimal)phav / (decimal)tot) * 100)), 2);
stats.Cpu = cpuCounter.NextValue();
Thread.Sleep(1000);
stats.Cpu = cpuCounter.NextValue();
stats.CreationDate = DateTime.UtcNow;
stats.MachineName = System.Environment.MachineName.ToString();
DriveInfo[] allDrives = DriveInfo.GetDrives();
DriveStatisticRepository driveRepo = new DriveStatisticRepository();
if (allDrives.Count() > 0)
{
stats.DriveSpaceAvailable = 0;
stats.DriveTotalSpace = 0;
for (int i = 0; i < allDrives.Count(); i++)
{
try
{
DriveStatistic dS = new DriveStatistic();
dS.CreationDate = stats.CreationDate;
dS.DriveName = allDrives[i].Name;
dS.MachineName = stats.MachineName + ":" + allDrives[i].Name;
dS.DriveSpaceAvailable = Math.Round(((allDrives[i].TotalFreeSpace / 1024.0) / 1024.0) / 1024.0, 2);
dS.DriveTotalSpace = Math.Round(((allDrives[i].TotalSize / 1024.0) / 1024.0) / 1024.0, 2);
string hostNames = Dns.GetHostName();
string myIPs = Dns.GetHostByName(hostNames).AddressList[0].ToString();
dS.IpAddress = myIPs + ":" + allDrives[i].Name;
driveRepo.InsertDriveStatistic(dS);
stats.DriveSpaceAvailable += dS.DriveSpaceAvailable;
stats.DriveTotalSpace += dS.DriveTotalSpace;
}
catch (Exception exp)
{ }
}
}
string hostName = Dns.GetHostName();
string myIP = Dns.GetHostByName(hostName).AddressList[0].ToString();
stats.IpAddress = myIP;
return(stats);
}
public virtual void CopyFrom(DriveStatistic other)
{
if (other != null)
{
this.DriveStatisticId = other.DriveStatisticId;
this.IpAddress = other.IpAddress;
this.DriveSpaceAvailable = other.DriveSpaceAvailable;
this.DriveTotalSpace = other.DriveTotalSpace;
this.DriveName = other.DriveName;
this.CreationDate = other.CreationDate;
this.MachineName = other.MachineName;
}
}
public DataTransfer <PutOutput> Update(PutInput Input)
{
DataTransfer <PutOutput> transer = new DataTransfer <PutOutput>();
IList <string> errors = Validator.Validate(Input);
if (errors.Count == 0)
{
DriveStatistic drivestatisticinput = new DriveStatistic();
DriveStatistic drivestatisticoutput = new DriveStatistic();
PutOutput output = new PutOutput();
drivestatisticinput.CopyFrom(Input);
DriveStatistic drivestatistic = _iDriveStatisticRepository.GetDriveStatistic(drivestatisticinput.DriveStatisticId);
if (drivestatistic != null)
{
drivestatisticoutput = _iDriveStatisticRepository.UpdateDriveStatistic(drivestatisticinput);
if (drivestatisticoutput != null)
{
output.CopyFrom(drivestatisticoutput);
transer.IsSuccess = true;
transer.Data = output;
}
else
{
transer.IsSuccess = false;
transer.Errors = new string[1];
transer.Errors[0] = "Error: Could not update.";
}
}
else
{
transer.IsSuccess = false;
transer.Errors = new string[1];
transer.Errors[0] = "Error: Record not found.";
}
}
else
{
transer.IsSuccess = false;
transer.Errors = errors.ToArray <string>();
}
return(transer);
}
public DataTransfer <PostOutput> Insert(PostInput Input)
{
DataTransfer <PostOutput> transer = new DataTransfer <PostOutput>();
IList <string> errors = Validator.Validate(Input);
if (errors.Count == 0)
{
DriveStatistic drivestatistic = new DriveStatistic();
PostOutput output = new PostOutput();
drivestatistic.CopyFrom(Input);
drivestatistic = _iDriveStatisticRepository.InsertDriveStatistic(drivestatistic);
output.CopyFrom(drivestatistic);
transer.IsSuccess = true;
transer.Data = output;
}
else
{
transer.IsSuccess = false;
transer.Errors = errors.ToArray <string>();
}
return(transer);
}
public virtual DriveStatistic DriveStatisticFromDataRow(DataRow dr)
{
if (dr == null)
{
return(null);
}
DriveStatistic entity = new DriveStatistic();
if (dr.Table.Columns.Contains("DriveStatisticId"))
{
entity.DriveStatisticId = (System.Int32)dr["DriveStatisticId"];
}
if (dr.Table.Columns.Contains("IPAddress"))
{
entity.IpAddress = dr["IPAddress"].ToString();
}
if (dr.Table.Columns.Contains("DriveSpaceAvailable"))
{
entity.DriveSpaceAvailable = dr["DriveSpaceAvailable"] == DBNull.Value?(System.Double?)null : (System.Double?)dr["DriveSpaceAvailable"];
}
if (dr.Table.Columns.Contains("DriveTotalSpace"))
{
entity.DriveTotalSpace = dr["DriveTotalSpace"] == DBNull.Value?(System.Double?)null : (System.Double?)dr["DriveTotalSpace"];
}
if (dr.Table.Columns.Contains("DriveName"))
{
entity.DriveName = dr["DriveName"].ToString();
}
if (dr.Table.Columns.Contains("CreationDate"))
{
entity.CreationDate = dr["CreationDate"] == DBNull.Value?(System.DateTime?)null : (System.DateTime?)dr["CreationDate"];
}
if (dr.Table.Columns.Contains("MachineName"))
{
entity.MachineName = dr["MachineName"].ToString();
}
return(entity);
}
public virtual DriveStatistic InsertDriveStatistic(DriveStatistic entity)
{
DriveStatistic other = new DriveStatistic();
other = entity;
if (entity.IsTransient())
{
string sql = @"Insert into DriveStatistic ( [IPAddress]
,[DriveSpaceAvailable]
,[DriveTotalSpace]
,[DriveName]
,[CreationDate]
,[MachineName] )
Values
( @IPAddress
, @DriveSpaceAvailable
, @DriveTotalSpace
, @DriveName
, @CreationDate
, @MachineName );
Select scope_identity()" ;
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)
};
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(GetDriveStatistic(Convert.ToInt32(identity)));
}
return(entity);
}
public DriveStatistic UpdateDriveStatistic(DriveStatistic entity)
{
return _iDriveStatisticRepository.UpdateDriveStatistic(entity);
}
public DataTransfer<PutOutput> Update(PutInput Input)
{
DataTransfer<PutOutput> transer = new DataTransfer<PutOutput>();
IList<string> errors = Validator.Validate(Input);
if (errors.Count == 0)
{
DriveStatistic drivestatisticinput = new DriveStatistic();
DriveStatistic drivestatisticoutput = new DriveStatistic();
PutOutput output = new PutOutput();
drivestatisticinput.CopyFrom(Input);
DriveStatistic drivestatistic = _iDriveStatisticRepository.GetDriveStatistic(drivestatisticinput.DriveStatisticId);
if (drivestatistic!=null)
{
drivestatisticoutput = _iDriveStatisticRepository.UpdateDriveStatistic(drivestatisticinput);
if(drivestatisticoutput!=null)
{
output.CopyFrom(drivestatisticoutput);
transer.IsSuccess = true;
transer.Data = output;
}
else
{
transer.IsSuccess = false;
transer.Errors = new string[1];
transer.Errors[0] = "Error: Could not update.";
}
}
else
{
transer.IsSuccess = false;
transer.Errors = new string[1];
transer.Errors[0] = "Error: Record not found.";
}
}
else
{
transer.IsSuccess = false;
transer.Errors = errors.ToArray<string>();
}
return transer;
}
public DriveStatistic InsertDriveStatistic(DriveStatistic entity)
{
return _iDriveStatisticRepository.InsertDriveStatistic(entity);
}
public DataTransfer<PostOutput> Insert(PostInput Input)
{
DataTransfer<PostOutput> transer = new DataTransfer<PostOutput>();
IList<string> errors = Validator.Validate(Input);
if(errors.Count==0)
{
DriveStatistic drivestatistic = new DriveStatistic();
PostOutput output = new PostOutput();
drivestatistic.CopyFrom(Input);
drivestatistic = _iDriveStatisticRepository.InsertDriveStatistic(drivestatistic);
output.CopyFrom(drivestatistic);
transer.IsSuccess = true;
transer.Data = output;
}
else
{
transer.IsSuccess = false;
transer.Errors = errors.ToArray<string>();
}
return transer;
}
public PerformanceStatistic GetPCPerformance()
{
PerformanceStatistic stats = new PerformanceStatistic();
PerformanceCounter cpuCounter;
PerformanceCounter ramCounter;
cpuCounter = new PerformanceCounter();
cpuCounter.CategoryName = "Processor";
cpuCounter.CounterName = "% Processor Time";
cpuCounter.InstanceName = "_Total";
ramCounter = new PerformanceCounter("Memory", "Available MBytes");
Int64 phav = PerformanceInfo.GetPhysicalAvailableMemoryInMiB();
Int64 tot = PerformanceInfo.GetTotalMemoryInMiB();
stats.Memory = Math.Round((double)(100 - (((decimal)phav / (decimal)tot) * 100)), 2);
stats.Cpu = cpuCounter.NextValue();
Thread.Sleep(1000);
stats.Cpu = cpuCounter.NextValue();
stats.CreationDate = DateTime.UtcNow;
stats.MachineName = System.Environment.MachineName.ToString();
DriveInfo[] allDrives = DriveInfo.GetDrives();
DriveStatisticRepository driveRepo = new DriveStatisticRepository();
if (allDrives.Count() > 0)
{
stats.DriveSpaceAvailable = 0;
stats.DriveTotalSpace = 0;
for (int i = 0; i < allDrives.Count(); i++)
{
try
{
DriveStatistic dS = new DriveStatistic();
dS.CreationDate = stats.CreationDate;
dS.DriveName = allDrives[i].Name;
dS.MachineName = stats.MachineName + ":" + allDrives[i].Name;
dS.DriveSpaceAvailable = Math.Round(((allDrives[i].TotalFreeSpace / 1024.0) / 1024.0) / 1024.0, 2);
dS.DriveTotalSpace = Math.Round(((allDrives[i].TotalSize / 1024.0) / 1024.0) / 1024.0, 2);
string hostNames = Dns.GetHostName();
string myIPs = Dns.GetHostByName(hostNames).AddressList[0].ToString();
dS.IpAddress = myIPs + ":" + allDrives[i].Name;
driveRepo.InsertDriveStatistic(dS);
stats.DriveSpaceAvailable += dS.DriveSpaceAvailable;
stats.DriveTotalSpace += dS.DriveTotalSpace;
}
catch (Exception exp)
{ }
}
}
string hostName = Dns.GetHostName();
string myIP = Dns.GetHostByName(hostName).AddressList[0].ToString();
stats.IpAddress = myIP;
return stats;
}
public virtual DriveStatistic DeleteDriveStatistic(DriveStatistic entity)
{
this.DeleteDriveStatistic(entity.DriveStatisticId);
return entity;
}
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 InsertDriveStatistic(DriveStatistic entity)
{
DriveStatistic other=new DriveStatistic();
other = entity;
if(entity.IsTransient())
{
string sql=@"Insert into DriveStatistic ( [IPAddress]
,[DriveSpaceAvailable]
,[DriveTotalSpace]
,[DriveName]
,[CreationDate]
,[MachineName] )
Values
( @IPAddress
, @DriveSpaceAvailable
, @DriveTotalSpace
, @DriveName
, @CreationDate
, @MachineName );
Select scope_identity()";
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)};
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 GetDriveStatistic(Convert.ToInt32(identity));
}
return entity;
}
public virtual DriveStatistic DeleteDriveStatistic(DriveStatistic entity)
{
this.DeleteDriveStatistic(entity.DriveStatisticId);
return(entity);
}
public DriveStatistic UpdateDriveStatistic(DriveStatistic entity)
{
return(_iDriveStatisticRepository.UpdateDriveStatistic(entity));
}
public DriveStatistic InsertDriveStatistic(DriveStatistic entity)
{
return(_iDriveStatisticRepository.InsertDriveStatistic(entity));
}
