public void UpSert(List <Product_Evaluation> lstProductEvaluation, string UserName, string Type, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (Product_Evaluation row in lstProductEvaluation)
{
if (Type == "Insert")
{
row.ngay_tao = row.ngay_cap_nhat = DateTime.Now;
row.nguoi_tao = row.nguoi_cap_nhat = UserName;
db.Save(row);
}
else
{
row.ngay_cap_nhat = DateTime.Now;
row.nguoi_cap_nhat = UserName;
db.Update(row);
}
}
dbTrans.Commit();
}
catch
{
dbTrans.Rollback();
}
}
}
}
public void UpSert(List <Product_Merchant> lstProduct_Merchant, string UserName, string Type, string connectionString)
{
using (var db = new OrmliteConnection().openConn(connectionString))
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
foreach (Product_Merchant row in lstProduct_Merchant)
{
var checkID = db.SingleOrDefault <Product_Merchant>("id={0}", row.id);
if (checkID != null)
{
row.ngay_cap_nhat = DateTime.Now;
row.nguoi_cap_nhat = UserName;
if (checkID.trang_thai_duyet != row.trang_thai_duyet && (row.trang_thai_duyet == BIBIAM.Core.AllConstant.trang_thai_duyet.DA_DUYET || row.trang_thai_duyet == BIBIAM.Core.AllConstant.trang_thai_duyet.TU_CHOI))
{
row.ngay_duyet = DateTime.Now;
row.nguoi_duyet = UserName;
}
db.Update(row);
}
else
{
row.ngay_tao = row.ngay_cap_nhat = DateTime.Now;
row.nguoi_tao = row.nguoi_cap_nhat = UserName;
db.Save(row);
}
}
dbTrans.Commit();
}
catch
{
dbTrans.Rollback();
}
}
}
}