public bool DeleteEvent(IEventModel model)
{
var connectionString = defaultConnection + $"database={databaseName};";
var connection = new SqlConnection(connectionString);
return(eventService.Delete(connection, model));
}
private void UserPageUI_OnDeleteEvent(IEventModel eventModel, IUserModel userModel)
{
var userId = userModel.Id;
var invitation = eventModel.Invitation;
var invitationTable = service.GetInvitationsByCode(invitation);
if (service.DeleteEvent(eventModel))
{
foreach (DataRow row in invitationTable.Rows)
{
var id = Convert.ToInt32(row[0].ToString());
var gID = Convert.ToInt32(row[4].ToString());
var invitationModel = new InvitationModel()
{
Id = id,
UserId = userId,
Invitation = invitation,
Date = eventModel.Date,
GuestId = gID
};
service.DeleteInvitation(invitationModel);
}
}
UpdateTables(userId);
}
public void SaveTest()
{
string firstDescription = "Ivanovo station. 5 min.";
string changedDescription = "Ivanovo station. 10 min.";
string changedName = "Ivanovo3";
IEventModel dataModel = new EventModel(23523, "Ivanovo", DateTime.Now, firstDescription);
IItemModel <IEventModel> model = new ItemModel <IEventModel>(dataModel);
IEventModel dataModelFromUpdate = null;
model.Updated += (sender, e) =>
{
dataModelFromUpdate = e.Item.DataModel;
};
EventModel saveDataModel = new EventModel(23523, changedName, DateTime.Now, changedDescription);
IItemModel <IEventModel> saveModel = new ItemModel <IEventModel>(saveDataModel);
model.Save(saveModel);
Assert.IsTrue(dataModelFromUpdate.Name == changedName);
Assert.IsTrue(dataModelFromUpdate.Description == changedDescription);
Assert.IsTrue(model.DataModel.Name == changedName);
Assert.IsTrue(model.DataModel.Description == changedDescription);
}
private void UserPageUI_OnCreateEvent(IEventModel eventModel, IUserModel userModel)
{
var userId = userModel.Id;
var eventList = service.GetEvents(userId);
var invitation = 10000 * userId + eventList.Rows.Count;
var date = eventModel.Date;
eventModel.Invitation = invitation;
if (service.GetEventsByDate(eventModel.Date).Rows.Count > 0)
{
MessageBox.Show("There is already an event on this day!");
}
else
{
if (service.CreateEvent(eventModel))
{
foreach (var guest in eventModel.Guests)
{
var invitationModel = new InvitationModel()
{
UserId = userId,
Invitation = invitation,
Date = date,
GuestId = guest
};
service.CreateInvitation(invitationModel);
}
UpdateTables(userId);
}
}
}
public bool Update(SqlConnection connection, IEventModel model)
{
var id = model.Id;
var userId = model.UserId;
var description = model.Description;
var date = model.Date;
var location = model.Location;
var exclusive = model.IsExclusive ? 1 : 0;
var invitation = model.Invitation;
if (id != 0)
{
var cmdText = $"UPDATE {TableName} SET USERID=@userId, DESCRIPTION=@description, DATE=@date, LOCATION=@location, EXCLUSIVE=@exclusive, INVITATION=@invitation WHERE ID=@id";
var myCommand = new SqlCommand(cmdText, connection);
connection.Open();
myCommand.Parameters.AddWithValue("@id", id);
myCommand.Parameters.AddWithValue("@userId", userId);
myCommand.Parameters.AddWithValue("@description", description);
myCommand.Parameters.AddWithValue("@date", date);
myCommand.Parameters.AddWithValue("@location", location);
myCommand.Parameters.AddWithValue("@exclusive", exclusive);
myCommand.Parameters.AddWithValue("@invitation", invitation);
myCommand.ExecuteNonQuery();
connection.Close();
return(true);
}
else
{
return(false);
}
}
public void AddSubscriber(IEventModel subscriber)
{
if (!this.subscriperMap.ContainsKey(subscriber.SubscriberName))
{
this.subscriperMap.Add(subscriber.SubscriberName, subscriber);
}
}
public void Save(IEventModel saveDataModel)
{
Id = saveDataModel.Id;
Name = saveDataModel.Name;
Time = saveDataModel.Time;
Description = saveDataModel.Description;
SubProcess = saveDataModel.SubProcess;
}
public DetailEventViewModel(IEventModel model, EventViewModelCreator creator = null,
EventModelAdapterCreator eventModelCreator = null)
{
_model = model;
if (_model.SubProcess != null)
{
SubProcess = new ProcessViewModel(_model.SubProcess, creator, eventModelCreator);
}
}
private string GetWorkflowNotificationMessages(ServiceBusMessage result)
{
IEventModel <WorkflowNotification> @event = result.Content as IEventModel <WorkflowNotification>;
if (@event != null && @event.ContentType != null && @event.ContentType.ContentTypeValue != null)
{
return(@event.ContentType.ContentTypeValue.Description);
}
return(string.Empty);
}
public void Init()
{
firstDescription = "Ivanovo station. 5 min.";
dataModel = new EventModel(23523, "Ivanovo", DateTime.Now, firstDescription);
model = new ItemModelAdapterForPassive <IEventModel>(dataModel);
var viewModelCreator = new EventDataDetailViewModelCreator();
var itemModelCreator = new EventModelAdapterCreator();
viewModel = new DetailItemViewModel <IEventModel, IDetailEventViewModel>(model, viewModelCreator, itemModelCreator);
}
private void SendMessageToAllSubscribers(VSEvents e, object state)
{
bool shouldCallNextProcedure = true;
foreach (KeyValuePair <String, IEventModel> pair in this.subscriperMap)
{
IEventModel model = pair.Value;
model.EventMessageProcedure(e, state, out shouldCallNextProcedure);
if (!shouldCallNextProcedure)
{
break;
}
}
}
private void ThrowIfThereIsHole(IEventModel @event, Guid aggregateId)
{
var record = GetRecord(aggregateId);
if (record == null)
{
return; //record is not created yet!
}
if (@event.Version - 1 - record.Version != 0)
{
throw new Exception("Error: An event with un-expected version is arrived. " +
$"Expected version: {record.Version + 1}, Event version: {@event.Version}");
}
}
public bool Delete(SqlConnection connection, IEventModel model)
{
var id = model.Id;
if (id != 0)
{
var cmdText = $"DELETE {TableName} WHERE ID=@id";
var myCommand = new SqlCommand(cmdText, connection);
connection.Open();
myCommand.Parameters.AddWithValue("@id", id);
myCommand.ExecuteNonQuery();
connection.Close();
return(true);
}
else
{
return(false);
}
}
public static void Load(this IEventModel @this, ICodeTextWriter writer, SourceBuilder builder, IEventSymbol @event, ScopeInfo scope, IEnumerable <IMemberInfo> references)
{
{
SourceBuilder builder2 = builder.AppendNewBuilder(false);
writer.WriteIdentifier(builder2, @event);
@this.Name = builder2.ToString();
}
{
SourceBuilder builder2 = builder.AppendNewBuilder(false);
writer.WriteTypeReference(builder2, @event.Type, scope);
@this.Type = builder2.ToString();
}
foreach (IMemberInfo reference in references)
{
SourceBuilder builder2 = builder.AppendNewBuilder(false);
writer.WriteMemberReference(builder2, reference, scope, false, false);
builder2.Append('.');
writer.WriteIdentifier(builder2, @event);
@this.Expressions.Add(builder2.ToString());
}
}
public IEventModel GetEvent(string moduleName, string eventName)
{
#region Variables
IEventModel findEvent = null;
#endregion Variables
#region Action Body
findEvent = _events.FirstOrDefault(i => i.EventInfo.ModuleName == moduleName && i.EventInfo.EventName == eventName);
#endregion Action Body
#region Clear Memory
moduleName = null;
eventName = null;
#endregion Clear Memory
return(findEvent ?? new EventModel());
}
public bool Create(SqlConnection connection, IEventModel model)
{
var userId = model.UserId;
var description = model.Description;
var date = model.Date;
var location = model.Location;
var exclusive = model.IsExclusive ? 1 : 0;
var invitation = model.Invitation;
var cmdText = $"INSERT INTO {TableName} (USERID, DESCRIPTION, DATE, LOCATION, EXCLUSIVE, INVITATION) VALUES (@userId, @description, @date, @location, @exclusive, @invitation)";
var myCommand = new SqlCommand(cmdText, connection);
connection.Open();
myCommand.Parameters.AddWithValue("@userId", userId);
myCommand.Parameters.AddWithValue("@description", description);
myCommand.Parameters.AddWithValue("@date", date);
myCommand.Parameters.AddWithValue("@location", location);
myCommand.Parameters.AddWithValue("@exclusive", exclusive);
myCommand.Parameters.AddWithValue("@invitation", invitation);
myCommand.ExecuteNonQuery();
connection.Close();
return(true);
}
public void ApplyEvent(IEventModel @event)
{
Mutate(@event);
_eventList.Add(@event);
}
public EventTimerViewModel(IEventModel eventModel)
{
EventModel = eventModel;
}
public void Save(IEventModel saveDataModel)
{
}
public bool CreateEvent(IEventModel model) => sqlService.CreateEvent(model);
public bool UpdateEvent(IEventModel model) => sqlService.UpdateEvent(model);
public bool DeleteEvent(IEventModel model) => sqlService.DeleteEvent(model);
private void UserPageUI_OnUpdateEvent(IEventModel eventModel, IUserModel userModel)
{
var userId = userModel.Id;
var hasEventOnThisDay = false;
var invitation = eventModel.Invitation;
var eventsTable = service.GetEventsByDate(eventModel.Date);
foreach (DataRow row in eventsTable.Rows)
{
var date = row[3].ToString();
var invt = row[6].ToString();
if (Convert.ToDateTime(date) == eventModel.Date &&
Convert.ToInt32(invt) != eventModel.Invitation)
{
hasEventOnThisDay = true;
}
}
if (hasEventOnThisDay)
{
MessageBox.Show("There is already an event on this day!");
}
else
{
var invitationTable = service.GetInvitationsByCode(invitation);
if (service.UpdateEvent(eventModel))
{
foreach (DataRow row in invitationTable.Rows)
{
var id = Convert.ToInt32(row[0].ToString());
var gID = Convert.ToInt32(row[4].ToString());
if (!eventModel.Guests.Contains(gID))
{
var invitationModel = new InvitationModel()
{
Id = id,
UserId = userId,
Invitation = invitation,
Date = eventModel.Date,
GuestId = gID
};
service.DeleteInvitation(invitationModel);
}
}
foreach (var guest in eventModel.Guests)
{
if (invitationTable.Select("guestid = " + guest).Length == 0)
{
// CREATE
var invitationModel = new InvitationModel()
{
UserId = userId,
Invitation = invitation,
Date = eventModel.Date,
GuestId = guest
};
service.CreateInvitation(invitationModel);
}
}
}
UpdateTables(userId);
}
}
private void Mutate(IEventModel @event)
{
((dynamic)this).On((dynamic)@event);
}
public EventViewModel(IEventModel model)
{
_model = model;
}
public EventViewModel(IEventModel eventModel)
{
EventModel = eventModel;
}
public override IDetailEventViewModel CreateDataDetailViewModel(IEventModel dataModel)
{
return(new DetailEventViewModel(dataModel));
}
public override IDetailEventViewModel CreateDataDetailViewModel(IEventModel dataModel)
{
var stationCreator = new ViewModelStationEventCreator();
return(new DetailEventViewModel(dataModel, stationCreator, new StationEventModelAdapterCreator()));
}
