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; }