private List <EventModel> followingMonthReport()
{
List <EventModel> followinWeekEvent = new List <EventModel>();
EventModelManager eventModelManager = new EventModelManager();
return(followinWeekEvent = eventModelManager.getFollowingMonthEvents(loggedInUser.Id));
}
private void getFollowingSevenDayEvents()
{
EventModelManager eventModelManager = new EventModelManager();
EventSummaryViewController eventSummaryView = new EventSummaryViewController();
followinWeekEvent = eventModelManager.getFollowingWeekEvents(loggedInUser.Id);
//int quantity = contactModelsList.Count;
int i = 0;
foreach (EventModel eventModel in followinWeekEvent)
{
EventSummaryViewController ecc = new EventSummaryViewController();
// uc.Size = new Size(100, 20);
ecc.Location = new Point(200, 200 + (i * 20));
ecc.lblDate.Text = eventModel.Event_begin_time.Day.ToString();
ecc.lblFullDate.Text = eventModel.Event_begin_time.Date.ToString();
ecc.lblTime.Text = eventModel.Event_begin_time.TimeOfDay.ToString() + " TO " + eventModel.Event_end_time.TimeOfDay.ToString();
ecc.lblTitle.Text = eventModel.Event_title;
ecc.lblDescription.Text = eventModel.Event_description;
// cdc.btnDelete.Click += button_action_delete;
this.flowLayoutPanel1.Controls.Add(ecc);
i++;
}
}
private Boolean dateValidationStatusUpdate(DateTime start_date_time, DateTime end_date_time)
{
EventModelManager eventModelManager = new EventModelManager();
List <EventModel> eventModelsList = eventModelManager.getAllEvents(loggedInUser.Id);
DateTime beginTime = new DateTime();
DateTime endTime = new DateTime();
Boolean checkBeginTime = false;
Boolean checkEndTime = false;
foreach (EventModel eventModel in eventModelsList)
{
if (editableEvent.Event_id != eventModel.Event_id)
{
if (start_date_time >= eventModel.Event_begin_time && end_date_time < eventModel.Event_end_time)
{
beginTime = eventModel.Event_begin_time;
endTime = eventModel.Event_end_time;
checkBeginTime = true;
break;
}
else
{
checkBeginTime = false;
if (end_date_time >= eventModel.Event_begin_time && end_date_time < eventModel.Event_end_time)
{
beginTime = eventModel.Event_begin_time;
endTime = eventModel.Event_end_time;
checkEndTime = true;
break;
}
else
{
checkEndTime = false;
}
}
}
}
if (!checkBeginTime && !checkEndTime)
{
return(true);
}
else
{
MessageBox.Show("There is already have event for you from " + start_date_time.ToString() + " to " + endTime.ToString() +
". Choose another time slot!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
/// <summary>
/// ModelsCompositeからEventModelManagerを作る
/// </summary>
/// <returns>生成されたEventModelManager</returns>
public static EventModelManager Generate()
{
EventModelManager manager = new EventModelManager();
foreach (var model in ModelsComposite.StoryFrameModelManager.ModelCollection)
{
manager.Add(GenerateEventModel(model as StoryFrameModel));
}
foreach (var model in ModelsComposite.TimelineEventModelManager.ModelCollection)
{
manager.Add(GenerateEventModel(model));
}
return(manager);
}
private void button_action_delete_event(object sender, EventArgs e)
{
if (sender is Button)
{
Button temp = (Button)sender;
// FlowLayoutPanel flowLayout = (FlowLayoutPanel)temp.Parent;
TableLayoutPanel tableLayoutPanel = (TableLayoutPanel)temp.Parent;
// MessageBox.Show(sender.ToString());
EventDisplayController eventDisplayController = (EventDisplayController)tableLayoutPanel.Parent;
string event_id = eventDisplayController.id;
int userId = loggedInUser.Id;
//MessageBox.Show(name + email + mobileNo);
if (MessageBox.Show("Do you wish to delete Contact ", "Delete Eevent",
MessageBoxButtons.YesNo, MessageBoxIcon.Question,
MessageBoxDefaultButton.Button1) == System.Windows.Forms.DialogResult.Yes)
{
EventModelManager eventModelManager = new EventModelManager();
Boolean deleteStatus = eventModelManager.deleteEvent(event_id, userId);
if (deleteStatus)
{
MessageBox.Show("Successfully deleted Event");
EventView eventView = new EventView(loggedInUser, false);
this.Hide();
eventView.ShowDialog();
this.Close();
}
else
{
MessageBox.Show("Db error");
}
}
}
}
public abstract void GenerateEvents(System.Windows.Controls.Canvas canvas, EventModelManager eventManager);
private void button_action_create(object sender, EventArgs e)
{
if (sender is Button)
{
Button temp = (Button)sender;
// FlowLayoutPanel flowLayout = (FlowLayoutPanel)temp.Parent;
TableLayoutPanel tableLayoutPanel = (TableLayoutPanel)temp.Parent;
TableLayoutPanel tableLayoutPanel1 = (TableLayoutPanel)tableLayoutPanel.Parent;
EventFormController eventFormController = (EventFormController)tableLayoutPanel1.Parent;
// MessageBox.Show(sender.ToString());
if (eventFormController.validation)
{
//data retrive
//Console.WriteLine("aa");
EventModel eventModel = new EventModel();
EventModelManager em = new EventModelManager();
int recuringId = em.getEventLatestId();
//int recId = eventModel.getEventId() + 1;
string title = eventFormController.event_title;
string description = eventFormController.event_description;
string location = eventFormController.event_location;
DateTime begin_time = eventFormController.start_time;
DateTime end_Time = eventFormController.end_time;
string event_type = "";
if (eventFormController.event_vareity == "a")
{
event_type = EventVareityEnum.Appointment.ToString();
}
if (eventFormController.event_vareity == "b")
{
event_type = EventVareityEnum.Task.ToString();
}
int userId = loggedInUser.Id;
int recuring_vareity = eventFormController.recuring_vareity;
int recurring_time = eventFormController.recur_freq;
List <string> pickedContactNames = eventFormController.contact_list;
/////////////
Boolean addEventStatus = false;
//daily
if (recuring_vareity == 2)
{
for (int i = 0; i < recurring_time; i++)
{
List <ContactModel> pickedContactsList = new List <ContactModel>();
Console.WriteLine("daily");
Console.WriteLine("event vareity=" + event_type + " recuring Vareity=" + recuring_vareity);
foreach (string contactName in pickedContactNames)
{
Console.WriteLine(contactName);
foreach (ContactModel contact in this.contactModelsDatalist)
{
if (contactName == contact.ContactName)
{
ContactModel contactTemp = new ContactModel();
contactTemp = contact;
pickedContactsList.Add(contactTemp);
}
}
}
/////////////call modelmanager methode
EventModel eventModel1 = new EventModel();
eventModel1.Event_title = title;
eventModel1.Event_description = description;
eventModel1.Event_begin_time = begin_time.AddDays(i);
eventModel1.Event_end_time = end_Time.AddDays(i);
eventModel1.Event_location = location;
eventModel1.Event_variety = event_type;
eventModel1.Event_recuring_variety = recuring_vareity;
eventModel1.UserId = loggedInUser.Id;
EventModelManager eventModelManager = new EventModelManager();
addEventStatus = eventModelManager.addevent(eventModel1, pickedContactsList, recuringId);
}
}
//weekly
if (recuring_vareity == 3)
{
for (int i = 0; i < recurring_time; i++)
{
List <ContactModel> pickedContactsList = new List <ContactModel>();
Console.WriteLine("event vareity=" + recuring_vareity + " recuring Vareity=" + recurring_time);
foreach (string contactName in pickedContactNames)
{
Console.WriteLine(contactName);
foreach (ContactModel contact in this.contactModelsDatalist)
{
if (contactName == contact.ContactName)
{
ContactModel contactTemp = new ContactModel();
contactTemp = contact;
pickedContactsList.Add(contactTemp);
}
}
}
/////////////call modelmanager methode
EventModel eventModel2 = new EventModel();
eventModel2.Event_title = title;
eventModel2.Event_description = description;
eventModel2.Event_begin_time = begin_time.AddDays(7 * i);
eventModel2.Event_end_time = end_Time.AddDays(7 * i);
eventModel2.Event_location = location;
eventModel2.Event_variety = event_type;
eventModel2.Event_recuring_variety = recuring_vareity;
eventModel2.UserId = loggedInUser.Id;
EventModelManager eventModelManager = new EventModelManager();
addEventStatus = eventModelManager.addevent(eventModel2, pickedContactsList, recuringId);
}
}
if (recuring_vareity == 1)
{
List <ContactModel> pickedContactsList = new List <ContactModel>();
Console.WriteLine("event vareity=" + recuring_vareity + " recuring Vareity=" + recuring_vareity);
foreach (string contactName in pickedContactNames)
{
Console.WriteLine(contactName);
foreach (ContactModel contact in this.contactModelsDatalist)
{
if (contactName == contact.ContactName)
{
ContactModel contactTemp = new ContactModel();
contactTemp = contact;
pickedContactsList.Add(contactTemp);
}
}
}
/////////////call modelmanager methode
/////////////call modelmanager methode
EventModel eventModel3 = new EventModel();
eventModel3.Event_title = title;
eventModel3.Event_description = description;
eventModel3.Event_begin_time = begin_time;
eventModel3.Event_end_time = end_Time;
eventModel3.Event_location = location;
eventModel3.Event_variety = event_type;
eventModel3.Event_recuring_variety = recuring_vareity;
eventModel3.UserId = loggedInUser.Id;
EventModelManager eventModelManager = new EventModelManager();
addEventStatus = eventModelManager.addevent(eventModel3, pickedContactsList, 0);
}
if (addEventStatus)
{
MessageBox.Show("Successfully Addes Event");
eventFormController.Hide();
}
else
{
MessageBox.Show("Database Error");
}
}
else
{
MessageBox.Show("Validation Error");
}
}
}
private void ShowEvents()
{
EventModelManager eventModelManager = new EventModelManager();
EventModelsList = eventModelManager.getAllEvents(loggedInUser.Id);
//int quantity = contactModelsList.Count;
int i = 0;
foreach (EventModel eventModel in EventModelsList)
{
ContactModelManager contactModelManager = new ContactModelManager();
List <string> contactsData = contactModelManager.getContactListwithNumber(eventModel.Event_id);
EventDisplayController edc = new EventDisplayController();
// uc.Size = new Size(100, 20);
edc.Location = new Point(200, 200 + (i * 20));
string contact = "";
foreach (string data in contactsData)
{
contact += data + ", ";
}
edc.lblContact.Text = contact;
edc.lblTitle.Text = eventModel.Event_title;
edc.lblDescription.Text = eventModel.Event_description;
edc.lblVareity.Text = eventModel.Event_variety;
edc.lblDateStart.Text = Convert.ToString(eventModel.Event_begin_time);
edc.lblDateEnd.Text = Convert.ToString(eventModel.Event_end_time);
edc.lblLocation.Text = eventModel.Event_location;
edc.lblId.Text = Convert.ToString(eventModel.Event_id);
edc.lblRecurVareity.Text = Convert.ToString(eventModel.Event_recuring_variety);
if (eventModel.Event_recuring_variety == 1)
{
edc.lblRecuringType.Text = "Once";
}
else if (eventModel.Event_recuring_variety == 2)
{
edc.lblRecuringType.Text = "Daily";
}
else if (eventModel.Event_recuring_variety == 3)
{
edc.lblRecuringType.Text = "Weekly";
}
edc.btnEditEvent.Click += button_action_edit_event;
edc.btnDeleteEvent.Click += button_action_delete_event;
//flowLayoutPanel1.Controls.Add(edc);
//use thread to get ui data
this.flowLayoutPanel1.Invoke((MethodInvoker) delegate
{
// Running on the UI thread
this.flowLayoutPanel1.Controls.Add(edc);
});
i++;
}
}
//private void contactCheckedListBox_Validating(object sender, CancelEventArgs e)
//{
// if (contactCheckedListBox.CheckedIndices.Count == 0)
// {
// errorProvidereventCreate.SetError(contactCheckedListBox, "Pick atleast one contact");
// e.Cancel = true;
// }
// else
// {
// errorProvidereventCreate.SetError(contactCheckedListBox, "");
// }
//}
private void btnUpdateEvent_Click(object sender, EventArgs e)
{
if (ValidateChildren(ValidationConstraints.Enabled))
{
string start_time = this.startTimetxt.Value.ToString("HH:mm");
string start_date = this.startDatetxt.Value.ToString("yyyy-MM-dd");
string end_time = this.endTimetxt.Value.ToString("HH:mm");
string end_date = this.endDatetxt.Value.ToString("yyyy-MM-dd");
DateTime start_date_time = DateTime.Parse(start_date + " " + start_time);
DateTime end_date_time = DateTime.Parse(end_date + " " + end_time);
Boolean isdateValidationStatus = dateValidationStatusUpdate(start_date_time, end_date_time);
if (isdateValidationStatus)
{
ContactModelManager cmm = new ContactModelManager();
Boolean status = cmm.deleteByEventContact(editableEvent.Event_id);
/////////////////initialize data
List <ContactModel> pickedContactsList = new List <ContactModel>();
//int recuring_variety = 1; //default recuring one time
string event_variety = "";//appoinment or task
if (typeAppointment.Checked)
{
event_variety = EventVareityEnum.Appointment.ToString();
}
else if (typeTask.Checked)
{
event_variety = EventVareityEnum.Task.ToString();
}
Console.WriteLine("event vareity=" + event_variety);
foreach (string contactName in contactCheckedListBox.CheckedItems)
{
Console.WriteLine(contactName);
foreach (ContactModel contact in this.contactModelsDatalist)
{
if (contactName == contact.ContactName)
{
ContactModel contactTemp = new ContactModel();
contactTemp = contact;
pickedContactsList.Add(contactTemp);
}
}
}
/////////////call modelmanager methode
EventModel eventModel = new EventModel();
eventModel.Event_title = eventTitletxt.Text;
eventModel.Event_description = eventDescriptiontxt.Text;
eventModel.Event_begin_time = start_date_time;
eventModel.Event_end_time = end_date_time;
eventModel.Event_location = locationtxt.Text;
eventModel.Event_variety = event_variety;
eventModel.UserId = loggedInUser.Id;
eventModel.Event_id = editableEvent.Event_id;
EventModelManager eventModelManager = new EventModelManager();
Boolean addEventStatus = eventModelManager.updateEvent(eventModel, editableEvent, pickedContactsList);
if (addEventStatus)
{
}
else
{
MessageBox.Show("Database Error");
}
}
else
{
MessageBox.Show("Selected time slot already picked select different time slot");
}
}
else
{
MessageBox.Show("Please Fill Required fields");
}
}
private void btnEventCreate_Click(object sender, EventArgs e)
{
//recuring daily=1 weekly=2
//type enumdata
if (ValidateChildren(ValidationConstraints.Enabled))
{
string start_time = this.startTimetxt.Value.ToString("HH:mm");
string start_date = this.startDatetxt.Value.ToString("yyyy-MM-dd");
string end_time = this.endTimetxt.Value.ToString("HH:mm");
string end_date = this.endDatetxt.Value.ToString("yyyy-MM-dd");
DateTime start_date_time = DateTime.Parse(start_date + " " + start_time);
DateTime end_date_time = DateTime.Parse(end_date + " " + end_time);
Boolean isdateValidationStatus = dateValidationStatus(start_date_time, end_date_time);
if (isdateValidationStatus)
{
/////////////////initialize data
EventModelManager em = new EventModelManager();
int recuringId = em.getEventLatestId();
int recuring_variety = 1; //default recuring one time
string event_variety = ""; //appoinment or task
if (typeDaily.Checked)
{
recuring_variety = 2;//daily
}
else if (typeWeekly.Checked)
{
recuring_variety = 3;//weekly
}
else if (typeOnetime.Checked)
{
recuring_variety = 1;//once
}
if (typeAppointment.Checked)
{
event_variety = EventVareityEnum.Appointment.ToString();
}
else if (typeTask.Checked)
{
event_variety = EventVareityEnum.Task.ToString();
}
int recureVal = Convert.ToInt32(recureFreq.Value);
Boolean addEventStatus = false;
//daily
if (recuring_variety == 2)
{
for (int i = 0; i < recureVal; i++)
{
List <ContactModel> pickedContactsList = new List <ContactModel>();
Console.WriteLine("daily");
Console.WriteLine("event vareity=" + event_variety + " recuring Vareity=" + recuring_variety);
foreach (string contactName in contactCheckedListBox.CheckedItems)
{
Console.WriteLine(contactName);
foreach (ContactModel contact in this.contactModelsDatalist)
{
if (contactName == contact.ContactName)
{
ContactModel contactTemp = new ContactModel();
contactTemp = contact;
pickedContactsList.Add(contactTemp);
}
}
}
/////////////call modelmanager methode
EventModel eventModel = new EventModel();
eventModel.Event_title = eventTitletxt.Text;
eventModel.Event_description = eventDescriptiontxt.Text;
eventModel.Event_begin_time = start_date_time.AddDays(i);
eventModel.Event_end_time = end_date_time.AddDays(i);
eventModel.Event_location = locationtxt.Text;
eventModel.Event_variety = event_variety;
eventModel.Event_recuring_variety = recuring_variety;
eventModel.UserId = loggedInUser.Id;
EventModelManager eventModelManager = new EventModelManager();
addEventStatus = eventModelManager.addevent(eventModel, pickedContactsList, recuringId);
}
}
//weekly
if (recuring_variety == 3)
{
for (int i = 0; i < recureVal; i++)
{
List <ContactModel> pickedContactsList = new List <ContactModel>();
Console.WriteLine("event vareity=" + event_variety + " recuring Vareity=" + recuring_variety);
foreach (string contactName in contactCheckedListBox.CheckedItems)
{
Console.WriteLine(contactName);
foreach (ContactModel contact in this.contactModelsDatalist)
{
if (contactName == contact.ContactName)
{
ContactModel contactTemp = new ContactModel();
contactTemp = contact;
pickedContactsList.Add(contactTemp);
}
}
}
/////////////call modelmanager methode
EventModel eventModel = new EventModel();
eventModel.Event_title = eventTitletxt.Text;
eventModel.Event_description = eventDescriptiontxt.Text;
eventModel.Event_begin_time = start_date_time.AddDays(7 * i);
eventModel.Event_end_time = end_date_time.AddDays(7 * i);
eventModel.Event_location = locationtxt.Text;
eventModel.Event_variety = event_variety;
eventModel.Event_recuring_variety = recuring_variety;
eventModel.UserId = loggedInUser.Id;
EventModelManager eventModelManager = new EventModelManager();
addEventStatus = eventModelManager.addevent(eventModel, pickedContactsList, recuringId);
}
}
if (recuring_variety == 1)
{
List <ContactModel> pickedContactsList = new List <ContactModel>();
Console.WriteLine("event vareity=" + event_variety + " recuring Vareity=" + recuring_variety);
foreach (string contactName in contactCheckedListBox.CheckedItems)
{
Console.WriteLine(contactName);
foreach (ContactModel contact in this.contactModelsDatalist)
{
if (contactName == contact.ContactName)
{
ContactModel contactTemp = new ContactModel();
contactTemp = contact;
pickedContactsList.Add(contactTemp);
}
}
}
/////////////call modelmanager methode
EventModel eventModel = new EventModel();
eventModel.Event_title = eventTitletxt.Text;
eventModel.Event_description = eventDescriptiontxt.Text;
eventModel.Event_begin_time = start_date_time;
eventModel.Event_end_time = end_date_time;
eventModel.Event_location = locationtxt.Text;
eventModel.Event_variety = event_variety;
eventModel.Event_recuring_variety = recuring_variety;
eventModel.UserId = loggedInUser.Id;
EventModelManager eventModelManager = new EventModelManager();
addEventStatus = eventModelManager.addevent(eventModel, pickedContactsList, 0);
}
if (addEventStatus)
{
MessageBox.Show("Successfully Addes Event");
}
else
{
MessageBox.Show("Database Error");
}
}
}
else
{
MessageBox.Show("Please Fill Required Fields ");
}
}
