public async Task <bool> Order_DetailsExists(IOrder_Details order_Details)
{
string query = @"SELECT * FROM Order_Details WHERE [UID_Customer] LIKE @UID_Customer AND [Date] LIKE @date ";
var param = new
{
order_Details.UID_Customer,
date = order_Details.Date.ToShortDateString()
};
return(await _dataBaseManager.Find <Order_Details>(query, param) != null);
}
public async Task <bool> ModifyOrder_Details(IOrder_Details modifiedOrder_Details)
{
var param = new
{
modifiedOrder_Details.UID,
modifiedOrder_Details.Date,
modifiedOrder_Details.UID_Customer,
modifiedOrder_Details.UID_Design
};
return(await _dataBaseManager.Modify("SP_UPDATE_Order_Details", param));
}
public async Task <bool> AddOrder_Details(IOrder_Details order_Details)
{
var param = new
{
order_Details.UID,
order_Details.Date,
order_Details.UID_Customer,
order_Details.UID_Design
};
return(await _dataBaseManager.Add("SP_ADD_Order_Details", param));
}
