public async Task <IActionResult> Edit(int id, [Bind("CheckupsID,Name,Patients,Period")] Checkups checkups)
{
if (id != checkups.CheckupsID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(checkups);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!CheckupsExists(checkups.CheckupsID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction("Index"));
}
return(View(checkups));
}
public void getdatafrmrecmndcheckups(Checkups chkps)
{
String sqlStr = "Server=127.0.0.1;Uid=root;";
MySqlConnection con = new MySqlConnection(sqlStr);
String query = "select MAX(checkupno) from cmshdb.recmndcheckups WHERE patientid= '" + chkps.Pid + "' AND receiptid=SELECT MAX(receiptid)from cmshdb.recmndcheckups";
MySqlConnection MyConn2 = new MySqlConnection(sqlStr);
MyConn2.Open();
MySqlCommand MyCommand2 = new MySqlCommand(query, MyConn2);
// MyConn2.Open();
//For offline connection we weill use MySqlDataAdapter class.
try
{
var reader = MyCommand2.ExecuteReader();
while (reader.Read())
{
//Console.WriteLine(reader.GetString(0));
//Console.WriteLine(reader.GetString(1));
//Console.WriteLine(reader.GetString(2));
//Console.WriteLine(reader.GetString(3));
//User user = new User();
// chkps.Receiptid = reader.GetInt32(1);
chkps.Checkupno = reader.GetInt32(0);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
}
protected override void OnViewReady(object view)
{
base.OnViewReady(view);
Checkups.Clear();
using (var db = new OPContext())
{
Checkups.AddRange(db.Checkups.Where(c => c.PatientId == PatientId).ToList());
}
}
public async Task <IActionResult> Create([Bind("CheckupsID,Name,Patients,Period")] Checkups checkups)
{
if (ModelState.IsValid)
{
_context.Add(checkups);
await _context.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(checkups));
}
private void buttondapcheck_Click(object sender, EventArgs e)
{
paneldapatient.Visible = true;
Checkups chckups = new Checkups();
chckups.Pid = int.Parse(textBoxdapid.Text);
/*Formrcmndcheckups Formreccheckups = new Formrcmndcheckups();
* Formreccheckups.senddata(chckups);*/
setvaluespatnt();
}
/* private void buttonRecommendcheckups_Click(object sender, EventArgs e)
* {
*
* //senddata();
* }*/
private void buttonRecommendcheckups_Click(object sender, EventArgs e)
{
//Checkups[] chkps ;
Checkups chkps = new Checkups();
FormDoctoracc fda = new FormDoctoracc();
chkps.Pid = int.Parse(fda.textBoxdapid.Text);
usermng umng = new usermng();
Console.Write("here1");
umng.getdatafrmrecmndcheckups(chkps);
MessageBox.Show(chkps.Checkupno + " test:");
// MessageBox.Show("" + chkps[0].Pid);
}
public bool IsValid()
{
return(!string.IsNullOrEmpty(Name) &&
!string.IsNullOrEmpty(Title) &&
!string.IsNullOrEmpty(Description) &&
Uri.IsWellFormedUriString(Url.ToString(), UriKind.RelativeOrAbsolute) &&
Uri.IsWellFormedUriString(ParentStoryUrl.ToString(), UriKind.RelativeOrAbsolute) &&
KeyIdentifiers != null &&
KeyIdentifiers.Any() ? KeyIdentifiers.All(s => s.IsValid()) : true &&
TestCases != null &&
TestCases.Any() ? TestCases.All(s => s.IsValid()) : true &&
Checkups != null &&
Checkups.Any() ? Checkups.All(s => s.IsValid()) : true &&
Attachments != null &&
Attachments.Any() ? Attachments.All(s => Uri.IsWellFormedUriString(s.Value, UriKind.RelativeOrAbsolute)) : true &&
Queries != null &&
Queries.Any() ? Queries.All(s => Uri.IsWellFormedUriString(s.Value, UriKind.RelativeOrAbsolute)) : true &&
Scripts != null &&
Scripts.Any() ? Scripts.All(s => Uri.IsWellFormedUriString(s.Value, UriKind.RelativeOrAbsolute)) : true &&
SubTasks.Any() ? SubTasks.All(s => s.IsValid()) : true);
}
public void senddata(Checkups chckup)
{
//
}
private FlowDocument BuildDocument()
{
var doc = new FlowDocument();
doc.LineStackingStrategy = System.Windows.LineStackingStrategy.BlockLineHeight;
doc.LineHeight = 12;
doc.Blocks.Add(new Paragraph(new Bold(new Run("Summary"))));
doc.Blocks.Add(new Paragraph(new Run(" " + Title)));
doc.Blocks.Add(new Paragraph(new Bold(new Run("Description"))));
doc.Blocks.Add(new Paragraph(new Run(" " + Description)));
doc.Blocks.Add(new Paragraph(new Bold(new Run("Url"))));
var url = new Hyperlink(new Run(Url.ToString()));
doc.Blocks.Add(new Paragraph(url));
doc.Blocks.Add(new Paragraph(new Bold(new Run("Parent Story"))));
var parentUrl = new Hyperlink(new Run(ParentStoryUrl.ToString()));
parentUrl.NavigateUri = ParentStoryUrl;
doc.Blocks.Add(new Paragraph(parentUrl));
doc.Blocks.Add(new Paragraph(new Italic(new Run("Status: " + Status.ToString()))));
doc.Blocks.Add(new Paragraph(new Italic(new Run("Date Started: " + DateStarted.Value.ToString("yyyy-MM-dd hh:mm:ss")))));
if (DateEnded.HasValue && DateEnded.Value != DateTime.MinValue)
{
doc.Blocks.Add(new Paragraph(new Italic(new Run("Date Ended: " + DateEnded.Value.ToString("yyyy-MM-dd hh:mm:ss")))));
}
if (Attachments.Any())
{
doc.Blocks.Add(new Paragraph(new Bold(new Run("Attachments"))));
foreach (var item in Attachments)
{
var itemUri = new Uri(item.Value);
var itemUrl = new Hyperlink(new Run(item.Value));
doc.Blocks.Add(new Paragraph(itemUrl));
}
}
if (AcceptanceCriteria.Any())
{
doc.Blocks.Add(new Paragraph(new Bold(new Run("Acceptance Criteria"))));
foreach (var item in AcceptanceCriteria)
{
doc.Blocks.Add(new Paragraph(new Run(" + " + item.Value)));
}
}
if (DeveloperCriteria.Any())
{
doc.Blocks.Add(new Paragraph(new Bold(new Run("Development Criteria"))));
foreach (var item in DeveloperCriteria)
{
doc.Blocks.Add(new Paragraph(new Run(" + " + item.Value)));
}
}
var i = 0;
var j = 0;
if (KeyIdentifiers.Any())
{
doc.Blocks.Add(new Paragraph(new Bold(new Run("Key Identifiers"))));
foreach (var item in KeyIdentifiers)
{
doc.Blocks.Add(new Paragraph(new Run(" " + (++i).ToString() + ". " + item.Description)));
if (item.Questions.Any())
{
j = 0;
doc.Blocks.Add(new Paragraph(new Italic(new Run(" Questions"))));
foreach (var q in item.Questions)
{
doc.Blocks.Add(new Paragraph(new Run(" " + (++j).ToString() + ".Q. " + q.Ask)));
doc.Blocks.Add(new Paragraph(new Run(" A. " + q.Answer)));
}
}
}
}
if (Issues.Any())
{
i = 0;
doc.Blocks.Add(new Paragraph(new Bold(new Run("Issues"))));
foreach (var item in Issues)
{
doc.Blocks.Add(new Paragraph(new Run(" " + (++i).ToString() + ". " + item.Description)));
doc.Blocks.Add(new Paragraph(new Italic(new Run(" Is Open: " + item.IsOpen.ToString()))));
}
}
if (Queries.Any())
{
doc.Blocks.Add(new Paragraph(new Bold(new Run("Queries"))));
foreach (var item in Queries)
{
var itemUri = new Uri(item.Value);
var itemUrl = new Hyperlink(new Run(item.Value));
doc.Blocks.Add(new Paragraph(itemUrl));
}
}
if (Scripts.Any())
{
doc.Blocks.Add(new Paragraph(new Bold(new Run("Scripts"))));
foreach (var item in Scripts)
{
var itemUri = new Uri(item.Value);
var itemUrl = new Hyperlink(new Run(item.Value));
doc.Blocks.Add(new Paragraph(itemUrl));
}
}
if (TestCases.Any())
{
i = 0;
doc.Blocks.Add(new Paragraph(new Bold(new Run("Test Cases"))));
foreach (var item in TestCases)
{
doc.Blocks.Add(new Paragraph(new Run(" " + (++i).ToString() + ". " + item.Description)));
doc.Blocks.Add(new Paragraph(new Italic(new Run(" Status: " + item.Status.ToString()))));
if (item.Steps.Any())
{
j = 0;
doc.Blocks.Add(new Paragraph(new Italic(new Run(" Steps"))));
foreach (var q in item.Steps)
{
doc.Blocks.Add(new Paragraph(new Run(" " + (++j).ToString() + ". " + q.Value)));
}
}
}
}
if (Checkups.Any())
{
i = 0;
doc.Blocks.Add(new Paragraph(new Bold(new Run("Checkups"))));
foreach (var item in Checkups)
{
doc.Blocks.Add(new Paragraph(new Run(" " + (++i).ToString() + ". " + item.Description)));
doc.Blocks.Add(new Paragraph(new Italic(new Run(" Applied: " + item.Applied.ToString()))));
}
}
if (SubTasks.Any())
{
i = 0;
doc.Blocks.Add(new Paragraph(new Bold(new Run("SubTasks"))));
foreach (var item in SubTasks)
{
doc.Blocks.Add(new Paragraph(new Run(" " + (++i).ToString() + ". " + item.Title)));
doc.Blocks.Add(new Paragraph(new Italic(new Run(" Status: " + item.Status))));
}
}
return(doc);
}
