private bool AddSinglePatient(out Guid newPatientId)
{
var rand = new Random();
newPatientId = Guid.Empty;
string name = commonNames[rand.Next(commonNames.Length - 1)];
// Create a random patient info
PatientInfo patIfno = new PatientInfo(name, rand.Next(11111, 99999),
name + "@" + "abcd.com", "aaaa", Guid.Empty);
InsuranceInfo insuranceInfo = new InsuranceInfo(patIfno.m_patientId, "BasicMedicalPlan");
patIfno.m_insuranceId = insuranceInfo.m_insuranceId;
PhysicianDetails physicianDetails =
new PhysicianDetails(commonNames[rand.Next(commonNames.Length - 1)], "General Medicine");
if (!DBOperations.GetInstance().CreateNewPatient(patIfno, insuranceInfo, physicianDetails))
{
return(false);
}
newPatientId = patIfno.m_patientId;
return(true);
}
// GET: /Physician/
public ActionResult Index()
{
PhysicianDetails physiciandetails = new PhysicianDetails();
ViewBag.SpecialityList = specialitylist.GetSpecialityList();
ViewBag.HospitalList = hospitalservice.GetAllHospital();
return(View(physiciandetails.GetAllPhysicianDetails()));
}
public int UpdatePhysicianInfo(PhysicianDetails phyDeatailsObject)
{
databaseObject.CommandToExecute.CommandText = @"uspUpdatePhysicianInfo";
databaseObject.CommandToExecute.CommandType = CommandType.StoredProcedure;
SqlParameter param1 = new SqlParameter();
param1.ParameterName = "@PhysicianId";
param1.Value = phyDeatailsObject.PhysicianId;
SqlParameter param2 = new SqlParameter();
param2.ParameterName = "@DeptId";
param2.Value = phyDeatailsObject.DepartmentId;
SqlParameter param3 = new SqlParameter();
param3.ParameterName = "@StateId";
param3.Value = phyDeatailsObject.PhysicianStateId;
SqlParameter param4 = new SqlParameter();
param4.ParameterName = "@PlanId";
param4.Value = phyDeatailsObject.InsurancePlan;
SqlParameter param5 = new SqlParameter();
param5.ParameterName = "@EducationalQualification";
param5.Value = phyDeatailsObject.EducationalQualification;
SqlParameter param6 = new SqlParameter();
param6.ParameterName = "@YearsOfExperience";
param6.Value = phyDeatailsObject.YearsOfExperience;
try
{
databaseObject.CommandToExecute.Connection = databaseObject.DatabaseConnection;
databaseObject.DatabaseConnection.Open();
databaseObject.CommandToExecute.Parameters.Add(param1);
databaseObject.CommandToExecute.Parameters.Add(param2);
databaseObject.CommandToExecute.Parameters.Add(param3);
databaseObject.CommandToExecute.Parameters.Add(param4);
databaseObject.CommandToExecute.Parameters.Add(param5);
databaseObject.CommandToExecute.Parameters.Add(param6);
return(databaseObject.CommandToExecute.ExecuteNonQuery());
}
catch (Exception e)
{
return(0);
}
}
public string CheckNameOfPhysicianExists(PhysicianDetails physicianDetailsObject)
{
string result = null;
databaseObject.CommandToExecute.CommandText = @"uspCheckAvailabilityOfPhysicianName";
databaseObject.CommandToExecute.CommandType = CommandType.StoredProcedure;
SqlParameter param1 = new SqlParameter();
param1.ParameterName = "@physicianFirstName";
param1.Value = physicianDetailsObject.PhysicianFirstName;
SqlParameter param2 = new SqlParameter();
param2.ParameterName = "@physicianLastName";
param2.Value = physicianDetailsObject.PhysicianLastName;
try
{
databaseObject.CommandToExecute.Connection = databaseObject.DatabaseConnection;
databaseObject.DatabaseConnection.Open();
databaseObject.CommandToExecute.Parameters.Add(param1);
databaseObject.CommandToExecute.Parameters.Add(param2);
databaseObject.DBDataReader = databaseObject.CommandToExecute.ExecuteReader();
if (databaseObject.DBDataReader.HasRows == true)
{
while (databaseObject.DBDataReader.Read())
{
result = databaseObject.DBDataReader[0].ToString();
}
}
}
catch (SqlException ex)
{
}
finally
{
databaseObject.DatabaseConnection.Close();
}
return(result);
}
public int InsertPhysicianDetails(PhysicianDetails physicianDetailsObject)
{
int queryStatus = 0;
databaseObject.CommandToExecute = new SqlCommand();
databaseObject.CommandToExecute.CommandText = @"uspInsertPhysicianDetails";
databaseObject.CommandToExecute.CommandType = CommandType.StoredProcedure;
databaseObject.DBDataTable = new DataTable();
databaseObject.DBDataTable.Columns.Add("PhysicianId", typeof(string));
databaseObject.DBDataTable.Columns.Add("PhysicianFirstName", typeof(string));
databaseObject.DBDataTable.Columns.Add("PhysicianLastName", typeof(string));
databaseObject.DBDataTable.Columns.Add("DepartmentId", typeof(string));
databaseObject.DBDataTable.Columns.Add("EducationalQualification", typeof(string));
databaseObject.DBDataTable.Columns.Add("YearsOfExperience", typeof(int));
databaseObject.DBDataTable.Columns.Add("PhysicianStateId", typeof(string));
databaseObject.DBDataTable.Columns.Add("InsurancePlan", typeof(string));
databaseObject.DBDataTable.Rows.Add(physicianDetailsObject.PhysicianId, physicianDetailsObject.PhysicianFirstName,
physicianDetailsObject.PhysicianLastName, physicianDetailsObject.DepartmentId,
physicianDetailsObject.EducationalQualification, physicianDetailsObject.YearsOfExperience,
physicianDetailsObject.PhysicianStateId, physicianDetailsObject.InsurancePlan);
param1 = new SqlParameter();
param1.ParameterName = "@userPhysicianData";
param1.Value = databaseObject.DBDataTable;
param1.SqlDbType = SqlDbType.Structured;
//SqlParameter param2 = new SqlParameter();
//param2.ParameterName = "@physicianFirstName";
//param2.Value = physicianDetailsObject.PhysicianFirstName;
//SqlParameter param3 = new SqlParameter();
//param3.ParameterName = "@physicianLastName";
//param3.Value = physicianDetailsObject.PhysicianLastName;
try
{
databaseObject.CommandToExecute.Connection = databaseObject.DatabaseConnection;
databaseObject.DatabaseConnection.Open();
databaseObject.CommandToExecute.Parameters.Add(param1);
//databaseObject.CommandToExecute.Parameters.Add(param2);
//databaseObject.CommandToExecute.Parameters.Add(param3);
queryStatus = databaseObject.CommandToExecute.ExecuteNonQuery();
return(queryStatus);
}
catch (SqlException ex)
{
return(queryStatus);
}
finally
{
databaseObject.DatabaseConnection.Close();
}
}
public int UpdatePhysicianInfo(PhysicianDetails phyDeatailsObject)
{
return(dBAccess.UpdatePhysicianInfo(phyDeatailsObject));
}
public string CheckNameOfPhysicianExists(PhysicianDetails physicianDetailsObject)
{
return(PhysicianDetailsDALObject.CheckNameOfPhysicianExists(physicianDetailsObject));
}
public int InsertPhysicianDetails(PhysicianDetails physicianDetailsObject)
{
return(PhysicianDetailsDALObject.InsertPhysicianDetails(physicianDetailsObject));
}