public override int GetHashCode()
{
//Insensitive case
return((ServerId.ToString().ToLower() +
Database.ToLower() +
Schema.ToLower() +
Table.ToLower()).GetHashCode());
}
/// <summary>
/// The process record method.
/// </summary>
protected override void ProcessRecord()
{
base.ProcessRecord();
try
{
Status jobResult = null;
switch (ParameterSetName)
{
case "restoreById":
if (TargetServerId == Guid.Empty)
{
jobResult =
Connection.ApiClient.Backup.InPlaceRestore(ServerId.ToString(), BackupClientId.ToString(), AsAtDate).Result;
}
else
{
jobResult =
Connection.ApiClient.Backup.OutOfPlaceRestore(ServerId.ToString(), BackupClientId.ToString(), AsAtDate, TargetServerId.ToString()).Result;
}
break;
case "restoreByObject":
if (TargetServer == null)
{
jobResult =
Connection.ApiClient.Backup.InPlaceRestore(Server.id, BackupClient, AsAtDate).Result;
}
else
{
jobResult =
Connection.ApiClient.Backup.OutOfPlaceRestore(Server.id, BackupClient, AsAtDate, TargetServer).Result;
}
break;
}
WriteObject(jobResult);
}
catch (AggregateException ae)
{
ae.Handle(
e =>
{
if (e is ComputeApiException)
{
WriteError(new ErrorRecord(e, "-2", ErrorCategory.InvalidOperation, Connection));
}
else
{
ThrowTerminatingError(new ErrorRecord(e, "-1", ErrorCategory.ConnectionError, Connection));
}
return(true);
});
}
}
public void TestServerIdInvalid()
{
var target = new ServerId("irgendwas");
Assert.IsFalse(target.IsValid);
Assert.AreEqual("irgendwas", target.ToString());
Assert.AreEqual("irgendwas", target.ToHexString());
Assert.AreEqual("irgendwas", target.ToStringWithoutSpace());
}
public void AddServer(ServerId server)
{
_lock.EnterWriteLock();
if (!_model.Exists(x => x.Equals(server)))
{
var hash = HashConvertor.GetString(server.ToString());
_model.Add(new DistributorDescription(hash, server));
}
_lock.ExitWriteLock();
}
public void TestServerIdDin_43863_5_2010_2()
{
var target = new ServerId("064d554301001dd8594E");
Assert.IsTrue(target.IsValid);
Assert.AreEqual(ObisMedium.Electricity, target.Medium);
Assert.AreEqual("MUC", target.FlagId);
Assert.AreEqual(12345678u, target.Number);
Assert.AreEqual("1 MUC 10 00 12345678", target.ToString());
Assert.AreEqual("064D554301001DD8594E", target.ToHexString());
}
public void TestServerIdDin_43863_5_2010_7()
{
var target = new ServerId("090E4d5543AB00bc614e");
Assert.IsTrue(target.IsValid);
Assert.AreEqual(ObisMedium.Communication, target.Medium);
Assert.AreEqual("MUC", target.FlagId);
Assert.AreEqual(12345678u, target.Number);
Assert.AreEqual("E MUC AB 12345678", target.ToString());
Assert.AreEqual("090E4D5543AB00BC614E", target.ToHexString());
}
public void TestServerIdWirelessMBus()
{
var target = new ServerId("01E230197600150003");
Assert.IsTrue(target.IsValid);
Assert.AreEqual(ObisMedium.Gas, target.Medium);
Assert.AreEqual("LGB", target.FlagId);
Assert.AreEqual(15007619u, target.Number);
Assert.AreEqual("LGB 15007619", target.ToString());
Assert.AreEqual("01E230197600150003", target.ToHexString());
}
public void TestServerIdWiredMBus()
{
var target = new ServerId("0224010523AC484104");
Assert.IsTrue(target.IsValid);
Assert.AreEqual(ObisMedium.Heat, target.Medium);
Assert.AreEqual("REL", target.FlagId);
Assert.AreEqual(23050124u, target.Number);
Assert.AreEqual("REL 23050124", target.ToString());
Assert.AreEqual("0224010523AC484104", target.ToHexString());
}
public void TestServerWMBusWithoutTypeEsy()
{
var target = new ServerId("7916802852601001");
Assert.IsTrue(target.IsValid);
Assert.AreEqual(ObisMedium.Abstract, target.Medium);
Assert.AreEqual("ESY", target.FlagId);
Assert.AreEqual(60522880u, target.Number);
Assert.AreEqual("ESY 60522880", target.ToString());
Assert.AreEqual("7916802852601001", target.ToHexString());
Assert.AreEqual(ServerId.ServerIdType.WirelessMBusAddress, target.Type);
}
public void TestServerWMBusWithoutTypeLgb()
{
var target = new ServerId("e230197600150003");
Assert.IsTrue(target.IsValid);
Assert.AreEqual(ObisMedium.Gas, target.Medium);
Assert.AreEqual("LGB", target.FlagId);
Assert.AreEqual(15007619u, target.Number);
Assert.AreEqual("LGB 15007619", target.ToString());
Assert.AreEqual("E230197600150003", target.ToHexString());
Assert.AreEqual(ServerId.ServerIdType.WirelessMBusAddress, target.Type);
}
/// <summary>
/// Executes the cmdlet.
/// </summary>
public override void ExecuteCmdlet()
{
base.ExecuteCmdlet();
ExecuteClientAction(() =>
{
var resourceName = default(string);
var resourceGroupName = default(string);
var parentResourceName = default(string);
if (this.IsParameterBound(c => c.ResourceId))
{
var resourceIdentifier = new ResourceIdentifier(ResourceId);
if (!string.Equals(StorageSyncConstants.RegisteredServerType, resourceIdentifier.ResourceType, System.StringComparison.OrdinalIgnoreCase))
{
throw new PSArgumentException(nameof(ResourceId));
}
resourceName = resourceIdentifier.ResourceName;
resourceGroupName = resourceIdentifier.ResourceGroupName;
parentResourceName = resourceIdentifier.GetParentResourceName(StorageSyncConstants.StorageSyncServiceTypeName);
}
else if (this.IsParameterBound(c => c.InputObject))
{
resourceName = InputObject.ServerId;
resourceGroupName = InputObject.ResourceGroupName;
parentResourceName = InputObject.StorageSyncServiceName;
}
else
{
resourceName = ServerId.ToString();
resourceGroupName = ResourceGroupName;
parentResourceName = StorageSyncServiceName;
}
Target = string.Join("/", resourceGroupName, parentResourceName, resourceName);
ActionMessage = StorageSyncResources.UnregisterServerActionMessage;
if (ShouldProcess(Target, ActionMessage))
{
if (Force || ShouldContinue(string.Format("Remove Sync Server '{0}' and all content in it", resourceName), ""))
{
StorageSyncClientWrapper.StorageSyncManagementClient.RegisteredServers.Delete(resourceGroupName, parentResourceName, resourceName);
}
}
});
if (PassThru.IsPresent)
{
WriteObject(true);
}
}
public void TestServerIdLowerCase()
{
var target = new ServerId("e ppc 02 10486901");
Assert.AreEqual(ObisMedium.Communication, target.Medium);
Assert.AreEqual("PPC", target.FlagId);
Assert.AreEqual(2, target.ProductionBlock);
Assert.AreEqual(10486901u, target.Number);
Assert.AreEqual("E PPC 02 10486901", target.ToString());
Assert.AreEqual("EPPC0210486901", target.ToStringWithoutSpace());
Assert.AreEqual("0A0E5050430200A00475", target.ToHexString());
}
public void TestServerId2()
{
var target = new ServerId("0A01454D48000051971E");
Assert.AreEqual(ObisMedium.Electricity, target.Medium);
Assert.AreEqual("EMH", target.FlagId);
Assert.AreEqual(0, target.ProductionBlock);
Assert.AreEqual(5347102u, target.Number);
Assert.AreEqual("1 EMH 00 05347102", target.ToString());
Assert.AreEqual("1EMH0005347102", target.ToStringWithoutSpace());
Assert.AreEqual("0A01454D48000051971E", target.ToHexString());
}
/// <summary>
/// Convert the string to a formatted device id.
/// </summary>
/// <param name="value">The string value to format.</param>
/// <returns>The formatted string.</returns>
public static string ToFormattedDeviceId(this string value)
{
try
{
var serverId = new ServerId(value);
if (serverId.IsValid && string.IsNullOrWhiteSpace(serverId.FlagId))
{
return(serverId.Number.ToString());
}
return(serverId.ToString());
}
catch
{
return(value);
}
}
//
/// <summary>
/// Create a 'to string'.
/// </summary>
public override string ToString()
{
//
StringBuilder _return = new StringBuilder("record:[");
_return.AppendFormat("IncidentId: {0}, ", IncidentId.ToString());
_return.AppendFormat("ServerId: {0}, ", ServerId.ToString());
_return.AppendFormat("IPAddress: {0}, ", IPAddress);
_return.AppendFormat("NIC: {0}, ", NIC);
_return.AppendFormat("NetworkName: {0}, ", NetworkName);
_return.AppendFormat("AbuseEmailAddress: {0}, ", AbuseEmailAddress);
_return.AppendFormat("ISPTicketNumber: {0}, ", ISPTicketNumber);
_return.AppendFormat("Mailed: {0}, ", Mailed.ToString());
_return.AppendFormat("Closed: {0}, ", Closed.ToString());
_return.AppendFormat("Special: {0}, ", Special.ToString());
_return.AppendFormat("Notes: {0}, ", Notes);
_return.AppendFormat("CreatedDate: {0}]", CreatedDate.ToString());
return(_return.ToString());
}
//
/// <summary>
/// Create a 'to string'.
/// </summary>
public override string ToString()
{
//
StringBuilder _return = new StringBuilder("record:[");
_return.AppendFormat("ServerId: {0}, ", ServerId.ToString());
_return.AppendFormat("CompanyId: {0}, ", CompanyId.ToString());
_return.AppendFormat("ServerShortName: {0}, ", ServerShortName);
_return.AppendFormat("ServerName: {0}, ", ServerName);
_return.AppendFormat("ServerDescription: {0}, ", ServerDescription);
_return.AppendFormat("ServerLocation: {0}, ", ServerLocation);
_return.AppendFormat("FromName: {0}, ", FromName);
_return.AppendFormat("FromNicName: {0}, ", FromNicName);
_return.AppendFormat("FromEmailAddress: {0}, ", FromEmailAddress);
_return.AppendFormat("TimeZone: {0}, ", TimeZone);
_return.AppendFormat("DST: {0}, ", DST.ToString());
_return.AppendFormat("TimeZone_DST: {0}, ", TimeZone_DST);
if (DST_Start.HasValue)
{
_return.AppendFormat("DST_Start: {0}, ", DST_Start.ToString());
}
else
{
_return.AppendFormat("/DST_Start/, ");
}
if (DST_End.HasValue)
{
_return.AppendFormat("DST_End: {0}, ", DST_End.ToString());
}
else
{
_return.AppendFormat("/DST_End/, ");
}
_return.AppendFormat("]");
return(_return.ToString());
}
public override string GetKeyCode()
{
return(ServerId.ToString());
}
public static Dictionary <string, string> PolaczZBazaLinkZamowienieKlient()
{
//set the connection string
string connString = conn_string;
//variables to store the query results
try
{
//sql connection object
using (SqlConnection conn = new SqlConnection(connString))
{
//define the SqlCommand object
SqlCommand cmd = new SqlCommand(query_get_orders, conn);
//open connection
conn.Open();
//execute the SQLCommand
SqlDataReader dr = cmd.ExecuteReader();
// Console.WriteLine(Environment.NewLine + "Retrieving data from database...LinkZamowienieKlient" + Environment.NewLine);
// Console.WriteLine("Retrieved records:");
string ZamowienieIdHashKey, KlientIdHashKey, mail, RecordSource;
int ETL_RunId, ServerId, Id, id_klienta;
Dictionary <string, string> temp = new Dictionary <string, string>();
//check if there are records
if (dr.HasRows)
{
while (dr.Read())
{
ZamowienieIdHashKey = dr.GetString(1);
KlientIdHashKey = dr.GetString(2);
ETL_RunId = dr.GetInt32(3);
RecordSource = dr.GetString(4);
ServerId = dr.GetInt32(5);
Id = dr.GetInt32(6);
id_klienta = dr.GetInt32(7);
mail = dr.GetString(8);
Dictionary <string, string> tempin = new Dictionary <string, string>();
tempin["ZamowienieKlientHashKey"] = ZamowienieIdHashKey;
tempin["KlientIdHashKey"] = KlientIdHashKey;
tempin["ETL_RunId"] = ETL_RunId.ToString();
tempin["RecordSource"] = RecordSource;
tempin["ServerId"] = ServerId.ToString();
tempin["Id"] = Id.ToString();
tempin["id_klienta"] = id_klienta.ToString();
tempin["mail"] = mail;
temp[ZamowienieIdHashKey] = KlientIdHashKey;
}
}
else
{
Console.WriteLine("No data found.");
}
//close data reader
dr.Close();
//close connection
conn.Close();
return(temp);
}
}
catch (Exception ex)
{
//display error message
Console.WriteLine("Exception: " + ex.Message);
}
return(new Dictionary <string, string>());
}
public void ToString_should_return_string_representation()
{
var subject = new ServerId(__clusterId, __endPoint);
subject.ToString().Should().Be("{ ClusterId : 1, EndPoint : \"Unspecified/localhost:27017\" }");
}
