public List <PaymentDTO> GetAllPayment(string FrmPersianDate, string toPersianDate) { List <PaymentDTO> lstPayment = new List <PaymentDTO>(); DataTable dt = new DataTable(); dt = pDAO.GetAllPayment(FrmPersianDate, toPersianDate); for (int i = 0; i < dt.Rows.Count; i++) { PaymentDTO payDTO = new PaymentDTO(); payDTO.OrderId = int.Parse(dt.Rows[i]["OrderID"].ToString()); payDTO.Amount = long.Parse(dt.Rows[i]["AmountTrans"].ToString()); payDTO.stcode = dt.Rows[i]["StudentCode"].ToString(); payDTO.tterm = dt.Rows[i]["tterm"].ToString(); payDTO.PersianDate = dt.Rows[i]["PersianDate"].ToString(); if (dt.Rows[i]["TraceNumber"].ToString() != "") { payDTO.TraceNumber = long.Parse(dt.Rows[i]["TraceNumber"].ToString()); } else { payDTO.TraceNumber = 0; } payDTO.AppStatus = dt.Rows[i]["paystatus"].ToString(); lstPayment.Add(payDTO); } return(lstPayment); }