public ActionResult ProjectMeeting(ProjectMeetingTime objmeeting)
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
var Message = "";
var already = objdb.MettingSchedules.Where(o => o.Week == objmeeting.Week && o.Day == objmeeting.Day && o.TimeSlot == objmeeting.TimeSlotFrom).Select(i => i.ProjectID).FirstOrDefault();
if (already != null)
{
return(Json(new { Result = "AlreadyExist", URL = @Url.Action("AlertPopUp", "Popup") }, JsonRequestBehavior.AllowGet));
}
var time = Convert.ToDateTime(objmeeting.TimeSlotFrom);
var hour = Convert.ToInt32(time.Hour);
var min = Convert.ToInt32(time.Minute);
var tt = time.ToString("tt");
// List<string> obj = new List<string>();
var obj = objdb.MettingSchedules.Where(o => o.Week == objmeeting.Week && o.Day == objmeeting.Day).Select(o => o).ToList();
TimeSpan CurTime = new TimeSpan(hour, min, 0);
foreach (var item in obj)
{
var dbtime = Convert.ToDateTime(item.TimeSlot);
var hourdb = Convert.ToInt32(dbtime.Hour);
var mindb = Convert.ToInt32(dbtime.Minute);
var ttdb = dbtime.ToString("tt");
TimeSpan Db_StartTime = new TimeSpan(hourdb, mindb, 0);
var dbendtime = Convert.ToDateTime(item.EndTime);
var hourenddb = Convert.ToInt32(dbendtime.Hour);
var minenddb = Convert.ToInt32(dbendtime.Minute);
var endttdb = dbendtime.ToString("tt");
TimeSpan Db_EndTime = new TimeSpan(hourenddb, minenddb, 0);
if (Db_StartTime == CurTime)
{
Message = "availabletime";
return(Json(new { Result = Message }, JsonRequestBehavior.AllowGet));
}
else if (Db_StartTime >= CurTime && CurTime < Db_EndTime)
{
Message = "availabletime";
return(Json(new { Result = Message }, JsonRequestBehavior.AllowGet));
}
else if (Db_StartTime <= CurTime && CurTime <= Db_EndTime)
{
Message = "availabletime";
return(Json(new { Result = Message }, JsonRequestBehavior.AllowGet));
}
}
DSRCManagementSystemEntities1 db = new DSRCManagementSystemEntities1();
DSRCManagementSystem.MettingSchedule objdetail = new DSRCManagementSystem.MettingSchedule();
objdetail.ProjectID = Convert.ToInt32(objmeeting.ProjectNameId);
objdetail.TimeSlot = objmeeting.TimeSlotFrom;
objdetail.EndTime = objmeeting.TimeSlotTo;
objdetail.Day = objmeeting.Day;
objdetail.Week = objmeeting.Week;
objdetail.Attendees = objmeeting.Attendee;
db.AddToMettingSchedules(objdetail);
db.SaveChanges();
return(Json(new { Result = "Success" }, JsonRequestBehavior.AllowGet));
}
