public TreatmentInvoiceDetail GetTreatmentInvoiceDetailById(Int64 Id)
        {
            Hashtable lstItems = new Hashtable();
            lstItems.Add("@Id", Id);

            DataTable dt = dal.GetAllTreatmentInvoiceDetailById(lstItems);
            TreatmentInvoiceDetail objTreatmentInvoiceDetail = new TreatmentInvoiceDetail();
            DataRow dr = dt.Rows[0];
            return GetObject(dr);
        }
        private static TreatmentInvoiceDetail GetObject(DataRow dr)
        {
            TreatmentInvoiceDetail objTreatmentInvoiceDetail = new TreatmentInvoiceDetail
            {
                 Id = (Int64)dr["Id"],
                 MasterId = (Int64)dr["MasterId"],
                 TreatmentId = (Int64)dr["TreatmentId"],
                 TotalAmount = (Decimal)dr["TotalAmount"],
                 Payment = (Decimal)dr["Payment"],
                 DueAmount = (Decimal)dr["DueAmount"],
            };

            return objTreatmentInvoiceDetail;
        }