public JsonResult SaveSchedule()
{
var data = Request.GetArrayList("data");
int week = Request.GetInt("week");
long MealTimesCode = Request.GetInt("MealTimesCode");
string MealTimesName = Request.GetString("MealTimesName");
using (var context = flexibleContext.db.UseTransaction(true))
{
var mealScheduleDal = flexibleContext.GetService <MealScheduleDal>();
mealScheduleDal.Db.Sql("delete from dc_mealschedule where DayOfWeek = @0 and MealTimesCode = @1", week,
MealTimesCode).Execute();
foreach (var o in data)
{
MealSchedule model = new MealSchedule();
model.MealTimesCode = MealTimesCode;
model.MealTimesName = MealTimesName;
model.DayOfWeek = week;
model.MealMenuID = Convert.ToInt32(o["ItemID"].ToString().Split('_')[1]);
mealScheduleDal.Insert(model);
}
context.Commit();
}
var result = new { };
return(Json(result));
}
public ActionResult ConfigureMeal(MealSchedule mealSchedule)
{
mealSchedule.MealDay = mealSchedule.MealDay == 7 ? 0 : mealSchedule.MealDay;
var result = _mealLogic.ConfigureMeal(mealSchedule);
return(Json(result));
}
public static Attachment GetDailyMenuCard(MealSchedule mealSchedule)
{
if (mealSchedule is null)
{
throw new ArgumentNullException(nameof(mealSchedule));
}
StringBuilder content = new StringBuilder();
content.Append("{");
content.Append("\"$schema\": \"http://adaptivecards.io/schemas/adaptive-card.json\",");
content.Append("\"type\": \"AdaptiveCard\",");
content.Append("\"version\": \"1.0\",");
content.Append("\"body\": [");
content.Append("{");
content.Append("\"type\": \"TextBlock\",");
content.AppendFormat("\"text\": \"{0}\",", mealSchedule.Day);
content.Append("\"weight\": \"Bolder\"");
content.Append("},");
content.Append("{");
content.Append("\"type\": \"FactSet\",");
content.Append("\"facts\": [");
content.Append("{");
content.AppendFormat("\"title\": \"{0}\",", ipnbarbot.Application.Constants.MealTypeNames.Soup);
content.AppendFormat("\"value\": \"{0}\"", mealSchedule.SoupMeal.Name);
content.Append("},");
content.Append("{");
content.AppendFormat("\"title\": \"{0}\",", ipnbarbot.Application.Constants.MealTypeNames.MainDish);
content.AppendFormat("\"value\": \"{0}\"", mealSchedule.MainDishMeal.Name);
content.Append("},");
content.Append("{");
content.AppendFormat("\"title\": \"{0}\",", ipnbarbot.Application.Constants.MealTypeNames.VeganDish);
content.AppendFormat("\"value\": \"{0}\"", mealSchedule.VeganDishMeal.Name);
content.Append("}");
content.Append("]");
content.Append("}");
content.Append("]");
content.Append("}");
return(new Attachment()
{
ContentType = "application/vnd.microsoft.card.adaptive",
Content = JsonConvert.DeserializeObject(content.ToString()),
});
}
public void DataMaintainerService_EditMealSchedule_EditMealScheduleInDatabase()
{
dataHandler.AddMealschedule(mS1);
controller.DataMaintainerService.EditMealSchedule(mS1.Id, mS2.Topic, mS2.Participants, mS2.Location, mS2.StartDate, mS2.EndDate, mS2.LastEditUserId);
testMSchedule = dataHandler.FindMealScheduleById(mS1.Id);
Assert.AreEqual(mS2.Topic, testMSchedule.Topic);
Assert.AreEqual(mS2.Participants, testMSchedule.Participants);
Assert.AreEqual(mS2.Location, testMSchedule.Location);
Assert.AreEqual(mS2.StartDate, testMSchedule.StartDate);
Assert.AreEqual(mS2.EndDate, testMSchedule.EndDate);
}
//-----------------------------------DataMaintainerService-----------------------------------------
private Boolean CompareMealSchedule(MealSchedule mealSchedule1, MealSchedule mealSchedule2)
{
Boolean isSame = (mealSchedule1.Id.Equals(mealSchedule2.Id)) &&
(mealSchedule1.Topic.Equals(mealSchedule2.Topic)) &&
(mealSchedule1.Participants.Equals(mealSchedule2.Participants)) &&
(mealSchedule1.Location.Equals(mealSchedule2.Location)) &&
(mealSchedule1.StartDate.Equals(mealSchedule2.StartDate)) &&
(mealSchedule1.EndDate.Equals(mealSchedule2.EndDate)) &&
(mealSchedule1.LastEditUserId.Equals(mealSchedule2.LastEditUserId)) ? true : false;
return(isSame);
}
private bool _ConfigureMeal(MealSchedule mealSchedule)
{
var sql = "INSERT INTO `order_center`.`meal_schedule` (`id`,`meal_day`,`meal_id`,`date_created`,`last_updated`,`meal_type`) VALUES(NULL, @meal_day,@meal_id,now(),now(),@meal_type)";
var parameters = new Parameter[]
{
new Parameter("@meal_day", mealSchedule.MealDay),
new Parameter("@meal_id", mealSchedule.MealId),
new Parameter("@meal_type", mealSchedule.MealType)
};
return(DBHelper.ExecuteNonQuery(sql, parameters));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["Controller"] != null)
{
controller = (Controller)Session["Controller"];
//Reject access if no permission
if (!controller.CurrentUser.Role.ToString().Contains("DM"))
{
Response.Redirect("~/");
}
}
else
{
Context.GetOwinContext().Authentication.SignOut(DefaultAuthenticationTypes.ApplicationCookie);
Response.Redirect("~/");
}
if (IsPostBack)
{
// Retrieve the ID from the view state
currentId = (string)ViewState[IdKey];
}
else
{
//Retrieve the ID from the query string
string id = Request.QueryString[IdKey];
if (id != null && id != "")
{
// Edit Mode
ModeLabel.Text = "Edit";
// Save the ID for later
ViewState[IdKey] = id;
currentId = id;
// Get current data
MealSchedule ms = controller.DataMaintainerService.FindMealScheduleById(currentId);
if (ms != null)
{
TopicTextBox.Text = ms.Topic;
ParticipantsTextBox.Text = ms.Participants;
LocationTextBox.Text = ms.Location;
StartDateTextBox.Text = ms.StartDate;
EndDateTextBox.Text = ms.EndDate;
}
else
{
Response.Redirect("~/");
}
}
}
}
private async Task <string> GetMenuFor(DateTime date)
{
string response = null;
MealSchedule menu = await this._mealSchedulesApp.GetForDate(date);
if (menu is null)
{
throw new Exceptions.DefaultBotException("MenuNotFoundForDate");
}
else
{
response = ipnbarbot.Cards.CardsExtensions.GetDailyMenuCardAsString(menu);
}
return(response);
}
public static string GetDailyMenuCardAsString(MealSchedule mealSchedule)
{
if (mealSchedule is null)
{
throw new ArgumentNullException(nameof(mealSchedule));
}
StringBuilder result = new StringBuilder();
result.Append(string.Format("**{0}**", mealSchedule.Day));
result.Append(" \n ");
result.Append(string.Format("* **{0}**: {1}", ipnbarbot.Application.Constants.MealTypeNames.Soup, mealSchedule.SoupMeal.Name));
result.Append(" \n ");
result.Append(string.Format("* **{0}**: {1}", ipnbarbot.Application.Constants.MealTypeNames.MainDish, mealSchedule.MainDishMeal.Name));
result.Append(" \n ");
result.Append(string.Format("* **{0}**: {1}", ipnbarbot.Application.Constants.MealTypeNames.VeganDish, mealSchedule.VeganDishMeal.Name));
return(result.ToString());
}
public bool ConfigureMeal(MealSchedule mealSchedule)
{
if (mealSchedule.MealId < 1)
{
throw new Exception("请输入有效的菜品！");
}
if (mealSchedule.MealDay < 0 || mealSchedule.MealDay > 6)
{
throw new Exception("请输入星期一至星期天的一天！");
}
if (mealSchedule.MealType < 1 || mealSchedule.MealType > 3)
{
throw new Exception("请输入早中晚三餐！");
}
return(_ConfigureMeal(mealSchedule));
}
public void DataMaintainerService_AddMealSchedule_AddANewMealScheduleDataIntoDatabase()
{
controller.DataMaintainerService.AddMealSchedule(mS1.Topic, mS1.Participants, mS1.Location, mS1.StartDate, mS1.EndDate, mS1.LastEditUserId);
testMSchedule = dataHandler.FindMealScheduleById(mS1.Id);
Assert.IsTrue(CompareMealSchedule(mS1, testMSchedule));
}
