Exemple #1
0
        public int InsertGroupService(GroupServiceInputModel data)
        {
            using (SqlConnection con = new SqlConnection(_configuration.Get("ConnectionString:SQLConnection")))
            {
                try
                {
                    var res = Newtonsoft.Json.JsonConvert.SerializeObject(data);

                    var dbParams = new DynamicParameters();
                    con.Open();
                    dbParams.Add("@Group", Newtonsoft.Json.JsonConvert.SerializeObject(data));
                    var reader = con.ExecuteReader(
                        sql: "[ADM].[ADM_SP_INSERT_GROUP]",
                        param: dbParams,
                        commandType: CommandType.StoredProcedure);

                    return(1);
                }
                catch (Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    con.Close();
                }
            }
        }
Exemple #2
0
 public int DeleteGroupService(GroupServiceInputModel data)
 {
     throw new NotImplementedException();
 }