public void AddTreatment(Treatment treatment)
{
try
{
using (SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ToString()))
{
sqlConnection.Open();
SqlTransaction transaction = sqlConnection.BeginTransaction();
try
{
int consentType = GetConsentTypeId(sqlConnection, transaction, treatment._consentType.ToString());
int trackingID = GetTrackingId(sqlConnection, transaction, treatment._trackingInformation._device, treatment._trackingInformation._iP);
int doctorsAndProceduresID = GetDoctorsAndProcedures(sqlConnection, transaction, treatment._doctorAndPrcedures);
int signaturesID = GetSignatures(sqlConnection, transaction, treatment._signatureses);
// SqlCommand cmdTreatment = new SqlCommand("insert into Treatment(PatentId,ConsentType,IsPatientunabletosign,Unabletosignreason,TrackingID,Signatures,DoctorandProcedure,TransaltedBy,Date) values(" + treatment._patientId + "," + consentType + "," + (treatment._isPatientUnableSign == true ? 1 : 0) + ",'" + (string.IsNullOrEmpty(treatment._unableToSignReason) ? "" : treatment._unableToSignReason) + "'," + trackingID + "," + signaturesID + "," + doctorsAndProceduresID + ",'" + (string.IsNullOrEmpty(treatment._translatedBy) ? "" : treatment._translatedBy) + "','" + DateTime.Now + "')", sqlConnection, transaction);
SqlCommand cmdTreatment = new SqlCommand("insert into Treatment(PatentId,ConsentType,IsPatientunabletosign,IsStatementOfConsentAccepted,IsAutologousUnits,IsDirectedUnits,Unabletosignreason,TrackingID,Signatures,DoctorandProcedure,TransaltedBy,Date) values(" + treatment._patientId + "," + consentType + "," + (treatment._isPatientUnableSign == true ? 1 : 0) + ",'" + (treatment._IsStatementOfConsentAccepted == true ? 1 : 0) + ",'" + (treatment._IsAutologousUnits == true ? 1 : 0) + ",'" + (treatment._IsDirectedUnits == true ? 1 : 0) + ",'" + (string.IsNullOrEmpty(treatment._unableToSignReason) ? "" : treatment._unableToSignReason) + "'," + trackingID + "," + signaturesID + "," + doctorsAndProceduresID + ",'" + (string.IsNullOrEmpty(treatment._translatedBy) ? "" : treatment._translatedBy) + "','" + DateTime.Now + "')", sqlConnection, transaction);
cmdTreatment.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw new Exception(ex.Message);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public Treatment GetTreatment(string patientId, ConsentType consentType)
{
// open connection to sql server
var treatment = new Treatment();
try
{
System.Configuration.Configuration config = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
var conStr = config.AppSettings.Settings["DBConnection"].Value;
using (var sqlConnection = new SqlConnection(conStr))
{
sqlConnection.Open();
var daTreatment = new SqlDataAdapter(@"GetTreatment", sqlConnection) { SelectCommand = { CommandType = CommandType.StoredProcedure } };
daTreatment.SelectCommand.Parameters.Add("@consentType", SqlDbType.VarChar).Value = consentType.ToString();
var dsTreatment = new DataSet();
daTreatment.Fill(dsTreatment);
if (dsTreatment.Tables[0].Rows.Count > 0)
{
treatment._patientId = patientId;
treatment._consentType = consentType;
treatment._isPatientUnableSign = (dsTreatment.Tables[0].Rows[0]["IsPatientunabletosign"].ToString() == "True");
treatment._unableToSignReason = dsTreatment.Tables[0].Rows[0]["Unabletosignreason"].ToString();
treatment._translatedBy = dsTreatment.Tables[0].Rows[0]["TransaltedBy"].ToString();
treatment._trackingInformation = GetTrackingInformation(sqlConnection, dsTreatment.Tables[0].Rows[0]["TrackingID"].ToString());
treatment._doctorAndPrcedures = GetDoctorsProceduresInformation(sqlConnection, dsTreatment.Tables[0].Rows[0]["DoctorandProcedure"].ToString());
treatment._signatureses = GetSignaturesInformation(sqlConnection, dsTreatment.Tables[0].Rows[0]["Signatures"].ToString());
treatment._empID = dsTreatment.Tables[0].Rows[0]["EmpID"].ToString();
}
}
return treatment;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
[OperationContract] //This Attribute used to define the method inside of interface
public void AddTreatment(Treatment treatment)
{
try
{
System.Configuration.Configuration config = WebConfigurationManager.OpenWebConfiguration(HttpContext.Current.Request.ApplicationPath);
var conStr = config.AppSettings.Settings["DBConnection"].Value;
using (var sqlConnection = new SqlConnection(conStr))
{
sqlConnection.Open();
SqlTransaction transaction = sqlConnection.BeginTransaction();
try
{
if (treatment._doctorAndPrcedures == null)
treatment._doctorAndPrcedures = new List<DoctorAndProcedure>();
if (treatment._signatureses == null)
treatment._signatureses = new List<Signatures>();
int consentType = GetConsentTypeId(sqlConnection, transaction, treatment._consentType.ToString());
int trackingID = GetTrackingId(sqlConnection, transaction, treatment._trackingInformation._device, treatment._trackingInformation._iP);
int doctorsAndProceduresID = GetDoctorsAndProcedures(sqlConnection, transaction, consentType, treatment._doctorAndPrcedures);
int signaturesID = GetSignatures(sqlConnection, transaction, treatment._signatureses);
var addTreatmentCommand = new SqlCommand("AddTreatment", sqlConnection, transaction) { CommandType = CommandType.StoredProcedure };
addTreatmentCommand.Parameters.Add(new SqlParameter("@PatientID", SqlDbType.NVarChar)).Value = treatment._patientId;
addTreatmentCommand.Parameters.Add(new SqlParameter("@ConsentTypeID", SqlDbType.Int)).Value = consentType;
addTreatmentCommand.Parameters.Add(new SqlParameter("@isPatientUnableSign", SqlDbType.Int)).Value = (treatment._isPatientUnableSign ? 1 : 0);
addTreatmentCommand.Parameters.Add(new SqlParameter("@isStatementOfConsentAccepted", SqlDbType.Int)).Value = (treatment._IsStatementOfConsentAccepted ? 1 : 0);
addTreatmentCommand.Parameters.Add(new SqlParameter("@isAutologousUnits", SqlDbType.Int)).Value = (treatment._IsAutologousUnits ? 1 : 0);
addTreatmentCommand.Parameters.Add(new SqlParameter("@isDirectedUnits", SqlDbType.Int)).Value = (treatment._IsDirectedUnits ? 1 : 0);
addTreatmentCommand.Parameters.Add(new SqlParameter("@unableToSignReason", SqlDbType.VarChar)).Value = (string.IsNullOrEmpty(treatment._unableToSignReason) ? string.Empty : treatment._unableToSignReason);
addTreatmentCommand.Parameters.Add(new SqlParameter("@trackingID", SqlDbType.Int)).Value = trackingID;
addTreatmentCommand.Parameters.Add(new SqlParameter("@signaturesID", SqlDbType.Int)).Value = signaturesID;
addTreatmentCommand.Parameters.Add(new SqlParameter("@doctorsAndProceduresID", SqlDbType.Int)).Value = doctorsAndProceduresID;
addTreatmentCommand.Parameters.Add(new SqlParameter("@translatedBy", SqlDbType.VarChar)).Value = (string.IsNullOrEmpty(treatment._translatedBy) ? string.Empty : treatment._translatedBy);
addTreatmentCommand.Parameters.Add(new SqlParameter("@empID", SqlDbType.VarChar)).Value = treatment._empID;
addTreatmentCommand.ExecuteNonQuery();
/*
string query = @"insert into Treatment(PatentId,ConsentType,IsPatientunabletosign,IsStatementOfConsentAccepted,
IsAutologousUnits,IsDirectedUnits,Unabletosignreason,TrackingID,
Signatures,DoctorandProcedure,TransaltedBy,Date)
values(" + treatment._patientId + "," + consentType + "," + (treatment._isPatientUnableSign == true ? 1 : 0) + ",'"
+ (treatment._IsStatementOfConsentAccepted == true ? 1 : 0) + "','" + (treatment._IsAutologousUnits == true ? 1 : 0) + "','"
+ (treatment._IsDirectedUnits == true ? 1 : 0) + "','"
+ (string.IsNullOrEmpty(treatment._unableToSignReason) ? string.Empty : treatment._unableToSignReason) + "',"
+ trackingID + "," + signaturesID + "," + doctorsAndProceduresID + ",'"
+ (string.IsNullOrEmpty(treatment._translatedBy) ? string.Empty : treatment._translatedBy) + "','" + DateTime.Now + "')";
SqlCommand cmdTreatment = new SqlCommand(query, sqlConnection, transaction);
cmdTreatment.ExecuteNonQuery(); */
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw new Exception(ex.Message);
}
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public Treatment GetTreatment(string patientId, ConsentType consentType)
{
// open connection to sql server
Treatment treatment = new Treatment();
try
{
using (SqlConnection sqlConnection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ToString()))
{
sqlConnection.Open();
SqlCommand cmdConsentID = new SqlCommand("select ID from ConsentType where [Name]='" + consentType.ToString() + "'", sqlConnection);
string consentID = "0";
using (var readId = cmdConsentID.ExecuteReader())
{
if (readId.Read())
{
consentID = readId["ID"].ToString();
}
}
// SqlDataAdapter daTreatment = new SqlDataAdapter("select PatentId,ConsentType,IsPatientunabletosign,Unabletosignreason,TrackingID,Signatures,DoctorandProcedure,TransaltedBy,Date from Treatment where PatentId=" + patientId + " and ConsentType=" + consentID + " and date=(select MAX(date) from Treatment where PatentId=" + patientId + " and ConsentType=" + consentID + ")", sqlConnection);
SqlDataAdapter daTreatment = new SqlDataAdapter("select PatentId,ConsentType,IsPatientunabletosign,IsStatementOfConsentAccepted,IsAutologousUnits,IsDirectedUnits,Unabletosignreason,TrackingID,Signatures,DoctorandProcedure,TransaltedBy,Date from Treatment where PatentId=" + patientId + " and ConsentType=" + consentID + " and date=(select MAX(date) from Treatment where PatentId=" + patientId + " and ConsentType=" + consentID + ")", sqlConnection);
DataSet dsTreatment = new DataSet();
daTreatment.Fill(dsTreatment);
if (dsTreatment.Tables[0].Rows.Count > 0)
{
treatment._patientId = patientId;
treatment._consentType = consentType;
treatment._isPatientUnableSign = (dsTreatment.Tables[0].Rows[0]["IsPatientunabletosign"].ToString() == "1" ? true : false);
treatment._unableToSignReason = dsTreatment.Tables[0].Rows[0]["Unabletosignreason"].ToString();
treatment._translatedBy = dsTreatment.Tables[0].Rows[0]["TransaltedBy"].ToString();
treatment._trackingInformation = GetTrackingInformation(sqlConnection, dsTreatment.Tables[0].Rows[0]["TrackingID"].ToString());
treatment._doctorAndPrcedures = GetDoctorsProceduresInformation(sqlConnection, dsTreatment.Tables[0].Rows[0]["DoctorandProcedure"].ToString());
treatment._signatureses = GetSignaturesInformation(sqlConnection, dsTreatment.Tables[0].Rows[0]["Signatures"].ToString());
}
}
return treatment;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}