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 ActionResult GetTheData(int PageNumber, int PageSize)//Lazy Load
{
try
{
BLReceipt bl = new BLReceipt();
var result = bl.getAllReceipt(PageNumber, PageSize);
if (result.Count != 0)
{
return(Json(result, JsonRequestBehavior.AllowGet));
}
else//נגמרו הרשומות
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
catch (Exception e)
{
return(Json("", JsonRequestBehavior.AllowGet));
}
}
