public async Task <IEnumerable <SelectError_Model> > spi_nder_tip_kateogori(tbl_INTER_TABLE_TYPE_CATEGORY_Model ntk, string tablename)
{
using (IDbConnection sql = new SqlConnection(_constring))
{
string readSp = "spI_tbl_INTER_" + tablename + "_TYPE_CATEGORY";
var queryParameters = new DynamicParameters();
queryParameters.Add("@" + tablename + "_type_uid", ntk.table_type_uid);
queryParameters.Add("@" + tablename + "_type_category_uid", ntk.table_type_category_uid);
queryParameters.Add("@user_uid", ntk.user_uid);
return(await sql.QueryAsync <SelectError_Model>(readSp, queryParameters, commandType : CommandType.StoredProcedure));
}
}
public async Task spi_tbl_INTER_TABLE_TYPE_CATEGORY(tbl_INTER_TABLE_TYPE_CATEGORY_Model ntk, string tablename)
{
using (SqlConnection sql = new SqlConnection(_constring))
{
using (SqlCommand cmd = new SqlCommand("spI_tbl_nder_" + tablename + "_tip_kategori", sql))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@" + tablename + "_type_uid", ntk.table_type_uid));
cmd.Parameters.Add(new SqlParameter("@" + tablename + "_type_category_uid", ntk.table_type_category_uid));
cmd.Parameters.Add(new SqlParameter("@user_uid", ntk.user_uid));
await sql.OpenAsync();
await cmd.ExecuteNonQueryAsync();
return;
}
}
}
