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(); } } } }