public void UpdateEvent(int id, string NewEventStart, string NewEventEnd)
{
if (ClaimsPrincipal.Current != null)
{
DiaryEvent.UpdateDiaryEvent(id, NewEventStart, NewEventEnd);
}
}
public int UpdateEvent(DiaryEvent diaryEvent, string eveTitle)
{
string sql = "UPDATE DiaryEvents SET EventTitle='" + diaryEvent.EventTitle + "',Description='" + diaryEvent.Description + "',ModificationDate='" + diaryEvent.ModificationDate + "',Mood='" + diaryEvent.Mood + "',Importance='" + diaryEvent.Importance + "' WHERE EventTitle= '" + eveTitle + "'";
int result = this.dataAccess.ExecuteQuery(sql);
return(result);
}
public bool SaveHoliday(string NewEventDate)
{
if (ClaimsPrincipal.Current != null)
{
return(DiaryEvent.CreateHolidayNewEvent(NewEventDate));
}
return(false);
}
public bool SaveEvent(string Title, string NewEventDate, string NewEventTime, string NewEventTimeEnd)
{
if (ClaimsPrincipal.Current != null)
{
return(DiaryEvent.CreateNewEvent(Title, NewEventDate, NewEventTime, NewEventTimeEnd));
}
return(false);
}
private void ModifyEvent_Load(object sender, EventArgs e)
{
EventService eventService = new EventService();
DiaryEvent diaryEvent = new DiaryEvent();
diaryEvent = eventService.GetEventDetailss(eveTitle);
modifyTitleTextBox.Text = diaryEvent.EventTitle;
modifyDescriptionTextBox.Text = diaryEvent.Description;
modifyMoodComboBox.Text = diaryEvent.Mood;
modifyImportanceComboBox.Text = diaryEvent.Importance;
}
public static string GetCalendarEvents()
{
var listEvents = new List <DiaryEvent>();
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnStringDeltoneCRM"].ConnectionString;
using (SqlCommand cmd = new SqlCommand())
{
var querystring = "";
if (System.Web.HttpContext.Current.Session["USERPROFILE"].ToString() == "ADMIN")
{
querystring = "SELECT distinct( QT.QuoteID) , CO.CompanyName, QT.QuoteBy , QT.CallBackDate " +
" FROM dbo.Quote QT INNER JOIN " +
"dbo.Contacts CT ON QT.ContactID = CT.ContactID INNER JOIN dbo.Companies CO ON CO.CompanyID=QT.CompanyID where QT.Flag='LiveDB' and QT.QuoteCategory=1 " +
" Union SELECT distinct(QT.QuoteID), CO.CompanyName, QT.QuoteBy , QT.CallBackDate " +
" FROM dbo.Quote QT " +
" INNER JOIN dbo.Quote_Companies CO ON CO.CompanyID=QT.CompanyID where QT.Flag='QuoteDB' and QT.QuoteCategory=1 ";
}
else
{
var createdBy = System.Web.HttpContext.Current.Session["LoggedUser"].ToString();
querystring = "SELECT QT.QuoteID, QT.QuoteDateTime as QuoteDate, CO.CompanyName FROM dbo.Quote QT INNER JOIN " +
" QT.QuoteBy FROM dbo.Quote QT INNER JOIN " +
" dbo.Companies CO ON CO.CompanyID=QT.CompanyID where QT.QuoteBy=@createdBy And QT.QuoteCategory=" + 1;
cmd.Parameters.AddWithValue("@createdBy", createdBy);
}
cmd.CommandText = querystring;
cmd.Connection = conn;
conn.Open();
using (SqlDataReader sdr = cmd.ExecuteReader())
{
if (sdr.HasRows)
{
while (sdr.Read())
{
var events = new DiaryEvent();
events.start = sdr["CallBackDate"].ToString();
events.id = Convert.ToInt32(sdr["QuoteID"].ToString());
events.title = sdr["CompanyName"].ToString();
listEvents.Add(events);
}
}
}
conn.Close();
}
}
return(JsonConvert.SerializeObject(listEvents));;
}
private void EventDetails_Load(object sender, EventArgs e)
{
EventService eventService = new EventService();
DiaryEvent diaryEvent = new DiaryEvent();
diaryEvent = eventService.GetEventDetailss(evTitle);
eventTitleLebel.Text = diaryEvent.EventTitle;
descriptionTextBox.Text = diaryEvent.Description;
createdLabel.Text = diaryEvent.CreationDate;
ModifiedLabel.Text = diaryEvent.ModificationDate;
moodLebel.Text = diaryEvent.Mood;
importanceLebel.Text = diaryEvent.Importance;
}
public async Task CreateEvent(Guid userId, params CreateEventModel[] models)
{
var eventTypes = (await GetEventTypes()).ToArray();
using (var unitOfWork = await DataConnectionFactory.CreateUnitOfWork())
{
var user = await unitOfWork.Users.GetById(userId);
foreach (var model in models)
{
var eventType = eventTypes.FirstOrDefault(t => t.Id == model.EventTypeId);
if (eventType == null)
{
throw new NotFoundException("Event type not found.");
}
if (eventType.System)
{
throw new SystemEntityException("Events of this type cannot be created manually.");
}
var diaryEvent = new DiaryEvent
{
EventTypeId = model.EventTypeId,
RoomId = model.RoomId,
Subject = model.Subject,
Description = model.Description,
Location = model.Location,
StartTime = model.StartTime,
EndTime = model.EndTime,
IsPublic = model.IsPublic
};
if (user.PersonId.HasValue)
{
diaryEvent.Attendees.Add(new DiaryEventAttendee
{
PersonId = user.PersonId.Value,
Required = true,
ResponseId = AttendeeResponses.Accepted,
CanEdit = true
});
}
unitOfWork.DiaryEvents.Create(diaryEvent);
}
await unitOfWork.SaveChangesAsync();
}
}
public int ModifyEventDetails(string eventTitle, string description, string modifyDate, string mood, string importance, string eveTitle)
{
DiaryEvent diaryEvent = new DiaryEvent()
{
EventTitle = eventTitle,
Description = description,
ModificationDate = modifyDate,
Mood = mood,
Importance = importance,
};
eventDataAccess = new EventDataAccess();
return(eventDataAccess.UpdateEvent(diaryEvent, eveTitle));
}
public int CreateEvent(string eventTitle, string description, string creationDate, string mood, string importance)
{
DiaryEvent diaryEvent = new DiaryEvent()
{
EventTitle = eventTitle,
Description = description,
CreationDate = creationDate,
ModificationDate = creationDate,
Mood = mood,
Importance = importance,
UserId = MyGlobals.userId
};
eventDataAccess = new EventDataAccess();
return(eventDataAccess.CreateEvent(diaryEvent));
}
public JsonResult GetDiarySummary(double start, double end)
{
var ApptListForDate = DiaryEvent.LoadAppointmentSummaryInDateRange(start, end);
var eventList = from e in ApptListForDate
select new
{
id = e.ID,
title = e.Title,
start = e.StartDateString,
end = e.EndDateString,
someKey = e.SomeImportantKeyID,
allDay = false
};
var rows = eventList.ToArray();
return(Json(rows, JsonRequestBehavior.AllowGet));
}
public DiaryEvent GetEventDetails(string eventTitle)
{
string sql = "SELECT * FROM DIARYEVENTS WHERE EventTitle='" + eventTitle + "'";
SqlDataReader reader = this.dataAccess.GetData(sql);
reader.Read();
DiaryEvent diaryEvent = new DiaryEvent();
diaryEvent.EventTitle = reader["EventTitle"].ToString();
diaryEvent.Description = reader["Description"].ToString();
diaryEvent.CreationDate = reader["CreationDate"].ToString();
diaryEvent.ModificationDate = reader["ModificationDate"].ToString();
diaryEvent.Mood = reader["Mood"].ToString();
diaryEvent.Importance = reader["Importance"].ToString();
diaryEvent.UserId = (int)reader["UserId"];
return(diaryEvent);
}
public void CreateSeries_Weekly()
{
var now = DateTime.Now;
var endDate = now.AddDays(23);
var diaryEvent = new DiaryEvent
{
Subject = "Test Event",
StartTime = now,
EndTime = now.AddHours(1)
};
var model = new DiaryEventModel(diaryEvent);
var series = model.CreateSeries(EventFrequency.Weekly, endDate);
Assert.That(series, Has.Count.EqualTo(4));
}
public void CreateSeries_AllDay_Daily()
{
var now = DateTime.Now;
var endDate = now.AddDays(23);
var diaryEvent = new DiaryEvent
{
Subject = "Test Event",
StartTime = now.Date,
EndTime = now.GetEndOfDay()
};
var model = new DiaryEventModel(diaryEvent);
var series = model.CreateSeries(EventFrequency.Daily, endDate);
Assert.That(series, Has.Count.EqualTo(24));
}
// GET api/<controller>/5
public Array Get(double start, double end, string custom_param1)
{
var ApptListForDate = DiaryEvent.LoadAllAppointmentsInDateRange(start, end, custom_param1);
var eventList = from e in ApptListForDate
select new
{
id = e.ID,
title = e.Title,
start = e.StartDateString,
end = e.EndDateString,
color = e.StatusColor,
className = e.ClassName,
// someKey = e.SomeImportantKeyID,
allDay = false
};
var rows = eventList.ToArray();
return(rows);
}
public JsonResult GetDiaryEvents(double start, double end)
{
var ApptListForDate = DiaryEvent.LoadAllAppointmentsInDateRange(start, end);
var eventList = from e in ApptListForDate
select new
{
id = e.ID,
title = e.Title,
start = e.StartDateString,
end = e.EndDateString,
color = e.StatusColor,
className = e.ClassName,
someKey = e.SomeImportantKeyID,
allDay = false,
Description = e.Description
};
var rows = eventList.ToArray();
return(Json(rows, JsonRequestBehavior.AllowGet));
}
private void LoadFromModel(DiaryEvent model)
{
EventTypeId = model.EventTypeId;
RoomId = model.RoomId;
Subject = model.Subject;
Description = model.Description;
Location = model.Location;
StartTime = model.StartTime;
EndTime = model.EndTime;
IsPublic = model.IsPublic;
if (model.EventType != null)
{
EventType = new DiaryEventTypeModel(model.EventType);
}
if (model.Room != null)
{
Room = new RoomModel(model.Room);
}
}
public List <DiaryEvent> Obtiene_Reservas_New(int?cancha_id, string start, string end)
{
List <DiaryEvent> lista = new List <DiaryEvent>();
DiaryEvent obj;
iniciarConexion();
command = new SqlCommand(Constante.USP_SEL_EVENTOS, getCon());
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@cancha_Id", SqlDbType.Int).Value = cancha_id;
command.Parameters.Add("@Fecha_Inicio", SqlDbType.VarChar).Value = start;
command.Parameters.Add("@Fecha_Fin", SqlDbType.VarChar).Value = end;
using (IDataReader iDataReader = command.ExecuteReader())
{
int iIdReserva = iDataReader.GetOrdinal("IdReserva");
int iFechaInicio = iDataReader.GetOrdinal("FechaInicio");
int iFechaFin = iDataReader.GetOrdinal("FechaFin");
int iTitulo = iDataReader.GetOrdinal("Titulo");
int iIdEstado = iDataReader.GetOrdinal("IdEstado");
int iClienteNombre = iDataReader.GetOrdinal("ClienteNombre");
int iIdCancha = iDataReader.GetOrdinal("IdCancha");
while (iDataReader.Read())
{
obj = new DiaryEvent();
obj.IdReserva = DataUtil.ValueOfDataBase <Int32>(iDataReader[iIdReserva]);
obj.IdCancha = DataUtil.ValueOfDataBase <Int32>(iDataReader[iIdCancha]);
obj.StartDateString = DataUtil.ValueOfDataBase <string>(iDataReader[iFechaInicio]);
obj.EndDateString = DataUtil.ValueOfDataBase <string>(iDataReader[iFechaFin]);
obj.Title = DataUtil.ValueOfDataBase <string>(iDataReader[iTitulo]);
obj.IdEstado = DataUtil.ValueOfDataBase <Int32>(iDataReader[iIdEstado]);
obj.ClienteNombre = DataUtil.ValueOfDataBase <string>(iDataReader[iClienteNombre]);
lista.Add(obj);
}
}
cerrarConexion();
return(lista);
}
public IEnumerable <DiaryEvent> LoadAllAppointmentsInDateRange(DateTime fromDate, DateTime toDate)
{
List <DiaryEvent> result = new List <DiaryEvent>();
foreach (var item in GetAppointmentDiaries().Where(s => s.DateTimeScheduled >= fromDate && s.DateTimeScheduled.AddMinutes(s.AppointmentLength) <= toDate))
{
DiaryEvent rec = new DiaryEvent
{
ID = item.ID,
SomeImportantKeyID = item.SomeImportantKey,
StartDateString = item.DateTimeScheduled.ToString("s"), // "s" is a preset format that outputs as: "2009-02-27T12:12:22"
EndDateString = item.DateTimeScheduled.AddMinutes(item.AppointmentLength).ToString("s"), // field AppointmentLength is in minutes
Title = item.Title + " - " + item.AppointmentLength.ToString() + " mins",
StatusString = Enums.GetName((AppointmentStatus)item.StatusENUM)
};
rec.StatusColor = Enums.GetEnumDescription <AppointmentStatus>(rec.StatusString);
string ColorCode = rec.StatusColor.Substring(0, rec.StatusColor.IndexOf(":"));
rec.ClassName = rec.StatusColor.Substring(rec.StatusColor.IndexOf(":") + 1, rec.StatusColor.Length - ColorCode.Length - 1);
rec.StatusColor = ColorCode;
result.Add(rec);
}
return(result);
}
public int CreateEvent(DiaryEvent diaryEvent)
{
string sql = "INSERT INTO DIARYEVENTS (EventTitle,Description,CreationDate,ModificationDate,Mood,Importance,UserId) VALUES('" + diaryEvent.EventTitle + "','" + diaryEvent.Description + "','" + diaryEvent.CreationDate + "','" + diaryEvent.ModificationDate + "','" + diaryEvent.Mood + "','" + diaryEvent.Importance + "'," + diaryEvent.UserId + ")";
return(this.dataAccess.ExecuteQuery(sql));
}
public bool SaveEvent(string Title, string NewEventDate, string NewEventTime, string NewEventDuration, string Description)
{
//int InspectorID = LoginRepository.GetUserID(User.Identity.Name);
return(DiaryEvent.CreateNewEvent(Title, NewEventDate, NewEventTime, NewEventDuration, Description, 1));
}
public bool DeleteEvent(string NewDeleteEventId)
{
return(DiaryEvent.DeleteDiaryEvent(NewDeleteEventId));
}
public bool SaveEvent(string NewEventDate, string NeweventStartTime, string NeweventEndTime, string NewCurrentDate)
{
return(DiaryEvent.CreateNewEvent(NewEventDate, NeweventStartTime, NeweventEndTime, NewCurrentDate));
}
public void UpdateEvent(int id, string NewEventStart, string NewEventEnd, string Description, string Title)
{
DiaryEvent.UpdateDiaryEvent(id, NewEventStart, NewEventEnd, Description, Title);
}
public void Test(double start, double end)
{
DiaryEvent diaryEvent = new DiaryEvent(new YogaSpaceEventRepository());
var apptListForDate = DiaryEvent.LoadAllAppointmentsInDateRange(start, end);
}
public bool SaveEvent(string Title, string NewEventDate, string NewEventTime, string NewEventDuration)
{
return(DiaryEvent.CreateNewEvent(Title, NewEventDate, NewEventTime, NewEventDuration));
}
public void UpdateEvent(int id, string NewEventStart, string NewEventEnd)
{
DiaryEvent.UpdateDiaryEvent(id, NewEventStart, NewEventEnd);
}
/*
* [HttpPost]
* public bool Post(string Title,string NewEventDate,string NewEventTime,string NewEventDuration)
* {
* return DiaryEvent.CreateNewEvent(Title, NewEventDate, NewEventTime, NewEventDuration);
* }*/
public bool Post([FromBody] PostRequestEvent json)
{
return(DiaryEvent.CreateNewEvent(json.Title, json.NewEventDate, json.NewEventTime, json.NeweventMessage, json.NewNameProf, json.NewIdProf));
}
public DiaryEventModel(DiaryEvent model) : base(model)
{
LoadFromModel(model);
}
