private static TreatmentPayment GetObject(DataRow dr)
        {
            TreatmentPayment objTreatmentPayment = new TreatmentPayment
            {
                 Id = (Int64)dr["Id"],
                 PaymentCode = (String)dr["PaymentCode"],
                 PayDate = (DateTime)dr["PayDate"],
                 TreatmentId = (Int64)dr["TreatmentId"],
                 TotalAmount = (Decimal)dr["TotalAmount"],
                 Discount = (Decimal)dr["Discount"],
                 Payable = (Decimal)dr["Payable"],
                 PaidAmount = (Decimal)dr["PaidAmount"],
                 DueAmount = (Decimal)dr["DueAmount"],
                 ThisAmount = (Decimal)dr["ThisAmount"],
                 CurrentBalance = (Decimal)dr["CurrentBalance"],
            };

            return objTreatmentPayment;
        }
        public TreatmentPayment GetTreatmentPaymentById(Int64 Id)
        {
            Hashtable lstItems = new Hashtable();
            lstItems.Add("@Id", Id);

            DataTable dt = dal.GetAllTreatmentPaymentById(lstItems);
            TreatmentPayment objTreatmentPayment = new TreatmentPayment();
            DataRow dr = dt.Rows[0];
            return GetObject(dr);
        }