public HttpResponseMessage Put(Sale s)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
SalesDA.UpdateSale(s, p.Claims);
return new HttpResponseMessage(HttpStatusCode.OK);
}
private void NewOrder()
{
SelectedSale = new Sale();
if (Order != null)
Order.Clear();
Order = new ObservableCollection<Product>();
SelectedCustomer = null;
}
/*
public List<Sale> Get(Customer c)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
return SalesDA.GetSalesByCustomerID(c, p.Claims);
}
public List<Sale> Get(Register r)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
return SalesDA.GetSalesByRegisterID(r, p.Claims);
}
public List<Sale> Get(Product pr)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
return SalesDA.GetSalesByProductID(pr, p.Claims);
}
public List<Sale> Get(Customer c, Register r, Product pr)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
return SalesDA.GetSalesByCustRegProdID(c,r,pr,p.Claims);
}
*/
public HttpResponseMessage Post(Sale s)
{
ClaimsPrincipal p = RequestContext.Principal as ClaimsPrincipal;
int id = SalesDA.InsertSale(s, p.Claims);
HttpResponseMessage message = new HttpResponseMessage(HttpStatusCode.OK);
message.Content = new StringContent(id.ToString());
return message;
}
private async void SaveSaleClicked()
{
var query = Order.Select(prod => prod.ID).Distinct().ToList();
int amount = 0;
double totalPrice = 0;
Sale sale = new Sale();
foreach (int id in query)
{
var products = Order.Where(prod => prod.ID == id);
foreach (var product in products)
{
amount++;
totalPrice = totalPrice + product.Price;
}
sale.Timestamp = GetUnixTimeStamp();
sale.CustomerID = SelectedCustomer.ID;
sale.ProductID = id;
sale.Amount = amount;
sale.TotalPrice = totalPrice;
SelectedSale = sale;
SaveSale();
}
}
public static int UpdateSale(Sale s, IEnumerable<Claim> claims)
{
string sql = "UPDATE Sale SET Timestamp=@Timestamp, CustomerID=@CustomerID, RegisterID=@RegisterID, ProductID=@ProductID, Amount=@Amount, TotalPrice=@TotalPrice WHERE ID=@ID";
DbParameter par1 = Database.AddParameter(Database.ADMIN_DB, "@Timestamp", s.Timestamp);
DbParameter par2 = Database.AddParameter(Database.ADMIN_DB, "@CustomerID", s.CustomerID);
DbParameter par3 = Database.AddParameter(Database.ADMIN_DB, "@RegisterID", s.RegisterID);
DbParameter par4 = Database.AddParameter(Database.ADMIN_DB, "@ProductID", s.ProductID);
DbParameter par5 = Database.AddParameter(Database.ADMIN_DB, "@Amount", s.Amount);
DbParameter par6 = Database.AddParameter(Database.ADMIN_DB, "@TotalPrice", s.TotalPrice);
DbParameter par7 = Database.AddParameter(Database.ADMIN_DB, "@ID", s.ID);
return Database.ModifyData(Database.GetConnection(CreateConnectionString(claims)), sql, par1, par2, par3, par4, par5, par6, par7);
}
public static int InsertSale(Sale s, IEnumerable<Claim> claims)
{
string sql = "INSERT INTO Sale VALUES(@Timestamp,@CustomerID,@RegisterID,@ProductID,@Amount,@TotalPrice)";
DbParameter par1 = Database.AddParameter(Database.ADMIN_DB, "@Timestamp", s.Timestamp);
DbParameter par2 = Database.AddParameter(Database.ADMIN_DB, "@CustomerID", s.CustomerID);
DbParameter par3 = Database.AddParameter(Database.ADMIN_DB, "@RegisterID", s.RegisterID);
DbParameter par4 = Database.AddParameter(Database.ADMIN_DB, "@ProductID", s.ProductID);
DbParameter par5 = Database.AddParameter(Database.ADMIN_DB, "@Amount", s.Amount);
DbParameter par6 = Database.AddParameter(Database.ADMIN_DB, "@TotalPrice", s.TotalPrice);
return Database.InsertData(Database.GetConnection(CreateConnectionString(claims)), sql, par1, par2, par3, par4, par5, par6);
}
