public JsonResult SaveEvent(Events e)
{
var status = false;
using (EventsDbEntities dc = new EventsDbEntities())
{
//update event
if (e.EventID > 0)
{
var v = dc.Events.Where(a => a.EventID == e.EventID).FirstOrDefault();
if (v != null)
{
v.Subject = e.Subject;
v.Start = e.Start;
v.End = e.End;
v.Description = e.Description;
v.IsFullDay = e.IsFullDay;
v.ThemeColor = e.ThemeColor;
}
}
else
{
dc.Events.Add(e);
}
dc.SaveChanges();
status = true;
}
return(new JsonResult {
Data = new { status = status }
});
}
public string CreateProfile(ProfileModel ProfileModel)
{
string regStatus = "";
try
{
using (EventsDbEntities eventsContext = new EventsDbEntities())
{
T_LOGIN loginEntity = new T_LOGIN();
loginEntity.UserName = ProfileModel.UserName;
loginEntity.Password = ProfileModel.Password;
loginEntity.CreatedBy = "System";
loginEntity.CreatedOn = DateTime.Now;
eventsContext.T_LOGIN.Add(loginEntity);
T_PROFILE_DETAILS profilesEntity = new T_PROFILE_DETAILS();
profilesEntity.FirstName = ProfileModel.FirstName;
profilesEntity.LastName = ProfileModel.LastName;
profilesEntity.LoginId = loginEntity.LoginId;
eventsContext.T_PROFILE_DETAILS.Add(profilesEntity);
eventsContext.SaveChanges();
}
regStatus = "Success";
}
catch (Exception ex)
{
throw ex;
regStatus = "Error occured";
}
return regStatus;
}
public JsonResult getEvents()
{
using (EventsDbEntities dc = new EventsDbEntities())
{
var events = dc.Events.ToList();
return(new JsonResult {
Data = events, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
}
public JsonResult DeleteEvent(int eventID)
{
var status = false;
using (EventsDbEntities dc = new EventsDbEntities())
{
var v = dc.Events.Where(a => a.EventID == eventID).FirstOrDefault();
if (v != null)
{
dc.Events.Remove(v);
dc.SaveChanges();
status = true;
}
}
return(new JsonResult {
Data = new { status = status }
});
}
public int AddEvent(string EventDescription, DateTime StartDate, DateTime EndDate,string City, string State, string UserName)
{
int eventId = 0;
using (EventsDbEntities eventsContext = new EventsDbEntities())
{
T_EVENTS newEvent = new T_EVENTS();
newEvent.EventDescription = EventDescription;
newEvent.StartDate = StartDate;
newEvent.EndDate = EndDate;
newEvent.City = City;
newEvent.State = State;
var login = eventsContext.T_LOGIN.Where(i => i.UserName == UserName).FirstOrDefault();
newEvent.LoginId = login.LoginId;
eventsContext.T_EVENTS.Add(newEvent);
eventsContext.SaveChanges();
eventId = newEvent.EventId;
}
return eventId;
}
public List<CalendarItem> GetEvents()
{
List<CalendarItem> calItems = new List<CalendarItem>();
using (EventsDbEntities eventsContext = new EventsDbEntities())
{
var events = eventsContext.T_EVENTS.ToList();
foreach (var eve in events)
{
CalendarItem calItem = new CalendarItem();
//calItem.LoginId = eve.LoginId;
calItem.Id = eve.EventId;
calItem.Start = eve.StartDate;
calItem.End = eve.EndDate;
calItem.title = eve.EventDescription;
calItems.Add(calItem);
}
}
return calItems;
}
public EventModel GetEventItem(int eventId)
{
EventModel model = new EventModel();
using (EventsDbEntities eventsContext = new EventsDbEntities())
{
var eve = eventsContext.T_EVENTS.FirstOrDefault(ent => ent.EventId == eventId);
//calItem.LoginId = eve.LoginId;
// model.e = eve.EventId;
model.StartDate = eve.StartDate;
model.EndDate = eve.EndDate;
model.EventDescription = eve.EventDescription;
model.State = eve.State;
model.City = eve.City;
model.EventId = eventId;
}
return model;
}
public void UpdateEvents(EventModel model)
{
using (EventsDbEntities eventsContext = new EventsDbEntities())
{
T_EVENTS eve = eventsContext.T_EVENTS.FirstOrDefault(e => e.EventId == model.EventId);
eve.StartDate = model.StartDate;
eve.EndDate = model.EndDate;
eve.City = model.City;
eve.State = model.State;
eve.EventDescription = model.EventDescription;
eventsContext.SaveChanges();
}
}
public ProfileModel GetProfile(string userName)
{
ProfileModel model = new ProfileModel();
if (!String.IsNullOrWhiteSpace(userName))
{
using (EventsDbEntities eventsContext = new EventsDbEntities())
{
T_LOGIN loginDetails = eventsContext.T_LOGIN.FirstOrDefault(login => login.UserName == userName);
T_PROFILE_DETAILS profileDetails = eventsContext.T_PROFILE_DETAILS.FirstOrDefault(profile => profile.LoginId == loginDetails.LoginId);
model.FirstName = profileDetails.FirstName;
model.LastName = profileDetails.LastName;
model.Password = loginDetails.Password;
model.cnfmPassword = loginDetails.Password;
model.UserName = userName;
}
}
return model;
}
public void UpdateProfile(ProfileModel model)
{
using (EventsDbEntities eventsContext = new EventsDbEntities())
{
T_LOGIN loginDetails = eventsContext.T_LOGIN.FirstOrDefault(login => login.UserName == model.UserName);
T_PROFILE_DETAILS profileDetails = eventsContext.T_PROFILE_DETAILS.FirstOrDefault(profile => profile.LoginId == loginDetails.LoginId);
profileDetails.FirstName = model.FirstName;
profileDetails.LastName = model.LastName;
loginDetails.Password = model.Password;
eventsContext.SaveChanges();
}
}
