public void Destroy(purchase_history product)
{
//if (!UpdateDatabase)
//{
// var target = GetAll().FirstOrDefault(p => p.id == product.id);
// if (target != null)
// {
// GetAll().Remove(target);
// }
//}
//else
//{
// var entity = new Product();
// entity.ProductID = product.ProductID;
// entities.Products.Attach(entity);
// entities.Products.Remove(entity);
// var orderDetails = entities.Order_Details.Where(pd => pd.ProductID == entity.ProductID);
// foreach (var orderDetail in orderDetails)
// {
// entities.Order_Details.Remove(orderDetail);
// }
// entities.SaveChanges();
//}
}
public void Update(purchase_history product)
{
//is function ko khud implement krna pare ga requirement k mutabik.
//if (!UpdateDatabase)
//{
// var target = One(e => e.id == product.id);
// if (target != null)
// {
// target.item_id = product.item_id;
// target.dt = DateTime.Now;
// target.qty = product.qty;
// target.price = product.price;
// }
// entities.SaveChanges();
//}
//else
//{
// var entity = new purchase_history();
// entity.item_id = product.item_id;
// entity.dt = DateTime.Now;
// entity.qty = product.qty;
// entity.price = product.price;
// entities.purchase_history.Attach(entity);
// entities.Entry(entity).State = EntityState.Modified;
// entities.SaveChanges();
//}
}
public void Update(purchase_history product)
{
if (!UpdateDatabase)
{
var target = One(e => e.id == product.id);
if (target != null)
{
target.item_id = product.item_id;
target.dt = DateTime.Now;
target.qty = product.qty;
target.price = product.price;
}
entities.SaveChanges();
}
else
{
var entity = new purchase_history();
entity.item_id = product.item_id;
entity.dt = DateTime.Now;
entity.qty = product.qty;
entity.price = product.price;
entities.purchase_history.Attach(entity);
entities.Entry(entity).State = EntityState.Modified;
entities.SaveChanges();
}
}
public void Create(purchase_history product)
{
if (!UpdateDatabase)
{
var first = GetAll().OrderByDescending(e => e.id).FirstOrDefault();
var id = (first != null) ? first.id : 0;
product.id = id + 1;
entities.purchase_history.Add(product);
entities.SaveChanges();
}
else
{
var entity = new purchase_history();
entity.item_id = product.item_id;
entity.dt = DateTime.Now;
entity.qty = product.qty;
entity.price = product.price;
entities.purchase_history.Add(entity);
entities.SaveChanges();
product.id = entity.id;
}
}
private void DeleteButton_OnClick(object sender, RoutedEventArgs e)
{
string battleTag = BattleTag.Text;
string purchaseID = PurchaseID.Text;
if (!string.IsNullOrEmpty(battleTag))
{
int temp;
if (int.TryParse(battleTag, out temp))
{
purchase_history PurchaseHistory = purchase_historyDA.GetPurchase(int.Parse(battleTag));
if (PurchaseHistory != null)
{
if (PurchaseHistory.PurchaseID.ToString() == purchaseID)
{
purchase_historyDA.DeletePurchase(int.Parse(purchaseID));
Close();
}
}
else
{
MessageBox.Show($"Invalid Battle Tag! Try Again!");
}
}
else
{
MessageBox.Show($"Invalid Battle Tag! Try Again!");
}
}
}
public static purchase_history GetPurchase(int purchaseHistoryID)
{
string query = "SELECT * FROM purchase_history WHERE player_id = (@PurchaseHistoryID) limit 1";
cmd = DBHelper.GetPurchaseHistoryQuery(query, purchaseHistoryID);
purchase_history aUser = null;
if (cmd != null)
{
dt = new DataTable();
sda = new MySqlDataAdapter(cmd);
sda.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
string uPlayerID = dr["player_id"].ToString();
string uPurchaseID = dr["purchased_id"].ToString();
string uPurchasedItem = dr["purchased_item"].ToString();
string uCostInPhp = dr["cost_in_php"].ToString();
string uPaidAmountInPhp = dr["paid_amount_in_php"].ToString();
string uDatePurchased = dr["date_purchased"].ToString();
aUser = new purchase_history(uPlayerID, uPurchaseID, uPurchasedItem, uCostInPhp, uPaidAmountInPhp, uDatePurchased);
}
}
return(aUser);
}
