private bool addOrder()
{
if (missingValues()) return false;
if (invalidTelephone()
&& invalidEmail()
&& invalidPrice()) return false;
Address address = new Address();
if (emailText.Text.Trim().Length != 0)
address.Email = emailText.Text;
address.TelNumber = telephoneText.Text;
Customer customer = new Customer();
customer.FirstName = fNameText.Text;
customer.LastName = lNameText.Text;
customer.LastUpdate = System.DateTime.Now;
customer.Address = address;
Order newOrder = new Order();
newOrder.Bicycle = BicycleText.Text;
newOrder.DueDate = dueDateDatePicker.SelectedDate;
newOrder.OrderDate = System.DateTime.Now;
newOrder.Completed = false;
newOrder.Price = Convert.ToDecimal(priceText.Text);
newOrder.Comments = commentsText.Text;
newOrder.Customer = customer;
if (saveOrder(newOrder)) return true;
else return false;
}
public void orderIsPersistedInDatabase()
{
Order o = new Order();
o.Customer.Address.Email = "*****@*****.**";
o.Customer.Address.TelNumber = "02084854753";
o.Customer.FirstName = "Michal";
o.Customer.LastName = "Kepa";
o.Price = 244.83m;
o.Bicycle = "Damka";
o.DueDate=DateTime.Now;
o.DueDate = (DateTime.Now).AddDays(3);
o.Comments="Jaska";
SqlAccess.addOrder(o);
}
public AddOrderWindow(Order order)
{
InitializeComponent();
this.ExistingOrder = order;
this.Customer = ExistingOrder.Customer;
findButton.IsEnabled = false;
if (isCompletedCheck.IsChecked.Value) { isCompletedCheck.IsEnabled = false; }
fNameText.Text = Customer.FirstName;
// Disable some fields and this is only update, decide which ones
fNameText.IsEnabled = false;
lNameText.Text = Customer.LastName;
telephoneText.Text = Customer.Address.TelNumber;
emailText.Text = Customer.Address.Email;
priceText.Text = ExistingOrder.Price.ToString();
BicycleText.Text = order.Bicycle;
dueDateDatePicker.Text = order.DueDate.ToString();
commentsText.Text = order.Comments;
isCompletedCheck.IsChecked = order.Completed;
// is it how I find check buttion value?
if (isCompletedCheck.IsChecked.Value) { isCompletedCheck.IsEnabled = false; }
}
public static bool addOrder(Order newOrder)
{
using (SqlConnection con = new SqlConnection(
SqlConnectionString))
{
con.Open();
try
{
using (SqlCommand command = new SqlCommand(
@"
BEGIN TRANSACTION
INSERT INTO Addresses(TelNumber,Email) VALUES (@TelNumber,@Email);
INSERT INTO Customers(AddressID,FirstName,LastName) VALUES ((SELECT TOP 1 AddressID FROM Addresses WHERE TelNumber=@TelNumber AND Email=@Email), @FirstName,@LastName);
INSERT INTO Repairs(CustomerID,Bicycle,Price,DueDate,Comments) VALUES((SELECT TOP 1 CustomerID FROM Customers WHERE
FirstName=@FirstName AND LastName=@LastName AND AddressID=(SELECT TOP 1 AddressID FROM Addresses WHERE TelNumber=@TelNumber AND Email=@Email)),@Bicycle,@Price,@DueDate,@Comments);
COMMIT
", con))
{
command.Parameters.Add(new SqlParameter("TelNumber", newOrder.Customer.Address.TelNumber));
command.Parameters.Add(new SqlParameter("Email", newOrder.Customer.Address.Email));
command.Parameters.Add(new SqlParameter("FirstName", newOrder.Customer.FirstName));
command.Parameters.Add(new SqlParameter("LastName", newOrder.Customer.LastName));
command.Parameters.Add(new SqlParameter("Bicycle", newOrder.Bicycle));
command.Parameters.Add(new SqlParameter("Price", newOrder.Price));
command.Parameters.Add(new SqlParameter("DueDate", newOrder.DueDate));
command.Parameters.Add(new SqlParameter("Comments", newOrder.Comments));
command.ExecuteNonQuery();
return true;
}
}
catch (Exception e)
{
SqlExeptions(e);
return false;
}
}
}
private bool updateOrder()
{
if (missingValues()) return false;
if (invalidTelephone()
&& invalidEmail()
&& invalidPrice()) return false;
ExistingOrder = new Order();
ExistingOrder.Customer.FirstName = fNameText.Text;
ExistingOrder.Customer.LastName = lNameText.Text;
ExistingOrder.Customer.Address.Email = emailText.Text;
ExistingOrder.Customer.Address.TelNumber = telephoneText.Text;
ExistingOrder.DueDate = dueDateDatePicker.SelectedDate;
//HANDLE THIS
ExistingOrder.Price = Convert.ToDecimal(priceText.Text);
ExistingOrder.Comments = commentsText.Text;
ExistingOrder.Completed = isCompletedCheck.IsChecked;
if (updateOrderSQL()) return true;
else return false;
}
private bool saveOrder(Order newOrder)
{
//TODO: Add Order to Database
return SqlAccess.addOrder(newOrder);
//throw new NotImplementedException();
}
