public ActionResult ProjectMeeting()
{
DSRCManagementSystemEntities1 objdb = new DSRCManagementSystemEntities1();
// var ProjectList = objdb.Projects.Where(x=>x.IsActive==true).ToList();
int userId = Convert.ToInt32(Session["UserID"]);
var ProjectList = (from p in objdb.Projects
join pt in objdb.Master_ProjectTypes on p.ProjectTypeID equals pt.ProjectTypeID
join up in objdb.UserProjects.Where(x => x.UserID == userId) on p.ProjectID equals up.ProjectID
where p.IsActive == true && (p.IsDeleted != true || p.IsDeleted == null)
select new Projects()
{
ProjectID = p.ProjectID,
ProjectName = p.ProjectName,
ProjectCode = p.ProjectCode,
ProjectType = pt.ProjectTypeName,
RAGStatus = p.RAGStatus,
RAGComments = p.RAGComments ?? "Comments not added",
CommentsCreated = p.CommentsCreated,
//MemberTypeID = up.MemberTypeID
}).Distinct().ToList();
ProjectMeetingTime objtime = new ProjectMeetingTime();
var ProjectLead = (from t in objdb.Users.Where(x => x.IsActive == true && x.UserStatus != 6)
join atn in objdb.MeetingGuids on t.UserID equals atn.UserId
select new
{
Id = t.UserID,
FirstName = t.FirstName + " " + (t.LastName.Length > 0 ? t.LastName : ""),
LastName = t.LastName,
}).ToList();
var Days = objdb.Master_Days.ToList();
ViewBag.Leaders = new MultiSelectList(ProjectLead, "Id", "FirstName", "LastName");
ViewBag.DayList = new SelectList(new[] { new Master_Days()
{
Id = 0, Days = "--Select--"
} }.Union(Days), "Id", "Days", 0);
ViewBag.Projects = new SelectList(ProjectList, "ProjectID", "ProjectName");
ViewBag.Week = new SelectList(new[] { new { Text = "--Select--", Value = 0 }, new { Text = "1", Value = 1 }, new { Text = "2", Value = 2 } }, "Value", "Text", 0);
return(View());
}
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));
}