internal static DataSet GetSyncData(DateTime toDate)
{
MealSetTableAdapter mealSetTA = new MealSetTableAdapter();
ScheduleTableAdapter scheduleTA = new ScheduleTableAdapter();
ScheduleMealSetDetailTableAdapter scheduleMealSetDetailTA = new ScheduleMealSetDetailTableAdapter();
ServingTimeTableAdapter servingTimeTA = new ServingTimeTableAdapter();
TransactionHistoryTableAdapter transactionHistoryTA = new TransactionHistoryTableAdapter();
TransactionTypeTableAdapter transactionTypeTA = new TransactionTypeTableAdapter();
UserInfoTableAdapter userInfoTA = new UserInfoTableAdapter();
UserTypeTableAdapter userTypeTA = new UserTypeTableAdapter();
DateTime minDate = (DateTime)SqlDateTime.MinValue;
DataSet ds = new DataSet();
ds.Tables.Add(userTypeTA.GetDataByDate(minDate, toDate));
ds.Tables.Add(userInfoTA.GetDataByDate(minDate, toDate));
ds.Tables.Add(mealSetTA.GetDataByDate(minDate, toDate));
ds.Tables.Add(servingTimeTA.GetDataByDate(minDate, toDate));
ds.Tables.Add(scheduleTA.GetDataByDate(minDate, toDate));
ds.Tables.Add(scheduleMealSetDetailTA.GetDataByDate(minDate, toDate));
ds.Tables.Add(transactionTypeTA.GetDataByDate(minDate, toDate));
ds.Tables.Add(transactionHistoryTA.GetDataByDate(minDate, toDate));
return ds;
}
public ActionResult AddMealSet(MealSetViewModel model)
{
ViewBag.CheckRunTimes = "2";
if (!ModelState.IsValid)
{
return View(model);
}
string updateBy = AccountInfo.GetUserName(Request);
DateTime date = DateTime.Now;
string mealSetName = model.MealSetName;
string description = model.Description;
bool canEatMore = model.CanEatMore;
string imgPath = null;
string savePath = null;
MealSetTableAdapter mealSetAdapter = new MealSetTableAdapter();
DataTable mealSetDT = mealSetAdapter.GetDataByName(mealSetName);
foreach (DataRow row in mealSetDT.Rows)
{
if (StringExtensions.EqualsInsensitive(row["Name"].ToString(), mealSetName))
{
ModelState.AddModelError("", "Tên suất ăn đã tồn tại.");
return View(model);
}
}
if (!string.IsNullOrEmpty(model.Image))
{
savePath = _sourcePath + mealSetName.Replace(" ", "_") + ".jpg";
var sourcePath = AppDomain.CurrentDomain.BaseDirectory + model.Image;
System.IO.File.Move(sourcePath, savePath);
imgPath = "\\Images\\MealSetImages\\" + mealSetName.Replace(" ", "_") + ".jpg";
}
try
{
string mealSetID = mealSetAdapter.InsertMealSetScalar(mealSetName, imgPath, description, canEatMore, date, updateBy, date).ToString();
int id = int.Parse(mealSetID);
XmlSync.SaveMealSetXml(id, mealSetName, canEatMore, date, updateBy, date, null);
Log.ActivityLog("Insert into MealSet Table: MealSetName = " + mealSetName);
Session["addMeslSet"] = "Thêm suất ăn thành công!";
}
catch (Exception ex)
{
Log.ErrorLog(ex.Message);
Session["addMeslSet"] = "Thêm suất ăn thất bại!";
}
return RedirectToAction("AddMealSet", "MealSet");
}
public ActionResult ListMealSet(string search, string filter)
{
ViewBag.successMessage = "";
ViewBag.notExistMealSet = "";
MealSetTableAdapter mealSetAdapter = new MealSetTableAdapter();
try
{
mealSetDT = mealSetAdapter.GetData();
}
catch (Exception ex)
{
Log.ErrorLog(ex.Message);
}
if (!(string.IsNullOrEmpty(search) && string.IsNullOrEmpty(filter)))
{
int type = -1;
if (!string.IsNullOrEmpty(filter))
{
int.TryParse(filter, out type);
}
string name = search;
if (name == null)
{
name = String.Empty;
}
bool type_ = false;
if (type == 1)
{
type_ = true;
}
var result = from row in mealSetDT.AsEnumerable()
where (name == String.Empty ? true : StringExtensions.ContainsInsensitive(row.Field<string>("Name"), name))
&& (type < 0 ? true : row.Field<bool>("CanEatMore") == type_)
select row;
try
{
return View(result.CopyToDataTable());
}
catch (Exception ex)
{
if (string.IsNullOrEmpty(search))
{
ViewBag.notExistMealSet = "Không tìm thấy kết quả nào";
}
else
{
ViewBag.notExistMealSet = "Không tìm thấy kết quả nào với từ khóa: " + search;
}
Log.ErrorLog(ex.Message);
}
}
return View(mealSetDT);
}
public ActionResult EditMealSet(EditMealSetModel model)
{
if (!ModelState.IsValid)
{
return View(model);
}
MealSetTableAdapter mealSetAdapter = new MealSetTableAdapter();
string updateBy = AccountInfo.GetUserName(Request);
DateTime date = DateTime.Now;
int mealSetID = model.MealSetID;
string mealSetName = model.MealSetName;
string description = model.Description;
bool canEatMore = model.CanEatMore;
DataTable dt = mealSetAdapter.GetDataByMealSetID(mealSetID);
string savePath = "\\Images\\MealSetImages\\" + mealSetName.Replace(" ", "_") + ".jpg";
if (!StringExtensions.EqualsInsensitive(dt.Rows[0]["Name"].ToString(), mealSetName))
{
DataTable mealSetDT = mealSetAdapter.GetDataByName(mealSetName);
foreach (DataRow row in mealSetDT.Rows)
{
if (StringExtensions.EqualsInsensitive(row["Name"].ToString(), mealSetName))
{
ModelState.AddModelError("", "Tên món ăn đã tồn tại.");
return View(model);
}
}
savePath = "\\Images\\MealSetImages\\" + mealSetName.Replace(" ", "_") + ".jpg";
}
if (model.Image != null)
{
if (model.Image.Contains("Temp2"))
{
string oldImage = dt.Rows[0]["Image"].ToString();
var oldImagePath = AppDomain.CurrentDomain.BaseDirectory + oldImage;
System.IO.File.Delete(oldImagePath);
}
System.IO.File.Move(AppDomain.CurrentDomain.BaseDirectory + model.Image, AppDomain.CurrentDomain.BaseDirectory + savePath);
}
else
{
savePath = null;
}
try
{
mealSetAdapter.UpdateMealSet(mealSetName, savePath, description, canEatMore, updateBy, date, mealSetID);
XmlSync.SaveMealSetXml(mealSetID, mealSetName, canEatMore, date, updateBy, date, null);
Log.ActivityLog("Update to MealSet Table: MealSetID = " + mealSetID);
Session["editMealSet"] = "Cập nhật thành công!";
}
catch (Exception ex)
{
Log.ErrorLog(ex.Message);
Session["editMealSet"] = "Cập nhật thành công!";
}
return RedirectToAction("EditMealSet", "MealSet", new { @mealSetID = model.MealSetID});
}
public ActionResult EditMealSet(string mealSetID)
{
try
{
int id = int.Parse(mealSetID);
EditMealSetModel model = new EditMealSetModel();
MealSetTableAdapter mealSetAdapter = new MealSetTableAdapter();
DataTable mealSetDT = mealSetAdapter.GetDataByMealSetID(id);
model.MealSetID = id;
model.MealSetName = mealSetDT.Rows[0]["Name"].ToString();
model.Description = mealSetDT.Rows[0]["Description"].ToString();
model.Image = mealSetDT.Rows[0]["Image"].ToString();
model.CanEatMore = (bool)mealSetDT.Rows[0]["CanEatMore"];
return View(model);
}
catch (Exception ex)
{
Log.ErrorLog(ex.Message);
return RedirectToAction("Error", "Error");
}
}
public ActionResult DeletemealSet(int mealSetID)
{
MealSetTableAdapter MealSetAdapter = new MealSetTableAdapter();
DataTable MealSetData = MealSetAdapter.GetDataByMealSetID(mealSetID);
try
{
int test = MealSetAdapter.Delete(mealSetID);
if (!string.IsNullOrEmpty(MealSetData.Rows[0]["Name"].ToString()))
{
var deleteFilePath = AppDomain.CurrentDomain.BaseDirectory + MealSetData.Rows[0]["Name"].ToString();
System.IO.File.Delete(deleteFilePath);
}
Session["deleteMealSet"] = "Xóa thành công!";
}
catch (Exception ex)
{
Log.ErrorLog(ex.Message);
Session["deleteMealSet"] = "Xóa thất bại! Suất ăn đang được sử dụng.";
}
return RedirectToAction("ListMealSet","MealSet");
}
public ActionResult AddMealSetDish(string mealSetID, string search, string filter)
{
ViewBag.notExistMealSet = "";
DishTypeTableAdapter dishTypeAdapter = new DishTypeTableAdapter();
DataTable dishTypeDT = dishTypeAdapter.GetData();
List<SelectListItem> items = new List<SelectListItem>();
items.Add(new SelectListItem { Text = "Tất Cả", Value = "" });
foreach (DataRow row in dishTypeDT.Rows)
{
items.Add(new SelectListItem { Text = row["TypeName"].ToString(), Value = row["DishTypeID"].ToString() });
}
ViewData["DishType"] = items;
DataTable dishDT = new DataTable();
DishInfoDetailTableAdapter adapter = new DishInfoDetailTableAdapter();
try
{
dishDT = adapter.GetData();
}
catch (Exception ex)
{
Log.ErrorLog(ex.Message);
}
if (!(string.IsNullOrEmpty(search) && string.IsNullOrEmpty(filter)))
{
int type = -1;
int.TryParse(filter, out type);
string name = search;
if (name == null)
{
name = String.Empty;
}
var result = from row in dishDT.AsEnumerable()
where (name == String.Empty ? true : StringExtensions.ContainsInsensitive(row.Field<string>("Name"), name))
&& (type < 1 ? true : row.Field<int>("DishTypeID") == type)
select row;
try
{
dishDT = result.CopyToDataTable();
}
catch (Exception ex)
{
if (string.IsNullOrEmpty(search))
{
ViewBag.notExistMealSet = "Không tìm thấy kết quả nào";
}
else
{
ViewBag.notExistMealSet = "Không tìm thấy kết quả nào với từ khóa: " + search;
}
Log.ErrorLog(ex.Message);
}
}
ViewData["listDish"] = dishDT;
try
{
int id = int.Parse(mealSetID);
MealSetDishInfoTableAdapter mealSetDishInfoAdapter = new MealSetDishInfoTableAdapter();
ViewData["listMealSetDish"] = mealSetDishInfoAdapter.GetDataByMealSetID(id);
MealSetTableAdapter mealSetAdapter = new MealSetTableAdapter();
EditMealSetModel model = new EditMealSetModel();
DataTable mealSetDT = mealSetAdapter.GetDataByMealSetID(id);
model.MealSetID = id;
model.MealSetName = mealSetDT.Rows[0]["Name"].ToString();
model.Description = mealSetDT.Rows[0]["Description"].ToString();
model.Image = mealSetDT.Rows[0]["Image"].ToString();
model.CanEatMore = (bool)mealSetDT.Rows[0]["CanEatMore"];
return View(model);
}
catch (Exception ex)
{
Log.ErrorLog(ex.Message);
return RedirectToAction("Error", "Error");
}
}
public JsonResult GetMeatSetForDDL()
{
try
{
MealSetTableAdapter mealSetTA = new MealSetTableAdapter();
DataTable mealSetDT = mealSetTA.GetData();
IList<MeatSetForDDLJsonModel> mealSet = new List<MeatSetForDDLJsonModel>();
foreach (DataRow row in mealSetDT.Rows)
{
MeatSetForDDLJsonModel model = new MeatSetForDDLJsonModel();
model.MealSetID = row.Field<int>("MealSetID");
model.Name = row.Field<string>("Name");
mealSet.Add(model);
}
return Json(new { mealSet = mealSet }, JsonRequestBehavior.AllowGet);
}
catch (Exception ex)
{
Log.ErrorLog(ex.Message);
return Json("error", JsonRequestBehavior.AllowGet);
}
}
