/// <summary>
/// Search for tickets by employee
/// </summary>
/// <param name="empT">An EmpTick parameter</param>
/// <returns></returns>
public List<EmpTick> SearchEmpTicks(EmpTick empT)
{
SqlConnection corpcn = new SqlConnection(Settings.Default.cnHelpDesk);
var sb = new StringBuilder();
sb.Append("Select EmpID, TickID ");
sb.Append("From EmpTick ");
sb.Append("Where EmpID ='").Append(empT.EmpID).Append("';");
using (corpcn)
{
List<EmpTick> empTicks = new List<EmpTick>();
SqlCommand corpCmd = corpcn.CreateCommand();
corpCmd.CommandType = CommandType.Text;
corpCmd.CommandText = sb.ToString();
corpcn.Open();
SqlDataReader corprdr = corpCmd.ExecuteReader();
while (corprdr.Read())
{
EmpTick empTick = CreateEmpTick(corprdr);
empTicks.Add(empTick);
}
corprdr.Close();
return empTicks;
}
}
/// <summary>
/// Add a EmpTick
/// </summary>
/// <param name="emp">An EmpTick parameter</param>
public void InsertEmpTick(EmpTick emp)
{
SqlConnection corpcn = new SqlConnection(Settings.Default.cnHelpDesk);
var sb = new StringBuilder();
sb.Append("Insert Into [EmpTick]");
sb.Append(" ([EmpID], [TickID])");
sb.Append(" Values (");
sb.Append("'").Append(emp.EmpID).Append("',");
sb.Append("'").Append(emp.TickID).Append("');");
using (corpcn)
{
SqlCommand corpCmd = corpcn.CreateCommand();
corpCmd.CommandType = CommandType.Text;
corpCmd.CommandText = sb.ToString();
corpcn.Open();
corpCmd.ExecuteNonQuery();
}
}
public int SearchForEmp(int tickID)
{
int employeeID = 0;
ListEmpTicks();
EmpTick e1 = new EmpTick();
foreach (EmpTick empT in etsList)
{
if (empT.TickID == tickID)
{
employeeID = empT.EmpID;
}
}
//Returns the list of Tickets
return employeeID;
}
/// <summary>
/// Searchs for a list of tickets by employee
/// </summary>
/// <param name="empID">Employee ID</param>
/// <returns></returns>
public List<int> SearchEmpTicks(int empID)
{
ListEmpTicks();
List<int> empTickList = new List<int>();
EmpTick e1 = new EmpTick();
foreach (EmpTick empT in etsList)
{
if (empT.EmpID == empID)
{
empTickList.Add(empT.TickID);
}
}
//Returns the list of Tickets
return empTickList;
}
private EmpTick CreateEmpTick(SqlDataReader dr)
{
var e = new EmpTick();
e.EmpID = (int)dr["EmpID"];
e.TickID = (int)dr["TickID"];
return e;
}
