/// <summary>
/// -OLD-Delete ShopBill from the database
/// </summary>
/// <param name="orderProduct"></param>
/// <param name="db"></param>
public static void RemoveShopBill(ShopBillModel shopBill, string db)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnVal(db)))
{
var p = new DynamicParameters();
p.Add("@Id", shopBill.Id);
connection.Execute("dbo.spShopBill_Delete", p, commandType: CommandType.StoredProcedure);
}
}
/// <summary>
/// -OLD-Add shopBill to the database
/// </summary>
/// <param name="shopBill"></param>
/// <param name="db"></param>
/// <returns></returns>
public static ShopBillModel UpdateShopBillData(ShopBillModel shopBill, string db)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnVal(db)))
{
var p = new DynamicParameters();
p.Add("@Id", shopBill.Id);
p.Add("@Date", shopBill.Date);
p.Add("@Details", shopBill.Details);
p.Add("@TotalMoney", shopBill.TotalMoney);
connection.Execute("dbo.spShopBill_Update", p, commandType: CommandType.StoredProcedure);
}
return(shopBill);
}
/// <summary>
/// Add shopBill to the database
/// </summary>
/// <param name="shopBill"></param>
/// <param name="db"></param>
/// <returns></returns>
public static ShopBillModel AddShopBillToTheDatabase(ShopBillModel shopBill, string db)
{
using (IDbConnection connection = new System.Data.SqlClient.SqlConnection(GlobalConfig.CnnVal(db)))
{
var p = new DynamicParameters();
p.Add("@StoreId", shopBill.Store.Id);
p.Add("@StaffId", shopBill.Staff.Id);
p.Add("@Date", shopBill.Date);
p.Add("@Details", shopBill.Details);
p.Add("@TotalMoney", shopBill.TotalMoney);
p.Add("@Id", 0, dbType: DbType.Int32, direction: ParameterDirection.Output);
connection.Execute("dbo.spShopBill_Create", p, commandType: CommandType.StoredProcedure);
shopBill.Id = p.Get <int>("@Id");
}
return(shopBill);
}
