public CustomAppointmentForm(SchedulerControl control, Appointment apt, Event ev)
{
Event = ev;
InitializeComponent();
Controller = new EventAppointmentFormController(control, apt);
}
private void GetDataFromForm()
{
if (Event == null) Event = new Event { EventId = Guid.NewGuid() };
Event.Name = EventName.EditValue as string;
Event.Description = EventDescription.EditValue as string;
Event.Type = EventTypeReference.GetTypeByReference(EventType.EditValue as string);
int personNumber;
Int32.TryParse(EventPersonNumber.EditValue.ToString(), out personNumber);
Event.PersonNumber = personNumber;
Event.ManagerPersonId = EventManager.EditValue == null ? Guid.Empty : (Guid)EventManager.EditValue;
Event.ContactPersonId = EventContactPerson.EditValue == null ? Guid.Empty : (Guid)EventContactPerson.EditValue;
Event.OrganizationId = EventOrganization.EditValue == null ? Guid.Empty : (Guid)EventOrganization.EditValue;
Event.RegistrationDate = RegistrationDateEdit.EditValue == null
? DateTime.Now
: (DateTime) RegistrationDateEdit.EditValue;
Event.ExitDate = ExitDateEdit.EditValue == null
? DateTime.Now
: (DateTime)ExitDateEdit.EditValue;
}
public void UpdateEvent(Event ev)
{
if (ev == null) return;
using (IDbConnection connection = CreateConnection())
{
IDbCommand command = connection.CreateCommand();
#region sql statement
command.CommandText = @"
IF EXISTS(SELECT TOP 1 * FROM [dbo].[event] WHERE [event_id] = @event_id)
UPDATE [dbo].[event]
SET [contact_person_id] = @contact_person_id
,[manager_person_id] = @manager_person_id
,[name] = @name
,[type] = @type
,[person_number] = @person_number
,[review] = @review
,[price_cash] = @price_cash
,[price_non_cash] = @price_non_cash
,[loss] = @loss
,[description] = @description
,[state] = @state
,[registration_date] = @registration_date
,[exit_date] = @exit_date
,[organization_id] = @organization_id
WHERE [event_id] = @event_id
ELSE
INSERT INTO [dbo].[event]
([event_id] ,[contact_person_id] ,[manager_person_id] ,[name]
,[type] ,[person_number] ,[review] ,[price_cash],[price_non_cash]
,[loss] ,[description] ,[state] ,[organization_id],[registration_date],[exit_date])
VALUES
(@event_id ,@contact_person_id ,@manager_person_id ,@name
,@type ,@person_number ,@review ,@price_cash, @price_non_cash
,@loss ,@description ,@state , @organization_id,@registration_date,@exit_date)
";
#endregion
addParameter(command, "@event_id", ev.EventId);
addParameter(command, "@contact_person_id", ev.ContactPersonId == Guid.Empty ? null : (object)ev.ContactPersonId);
addParameter(command, "@manager_person_id", ev.ManagerPersonId == Guid.Empty ? null : (object)ev.ManagerPersonId);
addParameter(command, "@organization_id", ev.OrganizationId == Guid.Empty ? null : (object)ev.OrganizationId);
addParameter(command, "@person_number", ev.PersonNumber);
addParameter(command, "@review", ev.Review);
addParameter(command, "@price_cash", ev.CashPrice);
addParameter(command, "@price_non_cash", ev.NonCashPrice);
addParameter(command, "@loss", ev.Loss);
addParameter(command, "@type", ev.Type);
addParameter(command, "@name", ev.Name);
addParameter(command, "@state", ev.State);
addParameter(command, "@registration_date", ev.RegistrationDate);
addParameter(command, "@exit_date", ev.ExitDate);
addParameter(command, "@description", ev.Description);
command.ExecuteNonQuery();
}
}
public EventUpdatedEventArgs(Event ev)
{
Event = ev;
}
public EventChangedEventArgs(Event ev)
: base(ev)
{
}