public bool Add(string dbPath, EnergyConsumptionModel item)
{
if (!File.Exists(dbPath))
{
Console.WriteLine("Database does not exists!");
}
bool result = dataBase.Create(dbPath, item);
CustomPrincipal principal = Thread.CurrentPrincipal as CustomPrincipal;
try
{
Audit.AuthorizationSuccess(principal.Identity.Name, OperationContext.Current.IncomingMessageHeaders.Action);
Audit.AddSuccess(principal.Identity.Name);
}
catch (ArgumentException ae)
{
Audit.AddFailed(principal.Identity.Name);
Console.WriteLine(ae.Message);
}
proxy = Connect();
proxy.Add(dbPath, item);
return(result);
}
public bool Update(string path, EnergyConsumptionModel item)
{
if (!File.Exists(path))
{
Console.WriteLine("Database does not exists!");
}
return(dataBase.Update(path, item));
}
public bool Add(string path, EnergyConsumptionModel item)
{
if (!File.Exists(path))
{
Console.WriteLine("Database does not exists!");
}
bool result = database.Create(path, item);
return(result);
}
public bool Add(string path, EnergyConsumptionModel item)
{
try
{
return(factory.Add(path, item));
}
catch (SecurityAccessDeniedException e)
{
Console.WriteLine("[Add] ERROR = {0}", e.Message);
return(false);
}
}
static void Main(string[] args)
{
string srvCertCN = "sbesservice";
NetTcpBinding binding = new NetTcpBinding();
binding.Security.Transport.ClientCredentialType = TcpClientCredentialType.Certificate;
X509Certificate2 srvCert = Manager.GetCertificateFromStorage(StoreName.TrustedPeople, StoreLocation.LocalMachine, srvCertCN);
EndpointAddress address = new EndpointAddress(new Uri("net.tcp://localhost:9999/Receiver"), new X509CertificateEndpointIdentity(srvCert));
Dictionary <int, string> idMap = new Dictionary <int, string>();
Console.WriteLine("Korisnik {0} je pokrenuo klijenta", WindowsIdentity.GetCurrent().Name);
using (WCFClient proxy = new WCFClient(binding, address))
{
while (true)
{
string option = ShowMenu();
if (option == "1")
{
Console.WriteLine("Enter path:");
string path = Console.ReadLine();
if (proxy.CreateDataBase(path))
{
Console.WriteLine("Database created successfuly");
}
}
else if (option == "2")
{
Console.WriteLine("Enter path:");
string path = Console.ReadLine();
if (!proxy.DatabaseExists(path))
{
Console.WriteLine("Database does not exists!");
continue;
}
string id = Guid.NewGuid().ToString();
Console.Write("Enter region: ");
string region = Console.ReadLine();
Console.Write("Enter city: ");
string city = Console.ReadLine();
Console.Write("Enter year: ");
int year = int.Parse(Console.ReadLine());
Console.Write("Enter usage: ");
double usage = double.Parse(Console.ReadLine());
EnergyConsumptionModel e1 = new EnergyConsumptionModel()
{
identificator = id,
region = region,
city = city,
year = year,
usageOfElectricEnergyPerYear = usage
};
if (proxy.Add(path, e1))
{
Console.WriteLine("Item added successfully");
}
}
else if (option == "3")
{
Console.WriteLine("Enter path:");
string path = Console.ReadLine();
if (!proxy.DatabaseExists(path))
{
Console.WriteLine("Database does not exists!");
continue;
}
List <EnergyConsumptionModel> items = proxy.Read(path);
if (items == null)
{
Console.WriteLine("Database is empty!");
continue;
}
int itemCounter = 1;
for (int i = 0; i < items.Count; i++)
{
Console.WriteLine("---------------------");
Console.WriteLine($"ID: {itemCounter++}");
Console.WriteLine(items[i].region);
Console.WriteLine(items[i].city);
Console.WriteLine(items[i].year);
Console.WriteLine(items[i].usageOfElectricEnergyPerYear);
}
}
else if (option == "4")
{
Console.WriteLine("Enter path:");
string path = Console.ReadLine();
if (!proxy.DatabaseExists(path))
{
Console.WriteLine("Database does not exists!");
Console.WriteLine();
continue;
}
Console.Write("Enter item ID: ");
int id = int.Parse(Console.ReadLine());
idMap = CreateIdMap(proxy, path);
if (proxy.Delete(path, idMap[id]))
{
Console.WriteLine($"Item with id: {id} deleted succesfully");
}
}
else if (option == "5")
{
Console.WriteLine("Enter path:");
string path = Console.ReadLine();
if (!proxy.DatabaseExists(path))
{
Console.WriteLine("Database does not exists!");
continue;
}
Console.Write("Enter item ID: ");
int id = int.Parse(Console.ReadLine());
idMap = CreateIdMap(proxy, path);
var energyModel = proxy.ReadItem(path, idMap[id]);
if (energyModel == null)
{
continue;
}
Console.Write("Enter region: ");
string region = Console.ReadLine();
Console.Write("Enter city: ");
string city = Console.ReadLine();
Console.Write("Enter year: ");
int year = int.Parse(Console.ReadLine());
Console.Write("Enter usage: ");
double usage = double.Parse(Console.ReadLine());
energyModel.region = region;
energyModel.city = city;
energyModel.year = year;
energyModel.usageOfElectricEnergyPerYear = usage;
if (proxy.Update(path, energyModel))
{
Console.WriteLine($"Item with id: {id} updated succesfully");
}
}
else if (option == "6")
{
Console.WriteLine("Enter path:");
string path = Console.ReadLine();
if (!proxy.DatabaseExists(path))
{
Console.WriteLine("Database does not exists!");
continue;
}
Console.WriteLine("Enter city:");
string city = Console.ReadLine();
double result = proxy.AverageConsumptionPerCity(path, city);
if (result == -1)
{
Console.WriteLine("There is no energy consumption records for {0}", city);
}
else
{
Console.WriteLine("Average: {0}", result);
}
}
else if (option == "7")
{
Console.WriteLine("Enter path:");
string path = Console.ReadLine();
if (!proxy.DatabaseExists(path))
{
Console.WriteLine("Database does not exists!");
continue;
}
Console.WriteLine("Enter region:");
string region = Console.ReadLine();
double result = proxy.AverageConsumptionPerRegion(path, region);
if (result == -1)
{
Console.WriteLine("There is no energy consumption records for {0}", region);
}
else
{
Console.WriteLine("Average: {0}", result);
}
}
else if (option == "8")
{
Console.WriteLine("Enter path:");
string path = Console.ReadLine();
if (!proxy.DatabaseExists(path))
{
Console.WriteLine("Database does not exists!");
continue;
}
Console.WriteLine("Enter region:");
string region = Console.ReadLine();
string result = proxy.MaxConsumptionPerRegion(path, region);
if (result == null)
{
Console.WriteLine("There is no energy consumption records for {0}", region);
}
else
{
Console.WriteLine("Result: {0}", result);
}
}
}
}
}
