public ActionResult Create(tMetting_date data)
{
var old_time = db.tMetting_date.Where(p => p.fDate == data.fDate).Select(p => new { p.fStarttime, p.fEndtime });
is_空白驗證(data);
if (old_time.Count() != 0)
{
foreach (var old in old_time)
{
if (data.fStarttime < old.fEndtime && data.fEndtime > old.fStarttime)
{
this.ModelState.AddModelError("fEndtime", "跟其他時間選擇衝突到，請重新選擇請選擇時間");
break;
}
}
}
if (this.ModelState.IsValid)
{
tMetting_date d = data;
db.tMetting_date.Add(d);
db.SaveChanges();
return(RedirectToAction("mettingIndex"));
}
return(RedirectToAction("mettingIndex"));
}
public ActionResult Create(tMetting_date data)
{
var old_time = db.tMetting_date.Where(p => p.fDate == data.fDate && p.fRoom == data.fRoom).Select(p => new { p.fStarttime, p.fEndtime });
is_空白驗證(data);
if (old_time.Count() != 0)
{
foreach (var old in old_time)
{
if (data.fStarttime < old.fEndtime && data.fEndtime > old.fStarttime)
{
this.ModelState.AddModelError("fEndtime", "跟其他時間選擇衝突到，請重新選擇請選擇時間");
break;
}
}
}
var b = Convert.ToDateTime(data.fDate).DayOfWeek.ToString();
if (b == "Sunday" || b == "Saturday" || DateTime.Now.Date > Convert.ToDateTime(data.fDate))
{
this.ModelState.AddModelError("fDate", "請勿選六日時間");
}
if (this.ModelState.IsValid)
{
tMetting_date d = data;
db.tMetting_date.Add(d);
db.SaveChanges();
var fid = db.tMetting_date.OrderByDescending(p => p.fId).First().fId;
return(RedirectToAction("mettingIndex", new { message = "創建成功", fid = fid }));
}
return(RedirectToAction("mettingIndex", new { message = "除前端還有後端驗證!!!!" }));
}
public ActionResult Edit(tMetting_date data)
{
var new_date = db.tMetting_date.FirstOrDefault(p => p.fId == data.fId);
var old_time = db.tMetting_date.Where(p => p.fDate == data.fDate && p.fRoom == data.fRoom && p.fId != data.fId).Select(p => new { p.fStarttime, p.fEndtime });
if (data == null)
{
return(RedirectToAction("Index"));
}
is_空白驗證(data);
if (old_time.Count() != 0)
{
foreach (var old in old_time)
{
if (data.fStarttime < old.fEndtime && data.fEndtime > old.fStarttime)
{
this.ModelState.AddModelError("fEndtime", "跟其他時間選擇衝突到，請重新選擇請選擇時間");
break;
}
}
}
var b = Convert.ToDateTime(data.fDate).DayOfWeek.ToString();
if (b == "Sunday" || b == "Saturday" || DateTime.Now.Date > Convert.ToDateTime(data.fDate))
{
this.ModelState.AddModelError("fDate", "請勿選六日時間");
}
if (this.ModelState.IsValid)
{
new_date.fDate = data.fDate;
new_date.fStarttime = data.fStarttime;
new_date.fEndtime = data.fEndtime;
new_date.fReason = data.fReason;
db.SaveChanges();
return(RedirectToAction("mettingIndex", new { message = "編輯成功", fid = data.fId }));
}
return(RedirectToAction("mettingIndex", new { message = "除前端還有後端驗證!!!!" }));
}
private void is_空白驗證(tMetting_date data)
{
if (String.IsNullOrEmpty(data.fReason))
{
this.ModelState.AddModelError("fReason", "不可空白");
}
if (data.fStarttime != null && data.fEndtime != null)
{
if (data.fEndtime.Value < data.fStarttime.Value)
{
this.ModelState.AddModelError("fEndtime", "請選擇大於開始時間");
}
}
if (data.fStarttime == null)
{
this.ModelState.AddModelError("fStarttime", "請選擇時間");
}
if (data.fEndtime == null)
{
this.ModelState.AddModelError("fEndtime", "請選擇時間");
}
}
