private void DisplayMedSchoolDetails()
{
string MedicalSchoolCode = txtMedicalSchoolCode.Text;
//LINQ code to get the name, university and award of the medical school
using (var dtContext = new JMConsultantsDataContext())
{
//Put the results of stored procedure into a variable
var MedSchoolDetails = dtContext.sproc_GetMedicalSchoolDetails(MedicalSchoolCode);
//use a foreach loop to index the the details in the variable array
foreach (var DetailsIndexed in MedSchoolDetails)
{
//get the School name and pass the name to the School name text box
txtMedSchoolName.Text = Convert.ToString(DetailsIndexed.JM_Name);
//get the University and pass it to the text University textbox
txtUniversity.Text = Convert.ToString(DetailsIndexed.JM_University);
//get the Award and pass it to the Award textbox
txtAward.Text = Convert.ToString(DetailsIndexed.JM_Award);
}
}
}
private void DisplayGPDetails()
{
//first try to execute the code.
try
{
//declare an Integer to store the GP Number
Int32 GPNumberIn = Convert.ToInt32(txtGPNo.Text);
//LINQ code to get the name, medical school code for the GP
using (var dtContext = new JMConsultantsDataContext())
{
//Put the results of stored procedure into a variable
var GPDetails = dtContext.sproc_tblGP_Get_GPName_and_MedSchool(GPNumberIn);
//use a foreach loop to index the the details in the variable array
foreach (var DetailsIndexed in GPDetails)
{
//get the GP name and pass it to the GP name text box
txtGPName.Text = Convert.ToString(DetailsIndexed.JM_Name);
//get the Medical School number and pass it to the medical school box
txtMedicalSchoolCode.Text = Convert.ToString(DetailsIndexed.JM_MedicalSchoolCode);
}
}
}
catch
{
//in case of error do nothing
}
}
private Int32 GetNextPracticeGPNo()
{
//find the next available GP no
using (var dtContext = new JMConsultantsDataContext())
{
Int32 maxPracticeGPNo = 0;
//using stored procedure via LINQ assuming the GP number in database are ordered
var PracticeGPNumbers = dtContext.sproc_tblPracticeGP_Get_HighesPracticeGPNo();
foreach (var PracticeGPNumberIndexed in PracticeGPNumbers) //Note 1/2 to self: analogous to GPNumberIndexed[Index] = GPNumbers is the result
{
maxPracticeGPNo = Convert.ToInt32(PracticeGPNumberIndexed.maxJM_PracticeGPNo); //Note 2/2 to self: analogous to array GPNumberIndexed[Index].JM_GPNo
}
return(maxPracticeGPNo + 1);
}
}
private Int32 GetNextGPNo()
{
//find the next available GP no
using (var dtContext = new JMConsultantsDataContext())
{
Int32 previousGPNo = 0; //assume the numbers start at 1
Int32 currentGPNo;
//using stored procedure via LINQ assuming the GP number in database are ordered
var GPNumbers = dtContext.sproc_tblGP_Get_GP_numbers();
foreach (var GPNumberIndexed in GPNumbers) //Note 1/2 to self: analogous to GPNumberIndexed[Index] = GPNumbers is the result
{
currentGPNo = Convert.ToInt32(GPNumberIndexed.JM_GPNo); //Note 2/2 to self: analogous to array GPNumberIndexed[Index].JM_GPNo
//Find the difference;
var difference = currentGPNo - previousGPNo;
//if the difference is greater than one then there is a gap for a GPNo
if (difference > 1)
{
break;
}
previousGPNo = currentGPNo;
}
return(previousGPNo + 1);
}
}
