public ActionResult EditDetail(TongHopDetail model, string url)
{
var db = DB.Entities;
// Add new
db.AttachTo("TongHopDetail", model);
db.ObjectStateManager.ChangeObjectState(model, System.Data.EntityState.Modified);
db.SaveChanges();
return(Redirect(url));
}
public ActionResult TongHopLai(string fromDate, string endDate)
{
if (fromDate == null)
{
return(RedirectToAction("NewOrEdit", new { fromDate = fromDate, endDate = endDate }));
}
string[] arrFrom = fromDate.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries);
DateTime start = new DateTime(int.Parse(arrFrom[2]), int.Parse(arrFrom[1]), int.Parse(arrFrom[0]), 0, 0, 0);
DateTime end = start.AddDays(7).AddSeconds(-1);
string codedate = "" + start.Day + start.Month + start.Year;
ViewBag.CodeDate = codedate;
var db = DB.Entities;
if (db.TongHop.FirstOrDefault(m => m.Code == codedate) != null)
{
var listJob = db.JobRegister.Where(m => !m.Added && m.DateFrom >= start && m.DateFrom <= end).ToList();
if (listJob.Count > 0)
{
var lsttonghop = db.TongHop.Where(m => m.Code == codedate);
foreach (var item in lsttonghop)
{
foreach (var job in listJob)
{
if (((int)job.DateFrom.DayOfWeek + 6) % 7 != item.DayOfWeek)
{
continue;
}
var tonghopdetail = new TongHopDetail();
tonghopdetail.Time = job.DateFrom.TimeOfDay;
tonghopdetail.NoiDung = job.Content;
tonghopdetail.NguoiThucHien = job.NguoiThucHien;
tonghopdetail.TongHopID = item.ID;
tonghopdetail.Location = job.Location;
tonghopdetail.Code = codedate;
db.TongHopDetail.AddObject(tonghopdetail);
job.Added = true;
db.ObjectStateManager.ChangeObjectState(job, System.Data.EntityState.Modified);
}
}
db.SaveChanges();
}
var listTH = db.TongHop.Where(m => m.Code == codedate).ToList();
ViewBag.ListTongHop = listTH;
ViewBag.IsEdit = true;
return(RedirectToAction("NewOrEdit", new { fromDate = fromDate, endDate = endDate }));
}
return(RedirectToAction("NewOrEdit", new { fromDate = fromDate, endDate = endDate }));
}
public ActionResult TongHop(string fromDate, string endDate)
{
if (fromDate == null)
{
return(RedirectToAction("NewOrEdit", new { fromDate = fromDate, endDate = endDate }));
}
//DateTime start = DateTime.ParseExact(fromDate + " 12:00:00 AM", "MM/dd/yyyy HH:mm:ss tt", CultureInfo.InvariantCulture);
string[] arrFrom = fromDate.Split(new char[] { '/' }, StringSplitOptions.RemoveEmptyEntries);
DateTime start = new DateTime(int.Parse(arrFrom[2]), int.Parse(arrFrom[1]), int.Parse(arrFrom[0]), 0, 0, 0);
DateTime end = start.AddDays(7).AddSeconds(-1);
string codedate = "" + start.Day + start.Month + start.Year;
ViewBag.CodeDate = codedate;
var db = DB.Entities;
if (db.TongHop.FirstOrDefault(m => m.Code == codedate) == null)
{
var tieude = new TieuDe()
{
Title = "LỊCH CÔNG TÁC TUẦN TỪ " + string.Format("{0:d/M}", start) + " ĐẾN " + string.Format("{0:d/M/yyyy}", end)
};
db.TieuDe.AddObject(tieude);
db.SaveChanges();
var listJob = db.JobRegister.Where(m => m.DateFrom >= start && m.DateFrom <= end).ToList();
for (int i = 0; i < 7; i++)
{
var tonghop = new TongHop()
{
FromDate = start, DayOfWeek = i, Code = codedate, TieuDeID = tieude.ID
};
db.TongHop.AddObject(tonghop);
db.SaveChanges();
foreach (var item in listJob)
{
if (((int)item.DateFrom.DayOfWeek + 6) % 7 != i)
{
continue;
}
var tonghopdetail = new TongHopDetail();
tonghopdetail.Time = item.DateFrom.TimeOfDay;
tonghopdetail.NoiDung = item.Content;
tonghopdetail.NguoiThucHien = item.NguoiThucHien;
tonghopdetail.TongHopID = tonghop.ID;
tonghopdetail.Location = item.Location;
tonghopdetail.Code = codedate;
db.TongHopDetail.AddObject(tonghopdetail);
item.Added = true;
db.ObjectStateManager.ChangeObjectState(item, System.Data.EntityState.Modified);
}
}
db.SaveChanges();
var listTH = db.TongHop.Where(m => m.Code == codedate).ToList();
ViewBag.ListTongHop = listTH;
return(RedirectToAction("NewOrEdit", new { fromDate = fromDate, endDate = endDate }));
}
else
{
ViewBag.IsEdit = true;
}
return(RedirectToAction("NewOrEdit", new { fromDate = fromDate, endDate = endDate }));
}
