public List <Technicians> GetAllTechnicians(string techId = "")
{
Datahandler dh = Datahandler.getData();
List <Technicians> techs = new List <Technicians>();
DataTable table = new DataTable();
if (techId != "")
{
table = dh.readDataFromDB(DataAccesHelper.QueryGetTechnicians + " WHERE " + DataAccesHelper.techId + " = '" + this.PersonId + "'");
}
else
{
table = dh.readDataFromDB(DataAccesHelper.QueryGetTechnicians);
}
foreach (DataRow item in table.Rows)
{
Technicians t = new Technicians();
t.PersonId = item[DataAccesHelper.techId].ToString();
t.Name = item[DataAccesHelper.techName].ToString();
t.Surname = item[DataAccesHelper.techSurname].ToString();
t.PersonAddress = new Address(item[DataAccesHelper.addressId].ToString(), item[DataAccesHelper.addrLine1].ToString(), item[DataAccesHelper.addrLine2].ToString(), item[DataAccesHelper.addrCity].ToString(), item[DataAccesHelper.addrPostalCode].ToString());
t.PersonContact = new Contact(item[DataAccesHelper.contactId].ToString(), item[DataAccesHelper.contactCell].ToString(), item[DataAccesHelper.contactEmail].ToString());
t.Status = item[DataAccesHelper.techStatus].ToString();
t.SkillLevel = item[DataAccesHelper.techSkill].ToString();
techs.Add(t);
}
return(techs);
}
public override bool Equals(object obj)
{
if (obj == null)
{
return(false);
}
Technicians t = obj as Technicians;
if ((object)t == null)
{
return(false);
}
return(base.Equals(obj) && (this.Status == t.Status) && (this.SkillLevel == t.SkillLevel));
}
public TechnicalLog(RequestedEvents reqEvent, Technicians tlTech)
{
this.ReqEvent = reqEvent;
this.TlTech = tlTech;
}
