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