} // 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)
