public async Task <bool> Delete(string Id) { using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $"delete FROM T_RefreshToken where Id = '{Id}' "; try { var rtCount = await conn.ExecuteAsync(sql, null); if (rtCount == 1) { return(true); } else { return(false); } } catch (Exception ex) { throw ex; } finally { conn.Close(); } } }
public async Task <List <PurchaseReturn> > GetPurchaseReturn(QueryParam queryParam) { List <PurchaseReturn> collection = null; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $@"SELECT top {queryParam.limit} {queryParam.select} FROM T_PurchaseReturn t0 left JOIN T_PurchaseReturnItem t1 on t0.DocEntry = t1.DocEntry {queryParam.filter + " " + queryParam.orderby} "; try { var purchaseReturnList = await conn.QueryParentChildAsync <PurchaseReturn, PurchaseReturnItem, int>(sql, p => p.DocEntry, p => p.PurchaseReturnItems, splitOn : "DocEntry"); collection = purchaseReturnList.ToList(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(collection); } }
public async Task <bool> ModifyJournalRelationMapPositive(DocumentSync documentSyncData) { bool isSuccessOperate = false; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { string sql = $@"update T_JournalRelationMap set IsPositiveSync = '{documentSyncData.SyncResult}', NewPositiveTransId = '{documentSyncData.SAPDocEntry}', PositiveSyncMessage = '{documentSyncData.SyncMsg}', PositiveSyncDate='{DateTime.Now}' where DocEntry in ( {documentSyncData.DocEntry} )"; try { var rtCount = await conn.ExecuteAsync(sql); if (rtCount >= 1) { isSuccessOperate = true; } else if (rtCount == 0) { throw new Exception($"can't found the journalSource info by docentry:{documentSyncData.DocEntry}"); } } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(isSuccessOperate); } }
public async Task <List <JournalRelationMap> > GetJournalRelationMapList(QueryParam queryParam) { List <JournalRelationMap> collection = null; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $"select * from(SELECT top {queryParam.limit} {queryParam.select} FROM T_JournalRelationMap t0 {queryParam.filter + " " + queryParam.orderby}) t2 inner JOIN T_JournalRelationMapItem t1 on t2.DocEntry = t1.DocEntry "; try { var coll = await conn.QueryParentChildAsync <JournalRelationMap, JournalRelationMapLine, int>(sql, p => p.DocEntry, p => p.JournalRelationMapLines, splitOn : "DocEntry"); collection = coll.ToList(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(collection); } }
public async Task <RefreshToken> FindById(string Id) { RefreshToken collection = null; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $"SELECT * FROM T_RefreshToken where Id = '{Id}' "; try { var queryResult = await conn.QueryAsync <RefreshToken>(sql, null); collection = queryResult.FirstOrDefault(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(collection); } }
public async Task <User> GetUser(string UserName) { User client = null; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $"SELECT * FROM T_User where UserName = @UserName"; try { var queryResult = await conn.QueryAsync <User>(sql, new { UserName = UserName }); client = queryResult.FirstOrDefault(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(client); } }
public async Task <Client> FindById(string Id) { Client client = null; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $"SELECT * FROM T_Client where Id = @Id "; try { var queryResult = await conn.QueryAsync <Client>(sql, new { Id = Id }); client = queryResult.FirstOrDefault(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(client); } }
public async Task <bool> Update(SerialNumber serialNumber) { bool isSuccessOperate = false; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { string sql = $@"update T_SerialNumber set CurrentNumber = '{serialNumber.CurrentNumber}' where ObjectKey in ( {serialNumber.ObjectKey} )"; try { var rtCount = await conn.ExecuteAsync(sql); if (rtCount >= 1) { isSuccessOperate = true; } else if (rtCount == 0) { throw new Exception($"can't found the refund document by docentry:{serialNumber.ObjectKey}"); } } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(isSuccessOperate); } }
public async Task <List <PurchaseDelivery> > GetPurchaseDeliveryList(QueryParam Param) { List <PurchaseDelivery> collection = null; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $"SELECT top {Param.limit} {Param.select} FROM AVA_SP_VIEW_PURCHASE_OPOR t0 left JOIN AVA_SP_VIEW_PURCHASE_OPORLINE t1 on t0.DocEntry = t1.DocEntry {Param.filter + " " + Param.orderby} "; try { var coll = await conn.QueryParentChildAsync <PurchaseDelivery, PurchaseDeliveryItem, int>(sql, p => p.DocEntry, p => p.PurchaseDeliveryItems, splitOn : "DocEntry"); collection = coll.ToList(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(collection); } }
public async Task <bool> Insert(User User) { using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); IDbTransaction dbTransaction = conn.BeginTransaction(); try { string insertSql = @"INSERT INTO T_User(Id,UserName,Password,IsActive,Creator,CreateDate,UpdateTime,Updator,IsDelete)VALUES (@Id,@UserName,@Password,@IsActive,@Creator,@CreateDate,@UpdateTime,@Updator,@IsDelete)"; int rtCount = await conn.ExecuteAsync(insertSql, User, dbTransaction); dbTransaction.Commit(); if (rtCount == 1) { return(true); } else { return(false); } } catch (Exception ex) { dbTransaction.Rollback(); throw ex; } finally { conn.Close(); } } }
public async Task <List <Refund> > GetRefund(QueryParam Param) { List <Refund> collection = null; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $"SELECT top {Param.limit} {Param.select} FROM T_Refund t0 left JOIN T_RefundItem t1 on t0.DocEntry = t1.DocEntry {Param.filter + " " + Param.orderby} "; try { var coll = await conn.QueryParentChildAsync <Refund, RefundItem, int>(sql, p => p.DocEntry, p => p.RefundItems, splitOn : "DocEntry"); collection = coll.ToList(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(collection); } }
public async Task <bool> UpdateSyncData(DocumentSync documentSyncResult) { bool isSuccessOperate = false; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { string sql = "update T_Refund set IsSync = @SyncResult,SAPDocEntry = @SAPDocEntry,SyncMsg = @SyncMsg where DocEntry = @DocEntry"; try { var rtCount = await conn.ExecuteAsync(sql, new { DocEntry = documentSyncResult.DocEntry, SAPDocEntry = documentSyncResult.SAPDocEntry, SyncMsg = documentSyncResult.SyncMsg, SyncResult = documentSyncResult.SyncResult }); if (rtCount == 1) { isSuccessOperate = true; } else if (rtCount == 0) { throw new Exception($"can't found the refund document by docentry:{documentSyncResult.DocEntry}"); } } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(isSuccessOperate); } }
public async Task <List <Material> > GetMaterial(QueryParam queryParam) { List <Material> collection = null; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $"SELECT top {queryParam.limit} {queryParam.select} FROM T_Materials t0 {queryParam.filter + " " + queryParam.orderby} "; try { var materialList = await conn.QueryAsync <Material>(sql); collection = materialList.ToList(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(collection); } }
public async Task <PurchaseDelivery> GetPurchaseDelivery(int DocEntry) { List <PurchaseDelivery> collection = null; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $"SELECT * FROM AVA_SP_VIEW_PURCHASE_OPOR t0 left JOIN AVA_SP_VIEW_PURCHASE_OPORLINE t1 on t0.DocEntry = t1.DocEntry where t0.DocEntry = {DocEntry} "; try { var coll = await conn.QueryParentChildAsync <PurchaseDelivery, PurchaseDeliveryItem, int>(sql, p => p.DocEntry, p => p.PurchaseDeliveryItems, splitOn : "DocEntry"); collection = coll.ToList(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(collection.FirstOrDefault()); } }
public async Task <bool> UpdateSyncData(string ItemCode) { bool isSuccessOperate = false; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { string sql = $"update T_Materials set IsSync = 'Y',SyncDate = '{DateTime.Now}' where ItemCode = @ItemCode"; try { var rtCount = await conn.ExecuteAsync(sql, new { ItemCode = ItemCode }); if (rtCount == 1) { isSuccessOperate = true; } else if (rtCount == 0) { throw new Exception($"can't found the customer by cardcode:{ItemCode}"); } } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(isSuccessOperate); } }
public async Task <SerialNumber> GetSerialNumber() { List <SerialNumber> customerList = null; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $"SELECT * FROM T_SerialNumber where Year = {DateTime.Now.Year} and Month = {DateTime.Now.Month}"; try { var collection = await conn.QueryAsync <SerialNumber>(sql); customerList = collection.ToList(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(customerList.FirstOrDefault()); } }
public async Task <bool> UpdateINSyncDataBatch(DocumentSync documentSyncData) { bool isSuccessOperate = false; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { string sql = $@"update T_SalesOrder set IsINSync = '{documentSyncData.SyncResult}', INSAPDocEntry = '{documentSyncData.SAPDocEntry}', INMsg = '{documentSyncData.SyncMsg}', INSyncDate='{DateTime.Now}' where DocEntry in ( {documentSyncData.DocEntry} )"; try { var rtCount = await conn.ExecuteAsync(sql); if (rtCount >= 1) { isSuccessOperate = true; } else if (rtCount == 0) { throw new Exception($"can't found the refund document by docentry:{documentSyncData.DocEntry}"); } } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(isSuccessOperate); } }
public async Task <List <BusinessPartner> > Fetch(QueryParam queryParam) { List <BusinessPartner> customerList = null; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $"SELECT top {queryParam.limit} {queryParam.select} FROM T_BusinessPartner t0 {queryParam.filter + " " + queryParam.orderby} "; try { var collection = await conn.QueryAsync <BusinessPartner>(sql); customerList = collection.ToList(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(customerList); } }
public async Task <List <JournalSource> > GetJournalSourceList(QueryParam queryParam) { List <JournalSource> collection = null; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); string sql = $"select * from(SELECT top {queryParam.limit} {queryParam.select} FROM T_VIEW_JOURNAL_SOURCE t0 {queryParam.filter + " " + queryParam.orderby}) t2 inner JOIN T_View_JournalSourceItem t1 on t2.TransId = t1.TransId "; try { var coll = await conn.QueryParentChildAsync <JournalSource, JournalSourceLine, int>(sql, p => p.TransId, p => p.JournalSourceLines, splitOn : "TransId"); collection = coll.ToList(); } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(collection); } }
public async Task <SaveResult> Save(Refund Refund) { SaveResult saveRlt = new SaveResult(); saveRlt.UniqueKey = Refund.OMSDocEntry.ToString();//回传接收方的主键 using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); IDbTransaction dbTransaction = conn.BeginTransaction(); try { string insertSql = @"INSERT INTO T_Refund (OMSDocEntry,PlatformCode,DocType,BusinessType,RefundType,RefundReason,CardCode,GrossRefund,Freight,FrghtVendor,PayMethod,Comments,CreateDate,UpdateDate,Creator,UpDator) VALUES (@OMSDocEntry,@PlatformCode,@DocType,@BusinessType,@RefundType,@RefundReason,@CardCode,@GrossRefund,@Freight,@FrghtVendor,@PayMethod,@Comments,@CreateDate,@UpdateDate,@Creator,@UpDator)select SCOPE_IDENTITY();"; string insertItemSql = @"INSERT INTO T_RefundItem (DocEntry,LineNum,OMSDocEntry,OMSLineNum,ItemCode,Quantity,Price,ItemRefund) VALUES (@DocEntry,@LineNum,@OMSDocEntry,@OMSLineNum,@ItemCode,@Quantity,@Price,@ItemRefund)"; object DocEntry = await conn.ExecuteScalarAsync(insertSql, new { OMSDocEntry = Refund.OMSDocEntry, PlatformCode = Refund.PlatformCode, DocType = Refund.DocType, BusinessType = Refund.BusinessType, RefundType = Refund.RefundType, RefundReason = Refund.RefundReason, CardCode = Refund.CardCode, GrossRefund = Refund.GrossRefund, Freight = Refund.Freight, FrghtVendor = Refund.FrghtVendor, PayMethod = Refund.PayMethod, Comments = Refund.Comments, CreateDate = DateTime.Now, UpdateDate = Refund.UpdateDate, Creator = Refund.Creator, UpDator = Refund.UpDator }, dbTransaction); saveRlt.ReturnUniqueKey = DocEntry.ToString();//回传保存订单的主键 conn.Execute(insertItemSql, DocumentItemHandle <RefundItem> .GetDocumentItems(Refund.RefundItems, Convert.ToInt32(DocEntry)), dbTransaction); dbTransaction.Commit(); saveRlt.Code = 0; } catch (Exception ex) { dbTransaction.Rollback(); saveRlt.Code = 1; saveRlt.Message = ex.Message; throw ex; } finally { conn.Close(); } return(saveRlt); } }
public void TestMethod1() { using (var sqlConnection = SqlConnectionFactory.CreateSqlConnection()) { sqlConnection.Open(); var query = new GetInvoicesDbQuery(); var queryHandler = new GetInvoicesDbQueryHandler(sqlConnection, transaction: null); var queryResult = queryHandler.Handle(query); } }
public void TestMethod1() { using (var sqlConnection = SqlConnectionFactory.CreateSqlConnection()) { sqlConnection.Open(); var query = new GetCustomerInvoicesDbQuery(customerId: 1, invoiceDate: DateTime.Today); var queryHandler = new GetCustomerInvoicesDbQueryHandler(sqlConnection, transaction: null); var queryResult = queryHandler.Handle(query); } }
public async Task TestMethod2() { using (var sqlConnection = SqlConnectionFactory.CreateSqlConnection()) { await sqlConnection.OpenAsync(); var query = new GetInvoicesDbQuery(); var queryHandler = new GetInvoicesDbQueryHandler(sqlConnection, transaction: null); var queryResult = await queryHandler.HandleAsync(query, CancellationToken.None); } }
public async Task <SaveResult> Save(SalesOrder SalesOrder) { SaveResult saveRlt = new SaveResult(); saveRlt.UniqueKey = SalesOrder.OMSDocEntry.ToString();//回传接收方的主键 using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); IDbTransaction dbTransaction = conn.BeginTransaction(); try { string insertSql = @"insert into T_SalesOrder(OMSDocEntry,OMSDocDate,DocType,BusinessType,PlatformCode,CardCode,OrderPaied,Freight,PayMethod,Comments,CreateDate,UpdateDate) values(@OMSDocEntry,@OMSDocDate,@DocType,@BusinessType,@PlatfromCode,@CardCode,@OrderPaied,@Freight,@Paymenthod,@Comments,@CreateDate,@UpdateDate)select SCOPE_IDENTITY();"; string insertItemSql = @"insert into T_SalesOrderItem(DocEntry,LineNum,OMSDocEntry,OMSLineNum,ItemCode,Quantity,Price,ItemPaied) values(@DocEntry,@LineNum,@OMSDocEntry,@OMSLineNum,@ItemCode,@Quantity,@Price,@ItemPaied)"; object DocEntry = await conn.ExecuteScalarAsync(insertSql, new { OMSDocEntry = SalesOrder.OMSDocEntry, OMSDocDate = SalesOrder.OMSDocDate, DocType = SalesOrder.DocType, BusinessType = SalesOrder.BusinessType, PlatfromCode = SalesOrder.PlatformCode, CardCode = SalesOrder.CardCode, OrderPaied = SalesOrder.OrderPaied, Freight = SalesOrder.Freight, Paymenthod = SalesOrder.PayMethod, Comments = SalesOrder.Comments, CreateDate = DateTime.Now, UpdateDate = DateTime.Now }, dbTransaction); saveRlt.ReturnUniqueKey = DocEntry.ToString();//回传保存订单的主键 await conn.ExecuteAsync(insertItemSql, DocumentItemHandle <SalesOrderItem> .GetDocumentItems(SalesOrder.SalesOrderItems, Convert.ToInt32(DocEntry)), dbTransaction); dbTransaction.Commit(); saveRlt.Code = 0; } catch (Exception ex) { dbTransaction.Rollback(); saveRlt.Code = 1; saveRlt.Message = ex.Message; throw ex; } finally { conn.Close(); } return(saveRlt); } }
public TransactionScope(string connKey = "ConnectionString", IsolationLevel isolationLevel = IsolationLevel.Unspecified) { if (null == transaction) { IDbConnection connection = SqlConnectionFactory.CreateSqlConnection(connKey); connection.Open(); IDbTransaction dbTransaction = connection.BeginTransaction(isolationLevel); Transaction.Current = new CommittableTransaction(dbTransaction); } else { Transaction.Current = transaction.DependentClone(); } }
public async Task <SaveResult> Save(Material Material) { SaveResult saveRlt = new SaveResult(); saveRlt.UniqueKey = Material.ItemCode;//回传接收方的主键 using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); IDbTransaction dbTransaction = conn.BeginTransaction(); try { string insertSql = @"INSERT INTO T_Materials (ItemCode,ItemName,VatGourpSa,VatGourpPu,InitialCost,RealCost,SalesPrice,InvntItem,Consignment,Vendor,OMSGroupNum,CreateDate,UpdateDate) VALUES (@ItemCode,@ItemName,@VatGourpSa,@VatGourpPu,@InitialCost,@RealCost,@SalesPrice,@InvntItem,@Consignment,@Vendor,@OMSGroupNum,@CreateDate,@UpdateDate)"; await conn.ExecuteScalarAsync(insertSql, new { ItemCode = Material.ItemCode, ItemName = Material.ItemName, VatGourpSa = Material.VatGourpSa, VatGourpPu = Material.VatGourpPu, InitialCost = Material.InitialCost, RealCost = Material.RealCost, SalesPrice = Material.SalesPrice, InvntItem = Material.InvntItem, Consignment = Material.Consignment, Vendor = Material.Vendor, CreateDate = DateTime.Now, UpdateDate = DateTime.Now, OMSGroupNum = Material.OMSGroupNum }, dbTransaction); saveRlt.ReturnUniqueKey = Material.ItemCode;//回传保存订单的主键 dbTransaction.Commit(); saveRlt.Code = 0; } catch (Exception ex) { dbTransaction.Rollback(); saveRlt.Code = 1; saveRlt.Message = ex.Message; throw ex; } finally { conn.Close(); } return(saveRlt); } }
public async Task <SaveResult> Save(InvoicesReturn InvoicesReturn) { SaveResult saveRlt = new SaveResult(); saveRlt.UniqueKey = InvoicesReturn.ZFPHM;//回传接收方的主键 using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); IDbTransaction dbTransaction = conn.BeginTransaction(); try { string insertSql = $@"INSERT INTO [@AVA_INVRETURN] (Code,Name,U_ZFPDM,U_ZKPRQ,U_ZFPZT,U_ZFPJE,U_ZSKPH) VALUES ( '{InvoicesReturn.ZFPHM}', '{InvoicesReturn.ZFPHM}', '{InvoicesReturn.ZFPDM}', '{InvoicesReturn.ZKPRQ}', '{InvoicesReturn.ZFPZT}', '{InvoicesReturn.ZFPJE}', '{InvoicesReturn.ZSKPH}')"; //string insertSql = $@"INSERT INTO [@AVA_INVRETURN] (Code,Name,U_ZFPDM,U_ZKPRQ,U_ZFPZT,U_ZFPJE,U_ZSKPH) // VALUES (@Code,@Name,@U_ZFPDM,@U_ZKPRQ,@U_ZFPZT,@U_ZFPJE,@U_ZSKPH)"; var rt = await conn.ExecuteScalarAsync(insertSql, null, dbTransaction); //await conn.ExecuteAsync(insertSql); saveRlt.ReturnUniqueKey = InvoicesReturn.ZFPHM;//回传保存订单的主键 dbTransaction.Commit(); saveRlt.Code = 0; } catch (Exception ex) { dbTransaction.Rollback(); saveRlt.Code = 1; saveRlt.Message = ex.Message; throw ex; } finally { conn.Close(); } return(saveRlt); } }
public async Task <bool> ModifyJournalRelationMapStatus(DocumentSync documentSyncData) { bool isSuccessOperate = false; using (var conn = SqlConnectionFactory.CreateSqlConnection()) { //string sql = $@"update T_JournalRelationMap set IsSync = '{documentSyncData.SyncResult}', // NewTransId = '{documentSyncData.SAPDocEntry}', // SyncMessage = '{documentSyncData.SyncMsg}', // SyncDate='{DateTime.Now}' // where DocEntry in ( {documentSyncData.DocEntry} )"; string sql = $@"update T_JournalRelationMap set IsSync = @IsSync, NewTransId = @NewTransId, SyncMessage = @SyncMessage, SyncDate= @SyncDate where DocEntry in ( @DocEntry )"; try { var rtCount = await conn.ExecuteAsync(sql, new { IsSync = documentSyncData.SyncResult, NewTransId = documentSyncData.SAPDocEntry, SyncMessage = documentSyncData.SyncMsg, SyncDate = DateTime.Now, DocEntry = documentSyncData.DocEntry }); if (rtCount >= 1) { isSuccessOperate = true; } else if (rtCount == 0) { throw new Exception($"can't found the journalSource info by docentry:{documentSyncData.DocEntry}"); } } catch (Exception ex) { throw ex; } finally { conn.Close(); } return(isSuccessOperate); } }
public async Task <bool> Insert(RefreshToken refreshToken) { using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); IDbTransaction dbTransaction = conn.BeginTransaction(); try { string insertSql = @"INSERT INTO T_RefreshToken(Id,UserName,ClientId,IssuedUtc,ExpiresUtc,ProtectedTicket) VALUES(@Id,@UserName,@ClientId,@IssuedUtc,@ExpiresUtc,@ProtectedTicket)"; string sql = $@"INSERT INTO T_RefreshToken(Id,UserName,ClientId,IssuedUtc,ExpiresUtc,ProtectedTicket) VALUES('{refreshToken.Id}','{refreshToken.UserName}','{refreshToken.ClientId}',{refreshToken.IssuedUtc}, {refreshToken.ExpiresUtc},'{refreshToken.ProtectedTicket}')"; int rtCount = await conn.ExecuteAsync(insertSql, new { Id = refreshToken.Id, UserName = refreshToken.UserName, ClientId = refreshToken.ClientId, IssuedUtc = refreshToken.IssuedUtc, ExpiresUtc = refreshToken.ExpiresUtc, ProtectedTicket = refreshToken.ProtectedTicket }, dbTransaction); dbTransaction.Commit(); if (rtCount == 1) { return(true); } else { return(false); } } catch (Exception ex) { dbTransaction.Rollback(); throw ex; } finally { conn.Close(); } } }
public async Task <bool> Save(Client client) { using (IDbConnection conn = SqlConnectionFactory.CreateSqlConnection()) { conn.Open(); IDbTransaction dbTransaction = conn.BeginTransaction(); try { string insertSql = @"INSERT INTO T_Client(Id, Secret, Name, IsActive, RefreshTokenLifeTime, DateAdded) VALUES( @Id, @Secret, @Name, @IsActive, @RefreshTokenLifeTime, @DateAdded)"; int rtCount = await conn.ExecuteAsync(insertSql, new { Id = client.Id, Secret = client.Secret, Name = client.Name, IsActive = client.IsActive, RefreshTokenLifeTime = client.RefreshTokenLifeTime, DateAdded = client.DateAdded }, dbTransaction); dbTransaction.Commit(); if (rtCount == 1) { return(true); } else { return(false); } } catch (Exception ex) { dbTransaction.Rollback(); throw ex; } finally { conn.Close(); } } }