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