public void InsertCard(SheetCard newCard)
{
try
{
ConsultationAccessor.InsertCard(newCard);
}
catch (Exception)
{
throw;
}
}
public void RemoveCard(int sheetID, string cardName)
{
try
{
ConsultationAccessor.RemoveCard(sheetID, cardName);
}
catch (Exception)
{
throw;
}
}
public void CloseCardSheet(ConsultationSheet oldSheet, ConsultationSheet newSheet)
{
try
{
ConsultationAccessor.CloseCardSheet(oldSheet, newSheet);
}
catch (Exception)
{
throw;
}
}
public void UpdateConsultationEntries(ConsultationCard oldC, ConsultationCard newC)
{
try
{
ConsultationAccessor.UpdateConsultationEntries(oldC, newC);
}
catch (Exception)
{
throw;
}
}
public void CreateNewCardSheet(int EmployeeID)
{
try
{
ConsultationAccessor.CreateNewCardSheet(EmployeeID);
}
catch (Exception)
{
throw;
}
}
public void CreateConsultationCard(ConsultationCard newC)
{
try
{
ConsultationAccessor.CreateConsultationCard(newC);
}
catch (Exception)
{
throw;
}
}
public int SelectCountByMethod(int month, string method)
{
try
{
int currentMethodCount = ConsultationAccessor.SelectCountByMethod(month, method);
return(currentMethodCount);
}
catch (Exception)
{
throw;
}
}
public int SelectTotalEntriesBySup(int month, Employee sup)
{
try
{
int SelectTotalEntriesBySup = ConsultationAccessor.SelectTotalEntriesBySup(month, sup);
return(SelectTotalEntriesBySup);
}
catch (Exception)
{
throw;
}
}
public int SelectCurrentCardSheetCount(int sheetID)
{
try
{
int currentCardCount = ConsultationAccessor.SelectCurrentSheetCardCount(sheetID);
return(currentCardCount);
}
catch (Exception)
{
throw;
}
}
public int SelectTotalEntriesByDepartment(int month, string department)
{
try
{
int SelectTotalEntriesByDepartment = ConsultationAccessor.SelectTotalEntriesByDepartment(month, department);
return(SelectTotalEntriesByDepartment);
}
catch (Exception)
{
throw;
}
}
public List <CardMethod> SelectCardMethods()
{
try
{
List <CardMethod> currentMethods = ConsultationAccessor.SelectCardMethods();
return(currentMethods);
}
catch (Exception)
{
throw;
}
}
public ConsultationSheet SelectCurrentConsultationSheet(int employeeID)
{
try
{
ConsultationSheet currentConsultationSheet = ConsultationAccessor.SelectCurrentConsultationSheet(employeeID);
return(currentConsultationSheet);
}
catch (Exception)
{
throw;
}
}
public ConsultationCard FindCard(int employeeID)
{
try
{
var cardToFind = ConsultationAccessor.SelectCard(employeeID);
return(cardToFind);
}
catch (ApplicationException)
{
throw;
}
catch (Exception ex)
{
throw new ApplicationException("There was a problem accessing the database.", ex);
}
}
public NameValueCollection SelectTotalEntriesByDept(int month)
{
NameValueCollection sheetList = ConsultationAccessor.SelectTotalEntriesByDept(month);
return(sheetList);
}
public List <ConsultationSheet> SelectConsultationSheetDates(int month)
{
List <ConsultationSheet> sheetList = ConsultationAccessor.SelectConsultationSheetDates(month);
return(sheetList);
}
public List <string> SelectLeastTargetedCards(int month)
{
List <string> cardList = ConsultationAccessor.SelectLeastTargetedCards(month);
return(cardList);
}
public string SelectLeastAwardedCard(int month)
{
string cardName = ConsultationAccessor.SelectLeastAwardedCard(month);
return(cardName);
}
