public HospitalPatientConnectionDetails SeeHospitalPatientConnectionDetails(string HospID) { if (HospID == null) return null; #if DEBUG account = CloudStorageAccount.DevelopmentStorageAccount; #else account = new CloudStorageAccount(accountAndKey, true); #endif if (HospID == null) return null; client = account.CreateCloudTableClient(); client.CreateTableIfNotExist("DoctorDetails"); tableContext = new TableServiceContext(account.TableEndpoint.ToString(), account.Credentials); IQueryable<HospitalPatientConnectionDetails> data = (from i in tableContext.CreateQuery<HospitalPatientConnectionDetails>("DoctorDetails") where i.PartitionKey == "HospitalPatientConnectionDetails" select i).AsQueryable<HospitalPatientConnectionDetails>(); //Label1.Text = ""; if (data.AsEnumerable<HospitalPatientConnectionDetails>().Any<HospitalPatientConnectionDetails>()) { HospitalPatientConnectionDetails z = new HospitalPatientConnectionDetails(); var y = (from HospitalPatientConnectionDetails i in data where i.HospitalIDLinkRowKey == HospID select i).FirstOrDefault<HospitalPatientConnectionDetails>() as HospitalPatientConnectionDetails; if (y != null) { z = y; } else { z = null; } return z; } else return null; }
public void UpdateHospitalPatientConnectionDetails(string HospID, HospitalPatientConnectionDetails HospPatientData) { if (HospID == null) return; #if DEBUG account = CloudStorageAccount.DevelopmentStorageAccount; #else account = new CloudStorageAccount(accountAndKey, true); #endif client = account.CreateCloudTableClient(); client.CreateTableIfNotExist("DoctorDetails"); tableContext = new TableServiceContext(account.TableEndpoint.ToString(), account.Credentials); IQueryable<HospitalPatientConnectionDetails> data = (from i in tableContext.CreateQuery<HospitalPatientConnectionDetails>("DoctorDetails") where i.PartitionKey == "HospitalPatientConnectionDetails" select i).AsQueryable<HospitalPatientConnectionDetails>(); //Label1.Text = ""; if (data.AsEnumerable<HospitalPatientConnectionDetails>().Any<HospitalPatientConnectionDetails>()) { HospitalPatientConnectionDetails z = new HospitalPatientConnectionDetails(); var x = (from HospitalPatientConnectionDetails i in data where i.HospitalIDLinkRowKey == HospID select i).FirstOrDefault<HospitalPatientConnectionDetails>() as HospitalPatientConnectionDetails; if (x != null) { //x.HospitalIDLinkRowKey = HospPatientData.HospitalIDLinkRowKey; x.PatientIDLinkRowKey = HospPatientData.PatientIDLinkRowKey; tableContext.UpdateObject(x); tableContext.SaveChanges(); } } }
public void AddHospitalPatientConnectionDetails(HospitalPatientConnectionDetails HospPatientData) { #if DEBUG account = CloudStorageAccount.DevelopmentStorageAccount; #else account = new CloudStorageAccount(accountAndKey, true); #endif client = account.CreateCloudTableClient(); client.CreateTableIfNotExist("DoctorDetails"); tableContext = new TableServiceContext(account.TableEndpoint.ToString(), account.Credentials); HospitalPatientConnectionDetails x = new HospitalPatientConnectionDetails(); x.HospitalIDLinkRowKey = HospPatientData.HospitalIDLinkRowKey; x.PatientIDLinkRowKey = HospPatientData.PatientIDLinkRowKey; tableContext.AddObject("DoctorDetails", x); tableContext.SaveChanges(); }