public List <Entity.Event> GetAllEvent()
{
List <Entity.Event> eventResultList = new List <Entity.Event>();
IDbConnection connection = new SqlConnection(connectionString);
try
{
connection.Open();
IDbCommand command = connection.CreateCommand();
command.CommandText = @"SELECT * FROM Events";
IDataReader reader = command.ExecuteReader();
using (reader)
{
while (reader.Read())
{
Entity.Event myEvent = new Entity.Event();
myEvent.id = (int)reader["Id"];
myEvent.name = (string)reader["Name"];
myEvent.location = (string)reader["Location"];
myEvent.beginningDate = reader["BeginningDate"].ToString();
myEvent.endDate = reader["EndDate"].ToString();
eventResultList.Add(myEvent);
}
}
}
finally
{
connection.Close();
}
return(eventResultList);
}
public void AddEvent(string name, string location, string beginningDate, string endDate)
{
Repository.EventRepository repository = new Repository.EventRepository();
Entity.Event myEvent = new Entity.Event();
myEvent.name = name;
myEvent.location = location;
myEvent.beginningDate = beginningDate;
myEvent.endDate = endDate;
repository.Insert(myEvent);
}
public void UpdateEvent(int id, string name, string location, string beginningDate, string endDate)
{
Repository.EventRepository repository = new Repository.EventRepository();
Entity.Event myEvent = new Entity.Event
{
id = id,
name = name,
location = location,
beginningDate = beginningDate,
endDate = endDate
};
repository.Update(myEvent);
}
public async Task <ActionResult> Edit(int id, Entity.Event Event)
{
try
{
// TODO: Add update logic here
var Events = await _serviceContext.UpdateEventAsync(id, Event);
return(RedirectToAction(nameof(Index)));
}
catch
{
return(View());
}
}
public void Update(Entity.Event myEvent)
{
IDbConnection connection = new SqlConnection(connectionString);
IDbCommand command = connection.CreateCommand();
command.CommandText = @"UPDATE Events SET Name=@name, Location=@location, BeginningDate=@beginningDate, EndDate=@endDate WHERE Id=@id";
IDataParameter parameter = command.CreateParameter();
parameter.ParameterName = "@name";
parameter.Value = myEvent.name;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@location";
parameter.Value = myEvent.location;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@beginningDate";
parameter.Value = myEvent.beginningDate;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@endDate";
parameter.Value = myEvent.endDate;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@id";
parameter.Value = myEvent.id;
command.Parameters.Add(parameter);
try
{
connection.Open();
command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
public virtual List <Entity.Event> GetEventByFormName(string FormName)
{
List <Entity.Event> lstEvent = new List <Entity.Event>();
SqlCommand cmdSelect = new SqlCommand();
cmdSelect.CommandType = CommandType.StoredProcedure;
cmdSelect.CommandText = "GetEventByFormName";
cmdSelect.Parameters.AddWithValue("@FormName", FormName);
SqlDataReader dr = this.ExecuteDataReader(cmdSelect);
while (dr.Read())
{
Entity.Event objEvent = new Entity.Event();
lstEvent.Add(objEvent);
this.FillEntityEvent(dr, objEvent, 0);
}
base.ForceCloseConnection(cmdSelect);
return(lstEvent);
}
//public EventRepository(string connectionString)
//{
// this.connectionString = connectionString;
//}
public void Insert(Entity.Event myEvent)
{
IDbConnection connection = new SqlConnection(connectionString);
IDbCommand command = connection.CreateCommand();
command.CommandText = @"INSERT INTO Events(Name, Location,BeginningDate,EndDate)
VALUES(@name, @location,@beginningDate,@endDate)";
IDataParameter parameter = command.CreateParameter();
parameter.ParameterName = "@name";
parameter.Value = myEvent.name;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@location";
parameter.Value = myEvent.location;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@beginningDate";
parameter.Value = myEvent.beginningDate;
command.Parameters.Add(parameter);
parameter = command.CreateParameter();
parameter.ParameterName = "@endDate";
parameter.Value = myEvent.endDate;
command.Parameters.Add(parameter);
try
{
connection.Open();
command.ExecuteNonQuery();
}
finally
{
connection.Close();
}
}
private Client.Entity.CustomEvent ConvertEventToExternal(string externalCaseId, Entity.Event eventEntity)
{
return(new Client.Entity.CustomEvent
{
CaseId = externalCaseId,
Name = eventEntity.Activity,
Text = eventEntity.Comment,
DatetimeDatetime = eventEntity.Datetime,
CustomProperties = new Dictionary <string, string>()
{
{ "radioName", eventEntity.RadioName },
{ "dispatcherInit", eventEntity.DispatcherInit },
}
});
}
protected void FillEntityEvent(IDataReader dr, Entity.Event objEvent, int Type)
{
objEvent.EventId = GetFieldInt(dr, "EventId");
objEvent.EventName = GetField(dr, "EventName");
}
