public string SelectEventTableWithConstrain(string jsonValue)
{
IEventTableModal eventtable = Serializer.GetDeserialized<EventTableModal>(jsonValue);
EventAccessLayer al = new EventAccessLayer(eventtable);
EventCollection result = al.SelectEventsWithConstrain(Constants.SP_SelectEventsConstrain);
return Serializer.GetSerialized<EventCollection>(result);
}
public string DeleteEventTable(string jsonValue)
{
IEventTableModal modal = Serializer.GetDeserialized<EventTableModal>(jsonValue);
EventAccessLayer al = new EventAccessLayer(modal);
bool result=al.DeleteEvent(Constants.SP_DeleteEventTable);
return result.ToString();
}
public string InsertEventTable(string jsonValue, string loginValues)
{
EventTableModal modal = Serializer.GetDeserialized<EventTableModal>(jsonValue);
ILoginTableModal lTable = Serializer.GetDeserialized<LoginTableModal>(loginValues);
modal.UpdateModal.CreatedById = modal.UpdateModal.LastModifiedId= lTable.Id;
modal.UpdateModal.CreatedTime = modal.UpdateModal.LastModifiedTime= DateTime.Now;
EventAccessLayer al = new EventAccessLayer(modal);
int output = al.InsertEvents(Constants.SP_InsertEventTable);
return Serializer.GetSerialized<int>(output);
}
public string SelectEventTable()
{
EventAccessLayer al = new EventAccessLayer();
EventCollection output = al.SelectEvents(Constants.SP_SelectEventTable);
return Serializer.GetSerialized<EventCollection>(output);
}
