public void Table()
{
// Act
_parameters.AddTable("test", "testType", RandomValue.List <IntListType>());
// Assert
var x = _parameters.Get <SqlMapper.ICustomQueryParameter>("test");
x.Should().NotBeNull();
}
public void AuthorBlogPostComment(List <Author> authors, List <Blog> blogs, List <Post> posts, List <Comment> comments)
{
using (db)
{
using (db)
{
var parameters = new DynamicParameters();
parameters.AddTable("@author", nameof(Author), authors);
parameters.AddTable("@blog", nameof(Blog), blogs);
parameters.AddTable("@post", nameof(Post), posts);
parameters.AddTable("@comment", nameof(Comment), comments);
var result = db.Query("usp_InsertAuthorBlogPostComment", parameters, commandType: CommandType.StoredProcedure);
}
}
}
//2----------paramter extention ".AddTable()"
public int Update(List <UT_Contact> contacts)
{
var parameters = new DynamicParameters();
parameters.AddTable("@contacts", "UDT_Contact", contacts);
return(db.Query <int>("UpdateContact", parameters, commandType: CommandType.StoredProcedure).First());
}
public void AddOrUpdateUserPoll(List <UserPoll> userPolls)
{
using (SqlConnection con = new SqlConnection(ConString))
{
var parameters = new DynamicParameters();
parameters.AddTable <UserPoll>("@UserPoll", "UserPoll", userPolls);
con.Query("CR_AddOrUpdateUserPoll", parameters, commandType: CommandType.StoredProcedure);
}
}
public void BulkInsert(List <Author> authors)
{
using (db)
{
var parameters = new DynamicParameters();
parameters.AddTable("@author", nameof(Author), authors);
var result = db.Query("usp_InsertAuthors", parameters, commandType: CommandType.StoredProcedure);
}
}
public async Task <int> RearrangePdfFileList(ICollection <FileArrangeType> orderedLocations)
{
using (var connection = new SqlConnection(_connectionString))
{
var parameters = new DynamicParameters();
parameters.AddTable("@FileArrangeType", "[dbo].[FileArrangeType]", orderedLocations);
return(await connection.ExecuteAsync("[dbo].[uspRearrangePdfFileList]", parameters, commandType : CommandType.StoredProcedure));
}
}
public async Task <NewsPostResponse> PostNewsAsync(NewsPostRequest request, List <Tag> tags)
{
await using var connection = new SqlConnection(_connectionString);
await connection.OpenAsync();
var parameters = new DynamicParameters(request);
parameters.AddTable(TagsListType.parameterName, TagsListType.typeName, tags);
return(await connection.QueryFirstAsync <NewsPostResponse>(ExecNewsPost, parameters));
}
public Task <int> UpdateUserAccessToGroup(List <Models.Site.UserAccessToGroup> uatg, string UserID, int UserGroupID)
{
var p = new DynamicParameters();
p.AddTable("@tblUserGroups", "tblusergroupstype ", uatg);
p.Add("UserID", UserID);
p.Add("UserGroupID", UserGroupID);
return(_dataAccess.SaveData(
"scud97_kssu.spUpdateUserAccessToGroup",
p,
"Default"));
}
public async Task MergeAsync(TransactionDTO[] transactionDTOs)
{
using (var connection = _connectionFactory.GetOpenedConnection())
{
var parameters = new DynamicParameters();
parameters.AddTable("@ChildTransaction", "ChildItemsType", transactionDTOs);
await connection.ExecuteAsync(
"[dbo].[MergeTransaction]", parameters,
commandType : CommandType.StoredProcedure
);
}
}
public static void Save(List <EvrooptItem> items)
{
DataTable dt = new DataTable();
var parameters = new DynamicParameters();
parameters.AddTable("@items", "[stage].[TEvroopItems]", items);
parameters.Add("source_id", 1, DbType.Int16);
using (IDbConnection db = new SqlConnection("data source=.;Integrated Security=SSPI;Initial Catalog=food;"))
{
string saveSp = "[stage].[saveEvrooptItemsSP]";
db.Execute(saveSp, parameters,
commandType: CommandType.StoredProcedure);
}
}
public void SaveDocument(Document item)
{
using (var connection = CreateConnection())
{
connection.Open();
var param = new DynamicParameters(new
{
item.Document_ID,
item.DocumentDate,
item.DocumentNumber,
item.Sum,
});
param.AddTable("Document_Details", "document_details_list", item.Document_Details);
connection.ExecuteReader("[dbo].[Document_Save]", param, null, null, StoredProcedure);
}
}
public async Task <Dictionary <string, object> > BatchSP_ImportStockInfo(List <MainForceInOutInfo> MainForceInOutInfoList)
{
DynamicParameters parameters = new DynamicParameters();
Dictionary <string, object> result = new Dictionary <string, object>();
try
{
parameters.AddTable <MainForceInOutInfo>("@importTable", "TB_ImporeMainForceInOutInfo", MainForceInOutInfoList);
parameters.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output);
parameters.Add("@Msg", dbType: DbType.String, size: 500, direction: ParameterDirection.Output);
DynamicParameters Result = await SystemDB.DB_Action_Output(str_conn, "BatchSP_ImportMainForceInOutInfo", parameters);
int code = Result.Get <int>("@Code");
string message = Result.Get <string>("@Msg");
result.Add("Code", code);
result.Add("Message", message);
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
