public override NetworkStatistic InsertNetworkStatistic(NetworkStatistic entity) { NetworkStatistic other = new NetworkStatistic(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into NetworkStatistic ( [InterfaceName] ,[IPAddress] ,[TotalUsage] ,[Download] ,[Upload] ,[CreationDate] ,[ServerIp] ,[ServerName] ) Values ( @InterfaceName , @IPAddress , @TotalUsage , @Download , @Upload , @CreationDate , @ServerIp , @ServerName ); Select scope_identity()" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@InterfaceName", entity.InterfaceName) , new SqlParameter("@IPAddress", entity.IpAddress) , new SqlParameter("@TotalUsage", entity.TotalUsage) , new SqlParameter("@Download", entity.Download) , new SqlParameter("@Upload", entity.Upload) , new SqlParameter("@CreationDate", entity.CreationDate) , new SqlParameter("@ServerIp", entity.ServerIp ?? (object)DBNull.Value) , new SqlParameter("@ServerName", entity.ServerName ?? (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(GetNetworkStatistic(Convert.ToInt32(identity))); } return(entity); }
public override NetworkStatistic InsertNetworkStatistic(NetworkStatistic entity) { NetworkStatistic other = new NetworkStatistic(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into NetworkStatistic ( [InterfaceName] ,[IPAddress] ,[TotalUsage] ,[Download] ,[Upload] ,[CreationDate] ,[ServerIp] ,[ServerName] ) Values ( @InterfaceName , @IPAddress , @TotalUsage , @Download , @Upload , @CreationDate , @ServerIp , @ServerName ); Select scope_identity()"; SqlParameter[] parameterArray = new SqlParameter[]{ new SqlParameter("@InterfaceName",entity.InterfaceName) , new SqlParameter("@IPAddress",entity.IpAddress) , new SqlParameter("@TotalUsage",entity.TotalUsage) , new SqlParameter("@Download",entity.Download) , new SqlParameter("@Upload",entity.Upload) , new SqlParameter("@CreationDate",entity.CreationDate) , new SqlParameter("@ServerIp",entity.ServerIp ?? (object)DBNull.Value) , new SqlParameter("@ServerName",entity.ServerName ?? (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 GetNetworkStatistic(Convert.ToInt32(identity)); } return entity; }
public virtual NetworkStatistic UpdateNetworkStatistic(NetworkStatistic entity) { if (entity.IsTransient()) { return(entity); } NetworkStatistic other = GetNetworkStatistic(entity.NetworkStatisticId); if (entity.Equals(other)) { return(entity); } string sql = @"Update NetworkStatistic set [InterfaceName]=@InterfaceName , [IPAddress]=@IPAddress , [TotalUsage]=@TotalUsage , [Download]=@Download , [Upload]=@Upload , [CreationDate]=@CreationDate , [ServerIp]=@ServerIp , [ServerName]=@ServerName where NetworkStatisticId=@NetworkStatisticId" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@InterfaceName", entity.InterfaceName) , new SqlParameter("@IPAddress", entity.IpAddress) , new SqlParameter("@TotalUsage", entity.TotalUsage) , new SqlParameter("@Download", entity.Download) , new SqlParameter("@Upload", entity.Upload) , new SqlParameter("@CreationDate", entity.CreationDate) , new SqlParameter("@ServerIp", entity.ServerIp ?? (object)DBNull.Value) , new SqlParameter("@ServerName", entity.ServerName ?? (object)DBNull.Value) , new SqlParameter("@NetworkStatisticId", entity.NetworkStatisticId) }; SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray); return(GetNetworkStatistic(entity.NetworkStatisticId)); }
public virtual NetworkStatistic UpdateNetworkStatistic(NetworkStatistic entity) { if (entity.IsTransient()) return entity; NetworkStatistic other = GetNetworkStatistic(entity.NetworkStatisticId); if (entity.Equals(other)) return entity; string sql=@"Update NetworkStatistic set [InterfaceName]=@InterfaceName , [IPAddress]=@IPAddress , [TotalUsage]=@TotalUsage , [Download]=@Download , [Upload]=@Upload , [CreationDate]=@CreationDate , [ServerIp]=@ServerIp , [ServerName]=@ServerName where NetworkStatisticId=@NetworkStatisticId"; SqlParameter[] parameterArray=new SqlParameter[]{ new SqlParameter("@InterfaceName",entity.InterfaceName) , new SqlParameter("@IPAddress",entity.IpAddress) , new SqlParameter("@TotalUsage",entity.TotalUsage) , new SqlParameter("@Download",entity.Download) , new SqlParameter("@Upload",entity.Upload) , new SqlParameter("@CreationDate",entity.CreationDate) , new SqlParameter("@ServerIp",entity.ServerIp ?? (object)DBNull.Value) , new SqlParameter("@ServerName",entity.ServerName ?? (object)DBNull.Value) , new SqlParameter("@NetworkStatisticId",entity.NetworkStatisticId)}; SqlHelper.ExecuteNonQuery(this.ConnectionString,CommandType.Text,sql,parameterArray); return GetNetworkStatistic(entity.NetworkStatisticId); }