public FoodMarkerDTO GetFoodMarker(int id) { List <SqlParameter> sqlParams = new List <SqlParameter>(); sqlParams.Add("@id", SqlDbType.Int, (object)id); string sql = " SELECT FM_ID, FM_FC_ID, FM_REST_ID, FM_NAME, "; sql += " FM_COMMENT, FM_RATING "; sql += " FROM FoodMarker "; sql += " WHERE FM_ID = @id "; DataTable retTbl = m_DataAccess.FillTable(sql, sqlParams); if (retTbl.Rows.Count == 0) { return(null); } FoodMarkerDTO ret = new FoodMarkerDTO() { Id = (int)retTbl.Rows[0]["FM_ID"], FoodCategoryId = (int)retTbl.Rows[0]["FM_FC_ID"], RestaurantId = (int)retTbl.Rows[0]["FM_REST_ID"], Name = (string)retTbl.Rows[0]["FM_NAME"], Comment = (string)retTbl.Rows[0]["FM_COMMENT"], Rating = (int)retTbl.Rows[0]["FM_RATING"] }; return(ret); }
public int Post(FoodMarkerDTO foodMarker) { using (SqlConnection conn = new SqlConnection(m_DataAccess.ConnectionString)) { conn.Open(); using (SqlCommand cmd = m_DataAccess.GetCommand("ADD_FOODMARKER", CommandType.StoredProcedure, conn)) { cmd.Parameters.Add(m_DataAccess.BuildSqlParam("@fcid", SqlDbType.Int, foodMarker.FoodCategoryId)); cmd.Parameters.Add(m_DataAccess.BuildSqlParam("@frid", SqlDbType.Int, foodMarker.RestaurantId)); cmd.Parameters.Add(m_DataAccess.BuildSqlParam("@name", SqlDbType.VarChar, foodMarker.Name)); cmd.Parameters.Add(m_DataAccess.BuildSqlParam("@comment", SqlDbType.VarChar, foodMarker.Comment)); cmd.Parameters.Add(m_DataAccess.BuildSqlParam("@rating", SqlDbType.Int, foodMarker.Rating)); cmd.Parameters.Add("@id", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); return((int)cmd.Parameters["@id"].Value); } } }
public async Task <IActionResult> CreateFoodMarker(FoodMarkerClient reqObj) { if (reqObj == null) { BadRequest(); } JSONRetObj <int?> retObj = new JSONRetObj <int?>(); try { retObj.IsSuccess = true; FoodMarker foodMarker = Mapper.Map <FoodMarker>(reqObj); FoodMarkerDTO foodMarkerDto = Mapper.Map <FoodMarkerDTO>(foodMarker); int foodMarkerId = _repoFoodMarker.Post(foodMarkerDto); foreach (var file in Request.Form.Files) { FoodMarkerImageData postImageMeta = new FoodMarkerImageData(foodMarkerId, file.FileName); var postImageMetaDto = Mapper.Map <FoodMarkerImageDataDTO>(postImageMeta); postImageMeta.Id = postImageMetaDto.Id = _repoImageMeta.Post(postImageMetaDto); Stream stream = file.OpenReadStream(); await _repoImageFile.PostFile(postImageMetaDto, file.ContentType, stream); } retObj.ResponseObj = foodMarkerId; } catch (Exception ex) { retObj.IsSuccess = false; retObj.Message = ex.Message; } ViewData["RetObj"] = retObj; return(View("_Success")); }
public int PostFoodMarker(FoodMarker foodMarker) { FoodMarkerDTO foodMarkerDTO = _mapper.Map<FoodMarkerDTO>(foodMarker); int id = _repo.Post(foodMarkerDTO); return id; }
public FoodMarker GetFoodMarker(int id) { FoodMarkerDTO foodMarkerDto = _repo.GetFoodMarker(id); FoodMarker foodMarker = _mapper.Map<FoodMarker>(foodMarkerDto); return foodMarker; }
public void Update(FoodMarkerDTO foodMarker, int id) { throw new NotImplementedException(); }