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