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