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