public HospitalDoctorConnectionDetails SeeHospitalDoctorConnectionDetails(string HospID) { if (HospID == null) return null; #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<HospitalDoctorConnectionDetails> data = (from i in tableContext.CreateQuery<HospitalDoctorConnectionDetails>("DoctorDetails") where i.PartitionKey == "HospitalDoctorConnectionDetails" select i).AsQueryable<HospitalDoctorConnectionDetails>(); //Label1.Text = ""; if (data.AsEnumerable<HospitalDoctorConnectionDetails>().Any<HospitalDoctorConnectionDetails>()) { HospitalDoctorConnectionDetails z = new HospitalDoctorConnectionDetails(); var y = (from HospitalDoctorConnectionDetails i in data where i.HospitalIDLinkRowKey == HospID select i).FirstOrDefault<HospitalDoctorConnectionDetails>() as HospitalDoctorConnectionDetails; if (y != null) { z = y; } else { z = null; } return z; } else return null; }
public void UpdateHospitalDoctorConnectionDetails(string HospID, HospitalDoctorConnectionDetails HospDocData) { 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<HospitalDoctorConnectionDetails> data = (from i in tableContext.CreateQuery<HospitalDoctorConnectionDetails>("DoctorDetails") where i.PartitionKey == "HospitalDoctorConnectionDetails" select i).AsQueryable<HospitalDoctorConnectionDetails>(); //Label1.Text = ""; if (data.AsEnumerable<HospitalDoctorConnectionDetails>().Any<HospitalDoctorConnectionDetails>()) { HospitalDoctorConnectionDetails z = new HospitalDoctorConnectionDetails(); var x = (from HospitalDoctorConnectionDetails i in data where i.HospitalIDLinkRowKey == HospID select i).FirstOrDefault<HospitalDoctorConnectionDetails>() as HospitalDoctorConnectionDetails; if (x != null) { //x.HospitalIDLinkRowKey = HospDocData.HospitalIDLinkRowKey; x.DoctorIDLinkRowKey = HospDocData.DoctorIDLinkRowKey; x.DoctorHospitalPhoneNumber = HospDocData.DoctorHospitalPhoneNumber; tableContext.UpdateObject(x); tableContext.SaveChanges(); } } }
public void AddHospitalDoctorConnectionDetails(HospitalDoctorConnectionDetails HospDocData) { #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); HospitalDoctorConnectionDetails x = new HospitalDoctorConnectionDetails(); x.HospitalIDLinkRowKey = HospDocData.HospitalIDLinkRowKey; x.DoctorIDLinkRowKey = HospDocData.DoctorIDLinkRowKey; x.DoctorHospitalPhoneNumber = HospDocData.DoctorHospitalPhoneNumber; tableContext.AddObject("DoctorDetails", x); tableContext.SaveChanges(); }