} // End AddVisit(OutVisit visit) /************************************************************ * UpdateVisit(InVisit visit) * Add provided InVisit to database ***********************************************************/ public static bool UpdateVisit(InVisit visit) { try { // Attempt new SqlConnection with update visit command SqlConnection conn = new SqlConnection(Utility.GetConnectionString()); SqlCommand comm = new SqlCommand(); comm.CommandType = System.Data.CommandType.Text; comm.CommandText = "UPDATE Visit SET [DateOfDischarge]" + " = @DateOfDischarge WHERE [Id] = @Id"; // Add values to parameters being inserted comm.Parameters.AddWithValue("@DateOfDischarge", visit.discharge); comm.Parameters.AddWithValue("@id", visit.id); comm.Connection = conn; // Open connection conn.Open(); // Execute Update Query comm.ExecuteNonQuery(); // Close connection conn.Close(); // Return true if successfull return true; } catch (Exception) { // If exception caught return false return false; } } // End UpdateVisit(InVisit visit)
} // End GetNewId() /************************************************************ * AddVisit(InVisit visit) * Add provided InVisit to database ***********************************************************/ public static bool AddVisit(InVisit visit) { try { // Attempt new SqlConnection with insert visit command SqlConnection conn = new SqlConnection(Utility.GetConnectionString()); SqlCommand comm = new SqlCommand("INSERT INTO Visit (Id, PatientId, PatientType, " + "DoctorId, BedId, DateOfVisit, DateOfDischarge) VALUES (@Id, @PatientId, " + "@PatientType, @DoctorId, @BedId, @DateOfVisit, @DateOfDischarge)"); comm.CommandType = CommandType.Text; comm.Connection = conn; // Add values to parameters being inserted comm.Parameters.AddWithValue("@Id", visit.id); comm.Parameters.AddWithValue("@PatientId", visit.patientId); comm.Parameters.AddWithValue("@PatientType", visit.type); comm.Parameters.AddWithValue("@DoctorId", visit.doctor); comm.Parameters.AddWithValue("@BedId", visit.bed); comm.Parameters.AddWithValue("@DateOfVisit", visit.date); comm.Parameters.AddWithValue("@DateOfDischarge", DBNull.Value); // Open connection conn.Open(); // Execute insert query comm.ExecuteNonQuery(); // Close connection conn.Close(); // Return true if successfull return true; } catch (Exception) { // If exception caught return false return false; } } // End AddVisit(InVisit visit)
} // End UpdateVisit(InVisit visit) /************************************************************ * GetPrice(InVisit visit) * Get total price of inpatient visit ***********************************************************/ public static string GetPrice(InVisit visit) { // Start date split holding string[] startSplit = visit.date.Split(' '); // End date split holding string[] endSplit = DateTime.Now.ToString().Split(' '); // Start date string[] visitStart = startSplit[0].Split('/'); // End date string[] visitEnd = endSplit[0].Split('/'); // Create DateTime object from start time DateTime start = new DateTime(Convert.ToInt32(visitStart[2]), Convert.ToInt32(visitStart[1]), Convert.ToInt32(visitStart[0])); // Create DateTime object from end time DateTime end = new DateTime(Convert.ToInt32(visitEnd[2]), Convert.ToInt32(visitEnd[1]), Convert.ToInt32(visitEnd[0])); // Total amount of days of visit int days = (end - start).Days; // Price of bed per day int rate = BedUtility.GetBed(Convert.ToInt32(visit.bed)).rate; // Double holding for bed rate * days of visit double priceDouble = rate * days; // If the visit was only 1 day if (priceDouble == 0) // The rate of the bed is the price return rate.ToString(); else // Else return priceDouble as price return priceDouble.ToString(); } // End GetPrice(InVisit visit)