public string createHistory(string TableName, string MerchantID, string Value, string Username, string connectionString = "")
{
using (var db = connectionString != "" ? new OrmliteConnection().openConn(connectionString) : new OrmliteConnection().openConn())
{
using (var dbTrans = db.OpenTransaction(IsolationLevel.ReadCommitted))
{
try
{
db.ExecuteNonQuery("update Merchant_History set trang_thai = {2} where ten_bang = {0} and ma_gian_hang = {1}".Params(TableName, MerchantID, AllConstant.trang_thai.KHONG_SU_DUNG));
Merchant_History history = new Merchant_History();
history.ten_bang = TableName;
history.ma_gian_hang = MerchantID;
history.ngay_tao = DateTime.Now;
history.nguoi_tao = Username;
history.gia_tri = Value;
history.trang_thai = AllConstant.trang_thai.DANG_SU_DUNG;
db.Insert <Merchant_History>(history);
dbTrans.Commit();
return("true");
}
catch (Exception e)
{
dbTrans.Rollback();
return(e.Message.ToString());
}
}
}
}
public string createHistory(string TableName, string MerchantID, string Value, string Username, IDbConnection db)
{
try
{
db.ExecuteNonQuery("update Merchant_History set trang_thai = {2} where ten_bang = {0} and ma_gian_hang = {1}".Params(TableName, MerchantID, AllConstant.trang_thai.KHONG_SU_DUNG));
Merchant_History history = new Merchant_History();
history.ten_bang = TableName;
history.ma_gian_hang = MerchantID;
history.ngay_tao = DateTime.Now;
history.nguoi_tao = Username;
history.gia_tri = Value;
history.trang_thai = AllConstant.trang_thai.DANG_SU_DUNG;
db.Insert <Merchant_History>(history);
return("true");
}
catch (Exception e)
{
return(e.Message.ToString());
}
}
