//VIEW BASIC DETAILS
public BasicDetails SeePatientData(string SSN)
{
if (SSN == null)
return null;
#if DEBUG
account = CloudStorageAccount.DevelopmentStorageAccount;
#else
account = new CloudStorageAccount(accountAndKey, true);
#endif
client = account.CreateCloudTableClient();
client.CreateTableIfNotExist("PatientDetails");
tableContext = new TableServiceContext(account.TableEndpoint.ToString(), account.Credentials);
IQueryable<BasicDetails> data = (from i in tableContext.CreateQuery<BasicDetails>("PatientDetails") where i.PartitionKey == "BasicDetails" select i).AsQueryable<BasicDetails>();
//Label1.Text = "";
if (data.AsEnumerable<BasicDetails>().Any<BasicDetails>())
{
BasicDetails z = new BasicDetails();
var y = (from BasicDetails i in data where i.SSN == SSN select i).FirstOrDefault<BasicDetails>() as BasicDetails;
if (y != null)
{
z = y;
}
else
{
z = null;
}
return z;
}
else return null;
}
//UPDATE BASIC DETAILS
public void UpdateBasicDetails(string SSN, BasicDetails PatientData)
{
if (SSN == null)
return;
#if DEBUG
account = CloudStorageAccount.DevelopmentStorageAccount;
#else
account = new CloudStorageAccount(accountAndKey, true);
#endif
client = account.CreateCloudTableClient();
client.CreateTableIfNotExist("PatientDetails");
tableContext = new TableServiceContext(account.TableEndpoint.ToString(), account.Credentials);
IQueryable<BasicDetails> data = (from i in tableContext.CreateQuery<BasicDetails>("PatientDetails") where i.PartitionKey == "BasicDetails" select i).AsQueryable<BasicDetails>();
//Label1.Text = "";
if (data.AsEnumerable<BasicDetails>().Any<BasicDetails>())
{
var y = (from BasicDetails i in data where i.SSN == SSN select i).FirstOrDefault<BasicDetails>() as BasicDetails;
if (y != null)
{
y.Name = PatientData.Name;
//y.SSN = PatientData.SSN;
y.DOB = PatientData.DOB;
y.LegalStatus = PatientData.LegalStatus;
y.MedicalInsurance = PatientData.MedicalInsurance;
y.Gender = PatientData.Gender;
y.Address = PatientData.Address;
y.Nationality = PatientData.Nationality;
y.NextOfKin = PatientData.NextOfKin;
y.PhoneNumber = PatientData.PhoneNumber;
//tableContext.AddObject("PatientDetails", x);
tableContext.UpdateObject(y);
tableContext.SaveChanges();
}
}
}
//ADD BASIC DETAILS
public void AddPatientData(BasicDetails PatientData)
{
#if DEBUG
account = CloudStorageAccount.DevelopmentStorageAccount;
#else
account = new CloudStorageAccount(accountAndKey, true);
#endif
client = account.CreateCloudTableClient();
client.CreateTableIfNotExist("PatientDetails");
tableContext = new TableServiceContext(account.TableEndpoint.ToString(), account.Credentials);
BasicDetails x = new BasicDetails();
x.Name = PatientData.Name;
x.SSN = PatientData.SSN;
x.DOB = PatientData.DOB;
x.LegalStatus = PatientData.LegalStatus;
x.MedicalInsurance = PatientData.MedicalInsurance;
x.Gender = PatientData.Gender;
x.Address = PatientData.Address;
x.Nationality = PatientData.Nationality;
x.NextOfKin = PatientData.NextOfKin;
x.PhoneNumber = PatientData.PhoneNumber;
x.Longitude = PatientData.Longitude;
x.Latitude = PatientData.Latitude;
tableContext.AddObject("PatientDetails", x);
tableContext.SaveChanges();
}
