[HttpGet] // כניסה ללשונית פרטים דמוגרפיים של מטופלת public ActionResult Demography() { try { Session.Timeout += 10; if (Session["Patiant"] == null) { return(RedirectToAction("Login", "Account")); } ViewBag.status = Session["status"]; Session["status"] = ""; BLPatiants blp = new BLPatiants(); Patiants p = blp.getPatiantsById(Session["Patiant"].ToString()); //שליפת נתוני המטופלת מהמסד BLMaterialStatus blms = new BLMaterialStatus(); List <MaritalStatus> ms = blms.getMaterialStatus(); //שליפת נתוני המטופלת מהמסד BLGetKupot blk = new BLGetKupot(); List <Kupot> k = blk.getKupot(); //שליפת נתוני המטופלת מהמסד MyModels M = new MyModels(); M.MyP = p; M.MyS = ms; M.MyK = k; return(View(M)); } catch (Exception e) { return(View()); } }
public ActionResult ReciepitsListOfPatiants()// כניסה לקבלות של מטופל { try { if (Session["UserName"] == null || Session["UserPasswerd"] == null) { return(RedirectToAction("Login", "Account")); } if (Session["Patiant"] == null) { return(RedirectToAction("Login", "Account")); } Session.Timeout += 10; BLReceipt bl = new BLReceipt(); List <receipt> NewReceiptList = new List <receipt>(); //קבלות ממוינות List <receipt> result = bl.getReceipt(Session["Patiant"].ToString(), "p"); if (result != null && result.Count > 1) //מיון תוצאות { var GroupResult = result.GroupBy(gro => new { gro.receiptNum }).Select(xx => new { xx.Key.receiptNum }).ToList(); foreach (var rec in GroupResult) { double sum = 0; foreach (var itemInResult in result)//סכימת תשלומים לקבלה אחת { if (itemInResult.receiptNum == rec.receiptNum) { sum += itemInResult.Sum; } } var SingleReceipt = result.FirstOrDefault(xxx => xxx.receiptNum == rec.receiptNum); //לוקחים רשומה אחת והופכים אותה לקבלה מאוחדת SingleReceipt.Sum = sum; //עדכון הסכום הכולל של כל התשלומים לקבלה NewReceiptList.Add(SingleReceipt); } } else { if (result != null && result.Count != 0) { NewReceiptList.Add(result.FirstOrDefault()); } } BLPatiants blc = new BLPatiants(); Patiants p = blc.getPatiantsById(Session["Patiant"].ToString()); MyPatiantsRecepitModels model = new MyPatiantsRecepitModels(); model.recepit = NewReceiptList; model.MyP = p; return(View(model)); } catch { MyPatiantsRecepitModels model = new MyPatiantsRecepitModels(); return(View(model)); } }
public Patiants getPatiantsById(string id) { DAPatiants da = new DAPatiants(); ListDictionary Params = new ListDictionary(); Params.Add("@id", id); DataSet ds = da.getPatiantsById(Params); Patiants p = new Patiants(); p.A = BLCtrl.getInt(ds.Tables[0].Rows[0], "A", 0); p.BirthDate = BLCtrl.getDateTime(ds.Tables[0].Rows[0], "BirthDate", DateTime.Today); p.Children = BLCtrl.getInt(ds.Tables[0].Rows[0], "Children", 0); p.City = BLCtrl.getString(ds.Tables[0].Rows[0], "City", ""); p.Code = BLCtrl.getInt(ds.Tables[0].Rows[0], "Code", 0); p.ContactExam = BLCtrl.getString(ds.Tables[0].Rows[0], "ContactExam", ""); p.ContactGinformation = BLCtrl.getString(ds.Tables[0].Rows[0], "ContactGinformation", ""); p.Doctor = BLCtrl.getString(ds.Tables[0].Rows[0], "Doctor", ""); p.Email = BLCtrl.getString(ds.Tables[0].Rows[0], "Email", ""); p.FathersOrigin = BLCtrl.getString(ds.Tables[0].Rows[0], "FathersOrigin", ""); p.Fax = BLCtrl.getString(ds.Tables[0].Rows[0], "Fax", ""); p.FirstName = BLCtrl.getString(ds.Tables[0].Rows[0], "FirstName", ""); p.followedup = BLCtrl.getBool(ds.Tables[0].Rows[0], "followedup", false); p.FollowUp = BLCtrl.getBool(ds.Tables[0].Rows[0], "FollowUp", false); p.G = BLCtrl.getInt(ds.Tables[0].Rows[0], "G", 0); p.Id = BLCtrl.getString(ds.Tables[0].Rows[0], "Id", ""); p.Kupah = BLCtrl.getInt(ds.Tables[0].Rows[0], "Kupah", 0); p.L = BLCtrl.getInt(ds.Tables[0].Rows[0], "L", 0); p.Language = BLCtrl.getString(ds.Tables[0].Rows[0], "Language", ""); p.LastName = BLCtrl.getString(ds.Tables[0].Rows[0], "LastName", ""); p.MaritalStatus = BLCtrl.getInt(ds.Tables[0].Rows[0], "MaritalStatus", 0); p.MothersOrigin = BLCtrl.getString(ds.Tables[0].Rows[0], "MothersOrigin", ""); p.Occupation = BLCtrl.getString(ds.Tables[0].Rows[0], "Occupation", ""); p.P = BLCtrl.getInt(ds.Tables[0].Rows[0], "P", 0); p.Phone = BLCtrl.getString(ds.Tables[0].Rows[0], "Phone", ""); p.Phone2 = BLCtrl.getString(ds.Tables[0].Rows[0], "Phone2", ""); p.reffered = BLCtrl.getString(ds.Tables[0].Rows[0], "reffered", ""); p.Street = BLCtrl.getString(ds.Tables[0].Rows[0], "Street", ""); p.T = BLCtrl.getInt(ds.Tables[0].Rows[0], "T", 0); return(p); }
public List <Patiants> getPatiants() { PatientsList dm = new PatientsList(); ListDictionary Params = new ListDictionary(); // Params.Add("@dt", dt); DataSet ds = dm.getPatiants(Params); List <Patiants> l = new List <Patiants>(); Patiants p; foreach (DataRow item in ds.Tables[0].Rows) { // f.FollowUp = BLCtrl.getString(item, "FollowUp", ""); p = new Patiants(); p.Id = BLCtrl.getString(item, "Id", " "); p.FirstName = BLCtrl.getString(item, "FirstName", " "); p.LastName = BLCtrl.getString(item, "LastName", " "); p.Doctor = BLCtrl.getString(item, "Doctor", " "); l.Add(p); } return(l); }
public List <Patiants> getFolloaed_patient() { DAFolloaed_patient dfp = new DAFolloaed_patient(); ListDictionary Params = new ListDictionary(); DataSet ds = dfp.getFolloaed_patient(Params); List <Patiants> lp = new List <Patiants>(); Patiants p; foreach (DataRow item in ds.Tables[0].Rows) { p = new Patiants(); p.Id = BLCtrl.getString(item, "id", " "); p.FirstName = BLCtrl.getString(item, "FirstName", " "); p.LastName = BLCtrl.getString(item, "LastName", " "); p.Phone = BLCtrl.getString(item, "Phone", " "); p.Phone2 = BLCtrl.getString(item, "Phone2", " "); p.City = BLCtrl.getString(item, "City", " "); p.Kupah = BLCtrl.getInt(item, "Kupah", 1); //p.FollowUp = BLCtrl.getBool(item, "FollowUp", false); lp.Add(p); } return(lp); }
[HttpPost]// עדכון הנתונים במסד public ActionResult Demography(Patiants pat) { try { pat.Id = pat.Id.TrimEnd('/'); BLPatiants bl = new BLPatiants(); int result = bl.UpdatePatiant(pat.Id, pat.FirstName, pat.LastName, pat.Doctor, pat.reffered, pat.Language, pat.City, pat.Street, pat.Phone, pat.Phone2, pat.Fax, pat.Email, pat.BirthDate, pat.ContactExam, pat.ContactGinformation, pat.FathersOrigin, pat.MothersOrigin, pat.Kupah, pat.MaritalStatus, pat.Children, pat.G, pat.T, pat.P, pat.A, pat.L, pat.FollowUp, pat.Occupation, pat.followedup); if (result == 0)// שמירת הנתונים צלחה { Session["status"] = "הנתונים נשמרו בהצלחה"; return(RedirectToAction("Demography", "Patiants", new { pat.Id })); } else// כשל בשמירת הנתונים { Session["status"] = "התרחשה שגיאה"; return(RedirectToAction("Demography", "Patiants", new { pat.Id })); } } catch { Session["status"] = "התרחשה שגיאה"; return(RedirectToAction("Demography", "Patiants", new { pat.Id })); } }
public ActionResult addPatiant(Patiants s) //הוספת מטופל { try { Session.Timeout += 10;//session הגדלת ה BL_AddPatiants b = new BL_AddPatiants(); int i = 0; i = b.CheckID(s.Id); bool check = myStatic.IsValidId(s.Id); // שליחה לפונ' לבדיקת תקינות תעודת הזהות if (i == 20) // אם המטופל אינו קיים במערכת { if (check == false) // אם התעודת זהות איננה תקינה { s.Id = ""; ModelState.AddModelError("Id", "תעודת זהות אינה תקינה"); } if (ModelState.IsValid) { ModelState.Remove("Id"); int result = b.Add_Patiants(s.Id, s.FirstName, s.LastName, s.Kupah); ViewBag.message = "מטופל נוסף למערכת בהצלחה"; return(View(new Patiants())); } } else //אם המטופל קיים במערכת { s.Id = ""; ModelState.AddModelError("Id", "מטופל קיים במערכת"); } return(View(s)); } catch (Exception e) { return(View(s)); } }