public Worker Get(string identificationCard)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
var json = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(json);
int x = 0;
Worker worker = new Worker();
while (x < list.Workers.Count)
{
if (string.Equals(list.Workers[x].IdentificationCard, identificationCard))
{
worker = list.Workers[x];
}
x++;
}
return(worker);
}
}
public List <HourRecord> Get(string name)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
var json = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(json);
int x = 0;
List <HourRecord> hourRecords = new List <HourRecord>();
while (x < list.HourRecords.Count)
{
if (string.Equals(list.HourRecords[x].Name, name))
{
hourRecords.Add(list.HourRecords[x]);
}
x++;
}
return(hourRecords);
}
}
public List <BranchInventory> Get(string branchOffice)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
var json = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(json);
int x = 0;
List <BranchInventory> branchInventories = new List <BranchInventory>();
while (x < list.BranchInventories.Count)
{
if (string.Equals(list.BranchInventories[x].BranchOffice, branchOffice))
{
branchInventories.Add(list.BranchInventories[x]);
}
x++;
}
return(branchInventories);
}
}
public void Put(string barcode, string name, int price, string description, string provider, int tax, int discount)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
var json = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(json);
int x = 0;
while (x < list.Products.Count)
{
if (string.Equals(list.Products[x].Barcode, barcode) && string.Equals(list.Products[x].Name, name))
{
list.Products[x].Barcode = barcode;
list.Products[x].Name = name;
list.Products[x].Price = price;
list.Products[x].Description = description;
list.Products[x].Supplier = provider;
list.Products[x].Tax = tax;
list.Products[x].Discount = discount;
}
x++;
}
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public void Put(string identificationCard, string name, string birthDate, string admissionDate, string branchOffice, int hourlyWage, string rol)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
var json = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(json);
int x = 0;
while (x < list.Workers.Count)
{
if (string.Equals(list.Workers[x].IdentificationCard, identificationCard))
{
list.Workers[x].IdentificationCard = identificationCard;
list.Workers[x].Name = name;
list.Workers[x].BirthDate = birthDate;
list.Workers[x].AdmissionDate = admissionDate;
list.Workers[x].BranchOffice = branchOffice;
list.Workers[x].HourlyWage = hourlyWage;
list.Workers[x].Rol = rol;
}
x++;
}
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public void Put(string id, string description, string realDate, string registrationDate, string supplier, string image, string branchOffice)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
var json = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(json);
int x = 0;
while (x < list.Purchases.Count)
{
if (string.Equals(list.Purchases[x].ID, id))
{
list.Purchases[x].Description = description;
list.Purchases[x].RealDate = realDate;
list.Purchases[x].RegistrationDate = registrationDate;
list.Purchases[x].Supplier = supplier;
list.Purchases[x].Image = image;
list.Purchases[x].BranchOffice = branchOffice;
}
x++;
}
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public void Post(string description, string realDate, string registrationDate, string supplier, string image, string branchOffice)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
Random rnd = new Random();
Purchase purchase = new Purchase
{
ID = rnd.Next(0, 9999).ToString(),
Description = description,
RealDate = realDate,
RegistrationDate = registrationDate,
Supplier = supplier,
Image = image,
BranchOffice = branchOffice
};
var jsonOld = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(jsonOld);
list.Purchases.Add(purchase);
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public void Put(string name, string address, string phone, string administrator)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
var json = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(json);
int x = 0;
while (x < list.BranchOffices.Count)
{
if (string.Equals(list.BranchOffices[x].Name, name))
{
list.BranchOffices[x].Name = name;
list.BranchOffices[x].Address = address;
list.BranchOffices[x].Phone = phone;
list.BranchOffices[x].Administrator = administrator;
}
x++;
}
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public void Post(string barcode, string name, string description, int branchPrice, int stock, string branchOffice)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
BranchInventory branchInventory = new BranchInventory
{
Barcode = barcode,
Name = name,
Description = description,
BranchPrice = branchPrice,
Stock = stock,
BranchOffice = branchOffice
};
var jsonOld = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(jsonOld);
list.BranchInventories.Add(branchInventory);
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public void Post(string barcode, string name, int price, string description, string provider, int tax, int discount)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
Product product = new Product
{
Barcode = barcode,
Name = name,
Price = price,
Description = description,
Supplier = provider,
Tax = tax,
Discount = discount
};
var json = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(json);
list.Products.Add(product);
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public void Put(string name, string weekBeginning, string weekEnd, int workedHours)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
var json = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(json);
int x = 0;
while (x < list.HourRecords.Count)
{
if (string.Equals(list.HourRecords[x].Name, name) && string.Equals(list.HourRecords[x].WeekBeginning, weekBeginning) && string.Equals(list.HourRecords[x].WeekEnd, weekEnd))
{
list.HourRecords[x].Name = name;
list.HourRecords[x].WeekBeginning = weekBeginning;
list.HourRecords[x].WeekEnd = weekEnd;
list.HourRecords[x].WorkedHours = workedHours;
}
x++;
}
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public void Post(string identificationCard, string name, string birthDate, string admissionDate, string branchOffice, int hourlyWage, string rol)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
Worker worker = new Worker
{
IdentificationCard = identificationCard,
Name = name,
BirthDate = birthDate,
AdmissionDate = admissionDate,
BranchOffice = branchOffice,
HourlyWage = hourlyWage,
Rol = rol
};
var jsonOld = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(jsonOld);
list.Workers.Add(worker);
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public List <HourRecord> Get()
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
var json = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(json);
return(list.HourRecords);
}
}
public void Post(string name, string address, string phone, string administrator)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
BranchOffice BranchOffices = new BranchOffice
{
Name = name,
Address = address,
Phone = phone,
Administrator = administrator
};
var jsonOld = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(jsonOld);
list.BranchOffices.Add(BranchOffices);
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public void Delete(string identificationCard)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
var json = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(json);
int x = 0;
while (x < list.Workers.Count)
{
if (string.Equals(list.Workers[x].IdentificationCard, identificationCard))
{
list.Workers.RemoveAt(x);
}
x++;
}
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public void Post(string name, string weekBeginning, string weekEnd, int workedHours)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
HourRecord hourRecord = new HourRecord
{
Name = name,
WeekBeginning = weekBeginning,
WeekEnd = weekEnd,
WorkedHours = workedHours
};
var jsonOld = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(jsonOld);
list.HourRecords.Add(hourRecord);
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public void Post(string identificationCard, string name)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
Supplier Suppliers = new Supplier
{
IdentificationCard = identificationCard,
Name = name
};
var jsonOld = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(jsonOld);
list.Suppliers.Add(Suppliers);
//Serializar el json
var request2 = (HttpWebRequest)WebRequest.Create(url);
request2.Method = "POST";
request2.ContentType = "application/json";
request2.Timeout = 30000;
string jsonNew = JsonConvert.SerializeObject(list);
byte[] byteArray = Encoding.UTF8.GetBytes(jsonNew);
request2.ContentLength = byteArray.Length;
using (var dataStream = request2.GetRequestStream())
{
dataStream.Write(byteArray, 0, byteArray.Length);
}
using (HttpWebResponse response3 = (HttpWebResponse)request2.GetResponse())
{
using (Stream stream2 = response3.GetResponseStream())
{
using (StreamReader reader = new StreamReader(stream2))
{
string responseFromServer = reader.ReadToEnd();
}
}
}
}
}
public Purchase Get(string id)
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader jsonStream = new StreamReader(stream))
{
var json = jsonStream.ReadToEnd();
DataBaseStruct list = JsonConvert.DeserializeObject <DataBaseStruct>(json);
int x = 0;
Purchase purchase = new Purchase();
while (x < list.Purchases.Count)
{
if (string.Equals(list.Purchases[x].ID, id))
{
purchase = list.Purchases[x];
}
x++;
}
return(purchase);
}
}
public COMMON_DBC GetDataBase(DataBaseStruct edb)
{
return(GetDataBase((int)edb));
}
