public static User getUsuario(int userId)
{
User usuario = new User();
DataTable table = DB.getStaticData("SELECT * FROM Usuario WHERE ID = " + userId);
if (table.Rows.Count > 0)
usuario.Load(table.Rows[0]);
return usuario;
}
static void Main(string[] args)
{
//Task1
Address addressdefault = new Address();
Address address = new Address() { Apartment = 110 , City = "Kiev", Country = "Ukraine", House = 50 , Index = 58000, Street = "Hreshatik"};
Address addressChangedIndex = new Address(10000);
addressdefault.DisplayAddress();
address.DisplayAddress();
Console.WriteLine(addressChangedIndex.ToString());
//Task 2
string str = "";
double number1 = 0;
double number2 = 0;
number1 = str.CheckDoubleDigits();
number2 = str.CheckDoubleDigits();
Rectangle rectangle = new Rectangle(number1, number2);
Console.WriteLine(rectangle.ToString());
//Task 3
Book book = new Book("Programming","Troelsen","C#");
book.Show();
Console.ResetColor();
//Task 4
Point A = new Point(1, 2);
Point B = new Point(2, 1);
Point C = new Point(3, 2);
Figure figure = new Figure(A, B, C);
figure.Display();
//Task 5
User user = new User(login:"******", password: "******", name: "Jack", sername:"...");
user.Output();
//Task 6
Converter conv = new Converter(24.6081, 25.99,0.3274);
conv.Sum = 10.11;
conv.ChooseCurrency();
conv.ExchangeCurrency();
//Task 7
Employee employee = new Employee("User", "Relly");
employee.Display();
//Task 8
Invoice invoice = new Invoice(10000, "Customer" ,"Provider");
invoice.Article = "PC";
invoice.Quantity = 2;
invoice.Display();
Console.ReadLine();
Console.ReadLine();
}
public static List<User> getUsuarios()
{
List<User> usuarios = new List<User>();
DataTable table = DB.getStaticData(" SELECT * FROM Usuario ");
foreach (DataRow row in table.Rows)
{
User usuario = new User();
usuario.Load(row);
usuarios.Add(usuario);
}
return usuarios;
}
public static User getUsuarioByLogin(string email, string password)
{
DataTable dt = DB.getStaticData("SELECT * FROM [User] WHERE Email = "
+ DB.Quote(email) + " AND Password = " + DB.Quote(DB.getMD5Hash(password)));
User usuario = new User();
if (dt.Rows.Count > 0)
{
usuario.Load(dt.Rows[0]);
return usuario;
}
else
{
return null;
}
}
