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