public DeEatingGuideDetail Save(DeEatingGuideDetail obj)
{
if (GetByID(obj.HeadId, obj.FoodCode, obj.LangCode) == null)
{
using (MySqlConnection conn = GetConnection())
{
conn.Open();
var script = $"INSERT INTO `eating_guide_detail` (`HeadId`, `FoodCode`, `FoodDescription`, `FoodGroupID`, `SectionID`, `Quantity`, `Calories`, `Carbs`, `Protein`, `Fat`, `Quantity_MeasurementUnitCode`, `LangCode`, `UpdateDateTime`) VALUES ({obj.HeadId}, '{obj.FoodCode}', '{obj.FoodDescription}', {obj.FoodGroupID}, {obj.SectionID}, {obj.Quantity}, {obj.Calories}, {obj.Carbs}, {obj.Protein}, {obj.Fat}, '{obj.Quantity_MeasurementUnitCode}', '{obj.LangCode}', '{obj.UpdateDateTime.ToString("yyyy-MM-dd hh:mm:ss")}');";
MySqlCommand cmd = new MySqlCommand(script, conn);
cmd.ExecuteNonQuery();
}
}
else
{
using (MySqlConnection conn = GetConnection())
{
conn.Open();
var script = $"UPDATE `eating_guide_detail` SET `Fat` = {obj.Fat}, `Protein` = {obj.Protein}, `Carbs` = {obj.Carbs}, `Quantity_MeasurementUnitCode` = '{obj.Quantity_MeasurementUnitCode}', `FoodCode` = '{obj.FoodCode}', `FoodDescription` = '{obj.FoodDescription}', `FoodGroupID` = {obj.FoodGroupID}, SectionID = {obj.SectionID}, `Quantity` = {obj.Quantity}, `Calories` = '{obj.Calories}', `UpdateDateTime` = '{obj.UpdateDateTime.ToString("yyyy-MM-dd HH:mm:ss")}' WHERE `HeadId` = '{obj.HeadId}' AND `LangCode` = '{obj.LangCode}';";
MySqlCommand cmd = new MySqlCommand(script, conn);
cmd.ExecuteNonQuery();
}
}
return(obj);
}
public async Task <IActionResult> PostEatingGuide([FromBody] DeEatingGuideDetail model)
{
try
{
model.HeadId = 1;
model.UpdateDateTime = DateTime.Now;
model.FoodGroupID = BlFood.GetByCode(model.FoodCode, "es").FoodGroupID;
foreach (var lang in BlAppLanguage.GetAll())
{
model.LangCode = lang.LangCode;
model.FoodDescription = BlFood.GetByCode(model.FoodCode, model.LangCode).FoodTitle;
BlEatingGuideDetail.Save(model);
}
return(Ok("Success"));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public static DeEatingGuideDetail Save(DeEatingGuideDetail obj)
{
return(new DlEatingGuideDetail().Save(obj));
}
