public ActionResult InvestigationsForms(SurgicalInfo model)
{
if (Session["hosNo"] != null)
{
var Regno = Session["hosNo"].ToString();
var id = ProcedureSectonID(DateTime.Today, Regno);
using (IDbConnection db = new SqlConnection(constr))
{
string insertQuery = @"INSERT INTO [dbo].[Forminvestigations]([Unit], [Cost], [InvestigationId], [investigationDate], [RegistrationNo],[Active],[SurgeryBookId])VALUES (@Unit, @Cost, @InvestigationId, @investigationDate, @RegistrationNo,@Active,@SurgeryBookId)";
Investigations inv = new Investigations();
inv.InvestigationId = model.investID;
inv.InvestigationDate = DateTime.Today;
inv.Unit = model.Labunit;
inv.Cost = decimal.Parse(model.LabCost) * model.Labunit;
inv.RegistrationNo = Regno;
inv.Active = true;
inv.SurgeryBookId = id;
var result = db.Execute(insertQuery, inv);
}
var getPatList = LabInvest(DateTime.Today, Regno);
model.ListofLabTest = getPatList;
model.investigations = GetLabInvestigationsItems();
}
else
{
model.investigations = GetLabInvestigationsItems();
Session["error"] = "This Session has expired please click the back button";
return(RedirectToAction("Index"));
}
return(View(model));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,UserId,ReportId,InvEntry")] Investigations investigations)
{
if (id != investigations.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(investigations);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!InvestigationsExists(investigations.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["UserId"] = new SelectList(_context.Users, "Id", "Id", investigations.UserId);
ViewData["ReportId"] = new SelectList(_context.Reports, "Id", "Id", investigations.ReportId);
return(View(investigations));
}
public void Dispose()
{
LowRank.Dispose();
HighRank.Dispose();
MasterRank.Dispose();
Investigations.Dispose();
GuidingLands.Dispose();
All.Dispose();
}
public List <Investigations> LabInvest(DateTime date, string RegNo)
{
//var objMTDDetails = SqlMapper.QueryMultiple(con, "RunningPayorMixMTDCountVsRevenueOPDPost", new { facilityId = facilities, endTime = DateTime.Parse(End) }, null, null, commandType: CommandType.StoredProcedure);
var objDetails = SqlMapper.QueryMultiple(con, "labInvestperPatient", new { @RegNo = RegNo, @date = date }, null, null, commandType: CommandType.StoredProcedure);
Investigations k = new Investigations();
var t = objDetails.Read <Investigations>().ToList();
return(t);
}
public async Task <IActionResult> Create([Bind("Id,UserId,ReportId,InvEntry")] Investigations investigations)
{
if (ModelState.IsValid)
{
_context.Add(investigations);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["UserId"] = new SelectList(_context.Users, "Id", "Id", investigations.UserId);
ViewData["ReportId"] = new SelectList(_context.Reports, "Id", "Id", investigations.ReportId);
return(View(investigations));
}
private async void btnSave_Clicked(object sender, EventArgs e)
{
try
{
object obj;
overlay.IsVisible = true;
objInvestigations = new Models.Investigations();
if (!chkHaemoglobinKnown.Checked && !string.IsNullOrEmpty(txtHaemoglobin.Text))
{
objInvestigations.haemoglobin = txtHaemoglobin.Text.Trim();
}
objInvestigations.haemoglobin_dont_know = Convert.ToInt32(chkHaemoglobinKnown.Checked);
if (!chkCholestrol.Checked && !string.IsNullOrEmpty(txtCholestrol.Text))
{
objInvestigations.total_cholesterol = txtCholestrol.Text.Trim();
}
objInvestigations.total_cholesterol_dont_know = Convert.ToInt32(chkCholestrol.Checked);
if (!chkbloodsugar.Checked && !string.IsNullOrEmpty(txtBloodsugar.Text))
{
objInvestigations.blood_sugar = txtBloodsugar.Text.Trim();
}
objInvestigations.blood_sugar_dont_know = Convert.ToInt32(chkbloodsugar.Checked);
obj = await App.TodoManager.SaveHraStep2(objInvestigations, HRAid);
if (obj.ToString().Contains("error"))
{
InvgestigationErrorRootObject objInvgestigationErrorRootObject = JsonConvert.DeserializeObject <InvgestigationErrorRootObject>(obj.ToString());
DependencyService.Get <IMessage>().LongAlert(objInvgestigationErrorRootObject.errors.messsage);
ShowErrors(objInvgestigationErrorRootObject.errors.validation);
}
else
{
objHRA = JsonConvert.DeserializeObject <HRA>(obj.ToString());
if (objHRA.data != null)
{
await Navigation.PushAsync(new HRAStep3(objHRA, HRAid));
}
}
overlay.IsVisible = false;
}
catch (Exception ex)
{
DependencyService.Get <IMessage>().LongAlert();
}
finally
{
overlay.IsVisible = false;
}
}
public HRAStep2(HRA HRA)
{
InitializeComponent();
objHRA = HRA;
if (HRA != null)
{
HRAid = objHRA.data.id;
if (HRA.data.investigations != null)
{
objInvestigations = objHRA.data.investigations;
ShhowData();
}
}
else
{
btnSave.IsEnabled = false;
}
}
private void TxtIInvestigationID_TargetUpdated(object sender, System.Windows.Data.DataTransferEventArgs e)
{
if (this.MyViewModel == null)
{
return;
}
int InvId;
int.TryParse(txtIInvestigationID.Text.ToString(), out InvId);
Investigations ObjInv = this.MyViewModel.db.Investigations.Where(I => I.bIsActive == true && I.IInvid == InvId).FirstOrDefault();
//iFacede.GetdhItem(Globalized.ObjDbName, new dhItems { IItemID = Convert.ToInt32(ItemList.SelectedValue) });
//ObjDhItem.IQuantity = 0;
// creat the new object of doctor investigation
if (ObjInv == null)
{
return;
}
DocInvestigations objDocInv = new DocInvestigations();
objDocInv.IInvid = InvId;
objDocInv.IDocid = this.MyViewModel.ObjNewDoctor.IDocid;
objDocInv.VInvName = ObjInv.VInvName;
objDocInv.VInvDesc = ObjInv.VInvDesc;
objDocInv.IInvCharges = ObjInv.IInvCharges;
this.MyViewModel.ObjNewDoctor.DocInvestigations.Add(objDocInv);
// update the source
this.DocInvestigations.ItemsSource = this.MyViewModel.ObjNewDoctor.DocInvestigations;
// clear the source
// this.InvestigationList.SelectedItem = null;
// this.InvestigationList.SelectedValue = "";
//this.InvestigationList
}
private void ConstructResultSet()
{
Investigations objparty = new Investigations();
// dsGeneral.dtPosPartyDataTable dt = iFacede.GetParty(Globalized.ObjDbName, objparty);
_results = new List <Investigations>();
_results = db.Investigations.Where(x => x.bIsActive == true).ToList();
//foreach (DataRow row in dt.Rows)
//{
// _results.Add(new dhParty
// {
// IPartyID = Convert.ToInt32(row["IPartyID"]),
// VPartyName = Convert.ToString(row["VPartyName"]),
// VPartyadress = Convert.ToString(row["VPartyadress"]),
// VpartyMobile = Convert.ToString(row["VpartyMobile"]),
// VPartyInfo = Convert.ToString(row["VPartyName"]) + " , " + Convert.ToString(row["VPartyadress"]) + " , " + Convert.ToString(row["VpartyMobile"]),
// //VItemName = Convert.ToString(row["VItemName"]),
// //FMaxDiscountPresent = Convert.ToDouble(row["fMaxDiscountPresent"]),
// //VpartyMobile = Convert.ToString(row["VpartyMobile"]),
// //VPartyName = Convert.ToString(row["ReadingInches"]),
// });
//}
}
public override IDeepCopyable CopyTo(IDeepCopyable other)
{
var dest = other as ClinicalImpression;
if (dest != null)
{
base.CopyTo(dest);
if (Patient != null)
{
dest.Patient = (Hl7.Fhir.Model.ResourceReference)Patient.DeepCopy();
}
if (Assessor != null)
{
dest.Assessor = (Hl7.Fhir.Model.ResourceReference)Assessor.DeepCopy();
}
if (StatusElement != null)
{
dest.StatusElement = (Code <Hl7.Fhir.Model.ClinicalImpression.ClinicalImpressionStatus>)StatusElement.DeepCopy();
}
if (DateElement != null)
{
dest.DateElement = (Hl7.Fhir.Model.FhirDateTime)DateElement.DeepCopy();
}
if (DescriptionElement != null)
{
dest.DescriptionElement = (Hl7.Fhir.Model.FhirString)DescriptionElement.DeepCopy();
}
if (Previous != null)
{
dest.Previous = (Hl7.Fhir.Model.ResourceReference)Previous.DeepCopy();
}
if (Problem != null)
{
dest.Problem = new List <Hl7.Fhir.Model.ResourceReference>(Problem.DeepCopy());
}
if (Trigger != null)
{
dest.Trigger = (Hl7.Fhir.Model.Element)Trigger.DeepCopy();
}
if (Investigations != null)
{
dest.Investigations = new List <Hl7.Fhir.Model.ClinicalImpression.InvestigationsComponent>(Investigations.DeepCopy());
}
if (ProtocolElement != null)
{
dest.ProtocolElement = (Hl7.Fhir.Model.FhirUri)ProtocolElement.DeepCopy();
}
if (SummaryElement != null)
{
dest.SummaryElement = (Hl7.Fhir.Model.FhirString)SummaryElement.DeepCopy();
}
if (Finding != null)
{
dest.Finding = new List <Hl7.Fhir.Model.ClinicalImpression.FindingComponent>(Finding.DeepCopy());
}
if (Resolved != null)
{
dest.Resolved = new List <Hl7.Fhir.Model.CodeableConcept>(Resolved.DeepCopy());
}
if (RuledOut != null)
{
dest.RuledOut = new List <Hl7.Fhir.Model.ClinicalImpression.RuledOutComponent>(RuledOut.DeepCopy());
}
if (PrognosisElement != null)
{
dest.PrognosisElement = (Hl7.Fhir.Model.FhirString)PrognosisElement.DeepCopy();
}
if (Plan != null)
{
dest.Plan = new List <Hl7.Fhir.Model.ResourceReference>(Plan.DeepCopy());
}
if (Action != null)
{
dest.Action = new List <Hl7.Fhir.Model.ResourceReference>(Action.DeepCopy());
}
return(dest);
}
else
{
throw new ArgumentException("Can only copy to an object of the same type", "other");
}
}
public Task <object> SaveHraStep2(Investigations objPhysicalExamination, int hraid)
{
return(restService.SaveHraStep2(objPhysicalExamination, hraid));
}
public void Initialize() // TODO: rename to initialize
{
// users
var johnDoe = Users.CreateJohnDoe();
var janeDoe = Users.CreateJaneDoe();
Users.Add(johnDoe);
Users.Add(janeDoe);
// Vcs roots
var vcsGit = VcsRoots.CreateVcsRestClientGit();
var vcs1 = VcsRoots.CreateVcs(Guid.NewGuid());
VcsRoots.Add(vcsGit);
VcsRoots.Add(vcs1);
// Vcs root instances
var bitbucketInstance = VcsRootInstances.CreateVcsInstance(vcsGit);
VcsRootInstances.Add(bitbucketInstance);
// AgentPools
var defaultPool = BuildAgentPools.CreateDefaultPool();
BuildAgentPools.Add(defaultPool);
// Agents
var enabledAgent = BuildAgents.CreateEnabledAgent(johnDoe, johnDoe, defaultPool);
var disabledAgent = BuildAgents.CreateDisabledAgent(janeDoe, defaultPool);
BuildAgents.Add(enabledAgent);
BuildAgents.Add(disabledAgent);
var rootProject = Projects.CreateRootProject();
var clientProject = Projects.CreateRestClientProject(rootProject);
var cliProject = Projects.CreateTeamCityCliProject(rootProject);
var project1 = Projects.CreateProject(Guid.NewGuid(), rootProject);
Projects.Add(rootProject);
Projects.Add(clientProject);
Projects.Add(cliProject);
Projects.Add(project1);
var restType = BuildTypes.CreateBuildTypeRestClient(clientProject);
var cliType = BuildTypes.CreateBuildTypeTeamCityCli(cliProject);
BuildTypes.Add(restType);
BuildTypes.Add(cliType);
var buildOk = Builds.CreateOKBuild(restType, johnDoe, enabledAgent, bitbucketInstance);
var buildFailed = Builds.CreateFailedBuild(restType, johnDoe, enabledAgent, bitbucketInstance);
var buildQueued = Builds.CreateQueuedBuild(restType, johnDoe);
var buildCanceled = Builds.CreateCancelledBuild(restType, johnDoe);
var buildRunning = Builds.CreateRunningBuild(restType, johnDoe);
Builds.Add(buildOk);
Builds.Add(buildFailed);
Builds.Add(buildQueued);
Builds.Add(buildCanceled);
Builds.Add(buildRunning);
// Build queue
BuildQueue.AddRange(Builds.All().Items.Where(build => build.State == "queued"));
var change1 = Changes.CreateChange("1", "Initial commit.", DateTime.UtcNow.AddDays(-7), johnDoe, bitbucketInstance);
var change2 = Changes.CreateChange("2", "Add TeamCity fake data.", DateTime.UtcNow.AddDays(-6), johnDoe, bitbucketInstance);
var change3 = Changes.CreateChange("3", "Add Changes unit tests.", DateTime.UtcNow.AddDays(-4), johnDoe, bitbucketInstance);
Changes.Add(change1);
Changes.Add(change2);
Changes.Add(change3);
var inv = Investigations.CreateInvetigation("1", janeDoe);
Investigations.Add(inv);
}
