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

            DataTable dt = dal.GetAllServiceInvoiceMasterById(lstItems);
            ServiceInvoiceMaster objServiceInvoiceMaster = new ServiceInvoiceMaster();
            DataRow dr = dt.Rows[0];
            return GetObject(dr);
        }
        private static ServiceInvoiceMaster GetObject(DataRow dr)
        {
            ServiceInvoiceMaster objServiceInvoiceMaster = new ServiceInvoiceMaster
            {
                 Id = (Int64)dr["Id"],
                 InvoiceNo = (String)dr["InvoiceNo"],
                 PatienId = (Int64)dr["PatienId"],
                 NoOfTreatment = (Int32)dr["NoOfTreatment"],
                 Totalcharges = (Decimal)dr["Totalcharges"],
                 TotalPayment = (Decimal)dr["TotalPayment"],
                 DueAmount = (Decimal)dr["DueAmount"],
                 InvoiceAmount = (Decimal)dr["InvoiceAmount"],
                 InvoiceDate = (DateTime)dr["InvoiceDate"],
            };

            return objServiceInvoiceMaster;
        }