private CustomersList ReadFromFile()
{
FileStream fs = null;
CustomersList c = new CustomersList();
int type, size, outlets, bulbs;
string cc;
try
{
fs = new FileStream("customers.txt", FileMode.OpenOrCreate, FileAccess.Read);
BinaryReader br = new BinaryReader(fs);
while (br.BaseStream.Position != br.BaseStream.Length)
{
type = br.ReadInt32();
size = br.ReadInt32();
outlets = br.ReadInt32();
bulbs = br.ReadInt32();
cc = br.ReadString();
switch (type)
{
case 1:
c.Add(new Barn(size, bulbs, outlets, cc));
break;
case 2:
c.Add(new Garage(size, bulbs, outlets, cc));
break;
case 3:
c.Add(new House(size, bulbs, outlets, cc));
break;
}
}
return(c);
}
catch (IOException ioe)
{
string ex = ioe.ToString();
return(null);
}
finally
{
if (fs != null)
{
fs.Close();
}
}
}
private void OnAddCustomerCommandExecute()
{
Customer customer = new Customer();
customer.Name = CurrentCustomerName;
customer.MVZList = new ObservableCollection <MVZ>();
foreach (var item in MVZList)
{
customer.MVZList.Add(item);
}
CustomersList.Add(customer);
db.SaveChanges();
}
public static string GET_ALL_CUSTOMERS()
{
try
{
conn.Open();
//utworzenie zapytania do bazy o pozycję użytkownika
MySqlCommand command = conn.CreateCommand();
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "SELECT * FROM customers";
//sprawdzenie, czy baza zwróciła cokolwiek
object result = command.ExecuteScalar();
//jeśli zwróciła
if (result != null)
{
var reader = command.ExecuteReader();
reader.Read();
while (reader.Read())
{
CustomersList.Add(new Customer(reader));
}
return("customers-loaded");
}
//jeśli nie zwróciła - brak klientów w bazie
else
{
return("no-customer");
}
}
//obsługa błędu połączenia z bazą
catch (MySqlException)
{
return("no-connection");
}
finally
{
conn.Close();
}
}
private void BtnAdd_Click(object sender, RoutedEventArgs e)
{
bool result = true;
int size = 0;
int bulbs = 0;
int outlets = 0;
int i = -1;
string cc = string.Empty;
if ((!int.TryParse(TxtSize.Text.Trim(), out size)) || (size < 1000) || (size > 50000))
{
result = false;
TxtSize.Foreground = Brushes.Red;
}
if (!(int.TryParse(TxtBulbs.Text.Trim(), out bulbs)) || (bulbs < 1) || (bulbs > 20))
{
result = false;
TxtBulbs.Foreground = Brushes.Red;
}
if (!(int.TryParse(TxtOutlets.Text.Trim(), out outlets)) || (outlets < 1) || (outlets > 50))
{
result = false;
TxtOutlets.Foreground = Brushes.Red;
}
cc = TxtCC.Text.Trim();
if (!Program.CheckCard(cc))
{
result = false;
TxtCC.Foreground = Brushes.Red;
}
switch (TxtType.Text.Trim())
{
default:
TxtType.Foreground = Brushes.Red;
break;
case "Barn":
if (result)
{
customers.Add(new Barn(size, bulbs, outlets, cc));
i++;
WriteToFile(customers[i]);
ClearData();
}
break;
case "Garage":
if (result)
{
customers.Add(new Garage(size, bulbs, outlets, cc));
i++;
WriteToFile(customers[i]);
ClearData();
}
break;
case "House":
if (result)
{
customers.Add(new House(size, bulbs, outlets, cc));
i++;
WriteToFile(customers[i]);
ClearData();
}
break;
}
}
public void AddCustomer(Customer customer)
{
CustomersList.Add(customer);
}
