public async Task <IActionResult> Edit(int id, [Bind("id,adi")] Klinik klinik)
{
if (id != klinik.id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(klinik);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!KlinikExists(klinik.id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(klinik));
}
public async Task <IActionResult> PutKlinik([FromRoute] int id, [FromBody] Klinik klinik)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != klinik.KlinikID)
{
return(BadRequest());
}
_context.Entry(klinik).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!KlinikExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public List <Klinik> GetHastaList(Klinik klinik)
{
List <Klinik> res = new List <Klinik>();
string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["Merve"].ConnectionString;
using (MySqlConnection cn = new MySqlConnection(connStr))
{
cn.Open();
MySqlCommand cmd = new MySqlCommand();
cmd = new MySqlCommand("SELECT hasta_bilgileri.TC as TC_Kimlik,hasta_bilgileri.Hasta_No as Protokol,hasta_bilgileri.Hasta as Hastaİsmi,randevu_verme.Muayene_Adi as Muayene_Adi,randevu_verme.Doktor as Personel,randevu_verme.Randevu_Tarihi as Randevu_Tarihi,randevu_verme.Randevu_Saati as Randevu_Saati FROM hasta_bilgileri JOIN randevu_verme ON randevu_verme.Hasta_TC=hasta_bilgileri.TC WHERE randevu_verme.Doktor='" + klinik.Personel + "' AND randevu_verme.Randevu_Tarihi='" + klinik.Randevu_Tarihi + "' ORDER BY randevu_verme.Randevu_Saati ASC", cn);
MySqlDataReader r = cmd.ExecuteReader();
while (r.Read())
{
Klinik t = new Klinik();
for (int inc = 0; inc < r.FieldCount; inc++)
{
Type type = t.GetType();
PropertyInfo prop = type.GetProperty(r.GetName(inc));
//prop.SetValue(t, r.GetValue(inc), null);
prop.SetValue(t, Convert.ChangeType(r.GetValue(inc), prop.PropertyType), null);
}
res.Add(t);
}
return(res);
}
}
public List <Klinik> GetDoktorList()
{
List <Klinik> res = new List <Klinik>();
string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["Merve"].ConnectionString;
using (MySqlConnection cn = new MySqlConnection(connStr))
{
cn.Open();
MySqlCommand cmd = new MySqlCommand();
cmd = new MySqlCommand("SELECT Personel as Personel FROM personel_kayit WHERE Unvan=1 ", cn);
MySqlDataReader r = cmd.ExecuteReader();
while (r.Read())
{
Klinik t = new Klinik();
for (int inc = 0; inc < r.FieldCount; inc++)
{
Type type = t.GetType();
PropertyInfo prop = type.GetProperty(r.GetName(inc));
//prop.SetValue(t, r.GetValue(inc), null);
prop.SetValue(t, Convert.ChangeType(r.GetValue(inc), prop.PropertyType), null);
}
res.Add(t);
}
return(res);
}
}
public ActionResult Edit([Bind(Include = "K_Id,K_Address,K_Plz,K_Ort,K_Bundesland")] Klinik klinik)
{
if (ModelState.IsValid)
{
db.Entry(klinik).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.K_Bundesland = new SelectList(db.Bundeslands, "B_Id", "B_Name", klinik.K_Bundesland);
return(View(klinik));
}
public async Task <IActionResult> Create([Bind("id,adi")] Klinik klinik)
{
if (ModelState.IsValid)
{
_context.Add(klinik);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(klinik));
}
public async Task <IActionResult> PostKlinik([FromBody] Klinik klinik)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Kliniks.Add(klinik);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetKlinik", new { id = klinik.KlinikID }, klinik));
}
public ActionResult Klinik(Klinik klinik)
{
string connStr = System.Configuration.ConfigurationManager.ConnectionStrings["Merve"].ConnectionString;
using (MySqlConnection cn = new MySqlConnection(connStr))
{
cn.Open();
MySqlCommand cmd = new MySqlCommand();
RandevuVerme mi = new RandevuVerme();
mi.Klinik = GetHastaList(klinik);
return(View(mi));
}
}
// GET: Kliniks/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Klinik klinik = db.Kliniks.Find(id);
if (klinik == null)
{
return(HttpNotFound());
}
ViewBag.K_Bundesland = new SelectList(db.Bundeslands, "B_Id", "B_Name", klinik.K_Bundesland);
return(View(klinik));
}
public bool Ekle()
{
try
{
Klinik klinik = new Klinik();
klinik.klinikAd = KlinikAdi;
klinik.hastaneID = HastaneID;
db.Kliniks.Add(klinik);
db.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public async Task <IActionResult> Put(Klinik klinik)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
try
{
_context.Klinik.Update(klinik);
await _context.SaveChangesAsync();
return(Ok(klinik));
}
catch (System.Exception)
{
ModelState.AddModelError("Item couldn't updated!", "error");
return(BadRequest(ModelState));
}
}
public static ListViewItem[] convertToFkn(Klinik[] p)
{
ListViewItem[] lw = new ListViewItem[p.Length];
for (int i = 0; i < lw.Length; i++)
{
lw[i] = new ListViewItem(p[i].CustNr);
lw[i].SubItems.Add(p[i].Name);
lw[i].SubItems.Add(p[i].PoCity);
}
return lw;
}
/// <summary>
/// Konvertera en ArrayList till Fakturakund object.
/// </summary>
/// <param name="arr"></param>
/// <returns></returns>
public static Klinik[] convertFromArray(ArrayList arr)
{
Klinik[] p = new Klinik[arr.Count];
for (int i = 0; i < arr.Count; i++)
{
string[] s = arr[i].ToString().Split(";".ToCharArray(), 5);
p[i].CustNr = s[0];
p[i].Name = s[1];
p[i].PoCity = s[2];
p[i].InvoiceCustNr = s[3];
p[i].InvoiceCustName = s[4];
}
return p;
}
/// <summary>
/// Söker på kundnummer och Returnerar en Klinik (struct).
/// </summary>
/// <param name="cust"></param>
/// <returns></returns>
public Klinik[] getKlinikByCust(string cust)
{
Klinik[] p = new Klinik[0];
p.Initialize();
if (findByCust(cust))
{
p = new Klinik[1];
p[0].CustNr = KNR;
p[0].Name = PNR; // PNR är egentligen fältet NAM (där personnummer sparas på patienter)
p[0].PoCity = ORT;
p[0].InvoiceCustNr = FKN;
if (findByCust(FKN))
p[0].InvoiceCustName = PNR; // PNR är egentligen fältet NAM (där personnummer sparas på patienter)
}
else
{
// p[0].CustNr = "";
}
return p;
}
