public Treatment() { _doctorAndPrcedures = new List <DoctorAndProcedure>(); _signatureses = new List <Signatures>(); _trackingInformation = new TrackingInformation(); }
public Treatment() { _doctorAndPrcedures = new List<DoctorAndPrcedure>(); _signatureses = new List<Signatures>(); _trackingInformation = new TrackingInformation(); }
private TrackingInformation GetTrackingInformation(SqlConnection con, string trackingId) { var tracking = new TrackingInformation(); var cmdTacking = new SqlCommand("GetTrackingInformation", con) { CommandType = CommandType.StoredProcedure }; cmdTacking.Parameters.Add(new SqlParameter("@Id", SqlDbType.Int)).Value = trackingId; using (var read = cmdTacking.ExecuteReader()) { if (read.Read()) { tracking._device = read["Device"].ToString(); tracking._iP = read["IP"].ToString(); } } return tracking; }
private TrackingInformation GetTrackingInformation(SqlConnection con, string trackingId) { TrackingInformation tracking = new TrackingInformation(); SqlCommand cmdTacking = new SqlCommand("select Device,IP from TrackingInformation where Id=" + trackingId + "", con); using (var read = cmdTacking.ExecuteReader()) { if (read.Read()) { tracking._device = read["Device"].ToString(); tracking._iP = read["IP"].ToString(); } } return tracking; }