public void UpdateHospitalBasicDetails(string HospID, HospitalBasicDetails HospitalData) { 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<HospitalBasicDetails> data = (from i in tableContext.CreateQuery<HospitalBasicDetails>("DoctorDetails") where i.PartitionKey == "HospitalBasicDetails" select i).AsQueryable<HospitalBasicDetails>(); //Label1.Text = ""; if (data.AsEnumerable<HospitalBasicDetails>().Any<HospitalBasicDetails>()) { HospitalBasicDetails z = new HospitalBasicDetails(); var x = (from HospitalBasicDetails i in data where i.HospitalID == HospID select i).FirstOrDefault<HospitalBasicDetails>() as HospitalBasicDetails; if (x != null) { //x.HospitalID = HospitalData.HospitalID; x.HospitalName = HospitalData.HospitalName; x.Address = HospitalData.Address; x.Latitude = HospitalData.Latitude; x.Longitude = HospitalData.Longitude; x.Facilities = HospitalData.Facilities; x.Departments = HospitalData.Departments; x.Beds_Rooms = HospitalData.Beds_Rooms; x.Type = HospitalData.Type; tableContext.UpdateObject(x); tableContext.SaveChanges(); } } }
public void AddHospitalBasicDetails(HospitalBasicDetails HospitalData) { #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); HospitalBasicDetails x = new HospitalBasicDetails(); x.HospitalID = HospitalData.HospitalID; x.HospitalName = HospitalData.HospitalName; x.Address = HospitalData.Address; x.Latitude = HospitalData.Latitude; x.Longitude = HospitalData.Longitude; x.Facilities = HospitalData.Facilities; x.Departments = HospitalData.Departments; x.Beds_Rooms = HospitalData.Beds_Rooms; x.Type = HospitalData.Type; tableContext.AddObject("DoctorDetails", x); tableContext.SaveChanges(); }
public HospitalBasicDetails SeeHospitalBasicDetails(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<HospitalBasicDetails> data = (from i in tableContext.CreateQuery<HospitalBasicDetails>("DoctorDetails") where i.PartitionKey == "HospitalBasicDetails" select i).AsQueryable<HospitalBasicDetails>(); //Label1.Text = ""; if (data.AsEnumerable<HospitalBasicDetails>().Any<HospitalBasicDetails>()) { HospitalBasicDetails z = new HospitalBasicDetails(); var y = (from HospitalBasicDetails i in data where i.HospitalID == HospID select i).FirstOrDefault<HospitalBasicDetails>() as HospitalBasicDetails; if (y != null) { z = y; } else { z = null; } return z; } else return null; }
public override void Run() { // This is a sample worker implementation. Replace with your logic. Trace.WriteLine("$projectname$ entry point called", "Information"); while (true) { if (q.Exists()) { q.RetrieveApproximateMessageCount(); if (q.ApproximateMessageCount > 0) { Trace.WriteLine("Working", "Information"); var message = q.GetMessage(); q.DeleteMessage(message); var request = message.AsString; var parts = request.Split('|'); string ICD9Code = parts[0]; DateTime starttime = new DateTime(long.Parse(parts[1])); DateTime endtime = new DateTime(long.Parse(parts[2])); string OperationID = parts[3]; try { IQueryable<AilmentDetails> data = (from i in tableContext.CreateQuery<AilmentDetails>("PatientDetails") where i.PartitionKey == "AilmentDetails" && i.DiagnosisID == ICD9Code select i).AsQueryable<AilmentDetails>(); if (data.AsEnumerable<AilmentDetails>().Any<AilmentDetails>()) { foreach (AilmentDetails x in data) { if (DateTime.Compare(x.TimeIn, starttime) >= 0 && DateTime.Compare(x.TimeIn, endtime) <= 0) { string searchHospital = x.Hospital; IQueryable<HospitalBasicDetails> data2 = (from i in tableContext.CreateQuery<HospitalBasicDetails>("DoctorDetails") where i.PartitionKey == "HospitalBasicDetails" select i).AsQueryable<HospitalBasicDetails>(); if (data2.AsEnumerable<HospitalBasicDetails>().Any<HospitalBasicDetails>()) { HospitalBasicDetails z = new HospitalBasicDetails(); var y = (from HospitalBasicDetails i in data2 where i.HospitalID == searchHospital select i).FirstOrDefault<HospitalBasicDetails>() as HospitalBasicDetails; if (y != null) { ICD9MapPlotResultEntry temp = new ICD9MapPlotResultEntry(); temp.Latitude = y.Latitude; temp.Longitude = y.Longitude; temp.Time = x.TimeIn; rows.Add(temp); } } } } } var serializer = new XmlSerializer(typeof(List<ICD9MapPlotResultEntry>)); var stringBuilder = new StringBuilder(); XmlWriter writer = XmlWriter.Create(stringBuilder); serializer.Serialize(writer, rows); Encoding encoding = Encoding.Default; blob = container.GetBlobReference(OperationID + ".xml"); blob.UploadByteArray(encoding.GetBytes(stringBuilder.ToString())); var resultrecord = new ICD9MapPlotResult(ICD9Code, OperationID); resultrecord.SearchTimeStart = starttime; resultrecord.SearchTimeEnd = endtime; resultrecord.ResultURL = blob.Uri.ToString(); tableContext.AddObject("ICD9MapPlotResult", resultrecord); tableContext.SaveChanges(); } catch (Exception e) { Trace.WriteLine(e.Message, "Error"); } } } Thread.Sleep(10000); } }