public string CreateUpdate(string ma_san_pham, string ma_gian_hang, string username, string connectionString = "")
{
using (var db = connectionString != "" ? new OrmliteConnection().openConn(connectionString) : new OrmliteConnection().openConn())
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
var exist = db.FirstOrDefault <Merchant_Product_Warehouse>("ma_san_pham = {0}", ma_san_pham);
Merchant_Product_Warehouse warehouse = new Merchant_Product_Warehouse();
warehouse.ngay_tao = DateTime.Now;
warehouse.nguoi_tao = username;
warehouse.ma_san_pham = ma_san_pham;
warehouse.ma_gian_hang = ma_gian_hang;
warehouse.stock_available = warehouse.stock_onhand = 0;
if (exist == null)
{
db.Insert <Merchant_Product_Warehouse>(warehouse);
}
else
{
db.Update <Merchant_Product_Warehouse>(warehouse);
}
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public ActionResult GetBookAvailable(string ma_san_pham)
{
using (IDbConnection dbConn = Helpers.OrmliteConnection.openConn())
{
var data = new Merchant_Product_Warehouse();
if (isAdmin)
{
data = dbConn.FirstOrDefault <Merchant_Product_Warehouse>("ma_san_pham = {0}", ma_san_pham);
}
else
{
data = dbConn.FirstOrDefault <Merchant_Product_Warehouse>("ma_gian_hang ={0} and ma_san_pham = {1}", currentUser.ma_gian_hang, ma_san_pham);
}
if (data != null)
{
return(Json(new { success = true, data = data.book_available, JsonRequestBehavior.AllowGet }));
}
return(Json(new { success = false, error = "Sản phẩm không tồn tại!", JsonRequestBehavior.AllowGet }));
}
}
