public int CreateBingoCard(BingoCardDomain BingoCardmodel) { UserBase userBase = (UserBase)_principal.Identity.GetCurrentUser(); int id = 0; _dataProvider.ExecuteNonQuery( // "Emma_User_Insert", "HRB_Bingocard_insert", inputParamMapper : delegate(SqlParameterCollection paramList) { SqlParameter param = new SqlParameter(); param.ParameterName = "@Id"; param.SqlDbType = System.Data.SqlDbType.Int; param.Direction = System.Data.ParameterDirection.Output; paramList.Add(param); //set userId by current user paramList.AddWithValue("UserId", userBase.Id); paramList.AddWithValue("card", BingoCardmodel.card); paramList.AddWithValue("square1", BingoCardmodel.square1); paramList.AddWithValue("square2", BingoCardmodel.square2); paramList.AddWithValue("square3", BingoCardmodel.square3); paramList.AddWithValue("square4", BingoCardmodel.square4); paramList.AddWithValue("square5", BingoCardmodel.square5); paramList.AddWithValue("square6", BingoCardmodel.square6); paramList.AddWithValue("square7", BingoCardmodel.square7); paramList.AddWithValue("square8", BingoCardmodel.square8); paramList.AddWithValue("square9", BingoCardmodel.square9); paramList.AddWithValue("square10", BingoCardmodel.square10); paramList.AddWithValue("square11", BingoCardmodel.square11); paramList.AddWithValue("square12", BingoCardmodel.square12); paramList.AddWithValue("square13", BingoCardmodel.square13); paramList.AddWithValue("square14", BingoCardmodel.square14); paramList.AddWithValue("square15", BingoCardmodel.square15); paramList.AddWithValue("square16", BingoCardmodel.square16); }, returnParameters : delegate(SqlParameterCollection paramList) { id = (int)paramList["@Id"].Value; } ); return(id); }
public HttpResponseMessage CreateCard(BingoCardDomain model) { try { if (ModelState.IsValid) { int id = _bingoCardService.CreateBingoCard(model); ItemResponse <int> resp = new ItemResponse <int>(); resp.Item = id; return(Request.CreateResponse(HttpStatusCode.OK, resp)); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex)); } }
public List <BingoCardDomain> SelectByUserId(int UserId) { List <BingoCardDomain> model = new List <BingoCardDomain>(); _dataProvider.ExecuteCmd( "HRB_Bingocard_select_by_userId", inputParamMapper : delegate(SqlParameterCollection paramCol) { paramCol.AddWithValue("@UserId", UserId); }, singleRecordMapper : delegate(IDataReader reader, short set) { BingoCardDomain Mapmodel = new BingoCardDomain(); int index = 0; Mapmodel.Id = reader.GetInt32(index++); Mapmodel.UserId = reader.GetInt32(index++); Mapmodel.card = reader.GetString(index++); Mapmodel.square1 = reader.GetString(index++); Mapmodel.square2 = reader.GetString(index++); Mapmodel.square3 = reader.GetString(index++); Mapmodel.square4 = reader.GetString(index++); Mapmodel.square5 = reader.GetString(index++); Mapmodel.square6 = reader.GetString(index++); Mapmodel.square7 = reader.GetString(index++); Mapmodel.square8 = reader.GetString(index++); Mapmodel.square9 = reader.GetString(index++); Mapmodel.square10 = reader.GetString(index++); Mapmodel.square11 = reader.GetString(index++); Mapmodel.square12 = reader.GetString(index++); Mapmodel.square13 = reader.GetString(index++); Mapmodel.square14 = reader.GetString(index++); Mapmodel.square15 = reader.GetString(index++); Mapmodel.square16 = reader.GetString(index++); model.Add(Mapmodel); } ); return(model); }